SDW_TSDMF_LOAN_ORIG_PIT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_SDW_TSDMF_LOAN_ORIG_PIT

Columns
# Name Data Type Length
1 FACILITY_DIM_ID BIGINT 8
2 PERIOD_DIM_ID BIGINT 8
3 SOURCE_SYSTEM_DIM_ID BIGINT 8
4 FACILITY_STATUS_DIM_ID BIGINT 8
5 APPLICATION_DIM_ID BIGINT 8
6 ACCOUNT_DIM_ID BIGINT 8
7 CDTL_APPROVAL_PERIOD_DIM_ID BIGINT 8
8 UNCDTL_APPROVAL_PERIOD_DIM_ID BIGINT 8
9 CLIENT_ACCEPTED_PERIOD_DIM_ID BIGINT 8
10 CLIENT_ADVISED_PERIOD_DIM_ID BIGINT 8
11 SETTLED_PERIOD_DIM_ID BIGINT 8
12 FINANCED_PERIOD_DIM_ID BIGINT 8
13 SOURCE_PRODUCT_DIM_ID BIGINT 8
14 SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
15 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
16 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
17 LOAN_PURPOSE_DIM_ID BIGINT 8
18 BILL_TYPE_DIM_ID BIGINT 8
19 ACCOUNT_SECURITY_DIM_ID BIGINT 8
20 SOURCE_CURRENCY_DIMENSION_ID BIGINT 8
21 INTEREST_RATE_DIM_ID BIGINT 8
22 CHANNEL_DIM_ID BIGINT 8
23 GCIS_CUSTOMER_DIM_ID BIGINT 8
24 CUSTOMER_DIM_ID BIGINT 8
25 CUST_CLASSIFIER_DIM_ID BIGINT 8
26 ANZSIC_DIM_ID BIGINT 8
27 CUSTOMER_ADDRESS_DIM_ID BIGINT 8
28 COUNTERPARTY_TYPE_DIM_ID BIGINT 8
29 INTEREST_RATE_TERM_DIM_ID BIGINT 8
30 ORIG_LOAN_VALUE_RATIO_DIM_ID BIGINT 8
31 MATERIALITY_DIM_ID BIGINT 8
32 FACILITY_DECISION_DIM_ID BIGINT 8
33 LND_POLICY_GL_TYPE_DIM_ID BIGINT 8
34 OF_PRODUCT_SID BIGINT 8
35 OF_COST_CENTRE_SID BIGINT 8
36 TOTAL_LOAN_AMOUNT NUMERIC(14,2) 19
37 TOTAL_FUNDING_AMOUNT NUMERIC(14,2) 19
38 TOTAL_CAPITALISED_FEE_AMOUNT NUMERIC(14,2) 19
39 TOTAL_CAPITALISED_INS_AMOUNT NUMERIC(14,2) 19
40 NEW_LOAN_AMOUNT NUMERIC(14,2) 19
41 NEW_COMMIT_AMOUNT NUMERIC(14,2) 19
42 NEW_COMMIT_COUNT NUMERIC(38,0) 19
43 BUSINESS_LOAD_DATE TIMESTAMP 8
44 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
45 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
46 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
47 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8