HILP_ACCOUNT_DAILY

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..BNKNIC_HILP_ACCOUNT_DAILY

SDSNZP02_BANK..EFS_HILP_ACCOUNT_DAILY

SDSNZP02_BANK..NROD_HILP_ACCOUNT_DAILY

SDSNZP02_BANK..QRMCGN_HILP_ACCOUNT_DAILY

SDSNZP02_BANK..UBAR_HILP_ACCOUNT_DAILY

Columns
# Name Data Type Length
1 ACTION_CODE CHARACTER VARYING(1) 1
2 KEY_COID INTEGER 4
3 KEY_PROD CHARACTER VARYING(3) 3
4 KEY_ACCT CHARACTER VARYING(9) 9
5 CURR_BAL NUMERIC(16,2) 19
6 CALC_ADVANCE_AMT NUMERIC(12,2) 19
7 CALC_AMT_DUE NUMERIC(16,2) 19
8 AVL_CASHBACK NUMERIC(12,2) 19
9 OFFSET_BALANCE NUMERIC(13,2) 19
10 CALC_AVAIL_BAL NUMERIC(16,2) 19
11 COLL_CALC_BTV NUMERIC(9,2) 19
12 NBR_DAY_PDUE INTEGER 4
13 OLD_DUE_DT TIMESTAMP 8
14 AMT_ADV_TO_DT NUMERIC(16,2) 19
15 TOT_PYMT_PDUE INTEGER 4
16 TOT_NBR_TM_PDUE INTEGER 4
17 TOT_AMT_PDUE NUMERIC(13,2) 19
18 EFF_DT_LST_PYMT TIMESTAMP 8
19 UNAPLD_FUNDS NUMERIC(16,2) 19
20 AGGR_NET_BAL_MTD NUMERIC(16,2) 19
21 AGGR_DAY_MTD INTEGER 4
22 CALC_CURR_PAYOFF NUMERIC(16,2) 19
23 AGGR_DAY_QTD INTEGER 4
24 AGGR_DAY_YTD INTEGER 4
25 AGGR_LST_DT TIMESTAMP 8
26 AGGR_NBR_OF_DAY INTEGER 4
27 AGGR_NET_BAL_YTD NUMERIC(16,2) 19
28 AGGR_OUTSTG_MTD NUMERIC(16,2) 19
29 AGGR_OUTSTG_YTD NUMERIC(16,2) 19
30 AGGR_SNCE_BILL NUMERIC(16,2) 19
31 COLL_CALC_VALUE NUMERIC(13,2) 19
32 CURR_DUE_DT TIMESTAMP 8
33 AMT_LST_ADV INTEGER 4
34 BAL_LST_YR_END DOUBLE PRECISION 8
35 BGN_MTH_BAL NUMERIC(13,2) 19
36 CHG_ASSESS NUMERIC(13,2) 19
37 CHG_PD_ITD NUMERIC(13,2) 19
38 CHG_PD_LST_YR NUMERIC(13,2) 19
39 CHG_PD_YTD NUMERIC(13,2) 19
40 CHG_WAVD NUMERIC(13,2) 19
41 CHG_WAVD_YTD NUMERIC(13,2) 19
42 CURR_INS_ACCR_NOBL NUMERIC(15,6) 19
43 CURR_INT_ACCR_NOBL NUMERIC(15,6) 19
44 DT_INT_PD_TO TIMESTAMP 8
45 DT_LST_ADV TIMESTAMP 8
46 DT_LST_PRIN_ACTY TIMESTAMP 8
47 FEE_ACCR_ITD NUMERIC(15,6) 19
48 FEE_BLLD_UNPD NUMERIC(13,2) 19
49 FEE_BLLD_UNRND NUMERIC(13,2) 19
50 FEE_PD_ITD NUMERIC(13,2) 19
51 FEE_PD_LST_YR NUMERIC(13,2) 19
52 FEE_PD_YTD NUMERIC(13,2) 19
53 FEE_WAVD NUMERIC(13,2) 19
54 INS_BLLD_UNPD NUMERIC(13,2) 19
55 INS_BLLD_UNRND NUMERIC(13,2) 19
56 INS_PD_ITD NUMERIC(13,2) 19
57 INS_PD_LST_YR NUMERIC(13,2) 19
58 INS_PD_YTD NUMERIC(13,2) 19
59 INS_PDIEM_BGN_DT TIMESTAMP 8
60 INT_ACCR_PD_INT NUMERIC(13,2) 19
61 INT_BLLD_UNPD NUMERIC(13,2) 19
62 INT_NOT_NONACCR NUMERIC(13,2) 19
63 INT_PD_ITD NUMERIC(13,2) 19
64 INT_PD_LST_YR NUMERIC(13,2) 19
65 INT_PD_YTD NUMERIC(13,2) 19
66 INT_WAVD NUMERIC(13,2) 19
67 LCHG_ASSESS NUMERIC(10,2) 19
68 LCHG_PD NUMERIC(10,2) 19
69 LCHG_PD_YTD NUMERIC(10,2) 19
70 LCHG_WAVD NUMERIC(10,2) 19
71 LCHG_WAVD_YTD NUMERIC(10,2) 19
72 MSHP_CHG_ASSESS NUMERIC(10,2) 19
73 MSHP_CHG_PD NUMERIC(10,2) 19
74 MSHP_CHG_PD_YTD NUMERIC(10,2) 19
75 MSHP_CHG_WAVD NUMERIC(10,2) 19
76 MSHP_CHG_WAVD_YTD NUMERIC(10,2) 19
77 NONACCR_BLWMKT_INT NUMERIC(15,6) 19
78 NONACCR_PRIN_ITD NUMERIC(12,2) 19
79 NONACCR_PRIN_YTD NUMERIC(12,2) 19
80 OTH_CHG_ASSESS NUMERIC(10,2) 19
81 OTH_CHG_PD NUMERIC(10,2) 19
82 OTH_CHG_PD_YTD NUMERIC(10,2) 19
83 OTH_CHG_WAVD NUMERIC(10,2) 19
84 OTH_CHG_WAVD_YTD NUMERIC(10,2) 19
85 PARTL_PYMT NUMERIC(12,2) 19
86 PRIN_BLLD_UNPD NUMERIC(16,2) 19
87 PRIN_PD_TO_DT CHARACTER VARYING(10) 10
88 TOT_REBT_DUE NUMERIC(12,2) 19
89 DELQ_10_29_DAY INTEGER 4
90 DELQ_30_59_DAY INTEGER 4
91 DELQ_60_89_DAY INTEGER 4
92 DELQ_90_119_DAY INTEGER 4
93 DELQ_120_DAY INTEGER 4
94 DT_INS_PDUE TIMESTAMP 8
95 DT_PRIN_PDUE TIMESTAMP 8
96 ESCW_AMT_PDUE NUMERIC(12,2) 19
97 ESCW_PDUE_DT TIMESTAMP 8
98 NBR_1ST_NOTC INTEGER 4
99 NBR_2ND_NOTC INTEGER 4
100 TOT_FEE_PDUE NUMERIC(12,2) 19
101 TOT_INS_PDUE NUMERIC(12,2) 19
102 TOT_INT_PDUE NUMERIC(13,2) 19
103 TOT_OTH_PDUE NUMERIC(12,2) 19
104 TOT_PRIN_PDUE NUMERIC(13,2) 19
105 ACCT_LAST_ST_DATE TIMESTAMP 8
106 ACCT_NEXT_ST_DATE TIMESTAMP 8
107 HINT_ASSESSD_DATE TIMESTAMP 8
108 HINT_CURRENT_MTH NUMERIC(15,6) 19
109 HINT_EXEMPT_FLAG CHARACTER VARYING(1) 1
110 HINT_LAST_ACCR TIMESTAMP 8
111 HINT_MINUS_1MTH NUMERIC(15,6) 19
112 HINT_MINUS_2MTHS NUMERIC(15,6) 19
113 HINT_RATE NUMERIC(11,6) 19
114 LATE_CHG_NOTICE CHARACTER VARYING(1) 1
115 OFF_ACCR_MTD NUMERIC(17,6) 19
116 OFF_AMT_LCYC NUMERIC(13,2) 19
117 OFF_BAL_DATE TIMESTAMP 8
118 CAP_INT_LIMIT_AMOUNT NUMERIC(15,2) 19
119 CAP_INT_USED_AMOUNT NUMERIC(15,2) 19
120 CURRENT_LIMIT_AMOUNT NUMERIC(15,2) 19
121 HINT_INBA_ITD NUMERIC(13,2) 19
122 NET_ADJ_INBA_ITD NUMERIC(13,2) 19
123 PARTIAL_WO_INBA_ITD NUMERIC(13,2) 19
124 TOTAL_INBA NUMERIC(13,2) 19
125 DATA_DATE TIMESTAMP 8
126 LOAD_ID INTEGER 4
127 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
128 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
129 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
130 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8