HTDA_DAILY

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_HTDA_DAILY

SDSNZP02_BANK..NROD_HTDA_DAILY

SDSNZP02_BANK..UBAR_HTDA_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 BIGINT 8
9 AMT_DEPOSITS NUMERIC(19,2) 19
10 AMT_WITHDRAWALS NUMERIC(19,2) 19
11 INT_ACCRUED_CTD DOUBLE PRECISION 8
12 AMT_INT_PAID_MTD NUMERIC(12,2) 19
13 AMT_MISC_SV_CHG_MT NUMERIC(9,2) 19
14 AMT_OD_CHGS_MTD NUMERIC(9,2) 19
15 AMT_RET_CK_CHGS_MT NUMERIC(9,2) 19
16 AMT_SV_CHG_MTD NUMERIC(9,2) 19
17 AVG_BAL_PREV_CTD NUMERIC(15,2) 19
18 CURR_BAL NUMERIC(15,2) 19
19 CURR_COLL_BAL NUMERIC(15,2) 19
20 DT_LAST_CYCLE CHARACTER VARYING(10) 10
21 DT_LAST_STMT CHARACTER VARYING(10) 10
22 HIGH_BAL_MTD NUMERIC(15,2) 19
23 INTEREST_RATE_ANNUAL NUMERIC(9,5) 19
24 INTEREST_RATE_TYPE CHARACTER VARYING(1) 1
25 INT_PAID_YTD NUMERIC(15,2) 19
26 LAST_CUST_CONT_DTE CHARACTER VARYING(10) 10
27 LAST_CUST_DEP_DATE CHARACTER VARYING(10) 10
28 LAST_CUST_WDL_DATE CHARACTER VARYING(10) 10
29 LOW_BAL_MTD NUMERIC(19,2) 19
30 NO_DEPOSITS INTEGER 4
31 NO_WITHDRAWALS INTEGER 4
32 NO_CR_MTD BIGINT 8
33 NO_DR_MTD BIGINT 8
34 TOTAL_INT_PAID NUMERIC(19,2) 19
35 DATE_LAST_PROCESSED_IN_BATCH CHARACTER VARYING(10) 10
36 DATE_OD CHARACTER VARYING(10) 10
37 AVG_BAL_MTD NUMERIC(19,2) 19
38 ACT_INT_ACCRED_CTD NUMERIC(17,8) 19
39 AMT_INT_ACCRED_MTD NUMERIC(17,8) 19
40 COND_ACCUM_CTD NUMERIC(17,8) 19
41 COND_ACRD_CTD NUMERIC(17,8) 19
42 COND_AMT_DPTS NUMERIC(17,2) 19
43 COND_AMT_WDL NUMERIC(17,2) 19
44 COND_CRNT_CONS_CYC BIGINT 8
45 COND_DATE_LST_ACCM CHARACTER VARYING(10) 10
46 COND_DATE_LST_ACRD CHARACTER VARYING(10) 10
47 COND_DATE_QAL_LOST CHARACTER VARYING(10) 10
48 COND_NUM_DPTS INTEGER 4
49 COND_NUM_WDL INTEGER 4
50 COND_PREV_CONS_CYC INTEGER 4
51 INT_PD_FYTD NUMERIC(12,2) 19
52 INT_PD_PREV_FYR NUMERIC(12,2) 19
53 INT_PEN_FYTD NUMERIC(12,2) 19
54 INT_PEN_PREV_FYR NUMERIC(12,2) 19
55 LAST_CUST_WDL_DTE CHARACTER VARYING(10) 10
56 LST_INT_CYC_PFYR CHARACTER VARYING(10) 10
57 ICC_INT_BALANCE NUMERIC(19,2) 19
58 DAILY_ACCRUED_WHT NUMERIC(19,2) 19
59 DATA_DATE TIMESTAMP 8
60 LOAD_ID INTEGER 4
61 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
62 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
63 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
64 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8