SDW_TSDMF_LOAN_ORIG_PERIOD

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_SDW_TSDMF_LOAN_ORIG_PERIOD

Columns
# Name Data Type Length
1 FACILITY_DIM_ID BIGINT 8
2 CLOSING_PERIOD_DIM_ID BIGINT 8
3 PERIOD_TYPE_DIM_ID BIGINT 8
4 OPENING_PERIOD_DIM_ID BIGINT 8
5 SOURCE_SYSTEM_DIM_ID BIGINT 8
6 CLOSING_FACILITY_STATUS_DIM_ID BIGINT 8
7 OPENING_FACILITY_STATUS_DIM_ID BIGINT 8
8 APPLICATION_DIM_ID BIGINT 8
9 ACCOUNT_DIM_ID BIGINT 8
10 SOURCE_PRODUCT_DIM_ID BIGINT 8
11 SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
12 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
13 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
14 OF_PRODUCT_SID BIGINT 8
15 MATERIALITY_DIM_ID BIGINT 8
16 BILL_TYPE_DIM_ID BIGINT 8
17 LOAN_PURPOSE_DIM_ID BIGINT 8
18 ACCOUNT_SECURITY_DIM_ID BIGINT 8
19 SOURCE_CURRENCY_DIMENSION_ID BIGINT 8
20 INTEREST_RATE_DIM_ID BIGINT 8
21 CHANNEL_DIM_ID BIGINT 8
22 INTEREST_RATE_TERM_DIM_ID BIGINT 8
23 REG_LOAN_VAL_RATIO_DIM_ID BIGINT 8
24 FACILITY_DECISION_DIM_ID BIGINT 8
25 GCIS_CUSTOMER_DIM_ID BIGINT 8
26 CUSTOMER_DIM_ID BIGINT 8
27 CUST_CLASSIFIER_DIM_ID BIGINT 8
28 ANZSIC_DIM_ID BIGINT 8
29 CUSTOMER_ADDRESS_DIM_ID BIGINT 8
30 COUNTERPARTY_TYPE_DIM_ID BIGINT 8
31 OF_COST_CENTRE_SID BIGINT 8
32 OPENING_TOTAL_LOAN_AMOUNT NUMERIC(14,2) 19
33 CLOSING_TOTAL_LOAN_AMOUNT NUMERIC(14,2) 19
34 OPENING_TOTAL_FUNDING_AMOUNT NUMERIC(14,2) 19
35 CLOSING_TOTAL_FUNDING_AMOUNT NUMERIC(14,2) 19
36 OPENING_TOTAL_CPZ_FEES_AMOUNT NUMERIC(14,2) 19
37 CLOSING_TOTAL_CPZ_FEES_AMOUNT NUMERIC(14,2) 19
38 OPENING_TOTAL_CPZ_INS_AMOUNT NUMERIC(14,2) 19
39 CLOSING_TOTAL_CPZ_INS_AMOUNT NUMERIC(14,2) 19
40 OPENING_COMMIT_AMOUNT NUMERIC(14,2) 19
41 CLOSING_COMMIT_AMOUNT NUMERIC(14,2) 19
42 INCREASED_COMMIT_AMOUNT NUMERIC(14,2) 19
43 DECREASED_COMMIT_AMOUNT NUMERIC(14,2) 19
44 CANCELLED_COMMIT_AMOUNT NUMERIC(14,2) 19
45 OPENING_NEW_LOAN_AMOUNT NUMERIC(14,2) 19
46 CLOSING_NEW_LOAN_AMOUNT NUMERIC(14,2) 19
47 NEW_COMMIT_AMOUNT NUMERIC(14,2) 19
48 NEW_COMMIT_COUNT NUMERIC(38,0) 19
49 BUSINESS_LOAD_DATE TIMESTAMP 8
50 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
51 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
52 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
53 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8