SDW_TSDSA_TERM_DEP_EV_WKLY

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 ACCOUNT_DIM_ID BIGINT 8
3 OF_COST_CENTRE_SID BIGINT 8
4 SOURCE_PRODUCT_DIM_ID BIGINT 8
5 SALES_OFFICER_DIM_ID BIGINT 8
6 SECONDARY_OFFICER_DIM_ID BIGINT 8
7 ACCOUNT_TYPE_DEP_DIM_ID BIGINT 8
8 DEP_BALANCE_TIER_DIM_ID BIGINT 8
9 TERM_TIER_TERM_DEP_DIM_ID BIGINT 8
10 LAST_RECORDED_PERIOD_DIM_ID BIGINT 8
11 ACCOUNT_NUMBER CHARACTER VARYING(20) 20
12 DATE_OPEN TIMESTAMP 8
13 DATE_CLOSED TIMESTAMP 8
14 CURRENT_ISSUE_DATE TIMESTAMP 8
15 CURRENT_MAT_DATE TIMESTAMP 8
16 TERM_CODE CHARACTER VARYING(24) 24
17 TERM BIGINT 8
18 ANNUAL_INT_RATE NUMERIC(8,5) 19
19 AUTO_ROLL_TYPE CHARACTER VARYING(256) 256
20 EXPECTED_TERM_DAYS BIGINT 8
21 ACTUAL_TERM BIGINT 8
22 EXPECTED_TO_ACTUAL_TERM_PCT NUMERIC(23,8) 19
23 BREAKAGE_RATIO BIGINT 8
24 TERM_VARIATION BIGINT 8
25 OPENING_DEPOSIT_AMOUNT NUMERIC(15,5) 19
26 INT_PENALTY_AMOUNT_FYTD NUMERIC(14,2) 19
27 EXPECTED_INT_PAYABLE NUMERIC(15,5) 19
28 EXPECTED_INT_ADJUSTMENT NUMERIC(15,5) 19
29 INT_MISSED_AMOUNT NUMERIC(15,5) 19
30 FEE_APPLIED_TYPE CHARACTER VARYING(256) 256
31 ACCOUNT_FILTER CHARACTER VARYING(20) 20
32 NO_FEES_ACCOUNT_COUNT BIGINT 8
33 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
34 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
35 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
36 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8