FCT_SDW_TSDMF_CREDIT_USAGE_SUMM

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

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(24) 24
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 NUMERIC(14,2) 19
24 CLOSING_PRINCIPAL_LIMIT NUMERIC(14,2) 19
25 OPENING_BALANCE NUMERIC(14,2) 19
26 CLOSING_BALANCE NUMERIC(14,2) 19
27 ORIG_SETTLED_COMMIT_AMOUNT NUMERIC(14,2) 19
28 NEW_COMMIT_AMOUNT NUMERIC(14,2) 19
29 REDUCED_CANCELLED_LIMIT NUMERIC(14,2) 19
30 OPENING_UNDRAWN_COMMIT_AMOUNT NUMERIC(14,2) 19
31 CLOSING_UNDRAWN_COMMIT_AMOUNT NUMERIC(14,2) 19
32 TERM_LOAN_TOTAL_ADV_AMOUNT NUMERIC(14,2) 19
33 OPENING_REVOLVING_CR_UNUSED NUMERIC(14,2) 19
34 CLOSING_REVOLVING_CR_UNUSED NUMERIC(14,2) 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 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
39 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
40 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
41 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8