...
- The Service already exists in the Snapshot
- The Service is not in a deleted (D) state in the Snapshot
- The Location/Address information has changed
- The Contact Owner/Department Owner information has changed
- The Service ID is not NULL (blank)
- The Service has all required Location/Address information
- The Service Status is Active or Suspend
- The Building reports 911
- The Service Catalog reports 911
- The Phone Service reports 911
...
For more information on the USE_E911_NENA2_FIELDS parameter, please see the Misc Parameter page.
Location
The Location field is populated by the locations hierarchy. Here are a few examples:
...
LOCATION_TYPE refers to any of the following:
- The List RECID of a Location Type, example: 178
- The List Code (in all caps) of a Location Type, example: FLOOR
- BUILDING_NUMBER, the building number of an address
- BUILDING_NAME, the building name of an address
- SERVICE_LOCATION, the Service Location of the Service
The REGEX strings use a standard REGEX find and replace format: https://regex101.com/.
...
In the instance of a multi-location service, a single location must have the E911 Location enabled from the Locations grid on the service.
...
Using NENA 2
...
DATA_COLUMN
...
FIXED_START
...
FIXED_WIDTH
...
FUNCTION
...
0
...
1
...
NPA_CALLING_NUMBER
...
1
...
10
...
HOUSE_NUMBER
...
11
...
10
...
HOUSE_NUMBER_SUFFIX
...
21
...
4
...
PREFIX_DIRECTIONAL
...
25
...
2
...
STREET_NAME
...
27
...
60
...
STREET_SUFFIX
...
87
...
4
...
POST_DIRECTIONAL
...
91
...
2
...
COMMUNITY_NAME
...
93
...
32
...
STATE
...
125
...
2
...
LOCATION
...
127
...
60
...
CUSTOMER_NAME
...
187
...
32
...
CLASS_OF_SERVICE
...
219
...
1
...
TYPE_OF_SERVICE
...
220
...
1
...
EXCHANGE
...
221
...
4
...
ESN
...
225
...
5
...
MAIN_NPA_NUMBER
...
230
...
10
...
ORDER_NUMBER
...
240
...
10
...
EXTRACT_DATE
...
250
...
6
...
COUNTY_ID
...
256
...
4
...
COMPANY_ID
...
260
...
5
...
SOURCE_ID
...
265
...
1
...
ZIP_CODE
...
266
...
5
...
ZIP_PLUS_4
...
271
...
4
...
GENERAL_USE
...
275
...
11
...
CUSTOMER_CODE
...
286
...
3
...
COMMENTS
...
289
...
30
...
X_COORD
...
319
...
9
...
Y_COORD
...
328
...
9
...
Z_COORD
...
337
...
5
...
CELL_ID
...
342
...
6
...
SECTOR_ID
...
348
...
1
...
TAR_CODE
...
349
...
6
...
RESERVED_36
...
355
...
15
...
RECORD_DUE_DATE
...
370
...
6
...
DATE_STAMP
...
376
...
6
...
RESERVED_39
...
382
...
119
...
STATUS_INDICATOR
...
501
...
1
...
RESERVED_41
...
502
...
9
...
END_RECORD_MARKER
...
511
...
1
Example Output for NENA 2
...
and NENA 3 Formats
It is important to review the full NENA 2 or NENA 3 Standards. when using the formats. It is also important to remember when switching between formats, that it is important to create a new E911 Export for the new format, rather than convert an existing Export to a different one.
Example Output for NENA 2
| No Format |
|---|
I804000000010 E Franklin Ave Richmond VA246/S1253 10 East Franklin 00001 VCU Telecommunications Services 40 8040000000 070617 C23284 E Franklin Ave Richmond VA246/S1253 10 East Franklin 00001 VCU Telecommunications Services 40 8040000000 070617 C23284 * I000000003510 E Franklin Ave Richmond VA246/S1253 10 East Franklin 00001 Massey Cancer Center 40 0000000035 * I000000003510 070617 E FranklinC23284 Ave Richmond VA246/S1253 10 East Franklin 00001 Massey Cancer Center 40 0000000035 070617 C23284 * I616867530910 E Franklin Ave Richmond VA246/S1253 10 East Franklin SokolowskiJeremiah 40 *6168675309 I616867530910 070617 E Franklin C23284 |
Example Output for NENA 3
| No Format |
|---|
HDR|EXD20210402|CONJames Madison University|CYC000001857| DAT|FOCC|CTN5405686705|HNO738|STNSOUTH MASON STREET|STS|MSAGHARRISONBURG|STAVA|LOCSSC STUDENT SUCCESS CENTER 1 1202 PINNACLE|ARA|NAM FRONT DESK|CLS4|TYR1|ESN|COI|CPFJMU|ZIP22807|CUS000| DAT|FOCC|CTN5405686188|HNO395|STNS. HIGH STREET|STS|MSAGHARRISONBURG|STAVA|LOCMEMH MEMORIAL HALL 2 2002-RADIO BOOTH PINNACLE|ARA|NAMMEMORIAL 2002 TEMPORARY RADIO Ave Richmond VA246/S1253 10 East Franklin SokolowskiJeremiah 40 6168675309 070617 C23284BO|CLS4|TYR1|ESN|COI|CPFJMU|ZIP22807|CUS000| DAT|FOCC|CTN5405684561|HNO395|STNS. HIGH STREET|STS|MSAGHARRISONBURG|STAVA|LOCMEMH MEMORIAL HALL 2 2000 - PRESS BOX PINNACLE|ARA|NAMMEMORIAL BASEBALL TEMPORARY PRES|CLS4|TYR1|ESN|COI|CPFJMU|ZIP22807|CUS000| DAT|FOCC|CTN5405684561|HNO395|STNS. HIGH STREET|STS|MSAGHARRISONBURG|STAVA|LOCMEMH MEMORIAL HALL 2 2000/PRESS BOX BB PINNACLE|ARA|NAMMEMORIAL BASEBALL TEMPORARY PRES|CLS4|TYR1|ESN|COI|CPFJMU|ZIP22807|CUS000| DAT|FOCC|CTN5405684558|HNO395|STNS. HIGH STREET|STS|MSAGHARRISONBURG|STAVA|LOCMEMH MEMORIAL HALL 2 2003/PRESS BOX BB PINNACLE|ARA|NAMMEMORIAL BASEBALL TEMPORARY PRES|CLS4|TYR1|ESN|COI|CPFJMU|ZIP22807|CUS000| DAT|FOCC|CTN5405686545|HNO395|STNS. HIGH STREET|STS|MSAGHARRISONBURG|STAVA|LOCMEMH MEMORIAL HALL 2 2003/PRESS BOX BB PINNACLE|ARA|NAMMEMORIAL BASEBALL TEMPORARY PRES|CLS4|TYR1|ESN|COI|CPFJMU|ZIP22807|CUS000| DAT|FOCC|CTN5405684559|HNO395|STNS. HIGH STREET|STS|MSAGHARRISONBURG|STAVA|LOCMEMH MEMORIAL HALL 2 2004/PRESS BOX BB PINNACLE|ARA|NAMMEMORIAL BASEBALL TEMPORARY PRES|CLS4|TYR1|ESN|COI|CPFJMU|ZIP22807|CUS000| DAT|FOCC|CTN5405684560|HNO395|STNS. HIGH STREET|STS|MSAGHARRISONBURG|STAVA|LOCMEMH MEMORIAL HALL 2 2005/PRESS BOX BB PINNACLE|ARA|NAMMEMORIAL BASEBALL TEMPORARY PRES|CLS4|TYR1|ESN|COI|CPFJMU|ZIP22807|CUS000| DAT|FOCI|CTN5405686192|HNO395|STNS. HIGH STREET|STS|MSAGHARRISONBURG|STAVA|LOCMEMH MEMORIAL HALL 2 2001/PRESS BOX BB PINNACLE|ARA|NAMMEMORIAL 2001 TEMPORARY PRESS BO|CLS4|TYR1|ESN|COI|CPFJMU|ZIP22807|CUS000| TLR|REC000000011| |
Related Pages:
| Child pages (Children Display) | ||
|---|---|---|
|