SDW_TSDMF_RISK_WEIGHT_ASSETS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

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 SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
5 PRODUCT_TYPE CHARACTER VARYING(20) 20
6 SOURCE_PRODUCT_DIM_ID BIGINT 8
7 ACCOUNT_DIM_ID BIGINT 8
8 SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
9 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
10 COST_CENTRE_DIM_ID BIGINT 8
11 GL_BUSINESS_UNIT_DIM_ID BIGINT 8
12 GL_PRODUCT_DIM_ID BIGINT 8
13 GL_ACCOUNT_DIM_ID BIGINT 8
14 SECURITISATION_DIM_ID BIGINT 8
15 REG_LOAN_VAL_RATIO_DIM_ID BIGINT 8
16 REG_CREDIT_RATING_DIM_ID BIGINT 8
17 ACCOUNT_SECURITY_DIM_ID BIGINT 8
18 ACCT_CLASSIFIER_DIM_ID BIGINT 8
19 ACCT_CREDIT_RISK_DIM_ID BIGINT 8
20 ACCT_CREDIT_RISK_GUAR_DIM_ID BIGINT 8
21 SPECFC_PRVN_RATIO_DIM_ID BIGINT 8
22 APRA_ASSET_CLASS_DIM_ID BIGINT 8
23 APRA_CL_OFF_BAL_REDRAW_DIM_ID BIGINT 8
24 APRA_CL_OFF_BAL_UNDRAWN_DIM_ID BIGINT 8
25 APRA_CL_OFF_BAL_GUAR_DIM_ID BIGINT 8
26 DAYS_PAST_DUE_DIM_ID BIGINT 8
27 ORIG_TERM_MATURITY_DIM_ID BIGINT 8
28 IN_EXCESS_PERIOD_DIM_ID BIGINT 8
29 IMPAIRED_PERIOD_DIM_ID BIGINT 8
30 IMPAIRED_GUAR_PERIOD_DIM_ID BIGINT 8
31 MATURITY_PERIOD_DIM_ID BIGINT 8
32 SETTLEMENT_PERIOD_DIM_ID BIGINT 8
33 NEXT_REPRICE_PERIOD_DIM_ID BIGINT 8
34 LAST_REPRICE_PERIOD_DIM_ID BIGINT 8
35 PORTFOLIO_PERIOD_DIM_ID BIGINT 8
36 RWA_PROD_CATEGORY_DIM_ID BIGINT 8
37 RWA_PROD_CATEGORY_GUAR_DIM_ID BIGINT 8
38 COMMIT_CL_UNDRAWN_DIM_ID BIGINT 8
39 COMMIT_CL_REDRAW_DIM_ID BIGINT 8
40 SOURCE_CURRENCY_DIMENSION_ID BIGINT 8
41 RWA_CUSTOMER_TYPE_DIM_ID BIGINT 8
42 OF_GL_PRINCIPAL_BALANCE_DIM_ID BIGINT 8
43 OF_GL_INT_INCOME_ACR_DIM_ID BIGINT 8
44 OF_GL_INBA_DIM_ID BIGINT 8
45 CUSTOMER_ADDRESS_PARENT_DIM_ID BIGINT 8
46 CUSTOMER_ADDRESS_RSDNC_DIM_ID BIGINT 8
47 CUSTOMER_ADDRESS_RISK_DIM_ID BIGINT 8
48 NET_CREDIT_EXPOSURE_AMOUNT NUMERIC(14,2) 19
49 EXPOSURE_AT_DEFAULT_AMOUNT NUMERIC(14,2) 19
50 SPECFC_PRVN_AMOUNT NUMERIC(14,2) 19
51 SPECFC_PRVN_GUAR_AMOUNT NUMERIC(14,2) 19
52 PAST_DUE_AMOUNT NUMERIC(14,2) 19
53 FACE_AMOUNT NUMERIC(14,2) 19
54 REG_LOAN_VAL_RATIO NUMERIC(15,5) 19
55 SPECFC_PRVN_RATIO NUMERIC(6,2) 19
56 INBA_AMOUNT NUMERIC(14,2) 19
57 ACCRUED_INTEREST NUMERIC(23,8) 19
58 AVAILABLE_CASHBACK NUMERIC(14,2) 19
59 CALCULATED_AVAILABLE_BALANCE NUMERIC(14,2) 19
60 GUARANTEE_DRAWN_AMOUNT NUMERIC(14,2) 19
61 GUARANTEE_LIMIT NUMERIC(14,2) 19
62 CALCULATED_LIMIT NUMERIC(14,2) 19
63 RAW_LIMIT NUMERIC(14,2) 19
64 OFF_BAL_GUAR_PRINCIPAL_AMT NUMERIC(14,2) 19
65 OFF_BAL_UNDRAWN_PRINCIPAL_AMT NUMERIC(14,2) 19
66 ALLOCATED_CASH_COLL_VAL NUMERIC(23,8) 19
67 RISK_WEIGHT NUMERIC(6,2) 19
68 RWA_OFF_BAL_GUAR_AMOUNT NUMERIC(23,8) 19
69 RWA_OFF_BAL_UNDRAWN_AMOUNT NUMERIC(23,8) 19
70 RWA_OFF_BAL_REDRAW_AMOUNT NUMERIC(23,8) 19
71 RWA_ON_BAL NUMERIC(23,8) 19
72 CREDIT_CONV_FACTOR_GUAR NUMERIC(6,2) 19
73 CREDIT_CONV_FACTOR_UNDRAWN NUMERIC(6,2) 19
74 CREDIT_CONV_FACTOR_REDRAW NUMERIC(6,2) 19
75 COLL_GROUP_ID_ALL_ASSETS BIGINT 8
76 COLL_GROUP_ID_ELIG_RSDNT_MTGE BIGINT 8
77 COLL_GROUP_ID_ELIG_FIN_COLL BIGINT 8
78 DEBT_RECOV_SYS_GROUP_ID CHARACTER VARYING(20) 20
79 DEBT_RECOV_SYS_GUAR_GROUP_ID CHARACTER VARYING(20) 20
80 CREDIT_EQUIVALENT_GUAR_AMT NUMERIC(23,8) 19
81 CREDIT_EQUIVALENT_UNDRAWN_AMT NUMERIC(23,8) 19
82 CREDIT_EQUIVALENT_REDRAW_AMT NUMERIC(23,8) 19
83 BUSINESS_LOAD_DATE TIMESTAMP 8
84 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
85 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
86 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
87 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8