CFD_TCFDD_CTP_INS_NOMINATIONS

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CTP_INS_NOM_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 POL_NUM CHARACTER VARYING(20) 20
4 CTP_NOM_SRC CHARACTER VARYING(1) 1
5 NOM_EFF_DATE TIMESTAMP 8
6 NOM_EXPIRY_DATE TIMESTAMP 8
7 ACTDATE TIMESTAMP 8
8 RUN_NUM BIGINT 8
9 RUN_DATE TIMESTAMP 8
10 TXN_SEQ_NUM BIGINT 8
11 TXN_SUBSEQ_NUM BIGINT 8
12 PROCESSED_IND CHARACTER VARYING(2) 2
13 RGSTN_ID BIGINT 8
14 RGSTN_NUM CHARACTER VARYING(20) 20
15 NOM_TYP CHARACTER VARYING(7) 7
16 CVRG_EXPIRY_DATE TIMESTAMP 8
17 MSTR_KEY BIGINT 8
18 CVRG_RENEWED_DATE TIMESTAMP 8
19 VEH_MAKE_ID BIGINT 8
20 VEH_MAKE_CODE CHARACTER VARYING(20) 20
21 VEH_MODEL_ID BIGINT 8
22 VEH_MODEL_CODE CHARACTER VARYING(20) 20
23 VEH_BODYSTYLE_ID BIGINT 8
24 VEH_BODYSTYLE_CODE CHARACTER VARYING(20) 20
25 VEH_CLASS CHARACTER VARYING(2) 2
26 NUM_CYLS CHARACTER VARYING(20) 20
27 TRM_ID BIGINT 8
28 TRM_CODE CHARACTER VARYING(4) 4
29 USG_PURP_ID BIGINT 8
30 USG_PURP_CODE CHARACTER VARYING(20) 20
31 NUM_OF_SEATS BIGINT 8
32 WEIGHT_TARE BIGINT 8
33 EFF_STRT_DATE TIMESTAMP 8
34 EFF_END_DATE TIMESTAMP 8
35 SNPSHT_DATE TIMESTAMP 8
36 SRC_SYS_ID CHARACTER VARYING(5) 5
37 DATA_LOAD_DATE TIMESTAMP 8
38 LOAD_ID BIGINT 8
39 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
40 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
41 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
42 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8