Column List

Name	Max Length	Regular Expression
	Description
OCN	6	^IP[0-9]+$
	The Operating Carrier Number assigned to you.
PRIVACY_FLAG	1	^[0-1]?$
	0=Distribute the information to online data sources 1=Use data only for Directory Assistance
NPA	3	^[0-9]{3}$
	The three digit area code
TELNO	7	^[0-9]{7}$
	the seven digit telephone number of the listing ^[0-9]{7}$
SPLIT	1	^[1-7]$
	Split indicator. Indicate if the listing is a Business or Residential listing. Permitted values are: 1 Residential 4 Business 5 Business/Residential
LSTTYP	1	^[12]$
	Listing type. Permitted values are: 1 Listed telephone number 2 Nonlisted telephone number 3 Nonpublished telephone number
LSTSTY	1	^[0-9]$
	Listing style. Indicates how listing record is to be processed and displayed. Permitted values are: (1 is the usual choice) 0 Straight-line listing 1 Straight-line undent (SLU set) header 2 Indent under a straight-line undent header or indent. 8 Caption set header (no phone number on top heading) 9 Caption set subheader 6 Indent under
INDENT	1	^[0-5]$
	Degree or level of indentation used for each record during display generation. Permissible values are 0 through 7. Straight-line listings (LSTSTY= 0) and set headers (LSTSTY= 1 or 8) only have an indent level of zero. All other listings, indent level must be between 1 and 7.
LSTNM	255	^[a-zA-Z0-9,.&' \-$]+$
	Listed finding name. Field used for display. Residential listings will contain subscriber surname with punctuation. For example: Smith or O'Tool For business or government listings, field should contain first word of business/agency name including punctuation. For example: Lowes United Pete's Listings should not start with any special characters (!,@,#,$,%,^,&,*,(,),-,+,=,?,",') numbers (0-9) or space in order to enable their listings to flow to the top of the response screen.
LSTGN	255	^[a-zA-Z0-9,.&' \-]*$
	Listed given name/title/designation. Display field contains all of the other words of subscriber name not listed in the LSTNM field. The LSTGN field together with the LSTNM field makes up the complete subscriber name. For example: LSTNM LSTGN Smith John Lowes Hardware United States Mint Information Pete's New & Used Auto Sales
STRT	255	^[a-zA-Z0-9 .,#&'/\-]*$
	Street Address of the Listing For example: 123 South Main St. SW
LOCNM	255	^[A-Za-z][A-Za-z .'\-]*$
	Locality. Field contains the city for the given listing.
STATE	2	^[a-zA-Z][a-zA-Z]$
	State using US postal code designation.
ZIP	10	^[0-9]{5}\|[0-9]{9}\|[0-9]{5}\-[0-9]{4}\|[YXVTSRPJGABCEHLMNK][0-9][A-Z][ ][0-9][A-Z][0-9]$
	Zip code
NSTEL	255
	Nonstandard telephone number. Field contains telephone number that consists of something other than standard 10 digits. For example: 411, 611, 800 FLOWERS
SPLTX	255
	Special listing text. Field contains special display-only text that generally appears following listed address and before telephone number to an operator (e.g. NO CHARGE TO CALLING PARTY). (non-searchable)
XCODE	1	[I\|O]?
	I=In O=Out
MNPA	3	[0-9]*
	Match NPA is useful for placing foreign listings into the desired NPA/book. For foreign listings, MNPA should contain the NPA of the book in which the listing should appear. NOTE: Must be a valid NPA.
RECID	255	[A-Za-z0-9]*
	Unique record id.
FTD	255	^[a-zA-Z0-9,.&' \-$]*$
	Full title and designation field. Contains all titles and designations from subscriber name. Used for sequencing and matching, not display.
FSN	255	[A-Za-z0-9 ]*
	Fully spelled name containing all the words of subscriber name, not including titles, designations, or special characters. Used for sequencing and matching, not display. NOTE: Must contain only characters ( A-Z, a-z, 0-9).
DIRTX	255
	Directive text. Field contains display data for listed name and address (e.g., MASTER PLUMBER). During display generation, data generally appears after name and before address to an operator. NOTE: For an indent record, field should be displayed Instead of listed finding name (LSTNM) and listed given Name/title/designation (LSTGN).
COUNTY	255
	County subscriber address belongs.
SICCODE	255
	Business category code.
GEO_LONG	255	[0-9]+\.[0-9]+[EW]\|.?
	Geo code longitude number for listing. Longitude displays in decimal degrees. Longitude number has either a W or E (West or East) indicator appended to it. For example: 122.41707W
GEO_ACC	1	[1-4]?
	Geo code accuracy. If no accuracy value is present, GEO_LAT and GEO_LONG fields do not contain values. Permitted values are: 1 Rooftop 2 Block level 3 Within a few blocks 4 Center of 5-digit zip
GEO_LAT	255	[0-9]+\.[0-9]+[NS]\|.?.?
	Geo code latitude number for listing. Latitude displays in decimal degrees. Latitude number has either an N or S (North or South) indicator appended to it. For example: 37.780968N
CHECKDATE	10	[0-9]{4}-[0-9]{2}-[0-9]{2}\|
	Date, yyyy-mm-dd, to verify that the listing has been sucessfully incorpoated into the database. There is a per validation additional charge for this feature.