FCT_OBP_TM1_CREDIT_RISK_PRVN_SUMM

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 VERSION_DIM_ID BIGINT 8
3 OF_ENTITY_CODE CHARACTER VARYING(150) 150
4 OF_CATEGORY_CODE CHARACTER VARYING(150) 150
5 OF_ACCOUNT_CODE CHARACTER VARYING(150) 150
6 OF_INTERCOMPANY_CODE CHARACTER VARYING(150) 150
7 OF_PRODUCT_CODE CHARACTER VARYING(150) 150
8 OF_COST_CENTRE_CODE CHARACTER VARYING(150) 150
9 IMPAIRED_FLAG CHARACTER VARYING(24) 24
10 INBA_EXIST CHARACTER VARYING(5) 5
11 SPECIFIC_PROVISION_FLAG CHARACTER VARYING(5) 5
12 ASSET_QUALITY CHARACTER VARYING(256) 256
13 PAST_DUE_BAND CHARACTER VARYING(30) 30
14 PAYMENT_PERFORMANCE_TYPE_DESC CHARACTER VARYING(28) 28
15 RESTRUCTURED_INDICATOR_DESC CHARACTER VARYING(24) 24
16 CREDIT_MANAGEMENT_TYPE_DESC CHARACTER VARYING(26) 26
17 CORE_NON_CORE_FLAG_DESC CHARACTER VARYING(27) 27
18 OWNER_OCCUPIED_INVESTMENT_DESC CHARACTER VARYING(100) 100
19 ANZSIC_DIVISION CHARACTER VARYING(209) 209
20 COUNTERPARTY_TYPE CHARACTER VARYING(256) 256
21 MATERIALITY_BAND_DESC CHARACTER VARYING(42) 42
22 COMMERCIAL_PTY_TYPE_DESC CHARACTER VARYING(23) 23
23 COMMERCIAL_PTY_EXPOSURE_FLAG CHARACTER VARYING(27) 27
24 MEASURE CHARACTER VARYING(29) 29
25 VALUE DOUBLE PRECISION 8