SDW_TCRPF_CREDIT_PRTFL_SNPSHT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 LOAD_STATUS_FLAG CHARACTER VARYING(1) 1
3 INSERT_RUN_AUDIT_ID BIGINT 8
4 UPDATE_RUN_AUDIT_ID BIGINT 8
5 CREDIT_PORTFOLIO_DIM_ID BIGINT 8
6 ACCOUNT_CHARACTERISTIC_DIM_ID BIGINT 8
7 PRODUCT_DIM_ID BIGINT 8
8 CREDIT_PRODUCT_GROUP_DIM_ID BIGINT 8
9 SECURITISATION_DIM_ID BIGINT 8
10 CLMS_GROUP_DIM_ID BIGINT 8
11 DRS_GROUP_DIM_ID BIGINT 8
12 BORROWER_DIM_ID BIGINT 8
13 ACCOUNT_DIM_ID BIGINT 8
14 STATE_DIM_ID BIGINT 8
15 DEPARTMENT_DIM_ID BIGINT 8
16 CREDIT_LIMIT_TYPE_DIM_ID BIGINT 8
17 ARREARS_CATEGORY_DIM_ID BIGINT 8
18 ANZSIC_DIM_ID BIGINT 8
19 WATCHLIST_STRATEGY_DIM_ID BIGINT 8
20 SR_DIM_ID BIGINT 8
21 CQR_DIM_ID BIGINT 8
22 CHANNEL_DIM_ID BIGINT 8
23 PAST_DUE_IN_DAYS BIGINT 8
24 PAST_DUE_AMOUNT NUMERIC(19,2) 19
25 BALANCE NUMERIC(19,2) 19
26 RECEIVABLES_OUTSTANDING NUMERIC(19,2) 19
27 LIMIT NUMERIC(19,2) 19
28 ACCRUED_INTEREST NUMERIC(19,2) 19
29 INBA NUMERIC(19,2) 19
30 SPECIFIC_PROVISION_AMOUNT NUMERIC(19,2) 19
31 SSV NUMERIC(19,2) 19
32 DATE_ENTERED_WL TIMESTAMP 8
33 DATE_EXITED_WL TIMESTAMP 8
34 DATE_ENTERED_CR TIMESTAMP 8
35 DATE_EXITED_CR TIMESTAMP 8
36 DAYS_TO_MATURITY BIGINT 8
37 YEARS_TO_MATURITY NUMERIC(4,2) 19
38 INTEREST_RATE NUMERIC(8,5) 19
39 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
40 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
41 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
42 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8