FCT_BNK_CREDIT_USAGE_SUMM_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..FCT_BNK_CREDIT_USAGE_SUMM

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