SDW_TSDMF_PORTFOLIO_LMT_PIT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PORTFOLIO_FACILITY_DIM_ID BIGINT 8
2 PERIOD_DIM_ID BIGINT 8
3 SOURCE_SYSTEM_DIM_ID BIGINT 8
4 SOURCE_PRODUCT_DIM_ID BIGINT 8
5 SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
6 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
7 CURRENT_LOAN_VAL_RATIO_DIM_ID BIGINT 8
8 MAXIMUM_LOAN_VAL_RATIO_DIM_ID BIGINT 8
9 SOURCE_CURRENCY_DIMENSION_ID BIGINT 8
10 MATERIALITY_DIM_ID BIGINT 8
11 LOAN_PURPOSE_DIM_ID BIGINT 8
12 ACCOUNT_SECURITY_DIM_ID BIGINT 8
13 GCIS_CUSTOMER_DIM_ID BIGINT 8
14 CUSTOMER_DIM_ID BIGINT 8
15 CUSTOMER_ADDRESS_DIM_ID BIGINT 8
16 CUST_CLASSIFIER_DIM_ID BIGINT 8
17 ANZSIC_DIM_ID BIGINT 8
18 COUNTERPARTY_TYPE_DIM_ID BIGINT 8
19 LAST_MARGIN_CALL_PERIOD_DIM_ID BIGINT 8
20 PRINCIPAL_LIMIT NUMERIC(15,5) 19
21 BORROWING_LIMIT NUMERIC(15,5) 19
22 MAXIMUM_LOAN_VAL_RATIO NUMERIC(7,3) 19
23 CURRENT_LOAN_VAL_RATIO NUMERIC(7,3) 19
24 MARGIN_EXCEED_LIMIT NUMERIC(7,3) 19
25 UNUSED_CREDIT_LIMIT NUMERIC(14,2) 19
26 BALANCE NUMERIC(14,2) 19
27 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
28 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
29 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
30 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8