SDW_TSDSA_RTL_LND_MONTHLY

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PERIOD_ID BIGINT 8
2 ACCOUNT_DIM_ID BIGINT 8
3 CUSTOMER_DIM_ID BIGINT 8
4 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
5 OPENING_SOURCE_PRODUCT_DIM_ID BIGINT 8
6 CLOSING_SOURCE_PRODUCT_DIM_ID BIGINT 8
7 OF_COST_CENTRE_SID BIGINT 8
8 ACCOUNT_STATUS_DIM_ID BIGINT 8
9 RTL_LND_BALANCE_TIER_DIM_ID BIGINT 8
10 TOTAL_GUARANTEE_VALUE NUMERIC(14,2) 19
11 PRINCIPLE_LIMIT NUMERIC(15,5) 19
12 OPENING_BALANCE NUMERIC(14,2) 19
13 CLOSING_BALANCE NUMERIC(14,2) 19
14 RTL_LND_PURPOSE_DIM_ID BIGINT 8
15 PERIOD_CLOSE_GL_IMPACT_COUNT BIGINT 8
16 INTEREST NUMERIC(14,2) 19
17 CASHBACK NUMERIC(14,2) 19
18 DISBURSEMENT NUMERIC(14,2) 19
19 FEE NUMERIC(14,2) 19
20 INSURANCE NUMERIC(14,2) 19
21 PAYOUT NUMERIC(14,2) 19
22 REPAYMENT NUMERIC(14,2) 19
23 OPENING_SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
24 CLOSING_SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
25 OPENING_BAL_SHEET_INDICATOR CHARACTER VARYING(20) 20
26 CLOSING_BAL_SHEET_INDICATOR CHARACTER VARYING(20) 20
27 ACCOUNT_SECURITY_DIM_ID BIGINT 8
28 LOAN_PURPOSE_DIM_ID BIGINT 8
29 SOURCE_SYSTEM_CODE CHARACTER VARYING(12) 12
30 ACCOUNT_NUMBER CHARACTER VARYING(20) 20
31 DATE_CLOSED TIMESTAMP 8
32 DATE_OPEN TIMESTAMP 8
33 DATE_CLOSED_FINAL TIMESTAMP 8
34 ORIGINATION_CHANNEL CHARACTER VARYING(30) 30
35 SALES_OFFICER_DIM_ID BIGINT 8
36 SECONDARY_OFFICER_DIM_ID BIGINT 8
37 MARGIN_DIM_ID BIGINT 8
38 CARDED_RATE NUMERIC(8,5) 19
39 CUSTOMER_RATE NUMERIC(8,5) 19
40 MARGIN_RATE NUMERIC(8,5) 19
41 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
42 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
43 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
44 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8