FCT_BNK_LOAN_ORIG_PERIOD

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_BNK_LOAN_ORIG_PERIOD_V

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(105) 105
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 DOUBLE PRECISION 8
33 CLOSING_TOTAL_LOAN_AMOUNT DOUBLE PRECISION 8
34 OPENING_TOTAL_FUNDING_AMOUNT DOUBLE PRECISION 8
35 CLOSING_TOTAL_FUNDING_AMOUNT DOUBLE PRECISION 8
36 OPENING_TOTAL_CPZ_FEES_AMOUNT DOUBLE PRECISION 8
37 CLOSING_TOTAL_CPZ_FEES_AMOUNT DOUBLE PRECISION 8
38 OPENING_TOTAL_CPZ_INS_AMOUNT DOUBLE PRECISION 8
39 CLOSING_TOTAL_CPZ_INS_AMOUNT DOUBLE PRECISION 8
40 OPENING_COMMIT_AMOUNT DOUBLE PRECISION 8
41 CLOSING_COMMIT_AMOUNT DOUBLE PRECISION 8
42 INCREASED_COMMIT_AMOUNT DOUBLE PRECISION 8
43 DECREASED_COMMIT_AMOUNT DOUBLE PRECISION 8
44 CANCELLED_COMMIT_AMOUNT DOUBLE PRECISION 8
45 OPENING_NEW_LOAN_AMOUNT NUMERIC(14,2) 19
46 CLOSING_NEW_LOAN_AMOUNT NUMERIC(14,2) 19
47 NEW_COMMIT_AMOUNT DOUBLE PRECISION 8
48 NEW_COMMIT_COUNT NUMERIC(38,0) 19
49 BUSINESS_LOAD_DATE TIMESTAMP 8
50 SDW_IGNITE_SOURCE CHARACTER VARYING(1) 1
51 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
52 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
53 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
54 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8