...
- 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 this mode, the Report will not be updated within PCR-360's memory but updates will be visible in the output and will be generated quicker than when running normally. - 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.
...
Expand | ||
---|---|---|
| ||
# 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:
...
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
No Format |
---|
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 |
...