SDW_TSDMF_CREDIT_RISK_PRVN

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_SDW_TSDMF_CREDIT_RISK_PRVN

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(14,2) 19
31 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
32 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
33 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
34 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8