SDW_TSDMF_BSC_MEASURES

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 MSR_PRD_DIM_ID BIGINT 8
2 PROD_DIM_ID BIGINT 8
3 AR_DIM_ID BIGINT 8
4 CLS_BSC_PORTFOLIO_ID BIGINT 8
5 OPN_BSC_PORTFOLIO_ID BIGINT 8
6 BSC_EVENT_TP_CD CHARACTER VARYING(2) 2
7 CLS_BAL NUMERIC(14,2) 19
8 MIN_BAL NUMERIC(14,2) 19
9 MAX_BAL NUMERIC(14,2) 19
10 AVG_BAL NUMERIC(14,2) 19
11 AVG_DR_BAL NUMERIC(14,2) 19
12 AVG_CR_BAL NUMERIC(14,2) 19
13 CLS_PURCHASES_BAL NUMERIC(14,2) 19
14 CLS_CASH_ADVANCE_BAL NUMERIC(14,2) 19
15 CLS_SPECIAL_BAL NUMERIC(14,2) 19
16 CLS_AVAIL_CASH_ADVANCE_BAL NUMERIC(14,2) 19
17 NBR_DAYS_DR_BAL BIGINT 8
18 NBR_DAYS_CR_BAL BIGINT 8
19 DT_LAST_CUST_INIT_CR_TXN_LTD TIMESTAMP 8
20 DT_LAST_CUST_INIT_DR_TXN_LTD TIMESTAMP 8
21 DT_LAST_PAYMENT_TXN_LTD TIMESTAMP 8
22 DT_LAST_PURCHASE_TXN_LTD TIMESTAMP 8
23 DT_LAST_DISHONOUR_PYMT_TXN_LTD TIMESTAMP 8
24 DT_LAST_CASH_ADVANCE_TXN_LTD TIMESTAMP 8
25 DT_LAST_DR_BAL_LTD TIMESTAMP 8
26 DT_LAST_CR_BAL_LTD TIMESTAMP 8
27 DT_LAST_FRML_CR_LMT_CHANGE_LTD TIMESTAMP 8
28 DT_LAST_FRML_CR_LMT_INCR_LTD TIMESTAMP 8
29 DT_LAST_FRML_CR_LMT_DECR_LTD TIMESTAMP 8
30 ORIG_FRML_CNTIG_CR_LMT NUMERIC(14,2) 19
31 STRT_DT_ORIG_FRML_CNTIG_CR_LMT TIMESTAMP 8
32 ORIG_FORMAL_CR_LIMIT NUMERIC(14,2) 19
33 OPN_FORMAL_CR_LIMIT NUMERIC(14,2) 19
34 CLS_FORMAL_CR_LIMIT NUMERIC(14,2) 19
35 CLS_TEMP_CR_LIMIT_ACTIVE_FL CHARACTER VARYING(1) 1
36 CLS_TEMP_CR_LIMIT NUMERIC(14,2) 19
37 CLS_CASH_ADVANCE_LIMIT NUMERIC(14,2) 19
38 CLS_EXCESS_AMT NUMERIC(14,2) 19
39 AVG_EXCESS_AMT NUMERIC(14,2) 19
40 MAX_EXCESS_AMT NUMERIC(14,2) 19
41 NBR_EXCESS_EVENTS BIGINT 8
42 NBR_DAYS_EXCESS BIGINT 8
43 NBR_DAYS_CURR_EXCESS_EVENT BIGINT 8
44 DT_LAST_EXCESS_LTD TIMESTAMP 8
45 DT_STRT_LAST_EXCESS_EVENT_LTD TIMESTAMP 8
46 CLS_ARREARS_AMT NUMERIC(14,2) 19
47 MAX_ARREARS_AMT_CURR_ARREARS NUMERIC(14,2) 19
48 DT_STRT_LAST_ARREARS_EVENT_LTD TIMESTAMP 8
49 DT_END_LAST_ARREARS_EVENT_LTD TIMESTAMP 8
50 NBR_DAYS_ARREARS_AMT BIGINT 8
51 NBR_DAYS_DELQ BIGINT 8
52 TOT_WRITEOFF_AMT NUMERIC(14,2) 19
53 CLS_DR_ANNUAL_INT_RATE NUMERIC(8,5) 19
54 CLS_BAL_CYCLE NUMERIC(14,2) 19
55 NBR_DAYS_ARREARS_CYCLE BIGINT 8
56 CLS_ARREARS_AMT_CYCLE NUMERIC(14,2) 19
57 VAL_LAST_PAYMENT_TXN_LTD NUMERIC(14,2) 19
58 VAL_CASH_ADVANCE_TXN_CYCLE NUMERIC(14,2) 19
59 MIN_REPAYMENT_REQUIRED_AMT NUMERIC(14,2) 19
60 NBR_NET_CUST_INITIATED_CR_TXN BIGINT 8
61 VAL_NET_CUST_INITIATED_CR_TXN NUMERIC(14,2) 19
62 NBR_NET_CUST_INITIATED_DR_TXN BIGINT 8
63 VAL_NET_CUST_INITIATED_DR_TXN NUMERIC(14,2) 19
64 NBR_NET_DR_TXN BIGINT 8
65 VAL_NET_DR_TXN NUMERIC(14,2) 19
66 NBR_NET_CR_TXN BIGINT 8
67 VAL_NET_CR_TXN NUMERIC(14,2) 19
68 NBR_NET_INBOUND_CR_TXN BIGINT 8
69 VAL_NET_INBOUND_CR_TXN NUMERIC(14,2) 19
70 NBR_NET_HONOURED_OUTWARD_TXN BIGINT 8
71 VAL_NET_HONOURED_OUTWARD_TXN NUMERIC(14,2) 19
72 NBR_DISHONOURED_OUTWARD_TXN BIGINT 8
73 VAL_DISHONOURED_OUTWARD_TXN NUMERIC(14,2) 19
74 NBR_NET_DISHONOURED_INWARD_TXN BIGINT 8
75 VAL_NET_DISHONOURED_INWARD_TXN NUMERIC(14,2) 19
76 VAL_NET_CASH_ADVANCE_TXN NUMERIC(14,2) 19
77 NBR_NET_CASH_ADVANCE_TXN BIGINT 8
78 NBR_NET_PURCHASE_TXN BIGINT 8
79 NBR_SPECIAL_TXN BIGINT 8
80 NBR_NET_TXN BIGINT 8
81 VAL_NET_SUNCORP_FEE_TXN NUMERIC(14,2) 19
82 VAL_NET_INT_CHARGED_TXN NUMERIC(14,2) 19
83 VAL_NET_INT_PAID_TXN NUMERIC(14,2) 19
84 VAL_NET_EXCESS_FEE_TXN NUMERIC(14,2) 19
85 VAL_NET_ARREARS_FEE_TXN NUMERIC(14,2) 19
86 END_DT_ORIG_FRML_CNTIG_CR_LMT TIMESTAMP 8
87 CLS_NBR_MO_TERM_REMAINING BIGINT 8
88 CLS_DERIVED_LOAN_LIMIT NUMERIC(14,2) 19
89 CLS_PAID_ADVANCE_AMT NUMERIC(14,2) 19
90 DT_STRT_LAST_INBA_EVENT_LTD TIMESTAMP 8
91 DT_END_LAST_INBA_EVENT_LTD TIMESTAMP 8
92 CLS_DR_ANNUAL_INT_DISCNT_RATE NUMERIC(8,5) 19
93 CLS_CAPITAL_BAL NUMERIC(14,2) 19
94 CLS_CURR_AMT_DUE_BAL NUMERIC(14,2) 19
95 CLS_PRINCIPAL_LIMIT NUMERIC(14,2) 19
96 CLS_GUARANTEE_LIMIT NUMERIC(14,2) 19
97 CLS_INT_CAPITALISE_LIMIT NUMERIC(14,2) 19
98 NBR_MTH_IN_REPAYMENT_FREQ BIGINT 8
99 NBR_REPAYMENT_DELQ NUMERIC(15,5) 19
100 MAX_ARREARS_AMT NUMERIC(14,2) 19
101 DT_STRT_LAST_CNTIG_ARRS_EV_LTD TIMESTAMP 8
102 DT_END_LAST_CNTIG_ARRS_EV_LTD TIMESTAMP 8
103 LAST_PENALTY_INT_CHARGED_AMT NUMERIC(14,2) 19
104 INBA_STRT_PERIOD_DT TIMESTAMP 8
105 OLDST_OS_INBA_INSTLMT_DUE_DT TIMESTAMP 8
106 NBR_OS_INBA_INSTLMT BIGINT 8
107 NBR_DAYS_ARREARS_LTD BIGINT 8
108 EXPIRY_BALLOON_REPAYMENT_AMT NUMERIC(14,2) 19
109 NEXT_SPECIAL_REPAYMENT_DUE_AMT NUMERIC(14,2) 19
110 NEXT_SPECIAL_REPAYMENT_DUE_DT TIMESTAMP 8
111 DT_STRT_ARREARS_AMT TIMESTAMP 8
112 DT_STRT_LAST_COLL_EV_LTD TIMESTAMP 8
113 DT_END_LAST_COLL_EV_LTD TIMESTAMP 8
114 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
115 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
116 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
117 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8