FCT_BNK_IFRS_CPEL_DATA_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP02_BANK..FCT_BNK_IFRS_CPEL_DATA

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