Document toolboxDocument toolbox

(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

  1. Go to 'Admin > Imports / Exports > Export Files'.
    Export File page example

  2. Select the 'E911' Record from the Grid, then click the Generate Selectedbutton.
  3. 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.
    Generate Export File in Test Mode example

  4. Click either of the two Export File Buttons.
    • TheView Export Filebutton will display the Report in the browser.
    • TheDownload Export Filebutton 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:

Help Desk Portal - Email: help@pcr.com - Phone: 616.259.9242