| pbkey |
char (15) |
pbKey™ unique identifier |
| psapid |
Integer |
unique ID for the PSAP |
| fccid |
Integer |
FCC ID for the PSAP |
| psaptype |
char (20) |
Values: enhanced, basic, military, non-9-1-1 |
| countyname |
char (40) |
Name of the county where the PSAP is located |
| countyfips |
char (5) |
FIPS of the county where the PSAP is located |
| agency |
char (120) |
The name of the PSAP |
| coveragecomments |
char (254) |
Additional comments about the PSAP's coverage |
| psapcomments |
char (254) |
General comments about the PSAP |
| operatorphone |
char (15) |
Emergency number that is answered 24x7 |
| contactprefix |
char (50) |
Prefix (Mr, Mrs, etc.) for the contact person |
| contactfirstname |
char (20) |
First name of contact person |
| contactlastname |
char (20) |
Last name of contact person |
| contacttitle |
char (100) |
Title of contact person |
| contactphone |
char (15) |
Phone number of contact person |
| contactfax |
char (15) |
Fax number of contact person |
| contactemail |
char (50) |
Email address of contact person |
| contactcomments |
char (254) |
Comments regarding contact person |
| mailingstreet |
char (80) |
Street portion of the mailing address of the PSAP |
| mailingcity |
char (40) |
City portion of the mailing address of the PSAP |
| mailingstate |
char (2) |
State portion of the mailing address of the PSAP |
| mailingzip |
char (10) |
Zip code portion of the mailing address of the PSAP |
| sitephone |
char (15) |
Phone number of the PSAP site |
| sitefax |
char (15) |
Fax number of the PSAP site |
| sitestreet |
char (80) |
Street portion of the site address of the PSAP |
| sitecity |
char (40) |
City portion of the site address of the PSAP |
| sitestate |
char (2) |
State portion of the site address of the PSAP |
| sitezip |
char (10) |
Zip code portion of the site address of the PSAP |
| emsagency |
char (120) |
Name of the AHJ |
| emsstreet |
char (80) |
Street portion of the mailing address for the AHJ |
| emscity |
char (40) |
City portion of the mailing address for the AHJ |
| emsstate |
char (2) |
State portion of the mailing address for the AHJ |
| emszip |
char (10) |
Zip code portion of the mailing address for the AHJ |
| emscontactphone |
char (15) |
Phone number of contact person |
| emsalarmphone |
char (15) |
Alarm number for the AHJ |
| emscomments |
char (254) |
Comments for the AJH |
| fireagency |
char (120) |
Name of the AHJ |
| firestreet |
char (80) |
Street portion of the mailing address for the AHJ |
| firecity |
char (40) |
City portion of the mailing address for the AHJ |
| firestate |
char (2) |
State portion of the mailing address for the AHJ |
| firezip |
char (10) |
Zip code portion of the mailing address for the AHJ |
| firecontactphone |
char (15) |
Phone number of contact person |
| firealarmphone |
char (15) |
Alarm number for the AHJ |
| firecomments |
char (254) |
Comments for the AJH |
| policeagency |
char (120) |
Name of the AHJ |
| policestreet |
char (80) |
Street portion of the mailing address for the AHJ |
| policecity |
char (40) |
City portion of the mailing address for the AHJ |
| policestate |
char (2) |
State portion of the mailing address for the AHJ |
| policezip |
char (10) |
Zip code portion of the mailing address for the AHJ |
| policecontactphone |
char (15) |
Phone number of contact person |
| policealarmphone |
char (15) |
Alarm number for the AHJ |
| policecomments |
char (254) |
Comments for the AJH |