IFRS_CPEL_DATA

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..QRMCGN_IFRS_CPEL_DATA

Columns
# Name Data Type Length
1 ACCOUNT_NUMBER CHARACTER VARYING(20) 20
2 ACCRUED_INTEREST NUMERIC(15,2) 19
3 APRA_ASSET_CLASS_IRB CHARACTER VARYING(100) 100
4 COMPOSITE_CA_CDR_ORIGINATION CHARACTER VARYING(10) 10
5 COMPOSITE_CDR CHARACTER VARYING(10) 10
6 COMPOSITE_CR CHARACTER VARYING(8) 8
7 COMPOSITE_RATINGS_MODEL INTEGER 4
8 CP_115701 DOUBLE PRECISION 8
9 CP_115701_PRE_OVERLAY DOUBLE PRECISION 8
10 CP_115702 DOUBLE PRECISION 8
11 CP_115702_PRE_OVERLAY DOUBLE PRECISION 8
12 CP_310803 DOUBLE PRECISION 8
13 CREDIT_QUALITY CHARACTER VARYING(50) 50
14 ECL_STAGE INTEGER 4
15 EL_OVERLAY DOUBLE PRECISION 8
16 ERCL_310701 DOUBLE PRECISION 8
17 EXPOSURE NUMERIC(15,2) 19
18 FACE_AMT NUMERIC(15,2) 19
19 ID_NUMBER CHARACTER VARYING(50) 50
20 IMPDPASTDUE_FLAG CHARACTER VARYING(1) 1
21 INBA NUMERIC(17,2) 19
22 INTERNAL_PD_MODEL CHARACTER VARYING(50) 50
23 LIFETIME_EL DOUBLE PRECISION 8
24 LIFETIME_EL_PRE_OVERLAY DOUBLE PRECISION 8
25 NET_IMPAIRED NUMERIC(17,2) 19
26 NON_RETAIL_MGT_OVERLAY DOUBLE PRECISION 8
27 ORACLE_GL_ACCOUNT CHARACTER VARYING(8) 8
28 ORACLE_GL_BUSINESS_UNIT CHARACTER VARYING(8) 8
29 ORACLE_GL_COST_CENTRE CHARACTER VARYING(8) 8
30 ORACLE_GL_COST_CENTRE_CHANNEL CHARACTER VARYING(40) 40
31 ORACLE_GL_PRODUCT CHARACTER VARYING(10) 10
32 PAST_DUE_CATEGORY CHARACTER VARYING(50) 50
33 PORTBASED_CATEGORY CHARACTER VARYING(75) 75
34 PORTFOLIO_DATE TIMESTAMP 8
35 PROVISION_AMOUNT_COLLECTIVE DOUBLE PRECISION 8
36 PROVISION_AMOUNT_IFRS DOUBLE PRECISION 8
37 PROVISION_ERCL DOUBLE PRECISION 8
38 QRM_ACCOUNT CHARACTER VARYING(75) 75
39 RATINGS_BASED_APPROACH CHARACTER VARYING(1) 1
40 RESTRUCTURED_FLAG CHARACTER VARYING(1) 1
41 RETAIL_MGT_OVERLAY DOUBLE PRECISION 8
42 RULE_DESCRIPTION CHARACTER VARYING(50) 50
43 SICR_MRS_FLAG CHARACTER VARYING(1) 1
44 SICR_30_DPD_FLAG CHARACTER VARYING(1) 1
45 SOURCE_SYSTEM CHARACTER VARYING(4) 4
46 SP_115601 DOUBLE PRECISION 8
47 SP_115602_000 DOUBLE PRECISION 8
48 SP_115602_W28 DOUBLE PRECISION 8
49 SP_115604 DOUBLE PRECISION 8
50 SP_591224 DOUBLE PRECISION 8
51 SP_591225 DOUBLE PRECISION 8
52 SP_IND INTEGER 4
53 STAGE_1_EAD DOUBLE PRECISION 8
54 STAGE_1_ECL DOUBLE PRECISION 8
55 STAGE_1_LGD DOUBLE PRECISION 8
56 STAGE_1_PD DOUBLE PRECISION 8
57 STAGE_2_EAD DOUBLE PRECISION 8
58 STAGE_2_ECL DOUBLE PRECISION 8
59 STAGE_2_LGD DOUBLE PRECISION 8
60 STAGE_2_PD DOUBLE PRECISION 8
61 STAGE_3_EAD DOUBLE PRECISION 8
62 STAGE_3_ECL DOUBLE PRECISION 8
63 STAGE_3_LGD DOUBLE PRECISION 8
64 STAGE_3_PD DOUBLE PRECISION 8
65 STAT_STAGE_1 DOUBLE PRECISION 8
66 STAT_STAGE_1_DRAWN_ECL DOUBLE PRECISION 8
67 STAT_STAGE_1_UNDRAWN_ECL DOUBLE PRECISION 8
68 STAT_STAGE_2 DOUBLE PRECISION 8
69 STAT_STAGE_2_DRAWN_ECL DOUBLE PRECISION 8
70 STAT_STAGE_2_UNDRAWN_ECL DOUBLE PRECISION 8
71 STAT_STAGE_3 DOUBLE PRECISION 8
72 STAT_STAGE_3_DRAWN_ECL DOUBLE PRECISION 8
73 STAT_STAGE_3_UNDRAWN_ECL DOUBLE PRECISION 8
74 TCE_GROUP_ID BIGINT 8
75 TCE_GROUP_NAME CHARACTER VARYING(350) 350
76 DATA_DATE TIMESTAMP 8
77 LOAD_ID INTEGER 4
78 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
79 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
80 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
81 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8