Column List

Column List

NameMax 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 ^.*$
The three digit area code
TELNO 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.