CFD_TCFDD_LIFE_POL_CUST_LETTER

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_SYS_CODE CHARACTER VARYING(10) 10
2 PRDT_SYS_CUST_NUM CHARACTER VARYING(20) 20
3 LETTER_TYP_CODE CHARACTER VARYING(20) 20
4 LETTER_SEQ_NUM CHARACTER VARYING(20) 20
5 EFF_STRT_DATE TIMESTAMP 8
6 LETTER_TYP_ID BIGINT 8
7 LIFE_POL_ID BIGINT 8
8 POL_NUM CHARACTER VARYING(20) 20
9 LETTER_STAT_ID BIGINT 8
10 LETTER_STAT_CODE CHARACTER VARYING(20) 20
11 LETTER_REQ_DATE TIMESTAMP 8
12 LETTER_PRT_DATE TIMESTAMP 8
13 TXN_NUM BIGINT 8
14 LST_UPD_DATE TIMESTAMP 8
15 LST_UPD_TS TIMESTAMP 8
16 EFF_END_DATE TIMESTAMP 8
17 DATA_LOAD_DATE TIMESTAMP 8
18 SNPSHT_DATE TIMESTAMP 8
19 SRC_SYS_ID CHARACTER VARYING(5) 5
20 LOAD_ID BIGINT 8
21 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
22 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
24 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8