(v1) .Enhanced 911 v2.1.4.7

Overview

The Enhance 911 (E911) service creates and exports a file for reporting 911 services. The exported file uses a fixed-length file formatting in accordance with the NENA2 Standard.

Running the E911 Report Manually

Go to 'Admin > Imports / Exports > Export Files'.
Select the 'E911' Record from the Grid, then click the button.
Check the 'Test Mode' checkbox. It is very important to make sure to run the Report manually in 'Test Mode'.
While in Test Mode the exact same queries are run, but nothing is committed.
Click either of the two Export File Buttons.
- Thebutton will display the Report in the browser.
- Thebutton will download the Report to your machine.

CUSTOMER_NAME

The CUSTOMER_NAME field will be populated with the Service Owner. This can be either a person or a department. The report does not differentiate between the two owner types and will simply display the name of the owner.

Location

The Location field is populated by the locations hierarchy. Here are a few examples:

1234 Building Name > Floor 2 > Room 12 would populate as 1234 Building Name Floor 2 Room 12
1234 Building Name > 2 > 12 would populated as 1234 Building Name 2 12
1234 Building Name > 12 would populate as 1234 Building Name 12

PCR-360 provides configuration options to format specific location types as well.

For example, separate each sub-location by a comma and add Floor before each floor in a location field:

1234 Building Name > Floor 2 > Room 12 would be populated as 1234 Building Name, Floor Floor 2, Room 12
1234 Building Name > 12 would be populated as 1234 Building Name, Floor 12

Remove the floors from each location:

1234 Building Name > Floor 2 > Room 12 would be populated as 1234 Building Name Room 12

Custom Location Formatting

Custom Location Formatting uses REGEX to reformat specific Location Types while building the Enhanced 911 reports. It is configured by adding entries into the pcr360.ini file.

The settings are in the following format:
e911.type.<LOCATION_TYPE>.match = <REGEX_STRING>
e911.type.<<LOCATION_TYPE>.replace = '$1'

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/.

Regex Replacement example in the PCR360 INI

Example Usage

Let's say you have a Location like this:

1234 Example Building > 2 > 12

The Location Type for each part is

BUILDING_NUMBER BUILDING_NAME > FLOOR > ROOM

If the Example INI settings below are used on the e911 report, the location will be formatted as:

#1234 > Flr: 2 > Rm: 12

# Floors

# Example: A location type Floor is named "123"

# It would appear on the report as "Flr: 123"

# The config option uses the name (all in caps) of the location type

e911.type.FLOOR.match = '/(.*)/'

e911.type.FLOOR.replace = 'Flr: $1'

# Rooms

# Prepend "Rm: " to all room numbers

# The config option can also use the list ID of the location type

e911.type.178.match = '/(.*)/'

e911.type.178.replace = 'Rm: $1'

# Buildings

# Clear the building names

e911.type.BUILDING.match = '/(.*)/'

e911.type.BUILDING.replace = ''

# Building Numbers

# prepend the number symbol to all Building Numbers

e911.type.BUILDING_NUMBER.match = '/(.*)/'

e911.type.BUILDING_NUMBER.replace = '#$1'

Reported Services

The report will only show a service if ALL of the following conditions are met:

The Building has the Report 911 flag enabled
The Service Catalog has the Report 911 flag enabled
The Service has the Report 911 flag enabled
The service is active or suspended
If a multi-location service, the E911 Location must be set

Unless a service is multi-location, the Report 911 flag is ignored for all locations except buildings.

In the instance of a multi-location service, a single location must have the E911 Location enabled from the Locations grid on the service.

All File Columns

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

I804000000010            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          070617         C23284                                                                                                                                                                                                                                                *
I616867530910            E Franklin                                                    Ave   Richmond                        VA246/S1253 10 East Franklin                                  SokolowskiJeremiah              40         6168675309          070617         C23284

Related Pages: