FCT_BNK_TM1_OBP_LOAN_ORIG_ACCOUNT_DETAIL_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

Regulatory Reporting Insight used in TM1. OBP DATA ONLY at app ID grain

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