Para español, seleccione de la lista

Fictitious Name Data Download

File Structure

Do not confuse the add date with the filed date.

  • Add date: the date the information was entered into our database.
  • Filed date: the date the fictitious name was filed by the Division of Corporations.

 

Fictitious Name Data – File Structure
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)
 
Field Name Explanations
FIC_FIL_DOC_NUMBER The 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 address line.
FIC_FIL_ADDR2 2nd address line.
FIC_FIL_CITY City.
FIC_FIL_STATE State.
FIC_FIL_ZIP Zip Code.
FIC_FIL_COUNTRY Country.
FIC_FIC_FILING_DATE Date filed by the Division of Corporations.
FIC_FIL_PAGES Total number of pages filed.
FIC_FIL_STATUS Status: (C) Cancelled, (E) Expired, or (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 the Division of Corporations for a complete list.
FIC_OWNERS Table listing 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.