HILP_MASTER

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..BNKNIC_HILP_MASTER

SDSNZP02_BANK..EFS_HILP_MASTER

SDSNZP02_BANK..NROD_HILP_MASTER

SDSNZP02_BANK..QRMCGN_HILP_MASTER

SDSNZP02_BANK..UBAR_HILP_MASTER

SDSNZP05_BANK..CBP_HILP_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 CHARACTER VARYING(9) 9
6 ACCT_STATUS CHARACTER VARYING(3) 3
7 ANZSIC_CODE CHARACTER VARYING(4) 4
8 SUB_PRDCT_CD CHARACTER VARYING(3) 3
9 SBA_LOAN_IND CHARACTER VARYING(1) 1
10 ORIG_BR INTEGER 4
11 SRVC_BR INTEGER 4
12 PAYOUT_REASON_CODE CHARACTER VARYING(3) 3
13 DT_OPENED CHARACTER VARYING(10) 10
14 DT_CLOSED CHARACTER VARYING(10) 10
15 SETTLEMENT_DATE CHARACTER VARYING(10) 10
16 DT_CURR_MAT CHARACTER VARYING(10) 10
17 BASIS_PTS_1 DOUBLE PRECISION 8
18 LNDG_POLICY CHARACTER VARYING(8) 8
19 LOAN_PUR CHARACTER VARYING(3) 3
20 LOAN_SUB_PUR CHARACTER VARYING(2) 2
21 COLL_CALC_LTV DOUBLE PRECISION 8
22 ORIG_TRM INTEGER 4
23 DC_LOAN_TRM INTEGER 4
24 INT_REPRICING_IND INTEGER 4
25 CAP_RATE_END_DATE CHARACTER VARYING(10) 10
26 NXT_RT_CHG_DT CHARACTER VARYING(10) 10
27 OFF_IDS_ACCT CHARACTER VARYING(9) 9
28 OFF_IDS_PRODUCT CHARACTER VARYING(3) 3
29 OFF_IDS_RATE DOUBLE PRECISION 8
30 OFF_STATUS CHARACTER VARYING(1) 1
31 CASHBACK_IDENT CHARACTER VARYING(1) 1
32 COLL_CD CHARACTER VARYING(3) 3
33 SECUR_STATUS CHARACTER VARYING(1) 1
34 SECUR_POOL CHARACTER VARYING(3) 3
35 RELN_CODE CHARACTER VARYING(3) 3
36 NEW_CONV_IND CHARACTER VARYING(1) 1
37 SHORT_NAME CHARACTER VARYING(25) 25
38 COST_CENTER INTEGER 4
39 DT_LAST_MAINT CHARACTER VARYING(10) 10
40 ORIG_FEE_AMT NUMERIC(12,2) 19
41 ORIG_INS_AMT NUMERIC(12,2) 19
42 AMT_ORIG_LOAN NUMERIC(16,2) 19
43 ACCRED_BRKR_CDE CHARACTER VARYING(7) 7
44 BROKER_CD CHARACTER VARYING(5) 5
45 PACKAGE_CODE CHARACTER VARYING(4) 4
46 PACKAGE_DATE CHARACTER VARYING(10) 10
47 OWNING_ACCOUNT BIGINT 8
48 ASSOC_LOAN_NUM BIGINT 8
49 PRIM_OFFICER CHARACTER VARYING(5) 5
50 PROP_RHT CHARACTER VARYING(1) 1
51 SALE_OFF_CD CHARACTER VARYING(7) 7
52 SECONDARY_OFFICER CHARACTER VARYING(5) 5
53 SB_PACKAGE_CD CHARACTER VARYING(3) 3
54 LN_APPL_NBR CHARACTER VARYING(12) 12
55 GL_TYP_CD CHARACTER VARYING(3) 3
56 CONS_DATEIN_REPO CHARACTER VARYING(10) 10
57 CONS_REPO_STATUS CHARACTER VARYING(1) 1
58 DT_STAT_SET CHARACTER VARYING(10) 10
59 CONVT_TO_LEND_POL CHARACTER VARYING(11) 11
60 CONVT_TO_LN_TYPE CHARACTER VARYING(3) 3
61 PYFF_TXN_CD INTEGER 4
62 OFF_PRODUCT CHARACTER VARYING(3) 3
63 DT_EST_MAT CHARACTER VARYING(10) 10
64 DT_FNL_MAT CHARACTER VARYING(10) 10
65 DT_LOAN_ADDED CHARACTER VARYING(10) 10
66 DT_LOAN_ISS CHARACTER VARYING(10) 10
67 DT_LST_BILL_RESTR CHARACTER VARYING(10) 10
68 DT_NXT_RVW CHARACTER VARYING(10) 10
69 DT_OF_RECST CHARACTER VARYING(10) 10
70 DT_ORIG_MAT CHARACTER VARYING(10) 10
71 GRCE_DAY INTEGER 4
72 LNDG_POLICY_DT CHARACTER VARYING(10) 10
73 LOAN_CLASS CHARACTER VARYING(3) 3
74 MSHP_CD CHARACTER VARYING(1) 1
75 NBR_TM_RENEW INTEGER 4
76 NBR_TM_TO_RENEW INTEGER 4
77 ORIG_LTV INTEGER 4
78 PYMT_DUE_DT_1ST CHARACTER VARYING(10) 10
79 DT_1ST_ADV CHARACTER VARYING(10) 10
80 DT_LST_EXT CHARACTER VARYING(10) 10
81 DT_PRIN_PD_TO_ZR CHARACTER VARYING(10) 10
82 LOAN_PRCD_1ST_ADV NUMERIC(15,2) 19
83 PYFF_TYP INTEGER 4
84 SECOND_BORROWING_AMT NUMERIC(16,2) 19
85 ADDITIONAL_LOAN CHARACTER VARYING(3) 3
86 CHARGE_TYP CHARACTER VARYING(1) 1
87 DEF_CHARGE NUMERIC(12,2) 19
88 FEE_CONTRIB NUMERIC(12,2) 19
89 FIN_STAT CHARACTER VARYING(1) 1
90 FIN_STAT_DT_SET CHARACTER VARYING(10) 10
91 FIRST_ADV_AMT NUMERIC(16,2) 19
92 FIXED_FEE_EXEMPT CHARACTER VARYING(1) 1
93 FUND_UTILISED CHARACTER VARYING(3) 3
94 GTEED_RT_IND CHARACTER VARYING(1) 1
95 INT_ONLY_PD INTEGER 4
96 INTERNET_CSHBK_IND CHARACTER VARYING(1) 1
97 LOAN_LINK CHARACTER VARYING(3) 3
98 LOAN_PURP_STATE CHARACTER VARYING(3) 3
99 OFF_IDS_ACCR_BASE INTEGER 4
100 OFF_LTR_FLAG CHARACTER VARYING(1) 1
101 ORIG_LENDING_POL CHARACTER VARYING(11) 11
102 SML_BUS_SECUR_CD CHARACTER VARYING(3) 3
103 STAMP_DUTY_FINCD NUMERIC(12,2) 19
104 STATE_OF_JURSDCTN CHARACTER VARYING(3) 3
105 CHG_OFF_PRIN NUMERIC(15,2) 19
106 CHG_OFF_INT NUMERIC(13,2) 19
107 CLMS_BORR_ID CHARACTER VARYING(50) 50
108 CLMS_GRP_ID CHARACTER VARYING(50) 50
109 ACCT_CQR_CD CHARACTER VARYING(2) 2
110 ACCT_SR_CD CHARACTER VARYING(1) 1
111 BORR_CQR_CD CHARACTER VARYING(2) 2
112 BORR_SR_CD CHARACTER VARYING(1) 1
113 GRP_CQR_CD CHARACTER VARYING(2) 2
114 GRP_SR_CD CHARACTER VARYING(1) 1
115 RISK_MODEL_CD CHARACTER VARYING(2) 2
116 DT_OF_CHG CHARACTER VARYING(10) 10
117 ANZSIC_CD CHARACTER VARYING(4) 4
118 REVIEW_DT CHARACTER VARYING(10) 10
119 NET_SALES NUMERIC(18,2) 19
120 Q_19 CHARACTER VARYING(1) 1
121 Q_20 CHARACTER VARYING(1) 1
122 Q_21 CHARACTER VARYING(1) 1
123 Q_22 CHARACTER VARYING(1) 1
124 CRIT_TOT_SCORE NUMERIC(24,2) 19
125 CRIT_TOT_OVERALL CHARACTER VARYING(10) 10
126 OVERRIDE_FLAG CHARACTER VARYING(2) 2
127 OVERRIDE_RSN CHARACTER VARYING(100) 100
128 OVERRIDE_SRCE CHARACTER VARYING(100) 100
129 CALC_SCORE CHARACTER VARYING(2) 2
130 ACTUAL_SCORE NUMERIC(24,2) 19
131 SICR CHARACTER VARYING(3) 3
132 SYS_CODE CHARACTER VARYING(4) 4
133 PREV_CR_ACT_DESC CHARACTER VARYING(40) 40
134 PREV_CR_ACT_CDR_LDR CHARACTER VARYING(10) 10
135 Q_24 CHARACTER VARYING(10) 10
136 Q_25 CHARACTER VARYING(10) 10
137 Q_26 CHARACTER VARYING(2) 2
138 Q_27 CHARACTER VARYING(2) 2
139 Q_28 CHARACTER VARYING(2) 2
140 TRAIL_COMMISSION_OVRD_RATE NUMERIC(8,3) 19
141 TRAIL_COMMISSION_OVRD_DATE DATE 4
142 CLMS_ACCT_NUM INTEGER 4
143 RPM_QUOTE_NUM INTEGER 4
144 PROMOTION_CODE CHARACTER VARYING(6) 6
145 DIVISION_CODE CHARACTER VARYING(5) 5
146 BALLOON_AMOUNT NUMERIC(15,2) 19
147 BILL_PROFILE CHARACTER VARYING(1) 1
148 VAR_IO_START_DT DATE 4
149 VAR_IO_EXP_DT DATE 4
150 VAR_IO_EXP_NOTC_DT DATE 4
151 GRNTEE_NOTNL_EXPIRY_FLAG CHARACTER VARYING(1) 1
152 GRNTEE_LIMIT NUMERIC(15,2) 19
153 PAYMENT_PAUSE_FLAG CHARACTER VARYING(1) 1
154 WATCH_LIST_FLAG CHARACTER VARYING(1) 1
155 DELTA_TYPE CHARACTER VARYING(1) 1
156 EFFECTIVE_STRT_DT TIMESTAMP 8
157 EFFECTIVE_END_DT TIMESTAMP 8
158 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
159 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
160 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
161 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8