FCT_BNK_CREDIT_RISK_PRVN

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 ACCOUNT_NUMBER CHARACTER VARYING(20) 20
4 RISK_POINT_ID CHARACTER VARYING(20) 20
5 SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
6 ACCOUNT_DIM_ID BIGINT 8
7 IMPAIRMENT_START_PERIOD_DIM_ID BIGINT 8
8 OF_GL_INELIG_COLL_PRVN_DIM_ID BIGINT 8
9 OF_GL_ELIG_RSRV_COLL_DIM_ID BIGINT 8
10 OF_GL_SPECFC_PRVN_OBANK_DIM_ID BIGINT 8
11 OF_GL_SPECFC_PRVN_WBACK_DIM_ID BIGINT 8
12 OF_GL_SPECFC_PRVN_IFRS_DIM_ID BIGINT 8
13 OF_GL_SPECFC_PRVN_DIM_ID BIGINT 8
14 OF_GL_COLL_PRVN_DIM_ID BIGINT 8
15 OF_GL_INBA_DIM_ID BIGINT 8
16 ACCT_CREDIT_RISK_DIM_ID BIGINT 8
17 PRVN_TYPE_DIM_ID BIGINT 8
18 EXPECTED_LOSS_AMOUNT NUMERIC(23,8) 19
19 INBA_AMOUNT NUMERIC(14,2) 19
20 SECURITY_HELD_AMOUNT NUMERIC(23,8) 19
21 COLL_PRVN_AMOUNT NUMERIC(23,8) 19
22 SPECFC_PRVN_AMOUNT NUMERIC(23,8) 19
23 SPECFC_PRVN_IFRS_AMOUNT NUMERIC(23,8) 19
24 SPECFC_PRVN_WRITE_BACK_AMOUNT NUMERIC(23,8) 19
25 SPECFC_PRVN_OTHER_BANK_AMOUNT NUMERIC(23,8) 19
26 ELIG_RESERVE_COLL_PRVN_AMOUNT NUMERIC(23,8) 19
27 INELIG_COLL_PRV_AMOUNT NUMERIC(23,8) 19
28 BUSINESS_LOAD_DATE TIMESTAMP 8
29 SRC_SCR_ID_CODE CHARACTER VARYING(20) 20
30 NET_IMPAIRED_AMOUNT NUMERIC(38,2) 19
31 SDW_IGNITE_SOURCE CHARACTER VARYING(1) 1
32 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
33 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
34 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
35 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8