HILP_INTEREST_RATE

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_HILP_INTEREST_RATE

SDSNZP02_BANK..QRMCGN_HILP_INTEREST_RATE

SDSNZP02_BANK..UBAR_HILP_INTEREST_RATE

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 INT_CALC_TYPE CHARACTER VARYING(3) 3
6 INT_CALC_CODE CHARACTER VARYING(2) 2
7 INT_SEQ_NBR INTEGER 4
8 ANNUAL_RATE DOUBLE PRECISION 8
9 DAILY_FACTOR DOUBLE PRECISION 8
10 DAILY_CHARGEG DOUBLE PRECISION 8
11 AMT_PAID_INCEPTION_TO_DATE NUMERIC(16,2) 19
12 INDEX_1 CHARACTER VARYING(2) 2
13 AMT_ACCR_NOBL DOUBLE PRECISION 8
14 UNRND_PPMT_AMT DOUBLE PRECISION 8
15 RATE_CHG_FREQ CHARACTER VARYING(2) 2
16 DT_LST_ACCR TIMESTAMP 8
17 LST_RT_CHG_DT TIMESTAMP 8
18 LST_RT_NOT_DT TIMESTAMP 8
19 NXT_RT_NOT_DT TIMESTAMP 8
20 ACCR_MTHD_CD INTEGER 4
21 ACCR_STRT_DT TIMESTAMP 8
22 AMT_ACCR_FYTD DOUBLE PRECISION 8
23 AMT_ACCR_ITD DOUBLE PRECISION 8
24 AMT_ACCR_MTD DOUBLE PRECISION 8
25 AMT_ACCR_YTD DOUBLE PRECISION 8
26 AMT_BLLD_NOT_PD NUMERIC(12,2) 19
27 AMT_BLLD_UNRND NUMERIC(12,2) 19
28 FXD_INT_FEE_AMT NUMERIC(12,2) 19
29 REBT_CALC_CD CHARACTER VARYING(3) 3
30 REBT_DUE NUMERIC(12,2) 19
31 RT_PYMT_MODR_IND CHARACTER VARYING(1) 1
32 ST_RT DOUBLE PRECISION 8
33 ACCR_BASE INTEGER 4
34 DATA_DATE TIMESTAMP 8
35 LOAD_ID INTEGER 4
36 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
37 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
38 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
39 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8