HDDA_DAILY

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_HDDA_DAILY

SDSNZP02_BANK..NROD_HDDA_DAILY

SDSNZP02_BANK..UBAR_HDDA_DAILY

Columns
# Name Data Type Length
1 ACTION_CODE CHARACTER VARYING(1) 1
2 KEY_COID CHARACTER VARYING(5) 5
3 KEY_PROD CHARACTER VARYING(3) 3
4 KEY_ACCT BIGINT 8
5 AGG_OD_BAL_MTD NUMERIC(19,2) 19
6 AGG_OD_DAYS_MTD INTEGER 4
7 AGG_PLUS_BAL_MTD NUMERIC(19,2) 19
8 AGG_PLUS_DAYS_MTD INTEGER 4
9 AGGR_AMT_CUST_INIT_DEP_MTD NUMERIC(19,2) 19
10 AGGR_AMT_CUST_INIT_WIT_MTD NUMERIC(19,2) 19
11 AMT_CR_MTD NUMERIC(19,2) 19
12 AMT_DR_MTD NUMERIC(19,2) 19
13 AMT_INT_ACC_CTD DOUBLE PRECISION 8
14 AMT_INT_PAID_MTD NUMERIC(12,2) 19
15 AMT_MISC_SV_CHG_MT NUMERIC(9,2) 19
16 AMT_OD_CHGS_MTD NUMERIC(9,2) 19
17 AMT_RET_CK_CHGS_MT NUMERIC(9,2) 19
18 AMT_SV_CHG_MTD NUMERIC(9,2) 19
19 AVG_BAL_PREV_CTD NUMERIC(15,2) 19
20 CURR_BAL NUMERIC(15,2) 19
21 CURR_COLL_BAL NUMERIC(15,2) 19
22 DATE_IN_EXCESS CHARACTER VARYING(10) 10
23 DATE_OD CHARACTER VARYING(10) 10
24 DB_AMT_INT_ACC_CTD DOUBLE PRECISION 8
25 DT_LAST_CYCLE CHARACTER VARYING(10) 10
26 DT_LAST_STMT CHARACTER VARYING(10) 10
27 HIGH_BAL_MTD NUMERIC(16,2) 19
28 INT_PAID_YTD NUMERIC(16,2) 19
29 LAST_CUST_CONT_DTE CHARACTER VARYING(10) 10
30 LAST_CUST_DEP_DATE CHARACTER VARYING(10) 10
31 LAST_CUST_WDL_DATE CHARACTER VARYING(10) 10
32 LOW_BAL_MTD NUMERIC(19,2) 19
33 NBR_CUST_INIT_DEP_MTD INTEGER 4
34 NBR_CUST_INIT_WIT_MTD INTEGER 4
35 NO_CR_MTD INTEGER 4
36 NO_DR_MTD INTEGER 4
37 OD_BVR NUMERIC(9,2) 19
38 OD_DATE_OVER_LIMIT CHARACTER VARYING(10) 10
39 RTN_ITEMS_CRNT_CYC INTEGER 4
40 TOTAL_INT_PAID NUMERIC(15,2) 19
41 INTEREST_RATE_CREDIT DOUBLE PRECISION 8
42 INTEREST_RATE_DEBIT DOUBLE PRECISION 8
43 DAYS_PAST_DUE INTEGER 4
44 PAST_DUE_AMT NUMERIC(16,2) 19
45 AMT_INT_ACCRED_MTD NUMERIC(17,8) 19
46 COND_ACCUM_CTD NUMERIC(17,8) 19
47 COND_ACRD_CTD NUMERIC(17,8) 19
48 COND_AMT_DPTS NUMERIC(17,2) 19
49 COND_AMT_WDL NUMERIC(17,2) 19
50 COND_CRNT_CONS_CYC BIGINT 8
51 COND_DATE_LST_ACCM CHARACTER VARYING(10) 10
52 COND_DATE_LST_ACRD CHARACTER VARYING(10) 10
53 COND_DATE_QAL_LOST CHARACTER VARYING(10) 10
54 COND_NUM_DPTS INTEGER 4
55 COND_NUM_WDL INTEGER 4
56 DB_INT_ACCRED_MTD DOUBLE PRECISION 8
57 INT_PD_FYTD NUMERIC(15,2) 19
58 INT_PEN_FYTD NUMERIC(15,2) 19
59 LAST_CUST_DEP_DTE CHARACTER VARYING(10) 10
60 LAST_CUST_WDL_DTE CHARACTER VARYING(10) 10
61 ICC_INT_BALANCE NUMERIC(16,2) 19
62 OD_AGG_BAL_MTD NUMERIC(19,2) 19
63 OD_AGG_DAYS_MTD INTEGER 4
64 OD_AMT_INT_YTD NUMERIC(16,2) 19
65 OD_CURR_BAL NUMERIC(16,2) 19
66 OD_LOW_DB_BAL_MTD NUMERIC(16,2) 19
67 DAILY_ACCRUED_WHT NUMERIC(19,2) 19
68 DATA_DATE TIMESTAMP 8
69 LOAD_ID INTEGER 4
70 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
71 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
72 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
73 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8