SDW_TSDSA_TERM_DEP_MONTHLY

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 MAT_PERIOD_TERM_DEP_DIM_ID CHARACTER VARYING(18) 18
6 SALES_OFFICER_DIM_ID BIGINT 8
7 SECONDARY_OFFICER_DIM_ID BIGINT 8
8 ACCOUNT_TYPE_DEP_DIM_ID BIGINT 8
9 DEP_BALANCE_TIER_DIM_ID BIGINT 8
10 TERM_TIER_TERM_DEP_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 ESTIMATED_FINAL_MAT_DATE TIMESTAMP 8
17 TERM_CODE CHARACTER VARYING(12) 12
18 TERM NUMERIC(38,0) 19
19 ANNUAL_INT_RATE NUMERIC(8,5) 19
20 BALANCE NUMERIC(14,2) 19
21 WEIGHTED_CUSTOMER_RATE_AMOUNT NUMERIC(15,5) 19
22 CURRENT_EXPECTED_INT_PAYABLE NUMERIC(15,5) 19
23 EXPECTED_TERM_DAYS NUMERIC(38,0) 19
24 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
25 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
26 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
27 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8