Wireless E911 Guide CG-EWCG-001
TN Database Updates Issue 3, January 6, 2004
TableE SOIR File Data Record - BellSouth 512Character Format for Data Exchange (continued)
Sent to PSAP Stored in
Database Field Name Position Bytes Type BellSouth Description
No Yes order number 241 - 250 10 AN Service order number for the activity
establishing this record.
No Yes EXTRACT
DATE 251 - 256 6 NDate on which the record was created in
the format MMDDYY.
No Yes county identifier 257 - 260 4 AN County Identification code (usually the
FIPS code). Will be blank on input and
derivedfrom MSAG validation process.
Yes Yes COMPANY ID 261 - 265 5 AN Telephone Company Identificationcode
as assigned through NENA registration
process.
No Yes source identifier 266 1 AN Codewhich indicates whether data is part
of the initial database creation process or
part of the daily update process.
Daily = Space
Initial Load = C
No Yes zip code 267 - 271 5 AN Postal Zip Code.
No Yes zip +4 272 - 275 4 AN Postal Zip Code Extension.
No No general use 276- 286 11 AN This field is mutually used by data
exchange partners to pass information
not defined in previous fields.
No Yes CUSTOMER
CODE 287 - 289 3 AN Code used to uniquely identify a
customer. For ICO, ALEC, and Wireless
companies this code can be blank on
input or filled with 999. TN processing
will convertall blanksto 999.
No Yes comments 290 - 319 30 AN Optional notes
- continued -
Page 38