HDDA_MASTER

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..BNKNIC_HDDA_MASTER

SDSNZP02_BANK..EFS_HDDA_MASTER

SDSNZP02_BANK..NROD_HDDA_MASTER

SDSNZP02_BANK..UBAR_HDDA_MASTER

SDSNZP05_BANK..CBP_HDDA_MASTER

Columns
# Name Data Type Length
1 ID BIGINT 8
2 ACTION_CODE CHARACTER VARYING(1) 1
3 KEY_COID INTEGER 4
4 KEY_PROD CHARACTER VARYING(3) 3
5 KEY_ACCT BIGINT 8
6 ACCRED_BRKR_CDE CHARACTER VARYING(7) 7
7 ACCT_STATUS CHARACTER VARYING(2) 2
8 APPROVAL_OFF_CD CHARACTER VARYING(5) 5
9 BRANCH_NO INTEGER 4
10 BROKER_CD CHARACTER VARYING(5) 5
11 CLOSING_REASON CHARACTER VARYING(2) 2
12 COST_CENTER INTEGER 4
13 DATE_LAST_MAINT CHARACTER VARYING(10) 10
14 DT_CLOSED CHARACTER VARYING(10) 10
15 DT_OPENED CHARACTER VARYING(10) 10
16 INS_AMOUNT NUMERIC(16,2) 19
17 INS_COMPANY_CODE CHARACTER VARYING(3) 3
18 INS_EFFECTIVE_DTE CHARACTER VARYING(10) 10
19 INS_EXPIRY_DTE CHARACTER VARYING(10) 10
20 INS_POLICY_NUM CHARACTER VARYING(20) 20
21 INS_TYPE_CDE CHARACTER VARYING(2) 2
22 OD_COLL_TOLERANCE NUMERIC(16,2) 19
23 OD_APPL_BRANCH INTEGER 4
24 OD_DB_INT_CYCLE_CD CHARACTER VARYING(2) 2
25 OD_DB_INT_TYPE_CD CHARACTER VARYING(2) 2
26 OD_DOC_TYPE CHARACTER VARYING(5) 5
27 OD_INSURED_IND CHARACTER VARYING(1) 1
28 OD_LAST_REVIEW_DT CHARACTER VARYING(10) 10
29 OD_LDGR_TOLERANCE NUMERIC(16,2) 19
30 OD_LIMIT NUMERIC(16,2) 19
31 OD_LVR NUMERIC(7,2) 19
32 OD_REVIEW_DATE CHARACTER VARYING(10) 10
33 OD_SEC_TYPE_CODE CHARACTER VARYING(3) 3
34 OD_SECURED_FLAG CHARACTER VARYING(1) 1
35 OD_START_DATE CHARACTER VARYING(10) 10
36 OD_TERM_CODE CHARACTER VARYING(3) 3
37 OD_TERM_DATE CHARACTER VARYING(10) 10
38 OFFICER CHARACTER VARYING(5) 5
39 ORIGINAL_BRANCH INTEGER 4
40 SALE_OFF_CD CHARACTER VARYING(7) 7
41 SECONDARY_OFFICER CHARACTER VARYING(5) 5
42 SHORT_NAME CHARACTER VARYING(25) 25
43 SIC_OCCUPATION_CD CHARACTER VARYING(4) 4
44 SUB_PRDCT_CD CHARACTER VARYING(2) 2
45 SVC_TYPE_CD CHARACTER VARYING(2) 2
46 TEMP_OD_EXPIRY_DATE CHARACTER VARYING(10) 10
47 TEMP_OD_LIMIT NUMERIC(16,2) 19
48 WRITE_OFF_CODE CHARACTER VARYING(2) 2
49 WRITE_OFF_DATE CHARACTER VARYING(10) 10
50 BALANCE_BEFORE_CLOSING NUMERIC(16,2) 19
51 SMILE_ELN_NUMBER CHARACTER VARYING(12) 12
52 SUNLOANS_NUMBER INTEGER 4
53 SVC_CHG_WAIVE_CDE CHARACTER VARYING(2) 2
54 SECURITISATION_STATUS_CODE CHARACTER VARYING(1) 1
55 SECURITISATION_POOL_ID CHARACTER VARYING(3) 3
56 SECURITISATION_START_DATE CHARACTER VARYING(10) 10
57 REPURCHASE_REASON_CODE CHARACTER VARYING(1) 1
58 REPURCHASE_DATE CHARACTER VARYING(10) 10
59 DB_INT_PAY_CYCLE_CD CHARACTER VARYING(2) 2
60 INT_PAY_CYCLE_CD CHARACTER VARYING(2) 2
61 PACKAGE_CD CHARACTER VARYING(4) 4
62 STMT_CYCLE CHARACTER VARYING(2) 2
63 INT_CD CHARACTER VARYING(2) 2
64 BUS_MOFF_FLAG CHARACTER VARYING(1) 1
65 COND_CYC_CODE CHARACTER VARYING(2) 2
66 COND_INT_CODE CHARACTER VARYING(2) 2
67 CUR_CR_INT_VAR NUMERIC(7,2) 19
68 DB_INT_CD CHARACTER VARYING(2) 2
69 DTE_SUB_PRDCT_TFR CHARACTER VARYING(10) 10
70 FUNDS_OWNER_CD CHARACTER VARYING(2) 2
71 FUNDS_SUB_OWNER_CD CHARACTER VARYING(2) 2
72 INT_PAY_METHOD CHARACTER VARYING(2) 2
73 LINE_AMT NUMERIC(16,2) 19
74 MTGE_REMOVED_DTE CHARACTER VARYING(10) 10
75 OFFSET_ASSOC_ACCT BIGINT 8
76 OPENING_DEP NUMERIC(16,2) 19
77 PACKAGE_ROLE CHARACTER VARYING(1) 1
78 PBI_BALANCE_STEP NUMERIC(17,2) 19
79 PBI_END_DATE CHARACTER VARYING(10) 10
80 PBI_OLD_INT_CODE CHARACTER VARYING(2) 2
81 PBI_START_DATE CHARACTER VARYING(10) 10
82 PEND_MOFF_FLAG CHARACTER VARYING(1) 1
83 PENDING_OFFSET_DTE CHARACTER VARYING(10) 10
84 PENDING_PACKAGE_CD CHARACTER VARYING(4) 4
85 PROMO_CODE CHARACTER VARYING(10) 10
86 SVC_CYCLE_CD CHARACTER VARYING(2) 2
87 WRITE_OFF_AMT NUMERIC(16,2) 19
88 WVE_CDE_EXPR_DTE CHARACTER VARYING(10) 10
89 ICC_INT_BASE CHARACTER VARYING(1) 1
90 ICC_INT_METHOD CHARACTER VARYING(1) 1
91 ICC_INT_RATE DOUBLE PRECISION 8
92 ICC_KEY_INT_TYPE CHARACTER VARYING(1) 1
93 MOF_DATE_LINKED CHARACTER VARYING(10) 10
94 MOF_LOAN_ACCT BIGINT 8
95 MOF_ORIG_INT_CODE CHARACTER VARYING(2) 2
96 MOF_STATUS CHARACTER VARYING(1) 1
97 MOF_TYPE CHARACTER VARYING(3) 3
98 OD_ACT_STATUS CHARACTER VARYING(2) 2
99 OD_ANZSIC_CDE CHARACTER VARYING(4) 4
100 OD_DATE_LAST_CYCLE CHARACTER VARYING(10) 10
101 OD_DATE_OD CHARACTER VARYING(10) 10
102 OD_NEG_BASIS_POINT DOUBLE PRECISION 8
103 OD_REGULATED_FLAG CHARACTER VARYING(1) 1
104 OD_TYPE CHARACTER VARYING(1) 1
105 INS_COMPANY_CDE CHARACTER VARYING(3) 3
106 INS_FINANCED_IND CHARACTER VARYING(1) 1
107 INS_PREMIUM NUMERIC(19,2) 19
108 INS_TERM_MTHS INTEGER 4
109 INS_UNPAID_IND CHARACTER VARYING(1) 1
110 PRC_CODE CHARACTER VARYING(4) 4
111 PRC_MARGIN CHARACTER VARYING(2) 2
112 PRC_MARGIN_RATE DOUBLE PRECISION 8
113 PRC_START_DATE CHARACTER VARYING(10) 10
114 CUSTOMER_RATE NUMERIC(9,5) 19
115 DR_INT_RATE DOUBLE PRECISION 8
116 PKG_MAND_ACCT_PROD CHARACTER VARYING(3) 3
117 PKG_MAND_ACCT BIGINT 8
118 PKG_START_DTE CHARACTER VARYING(10) 10
119 PKG_END_DTE CHARACTER VARYING(10) 10
120 CLMS_BORR_ID CHARACTER VARYING(50) 50
121 CLMS_GRP_ID CHARACTER VARYING(50) 50
122 ACCT_CQR_CD CHARACTER VARYING(2) 2
123 ACCT_SR_CD CHARACTER VARYING(1) 1
124 BORR_CQR_CD CHARACTER VARYING(2) 2
125 BORR_SR_CD CHARACTER VARYING(1) 1
126 GRP_CQR_CD CHARACTER VARYING(2) 2
127 GRP_SR_CD CHARACTER VARYING(1) 1
128 RISK_MODEL_CD CHARACTER VARYING(2) 2
129 DT_OF_CHG CHARACTER VARYING(10) 10
130 ANZSIC_CD CHARACTER VARYING(4) 4
131 REVIEW_DT CHARACTER VARYING(10) 10
132 NET_SALES NUMERIC(18,2) 19
133 Q_19 CHARACTER VARYING(1) 1
134 Q_20 CHARACTER VARYING(1) 1
135 Q_21 CHARACTER VARYING(1) 1
136 Q_22 CHARACTER VARYING(1) 1
137 CRIT_TOT_SCORE NUMERIC(24,10) 19
138 CRIT_TOT_OVERALL CHARACTER VARYING(10) 10
139 OVERRIDE_FLAG CHARACTER VARYING(2) 2
140 OVERRIDE_RSN CHARACTER VARYING(100) 100
141 OVERRIDE_SRCE CHARACTER VARYING(100) 100
142 CALC_SCORE CHARACTER VARYING(2) 2
143 ACTUAL_SCORE NUMERIC(24,10) 19
144 SICR CHARACTER VARYING(3) 3
145 SYS_CODE CHARACTER VARYING(4) 4
146 PREV_CR_ACT_DESC CHARACTER VARYING(40) 40
147 PREV_CR_ACT_CDR_LDR CHARACTER VARYING(10) 10
148 Q_24 CHARACTER VARYING(10) 10
149 Q_25 CHARACTER VARYING(10) 10
150 Q_26 CHARACTER VARYING(2) 2
151 Q_27 CHARACTER VARYING(2) 2
152 Q_28 CHARACTER VARYING(2) 2
153 DELTA_TYPE CHARACTER VARYING(1) 1
154 EFFECTIVE_STRT_DT TIMESTAMP 8
155 EFFECTIVE_END_DT TIMESTAMP 8
156 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
157 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
158 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
159 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8