FCT_BNK_CREDIT_USAGE_SUMM_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

OBP Hogan and CLMS monthly account product and customer level summary of opening and closing balances with new commitments reduced limits and undrawn amounts

Columns
# Name Data Type Length
1 ACCOUNT_DIM_ID BIGINT 8
2 CLOSING_PERIOD_DIM_ID BIGINT 8
3 PORTFOLIO_FACILITY_DIM_ID BIGINT 8
4 PERIOD_TYPE_DIM_ID BIGINT 8
5 OPENING_PERIOD_DIM_ID BIGINT 8
6 SOURCE_SYSTEM_DIM_ID BIGINT 8
7 LATEST_FACILITY_DIM_ID BIGINT 8
8 ORIGINAL_FACILITY_DIM_ID BIGINT 8
9 SOURCE_PRODUCT_DIM_ID BIGINT 8
10 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
11 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
12 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
13 LOAN_PURPOSE_DIM_ID BIGINT 8
14 ACCOUNT_SECURITY_DIM_ID BIGINT 8
15 GCIS_CUSTOMER_DIM_ID BIGINT 8
16 CUSTOMER_DIM_ID BIGINT 8
17 CUSTOMER_ADDRESS_DIM_ID BIGINT 8
18 CUST_CLASSIFIER_DIM_ID BIGINT 8
19 ANZSIC_DIM_ID BIGINT 8
20 COUNTERPARTY_TYPE_DIM_ID BIGINT 8
21 COMMIT_STATUS_DIM_ID BIGINT 8
22 OF_GENERAL_LEDGER_DIM_ID BIGINT 8
23 OPENING_PRINCIPAL_LIMIT DOUBLE PRECISION 8
24 CLOSING_PRINCIPAL_LIMIT DOUBLE PRECISION 8
25 OPENING_BALANCE NUMERIC(37,2) 19
26 CLOSING_BALANCE NUMERIC(37,2) 19
27 ORIG_SETTLED_COMMIT_AMOUNT DOUBLE PRECISION 8
28 NEW_COMMIT_AMOUNT DOUBLE PRECISION 8
29 REDUCED_CANCELLED_LIMIT DOUBLE PRECISION 8
30 OPENING_UNDRAWN_COMMIT_AMOUNT DOUBLE PRECISION 8
31 CLOSING_UNDRAWN_COMMIT_AMOUNT DOUBLE PRECISION 8
32 TERM_LOAN_TOTAL_ADV_AMOUNT DOUBLE PRECISION 8
33 OPENING_REVOLVING_CR_UNUSED NUMERIC(38,6) 19
34 CLOSING_REVOLVING_CR_UNUSED NUMERIC(38,6) 19
35 REVOLVING_CR_NEW_COMMIT_UNUSED NUMERIC(14,2) 19
36 REVOLVING_CR_NEW_COMMIT_USED NUMERIC(14,2) 19
37 BUSINESS_LOAD_DATE TIMESTAMP 8
38 SDW_IGNITE_SOURCE CHARACTER VARYING(1) 1
39 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
40 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
41 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
42 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8