FCM_AIRLINE

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SEQ_FCM_FILES_REC_ID INTEGER 4
2 AIRLINE_CODE CHARACTER VARYING(5) 5
3 AIRLINE_NAME CHARACTER VARYING(30) 30
4 AIRLINE_NUMBER CHARACTER VARYING(5) 5
5 AIRLINE_STATUS CHARACTER VARYING(1) 1
6 DELTA_TYPE CHARACTER VARYING(1) 1
7 EFFECTIVE_STRT_DT TIMESTAMP 8
8 EFFECTIVE_END_DT TIMESTAMP 8
9 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
10 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
11 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
12 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8