Wireless E911 Guide CG-EWCG-001
TN Database Updates Issue 3, January 6, 2004
Table E SOIR File Data Record - BellSouth 512 Character 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
DA TE
251 - 256 6
N
Date 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
derived from MSAG validation process.
Yes Yes
COMPANY ID 261 - 265 5
AN
Telephone Company Identification code
as assigned through NENA registration
process.
No Yes
source identifier 266 1
AN
Code which 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 convert all blanks to 999.
No Yes comments
290 - 319 30
AN
Optional notes
- continued -
Page 38