CDI_MCFD_RB_DDA

Database

SDSNZS01_CFDM

Schema

CDCPADM_CFDM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 DPTS_PRDT_HOLDNG_ID BIGINT 8
2 PRDT_SYS_CODE CHARACTER VARYING(10) 10
3 PRDT_HOLDNG_NUM CHARACTER VARYING(20) 20
4 PRDT_HOLDNG_ID BIGINT 8
5 CMPY_CODE CHARACTER VARYING(10) 10
6 PRDT_SYS_PRDT_CODE CHARACTER VARYING(20) 20
7 PRDT_SYS_ACCT_NUM CHARACTER VARYING(20) 20
8 PRDT_ID BIGINT 8
9 PRDT_GRP_CODE CHARACTER VARYING(20) 20
10 PRDT_TYP_CODE CHARACTER VARYING(20) 20
11 PRDT_DESC CHARACTER VARYING(100) 100
12 PRDT_SEGMENT_GRP_ID BIGINT 8
13 PRDT_SEGMENT_GRP_CODE CHARACTER VARYING(20) 20
14 PRDT_BRND_ID BIGINT 8
15 PRDT_BRND_CODE CHARACTER VARYING(20) 20
16 PRDT_BRND_DESC CHARACTER VARYING(50) 50
17 CHNL_ID BIGINT 8
18 CHNL_TYP_CODE CHARACTER VARYING(20) 20
19 CHNL_CODE CHARACTER VARYING(10) 10
20 CHNL_DESC CHARACTER VARYING(50) 50
21 SERV_BRCH_ID BIGINT 8
22 SERV_BRCH_CODE CHARACTER VARYING(20) 20
23 SERV_BRCH_DESC CHARACTER VARYING(300) 300
24 ACCT_STAT_ID BIGINT 8
25 ACCT_STAT_CODE CHARACTER VARYING(20) 20
26 ACCT_STAT_DESC CHARACTER VARYING(300) 300
27 INT_CALC_METH_ID BIGINT 8
28 INT_CALC_METH_CODE CHARACTER VARYING(20) 20
29 INT_CALC_METH_DESC CHARACTER VARYING(100) 100
30 INT_WAIVE_RSN_ID BIGINT 8
31 INT_WAIVE_RSN_CODE CHARACTER VARYING(20) 20
32 INT_WAIVE_RSN_DESC CHARACTER VARYING(100) 100
33 STMT_CYC_ID BIGINT 8
34 STMT_CYC_CODE CHARACTER VARYING(10) 10
35 STMT_CYC_DESC CHARACTER VARYING(100) 100
36 PAYT_METH_ID BIGINT 8
37 PAYT_METH_CODE CHARACTER VARYING(10) 10
38 PAYT_METH_DESC CHARACTER VARYING(50) 50
39 INT_PAY_CYC_ID BIGINT 8
40 INT_PAY_CYC_CODE CHARACTER VARYING(10) 10
41 INT_PAY_CYC_DESC CHARACTER VARYING(100) 100
42 CNTL_BRCH_ID BIGINT 8
43 CNTL_BRCH_CODE CHARACTER VARYING(20) 20
44 CNTL_BRCH_DESC CHARACTER VARYING(300) 300
45 SCND_OFCR_ID BIGINT 8
46 SCND_OFCR_CODE CHARACTER VARYING(20) 20
47 SCND_OFCR_DESC CHARACTER VARYING(100) 100
48 ANZSIC_TYP_ID BIGINT 8
49 ANZSIC_TYP_CODE CHARACTER VARYING(20) 20
50 ANZSIC_TYP_DESC CHARACTER VARYING(100) 100
51 DPTS_OPENING_DATE DATE 4
52 DPTS_OPENING_AMT NUMERIC(18,6) 19
53 DPTS_CLSD_DATE DATE 4
54 CLOSING_RSN_ID BIGINT 8
55 CLOSING_RSN_CODE CHARACTER VARYING(10) 10
56 CLOSING_RSN_DESC CHARACTER VARYING(100) 100
57 ORG_BRCH_ID BIGINT 8
58 ORG_BRCH_CODE CHARACTER VARYING(20) 20
59 ORG_BRCH_DESC CHARACTER VARYING(300) 300
60 COST_CENTRE_CODE CHARACTER VARYING(20) 20
61 BRKR_ID BIGINT 8
62 BRKR_CODE CHARACTER VARYING(10) 10
63 BRKR_DESC CHARACTER VARYING(300) 300
64 SALES_OFCR_ID BIGINT 8
65 SALES_OFCR_CODE CHARACTER VARYING(20) 20
66 SALES_OFCR_DESC CHARACTER VARYING(50) 50
67 APRVL_OFCR_ID BIGINT 8
68 APRVL_OFCR_CODE CHARACTER VARYING(10) 10
69 APRVL_OFCR_DESC CHARACTER VARYING(100) 100
70 PACKAGE_CODE CHARACTER VARYING(20) 20
71 TAX_WITHHOLDING_ID BIGINT 8
72 TAX_WITHHOLDING_CODE CHARACTER VARYING(4) 4
73 TAX_WITHHOLDING_DESC CHARACTER VARYING(100) 100
74 OVERDRAWN_DATE DATE 4
75 EFF_STRT_DATE DATE 4
76 EFF_END_DATE DATE 4
77 DATA_LOAD_DATE DATE 4
78 SNPSHT_DATE DATE 4
79 SRC_SYS_ID CHARACTER VARYING(5) 5
80 LOAD_ID BIGINT 8
81 AGRESSIVE_LOAD_IND CHARACTER VARYING(1) 1
82 SERV_CHRG_CALC_METH_ID BIGINT 8
83 SERV_CHRG_CALC_METH_CODE CHARACTER VARYING(10) 10
84 SERV_CHRG_CALC_METH_DESC CHARACTER VARYING(100) 100
85 SERV_CHRG_WAIVER_ID BIGINT 8
86 SERV_CHRG_WAIVER_CODE CHARACTER VARYING(10) 10
87 SERV_CHRG_WAIVER_DESC CHARACTER VARYING(100) 100
88 SERV_CHRG_CYC_ID BIGINT 8
89 SERV_CHRG_CYC_CODE CHARACTER VARYING(10) 10
90 SERV_CHRG_CYC_DESC CHARACTER VARYING(100) 100
91 DR_INT_ID BIGINT 8
92 DR_INT_CODE CHARACTER VARYING(10) 10
93 DR_INT_DESC CHARACTER VARYING(100) 100
94 DR_INT_PAY_CYC_ID BIGINT 8
95 DR_INT_PAY_CYC_CODE CHARACTER VARYING(10) 10
96 DR_INT_PAY_CYC_DESC CHARACTER VARYING(100) 100
97 STMT_BRCH_ID BIGINT 8
98 STMT_BRCH_CODE CHARACTER VARYING(20) 20
99 STMT_BRCH_DESC CHARACTER VARYING(300) 300
100 PNDG_PACKAGE_CODE CHARACTER VARYING(10) 10
101 PACKAGE_ROLE_ID BIGINT 8
102 PACKAGE_ROLE_CODE CHARACTER VARYING(10) 10
103 PACKAGE_ROLE_DESC CHARACTER VARYING(100) 100
104 OFFSET_ASSC_ACCT_NUM BIGINT 8
105 PNDG_OFFSET_DATE DATE 4
106 PNDG_MTGE_OFFSET_FLG CHARACTER VARYING(3) 3
107 BUS_MTGE_OFFSET_ID BIGINT 8
108 BUS_MTGE_OFFSET_CODE CHARACTER VARYING(4) 4
109 BUS_MTGE_OFFSET_DESC CHARACTER VARYING(100) 100
110 WAIVE_CODE_EXPIRY_DATE DATE 4
111 RESERVE_WAIVE_ID BIGINT 8
112 RESERVE_WAIVE_CODE CHARACTER VARYING(10) 10
113 RESERVE_WAIVE_DESC CHARACTER VARYING(100) 100
114 RESERVE_WAIVE_CODE_EXPIRY_DATE DATE 4
115 WRITE_OFF_AMT NUMERIC(18,6) 19
116 WRITE_OFF_RSN_ID BIGINT 8
117 WRITE_OFF_RSN_CODE CHARACTER VARYING(10) 10
118 WRITE_OFF_RSN_DESC CHARACTER VARYING(100) 100
119 DR_INT_WAIVE_ID BIGINT 8
120 DR_INT_WAIVE_CODE CHARACTER VARYING(10) 10
121 DR_INT_WAIVE_DESC CHARACTER VARYING(100) 100
122 BAL_PSTG_TYP_ID BIGINT 8
123 BAL_PSTG_TYP_CODE CHARACTER VARYING(10) 10
124 BAL_PSTG_TYP_DESC CHARACTER VARYING(110) 110
125 ACRDTD_BRKR_ID BIGINT 8
126 ACRDTD_BRKR_CODE CHARACTER VARYING(20) 20
127 ACRDTD_BRKR_DESC CHARACTER VARYING(300) 300
128 OD_SERV_FEE_WAIVE_APPLD_DATE DATE 4
129 PROMOTIONAL_BONUS_INT_RT NUMERIC(18,6) 19
130 PROMOTIONAL_BONUS_STRT_DATE DATE 4
131 PROMOTIONAL_BONUS_END_DATE DATE 4
132 PROMOTIONAL_INT_RT_ID BIGINT 8
133 PROMOTIONAL_INT_RT_CODE CHARACTER VARYING(4) 4
134 PROMOTIONAL_INT_RT_DESC CHARACTER VARYING(100) 100
135 ACCT_BAL_XS_DATE DATE 4
136 EFF_STRT_DATE_DTL DATE 4
137 EFF_END_DATE_DTL DATE 4
138 SNPSHT_DATE_DTL DATE 4
139 DATA_LOAD_DATE_DTL DATE 4
140 SRC_SYS_ID_DTL CHARACTER VARYING(5) 5
141 LOAD_ID_DTL BIGINT 8
142 AGGRESSIVE_LOAD_IND_DTL CHARACTER VARYING(3) 3
143 DATE_ID_DLY BIGINT 8
144 DLY_SNP_DATE DATE 4
145 CRNT_ACCT_BAL_AMT NUMERIC(18,6) 19
146 CRNT_COLCTD_BAL_AMT NUMERIC(18,6) 19
147 LST_CYC_DATE DATE 4
148 LST_STMT_DATE DATE 4
149 LST_CUST_CNTCT_DATE DATE 4
150 LST_CUST_WDL_DATE DATE 4
151 LST_CUST_DPTS_DATE DATE 4
152 TOT_INT_PAID_AMT NUMERIC(18,6) 19
153 TOT_CUST_DR_TXN_CNT BIGINT 8
154 TOT_PAPER_DR_TXN_CNT BIGINT 8
155 ACH_WDL_CNT BIGINT 8
156 POS_DR_CNT BIGINT 8
157 AUTO_TFR_DR_CNT BIGINT 8
158 CTD_CHQ_CNT BIGINT 8
159 CTD_CHQ_DISHONOUR_CNT BIGINT 8
160 CTD_ACRD_INT_AMT NUMERIC(18,6) 19
161 LST_ACCT_MAINT_DATE DATE 4
162 DATA_LOAD_DATE_DLY DATE 4
163 SNPSHT_DATE_DLY DATE 4
164 SRC_SYS_ID_DLY CHARACTER VARYING(5) 5
165 LOAD_ID_DLY BIGINT 8
166 AGGRESSIVE_LOAD_IND_DLY CHARACTER VARYING(3) 3
167 DATE_ID_MTHY BIGINT 8
168 MTHY_SNP_DATE DATE 4
169 CRNT_ACCT_BAL_AMT_MTHY NUMERIC(18,6) 19
170 CRNT_COLCTD_BAL_AMT_MTHY NUMERIC(18,6) 19
171 LST_CYC_DATE_MTHY DATE 4
172 LST_STMT_DATE_MTHY DATE 4
173 TOT_INT_PAID_AMT_MTHY NUMERIC(18,6) 19
174 OVERDRAWN_DATE_MTHY DATE 4
175 MTD_AGG_BAL_AMT NUMERIC(18,6) 19
176 MTD_AGG_DAY_CNT BIGINT 8
177 MTD_LOW_BAL_AMT NUMERIC(18,6) 19
178 MTD_HIGH_BAL_AMT NUMERIC(18,6) 19
179 MTD_ACRD_INT_AMT NUMERIC(18,6) 19
180 MTD_INT_PAID_AMT NUMERIC(18,6) 19
181 MTD_ACRD_DR_INT_AMT NUMERIC(18,6) 19
182 CTD_ACRD_DR_INT_AMT NUMERIC(18,6) 19
183 YTD_INT_PAID_AMT NUMERIC(18,6) 19
184 PREV_FIN_YR_INT_PAID_AMT NUMERIC(18,6) 19
185 CRNT_FIN_YR_INT_PAID_AMT NUMERIC(18,6) 19
186 MTD_OVERDRAWN_AGG_BAL_AMT NUMERIC(18,6) 19
187 MTD_OVERDRAWN_AGG_DAY_CNT BIGINT 8
188 DATA_LOAD_DATE_MTHY DATE 4
189 SNPSHT_DATE_MTHY DATE 4
190 SRC_SYS_ID_MTHY CHARACTER VARYING(5) 5
191 LOAD_ID_MTHY BIGINT 8
192 AGGRESSIVE_LOAD_IND_MTHY CHARACTER VARYING(3) 3
193 NEXT_STATEMENT_DATE DATE 4
194 GRANDFATHER_PRODUCT_FLAG CHARACTER VARYING(1) 1
195 OD_REGULATED_FLG CHARACTER VARYING(4) 4
196 OD_STRT_DATE DATE 4
197 OD_LIM_AMT NUMERIC(18,6) 19
198 MOF_FLAG CHARACTER VARYING(1) 1
199 MOF_START_DATE DATE 4
200 MOF_END_DATE DATE 4
201 PLEDGE_ACCT_INT_RT NUMERIC(18,6) 19
202 PLEDGE_ACCT_STRT_DATE DATE 4
203 PLEDGE_ACCT_BAL_AMT NUMERIC(18,6) 19
204 ATM_FEE_WAIVER CHARACTER VARYING(1) 1
205 EDO_ACCT_COUNT BIGINT 8
206 EDO_ACCT_SUM_BAL NUMERIC(38,10) 19
207 AVG_BAL_30_DAYS NUMERIC(18,6) 19
208 CNT_ATTACHED_PPL BIGINT 8
209 LAST_TXN_DATE DATE 4
210 OTHER_GOVT_BENEFITS CHARACTER VARYING(1) 1
211 HISA_FLG CHARACTER VARYING(1) 1
212 COUNCIL_RT_PAYT_FLG CHARACTER VARYING(1) 1
213 OTH_FIN_INSTU_LN_PAYT_FLG CHARACTER VARYING(1) 1
214 RENT_PAYT_RCVD_FLG CHARACTER VARYING(1) 1
215 RENT_PAYT_PAID_FLG CHARACTER VARYING(1) 1
216 LST_2_YR_LTST_TXN_TS DATE 4
217 LST_2_YR_LTST_TXN_TYP_CODE CHARACTER VARYING(4) 4