 |
 |
 |
Fictitious Name Data On Compact Disc
Fictitious name data is currently available on Compact Disc. The data is pulled quarterly and contains a complete data set of active fictitious records. The information is in two separate files, fictitious filing data and the fictitious name owner data and is contained on CD. The data is in ACSII format.
Within each filing record there is a count (FIC_FILE_TOTAL_OWN_CUR_CTR) of the number of owners for that record. The owner's record contains the filing number associated with its filing record. Both files have been sorted by the filing record, and the owner count on the filing record has been verified with the number of owners in each file.
| FD FIC_DATA_FILE | |
|---|---|
| BLOCK CONTAINS 10 RECORDS | |
| RECORD CONTAINS 2098 CHARACTERS | |
| DATA RECORD IS FIC_REC. | |
| 01 FIC_REC. | |
| 05 FIC_FIL_DOC_NUM | PIC X(12). |
| 05 FIC_FIL_NAME | PIC X(192). |
| 05 FIC_FIL_COUNTY | PIC X(12). |
| 05 FIC_FIL_ADDR1 | PIC X(40). |
| 05 FIC_FIL_ADDR2 | PIC X(40). |
| 05 FIC_FIL_CITY | PIC X(28). |
| 05 FIC_FIL_STATE | PIC X(02). |
| 05 FIC_FIL_ZIP | PIC X(10). |
| 05 FIC_FIL_COUNTRY | PIC X(02). |
| 05 FIC_FIL_DATE | PIC X(08). |
| 05 FIC_FIL_PAGES | PIC 9(05). |
| 05 FIC_FIL_STATUS | PIC X(01). |
| 05 FIC_FIL_CANCELLATION_DATE | PIC X(08). |
| 05 FIC_FIL_EXPIRATION_DATE | PIC X(08). |
| 05 FIC_FIL_TOTAL_OWN_CUR_CTR | PIC 9(05). |
| 05 FIC_FIL_FEI_NUM | PIC X(14). |
| 05 FIC_GREATER_THAN_10_OWNERS | PIC X(01). |
| 05 FIC_OWNERS | OCCURS 10 TIMES. |
| 10 FIC_OWNER_DOC_NUM | PIC X(12). |
| 10 FIC_OWNER_NAME | PIC X(55). |
| 10 FIC_OWNER_NAME_FORMAT | PIC X(01). |
| 10 FIC_OWNER_ADDR | PIC X(40). |
| 10 FIC_OWNER_CITY | PIC X(28). |
| 10 FIC_OWNER_STATE | PIC X(02). |
| 10 FIC_OWNER_ZIP | PIC X(10). |
| 10 FIC_OWNER_COUNTRY | PIC X(02). |
| 10 FIC_OWNER_FEI_NUM | PIC X(09). |
| 10 FIC_OWNER_CHARTER_NUM | PIC X(12). | The following is an explanation of what each field contains. |
| FIC_FIL_DOC_NUMBER: | The fic document number (filing number) |
| FIC_FIL_NAME: | The name of the fictitious filing |
| FIC_FIL_COUNTY: | The county in which it resides |
| FIC_FIL_ADDR1: | 1st line of address |
| FIC_FIL_ADDR2: | 2nd line of address |
| FIC_FIL_CITY: | city |
| FIC_FIL_STATE: | state |
| FIC_FIL_ZIP: | zip code |
| FIC_FIL_COUNTRY: | country |
| FIC_FIC_FILING_DATE: | Date filed with our office |
| FIC_FIL_PAGES: | Total number of pages filed |
| FIC_FIL_STATUS: | Status: (C) cancelled (E) Expired and (A) Active |
| FIC_DATA_CANCELLATION_DATE: | Date filing was cancelled |
| FIC_DATA_EXPIRATION_DATE: | Date filing will expire |
| FIC_DATA_TOTAL_OWN_CUR_CTR: | Number of owners associated with filing |
| FIC_DATA_FEI_NUMBER: | FEI number associated with filing |
| FIC_GREATER_THAN_10_OWNERS: | (N) = Less than 10 owners (Y) = More than 10 owners, call Corporations for complete list. |
| FIC_OWNERS | This is a table of the owners (up to 10 entries) |
| FIC_OWNER_DOC_NUM: | Filing Document number |
| FIC_OWNER_NAME: | Owner name |
| FIC_OWNER_NAME_FORMAT: | Owner name format (P) person (C) corporation |
| FIC_OWNER_ADDR: | Owner address |
| FIC_OWNER_CITY: | Owner city |
| FIC_OWNER_STATE: | Owner state |
| FIC_OWNER_ZIP: | Owner zip |
| FIC_OWNER_COUNTRY: | Owner country |
| FIC_OWNER_FEI_NUM: | Owner FEI number |
| FIC_OWNER_CHARTER_NUM: | Owner Charter number |