Table description for OPR AGENCY in subject area OPERATOR
| Home | Free Reports and Queries Fee Based Services Database Description Database Access |
| COLUMN NAME | DATA TYPE | LENGTH | PRECISION | NULLABLE | COMMENT |
|---|---|---|---|---|---|
| DSGN_CODE | varchar | 4 | 0 | NO | |
| CERT_HOLDING_RO | varchar | 2 | 0 | YES | |
| CERT_HOLDING_DO | varchar | 2 | 0 | YES | |
| GEOGRAPHIC_RO | varchar | 2 | 0 | YES | |
| GEOGRAPHIC_DO | varchar | 2 | 0 | YES | |
| FAR_PART_NUM | varchar | 3 | 0 | YES | |
| PARENT_DSGN | varchar | 4 | 0 | YES | |
| AIRPORT_ID | varchar | 4 | 0 | YES | |
| FOREIGN_FLAG | varchar | 1 | 0 | YES | |
| TOTAL_EMP | numeric | 11 | 0 | YES | |
| ASSOC_REF_ID | varchar | 25 | 0 | YES | |
| SPEC_PURPOSE | varchar | 12 | 0 | YES | |
| NATNL_USE | varchar | 9 | 0 | YES | |
| POI | varchar | 7 | 0 | YES | |
| PMI | varchar | 7 | 0 | YES | |
| PAI | varchar | 7 | 0 | YES | |
| CERT_NO | varchar | 8 | 0 | YES | |
| CERT_STATUS | varchar | 1 | 0 | YES | |
| SATL_STATUS | varchar | 1 | 0 | YES | |
| AGENCY_NAME | varchar | 50 | 0 | YES | |
| AGENCY_ADDR1 | varchar | 35 | 0 | YES | |
| AGENCY_ADDR2 | varchar | 35 | 0 | YES | |
| AGENCY_ADDR3 | varchar | 35 | 0 | YES | |
| AGENCY_CITY | varchar | 22 | 0 | YES | |
| AGENCY_STATE | varchar | 2 | 0 | YES | |
| AGENCY_ZIP | varchar | 10 | 0 | YES | |
| AGENCY_COUNTRY | varchar | 2 | 0 | YES | |
| AGENCY_PHONE | varchar | 10 | 0 | YES | |
| AGENCY_ALT_PHONE | varchar | 10 | 0 | YES | |
| AGENCY_FRGN_PHONE | varchar | 16 | 0 | YES | |
| AGENCY_FAX | varchar | 16 | 0 | YES | |
| AGENCY_INTERNET | varchar | 50 | 0 | YES | |
| AGENCY_MAIL_ADDR1 | varchar | 35 | 0 | YES | |
| AGENCY_MAIL_ADDR2 | varchar | 35 | 0 | YES | |
| AGENCY_MAIL_ADDR3 | varchar | 35 | 0 | YES | |
| AGENCY_MAIL_CITY | varchar | 22 | 0 | YES | |
| AGENCY_MAIL_STATE | varchar | 2 | 0 | YES | |
| AGENCY_MAIL_COUNTRY | varchar | 2 | 0 | YES | |
| AGENCY_MAIL_ZIP | varchar | 10 | 0 | YES | |
| CEO_NAME | varchar | 50 | 0 | YES | |
| CEO_TITLE | varchar | 50 | 0 | YES | |
| CEO_PHONE | varchar | 10 | 0 | YES | |
| CEO_PHONE_EXT | varchar | 4 | 0 | YES | |
| CEO_FAX | varchar | 16 | 0 | YES | |
| CEO_FRGN_PHONE | varchar | 16 | 0 | YES | |
| CEO_INTERNET | varchar | 50 | 0 | YES | |
| COMP_LIAISN | varchar | 50 | 0 | YES | |
| LIAISN_TITLE | varchar | 50 | 0 | YES | |
| LIAISN_PHONE | varchar | 10 | 0 | YES | |
| LIAISN_PHONE_EXT | varchar | 4 | 0 | YES | |
| LIAISN_FAX | varchar | 16 | 0 | YES | |
| LIAISN_FRGN_PHONE | varchar | 16 | 0 | YES | |
| LIAISN_INTERNET | varchar | 50 | 0 | YES | |
| STATUS_DATE | date | 4 | 0 | YES | |
| CURR_ISSUE_DATE | date | 4 | 0 | YES | |
| ORIG_ISSUE_DATE | date | 4 | 0 | YES | |
| SATL_STATUS_DATE | date | 4 | 0 | YES | |
| EXPIR_DATE | date | 4 | 0 | YES | |
| VALID_DATE | date | 4 | 0 | YES | |
| DATE_TIME_STAMP | timestamp | 8 | 0 | YES | |
| DELETE_FLAG | varchar | 1 | 0 | YES | |
| DOWN_FLAG | varchar | 1 | 0 | YES | |
| DOWN_REGION | varchar | 2 | 0 | YES | |
| DOWN_DISTRICT | varchar | 2 | 0 | YES | |
| DOWN_DATE | date | 4 | 0 | YES | |
| FSDO_MAINT_DATE | date | 4 | 0 | YES | |
| ADDED_TIMESTAMP | timestamp | 8 | 0 | NO | |
| MODIFIED_TIMESTAMP | timestamp | 8 | 0 | YES |
| Legal | Copyright 2001 - 2004 AviationDB.com Corp. All Rights Reserved | Contact Us |