HTDA_MASTER

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..EFS_HTDA_MASTER

SDSNZP02_BANK..NROD_HTDA_MASTER

SDSNZP02_BANK..QRMCGN_HTDA_MASTER

SDSNZP02_BANK..UBAR_HTDA_MASTER

SDSNZP05_BANK..CBP_HTDA_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 BIGINT 8
6 ACCT_STATUS CHARACTER VARYING(2) 2
7 BRANCH_NO INTEGER 4
8 CLOSING_REASON CHARACTER VARYING(2) 2
9 COST_CENTER INTEGER 4
10 DATE_LAST_MAINT CHARACTER VARYING(10) 10
11 DT_CLOSED CHARACTER VARYING(10) 10
12 DT_OPENED CHARACTER VARYING(10) 10
13 TERM INTEGER 4
14 TERM_CODE CHARACTER VARYING(1) 1
15 NEGOTIABLE_RT CHARACTER VARYING(1) 1
16 TIMES_RENEWED INTEGER 4
17 CURRENT_ISSUE_DATE CHARACTER VARYING(10) 10
18 CURRENT_MATURITY_DATE CHARACTER VARYING(10) 10
19 FINAL_MATURITY_DATE CHARACTER VARYING(10) 10
20 INT_PAY_CYCLE_CD CHARACTER VARYING(2) 2
21 INT_PAY_METHOD CHARACTER VARYING(2) 2
22 INT_CD CHARACTER VARYING(2) 2
23 OFFICER CHARACTER VARYING(5) 5
24 ORIGINAL_BRANCH INTEGER 4
25 SALE_OFF_CD CHARACTER VARYING(7) 7
26 SECONDARY_OFFICER CHARACTER VARYING(5) 5
27 SHORT_NAME CHARACTER VARYING(25) 25
28 SIC_OCCUPATION_CD CHARACTER VARYING(4) 4
29 SUB_PRDCT_CD CHARACTER VARYING(2) 2
30 SVC_TYPE_CD CHARACTER VARYING(2) 2
31 INT_XFER_ACCT BIGINT 8
32 PRINC_XFER_ACCT BIGINT 8
33 BROKER_CD CHARACTER VARYING(5) 5
34 COND_CYC_CODE CHARACTER VARYING(2) 2
35 COND_INT_CODE CHARACTER VARYING(2) 2
36 CURR_REG_D_CAT CHARACTER VARYING(1) 1
37 FUNDS_OWNER_CD CHARACTER VARYING(2) 2
38 FUNDS_SUB_OWNER_CD CHARACTER VARYING(2) 2
39 INT_TYPE_CD CHARACTER VARYING(1) 1
40 MTGE_REMOVED_DTE CHARACTER VARYING(10) 10
41 OPENING_DEP NUMERIC(15,2) 19
42 PACKAGE_CD CHARACTER VARYING(6) 6
43 PROMO_CODE CHARACTER VARYING(10) 10
44 STMT_CYCLE CHARACTER VARYING(2) 2
45 SV_CHG_WAIVE_CODE CHARACTER VARYING(2) 2
46 ICC_INT_BASE CHARACTER VARYING(1) 1
47 ICC_INT_METHOD CHARACTER VARYING(1) 1
48 PAYOUT_METHOD_CD CHARACTER VARYING(2) 2
49 REN_ADD_ACCT BIGINT 8
50 REN_ADD_AMT NUMERIC(17,2) 19
51 REN_CDE CHARACTER VARYING(2) 2
52 REN_PART_PAY_AMT NUMERIC(15,2) 19
53 REN_TERM INTEGER 4
54 REN_TERM_CD CHARACTER VARYING(2) 2
55 RENEW_SUB_PRDCT_CD CHARACTER VARYING(2) 2
56 SEND_CUST_LETTER CHARACTER VARYING(1) 1
57 ISS_TIMES_TO_RENEW INTEGER 4
58 MOF_DATE_LINKED CHARACTER VARYING(10) 10
59 MOF_LOAN_ACCT BIGINT 8
60 MOF_ORIG_INT_CODE CHARACTER VARYING(2) 2
61 XFER_BSB BIGINT 8
62 DELTA_TYPE CHARACTER VARYING(1) 1
63 EFFECTIVE_STRT_DT TIMESTAMP 8
64 EFFECTIVE_END_DT TIMESTAMP 8
65 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
66 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
67 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
68 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8