CDI_TCFDR_CUSTOMER_INDICATORS

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PRDT_HOLDING_NUM CHARACTER VARYING(20) 20
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 AGENT_ID DOUBLE PRECISION 8
4 AGENT_CODE CHARACTER VARYING(20) 20
5 AGENT_DESC CHARACTER VARYING(300) 300
6 BRANCH_ID DOUBLE PRECISION 8
7 BRANCH_CODE CHARACTER VARYING(20) 20
8 BRANCH_DESC CHARACTER VARYING(50) 50
9 CHANNEL_ID DOUBLE PRECISION 8
10 CHANNEL_CODE CHARACTER VARYING(20) 20
11 CHANNEL_DESC CHARACTER VARYING(50) 50
12 CHNL_TYP_CODE CHARACTER VARYING(20) 20
13 BRKR_TYP_ID DOUBLE PRECISION 8
14 BRKR_CODE CHARACTER VARYING(20) 20
15 BRKR_DESC CHARACTER VARYING(50) 50
16 EFF_STRT_DATE TIMESTAMP 8
17 EFF_END_DATE TIMESTAMP 8
18 IFA_INDICATOR CHARACTER VARYING(2) 2
19 FA_INDICATOR CHARACTER VARYING(2) 2
20 CA_INDICATOR CHARACTER VARYING(2) 2
21 HOME_LOAN_BROKER_INDICATOR CHARACTER VARYING(2) 2
22 BB_BROKER_INDICATOR CHARACTER VARYING(2) 2
23 ODLIMIT NUMERIC(15,5) 19
24 SENIOR_DISC_IND CHARACTER VARYING(2) 2
25 MULTI_POL_DISC_IND CHARACTER VARYING(2) 2
26 OVR_55_DISC_IND CHARACTER VARYING(2) 2
27 COMBINED_DISC_IND CHARACTER VARYING(2) 2
28 STAFF_DISC_IND CHARACTER VARYING(2) 2
29 ALM_DISC_IND CHARACTER VARYING(2) 2
30 RETIREE_DISC_IND CHARACTER VARYING(2) 2
31 POL_DISC_IND CHARACTER VARYING(2) 2
32 SECURE_DISC_IND CHARACTER VARYING(2) 2
33 STAFF_FAMILY_DISC_IND CHARACTER VARYING(2) 2
34 FAMILY_NO_CLM_DISC_IND CHARACTER VARYING(2) 2
35 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
36 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
37 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
38 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8