| 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 | |
| TCO_KIND | varchar | 1 | 0 | YES | |
| PILOT_SCHL | varchar | 1 | 0 | YES | |
| PROVSNL_PILOT_SCHL | varchar | 1 | 0 | YES | |
| FLIGHT_GROUND | varchar | 1 | 0 | YES | |
| GROUND | varchar | 1 | 0 | YES | |
| ACTIVE_SATELLITES | varchar | 1 | 0 | YES | |
| ASSOC_COLLEGE_UNIV | varchar | 1 | 0 | YES | |
| CERT_INSTR_NO | numeric | 11 | 0 | YES | |
| AW_PERSONNEL_NO | numeric | 11 | 0 | YES | |
| CHF_ASST_CHF_INSTR_NO | numeric | 11 | 0 | YES | |
| CHECK_INSTR_NO | numeric | 11 | 0 | YES | |
| ACR_NO | numeric | 11 | 0 | YES | |
| AVG_YR_ENROLL_NO | numeric | 11 | 0 | YES | |
| RATINGS_COURS_NO | numeric | 11 | 0 | YES | |
| AIRCRFT_UN91409E_NO | numeric | 11 | 0 | YES | |
| AIRCRFT_NO | numeric | 11 | 0 | YES | |
| RPC_PLANE_SEL | varchar | 1 | 0 | YES | |
| RPC_PLANE_SES | varchar | 1 | 0 | YES | |
| RPC_ROTOR_HELI | varchar | 1 | 0 | YES | |
| RPC_ROTOR_GYRO | varchar | 1 | 0 | YES | |
| RPC_TTS_PLANE_SEL | varchar | 1 | 0 | YES | |
| RPC_TTS_PLANE_SES | varchar | 1 | 0 | YES | |
| RPC_TTS_ROTOR_HELI | varchar | 1 | 0 | YES | |
| RPC_TTS_ROTOR_GYRO | varchar | 1 | 0 | YES | |
| RPC_ACC_PLANE_SEL | varchar | 1 | 0 | YES | |
| RPC_ACC_PLANE_SES | varchar | 1 | 0 | YES | |
| RPC_ACC_ROTOR_HELI | varchar | 1 | 0 | YES | |
| RPC_ACC_ROTOR_GYRO | varchar | 1 | 0 | YES | |
| PPC_PLANE_MEL | varchar | 1 | 0 | YES | |
| PPC_PLANE_MES | varchar | 1 | 0 | YES | |
| PPC_PLANE_SEL | varchar | 1 | 0 | YES | |
| PPC_PLANE_SES | varchar | 1 | 0 | YES | |
| PPC_GLIDER | varchar | 1 | 0 | YES | |
| PPC_LTA_AIRSHIP | varchar | 1 | 0 | YES | |
| PPC_LTA_BALLOON | varchar | 1 | 0 | YES | |
| PPC_ROTOR_HELI | varchar | 1 | 0 | YES | |
| PPC_ROTOR_GYRO | varchar | 1 | 0 | YES | |
| PPC_POWER_LIFT | varchar | 1 | 0 | YES | |
| PPC_TTS_PLANE_MEL | varchar | 1 | 0 | YES | |
| PPC_TTS_PLANE_MES | varchar | 1 | 0 | YES | |
| PPC_TTS_PLANE_SEL | varchar | 1 | 0 | YES | |
| PPC_TTS_PLANE_SES | varchar | 1 | 0 | YES | |
| PPC_TTS_GLIDER | varchar | 1 | 0 | YES | |
| PPC_TTS_LTA_AIRSHIP | varchar | 1 | 0 | YES | |
| PPC_TTS_LTA_BALLOON | varchar | 1 | 0 | YES | |
| PPC_TTS_ROTOR_HELI | varchar | 1 | 0 | YES | |
| PPC_TTS_ROTOR_GYRO | varchar | 1 | 0 | YES | |
| PPC_TTS_POWER_LIFT | varchar | 1 | 0 | YES | |
| PPC_ACC_PLANE_MEL | varchar | 1 | 0 | YES | |
| PPC_ACC_PLANE_MES | varchar | 1 | 0 | YES | |
| PPC_ACC_PLANE_SEL | varchar | 1 | 0 | YES | |
| PPC_ACC_PLANE_SES | varchar | 1 | 0 | YES | |
| PPC_ACC_GLIDER | varchar | 1 | 0 | YES | |
| PPC_ACC_LTA_AIRSHIP | varchar | 1 | 0 | YES | |
| PPC_ACC_LTA_BALLOON | varchar | 1 | 0 | YES | |
| PPC_ACC_ROTOR_HELI | varchar | 1 | 0 | YES | |
| PPC_ACC_ROTOR_GYRO | varchar | 1 | 0 | YES | |
| PPC_ACC_POWER_LIFT | varchar | 1 | 0 | YES | |
| CPC_PLANE_MEL | varchar | 1 | 0 | YES | |
| CPC_PLANE_MES | varchar | 1 | 0 | YES | |
| CPC_PLANE_SEL | varchar | 1 | 0 | YES | |
| CPC_PLANE_SES | varchar | 1 | 0 | YES | |
| CPC_GLIDER | varchar | 1 | 0 | YES | |
| CPC_LTA_AIRSHIP | varchar | 1 | 0 | YES | |
| CPC_LTA_BALLOON | varchar | 1 | 0 | YES | |
| CPC_ROTOR_HELI | varchar | 1 | 0 | YES | |
| CPC_ROTOR_GYRO | varchar | 1 | 0 | YES | |
| CPC_POWER_LIFT | varchar | 1 | 0 | YES | |
| CPC_TTS_PLANE_MEL | varchar | 1 | 0 | YES | |
| CPC_TTS_PLANE_MES | varchar | 1 | 0 | YES | |
| CPC_TTS_PLANE_SEL | varchar | 1 | 0 | YES | |
| CPC_TTS_PLANE_SES | varchar | 1 | 0 | YES | |
| CPC_TTS_GLIDER | varchar | 1 | 0 | YES | |
| CPC_TTS_LTA_AIRSHIP | varchar | 1 | 0 | YES | |
| CPC_TTS_LTA_BALLOON | varchar | 1 | 0 | YES | |
| CPC_TTS_ROTOR_HELI | varchar | 1 | 0 | YES | |
| CPC_TTS_ROTOR_GYRO | varchar | 1 | 0 | YES | |
| CPC_TTS_POWER_LIFT | varchar | 1 | 0 | YES | |
| CPC_ACC_PLANE_MEL | varchar | 1 | 0 | YES | |
| CPC_ACC_PLANE_MES | varchar | 1 | 0 | YES | |
| CPC_ACC_PLANE_SEL | varchar | 1 | 0 | YES | |
| CPC_ACC_PLANE_SES | varchar | 1 | 0 | YES | |
| CPC_ACC_GLIDER | varchar | 1 | 0 | YES | |
| CPC_ACC_LTA_AIRSHIP | varchar | 1 | 0 | YES | |
| CPC_ACC_LTA_BALLOON | varchar | 1 | 0 | YES | |
| CPC_ACC_ROTOR_HELI | varchar | 1 | 0 | YES | |
| CPC_ACC_ROTOR_GYRO | varchar | 1 | 0 | YES | |
| CPC_ACC_POWER_LIFT | varchar | 1 | 0 | YES | |
| ATP_PLANE_MEL | varchar | 1 | 0 | YES | |
| ATP_PLANE_MES | varchar | 1 | 0 | YES | |
| ATP_PLANE_SEL | varchar | 1 | 0 | YES | |
| ATP_PLANE_SES | varchar | 1 | 0 | YES | |
| ATP_ROTOR_HELI | varchar | 1 | 0 | YES | |
| ATP_POWER_LIFT | varchar | 1 | 0 | YES | |
| ATP_TTS_PLANE_MEL | varchar | 1 | 0 | YES | |
| ATP_TTS_PLANE_MES | varchar | 1 | 0 | YES | |
| ATP_TTS_PLANE_SEL | varchar | 1 | 0 | YES | |
| ATP_TTS_PLANE_SES | varchar | 1 | 0 | YES | |
| ATP_TTS_ROTOR_HELI | varchar | 1 | 0 | YES | |
| ATP_TTS_POWER_LIFT | varchar | 1 | 0 | YES | |
| ATP_ACC_PLANE_MEL | varchar | 1 | 0 | YES | |
| ATP_ACC_PLANE_MES | varchar | 1 | 0 | YES | |
| ATP_ACC_PLANE_SEL | varchar | 1 | 0 | YES | |
| ATP_ACC_PLANE_SES | varchar | 1 | 0 | YES | |
| ATP_ACC_ROTOR_HELI | varchar | 1 | 0 | YES | |
| ATP_ACC_POWER_LIFT | varchar | 1 | 0 | YES | |
| INS_RATING_PLANE | varchar | 1 | 0 | YES | |
| INS_RATING_ROTOR_HELI | varchar | 1 | 0 | YES | |
| INS_RATING_POWER_LIFT | varchar | 1 | 0 | YES | |
| INS_RATING_TTS_PLANE | varchar | 1 | 0 | YES | |
| INS_RATING_TTS_ROTOR_HELI | varchar | 1 | 0 | YES | |
| INS_RATING_TTS_POWER_LIFT | varchar | 1 | 0 | YES | |
| ADD_INS_RATING_PLANE | varchar | 1 | 0 | YES | |
| ADD_INS_RATING_ROTOR_HELI | varchar | 1 | 0 | YES | |
| ADD_INS_RATING_POWER_LIFT | varchar | 1 | 0 | YES | |
| ADD_INS_RATING_TTS_PLANE | varchar | 1 | 0 | YES | |
| ADD_INS_RATING_TTS_ROTOR_HELI | varchar | 1 | 0 | YES | |
| ADD_INS_RATING_TTS_POWER_LIFT | varchar | 1 | 0 | YES | |
| CFI_PLANE_ME | varchar | 1 | 0 | YES | |
| CFI_PLANE_SE | varchar | 1 | 0 | YES | |
| CFI_GLIDER | varchar | 1 | 0 | YES | |
| CFI_ROTOR_HELI | varchar | 1 | 0 | YES | |
| CFI_ROTOR_GYRO | varchar | 1 | 0 | YES | |
| CFI_POWER_LIFT | varchar | 1 | 0 | YES | |
| CFI_TTS_PLANE_ME | varchar | 1 | 0 | YES | |
| CFI_TTS_PLANE_SE | varchar | 1 | 0 | YES | |
| CFI_TTS_ROTOR_HELI | varchar | 1 | 0 | YES | |
| CFI_TTS_GLIDER | varchar | 1 | 0 | YES | |
| CFI_TTS_ROTOR_GYRO | varchar | 1 | 0 | YES | |
| CFI_TTS_POWER_LIFT | varchar | 1 | 0 | YES | |
| CFI_INS_PLANE | varchar | 1 | 0 | YES | |
| CFI_INS_ROTOR_HELI | varchar | 1 | 0 | YES | |
| CFI_INS_POWER_LIFT | varchar | 1 | 0 | YES | |
| CFI_INS_TTS_PLANE | varchar | 1 | 0 | YES | |
| CFI_INS_TTS_ROTOR_HELI | varchar | 1 | 0 | YES | |
| CFI_INS_TTS_POWER_LIFT | varchar | 1 | 0 | YES | |
| AGRI_ACFT_OP_MEL | varchar | 1 | 0 | YES | |
| AGRI_ACFT_OP_MES | varchar | 1 | 0 | YES | |
| AGRI_ACFT_OP_SEL | varchar | 1 | 0 | YES | |
| AGRI_ACFT_OP_SES | varchar | 1 | 0 | YES | |
| AGRI_ACFT_OP_ROTOR_HELI | varchar | 1 | 0 | YES | |
| AGRI_ACFT_OP_ROTOR_GYRO | varchar | 1 | 0 | YES | |
| AGRI_ACFT_OP_POWER_LIFT | varchar | 1 | 0 | YES | |
| TEST_PILOT_MEL | varchar | 1 | 0 | YES | |
| TEST_PILOT_MES | varchar | 1 | 0 | YES | |
| TEST_PILOT_SEL | varchar | 1 | 0 | YES | |
| TEST_PILOT_SES | varchar | 1 | 0 | YES | |
| TEST_PILOT_ROTOR_HELI | varchar | 1 | 0 | YES | |
| TEST_PILOT_ROTOR_GYRO | varchar | 1 | 0 | YES | |
| TEST_PILOT_POWER_LIFT | varchar | 1 | 0 | YES | |
| TEST_PILOT_GLIDER | varchar | 1 | 0 | YES | |
| TEST_PILOT_LTA_AIRSHIP | varchar | 1 | 0 | YES | |
| TEST_PILOT_LTA_BALLOON | varchar | 1 | 0 | YES | |
| PGS_RPC | varchar | 1 | 0 | YES | |
| PGS_RPC_TTS | varchar | 1 | 0 | YES | |
| PGS_RPC_ACC | varchar | 1 | 0 | YES | |
| PGS_PPC | varchar | 1 | 0 | YES | |
| PGS_PPC_TTS | varchar | 1 | 0 | YES | |
| PGS_PPC_ACC | varchar | 1 | 0 | YES | |
| PGS_CPC | varchar | 1 | 0 | YES | |
| PGS_CPC_TTS | varchar | 1 | 0 | YES | |
| PGS_CPC_ACC | varchar | 1 | 0 | YES | |
| PGS_ATP | varchar | 1 | 0 | YES | |
| PGS_ATP_TTS | varchar | 1 | 0 | YES | |
| PGS_ATP_ACC | varchar | 1 | 0 | YES | |
| PGS_INS_RATING | varchar | 1 | 0 | YES | |
| PGS_INS_RATING_TTS | varchar | 1 | 0 | YES | |
| PGS_ADD_INS_RATING | varchar | 1 | 0 | YES | |
| PGS_ADD_INS_RATING_TTS | varchar | 1 | 0 | YES | |
| PGS_CFI | varchar | 1 | 0 | YES | |
| PGS_CFI_TTS | varchar | 1 | 0 | YES | |
| PGS_CFI_INS | varchar | 1 | 0 | YES | |
| PGS_CFI_INS_TTS | varchar | 1 | 0 | YES | |
| PGS_ROTOR_EXT_LOAD_OP | varchar | 1 | 0 | YES | |
| PGS_AGRI_ACFT_OP | varchar | 1 | 0 | YES | |
| PGS_TEST_PILOT | varchar | 1 | 0 | YES | |
| GROUND_INSTR_BASIC | varchar | 1 | 0 | YES | |
| GROUND_INSTR_ADV | varchar | 1 | 0 | YES | |
| GROUND_INSTR_INS | varchar | 1 | 0 | YES | |
| PRC | varchar | 1 | 0 | YES | |
| PRC_CAT_CLASS | varchar | 1 | 0 | YES | |
| PRC_INS | varchar | 1 | 0 | YES | |
| SPEC_OPS | varchar | 1 | 0 | YES | |
| AIRCRAFT_TYPE_RATING | varchar | 1 | 0 | YES | |
| FUNDAMENTALS | varchar | 1 | 0 | YES | |
| ROTOR_EXT_LOAD_OP_HELI | varchar | 1 | 0 | YES | |
| ROTOR_EXT_LOAD_OP_GYRO | varchar | 1 | 0 | YES | |
| OTH_REFRESH_FLT_INSTR | varchar | 1 | 0 | YES | |
| OTH_REFRESH_GRND_INSTR | varchar | 1 | 0 | YES | |
| DATE_TIME_STAMP | timestamp | 8 | 0 | YES | |
| ADDED_TIMESTAMP | timestamp | 8 | 0 | NO | |
| MODIFIED_TIMESTAMP | timestamp | 8 | 0 | YES | |
