 |
 |
 |
FICTITIOUS NAME DATA FILE DOWNLOAD
The information provided in the Fictitious Name data file is a summary of all fictitious name data records added to our database on a particular date. This data is provided for information purposes only and may be changed or deleted from our database at any time.
The download file name is generated from the add date of the information contained in the file. The data file name will reflect the date on which the information was added to our database. Do not confuse add date with filed date. Add date is the date on which the information was input into our database. File date is the recorded date of filing for the fictitious name record. Data may be added to our database on a date that is different from the file date in the record.
| 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 |