FCT_OBP_RETAIL_LENDING_MONTHLY_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..FCT_OBP_RETAIL_LENDING_MONTHLY

Columns
# Name Data Type Length
1 PERIOD_DIM_ID NUMERIC(38,0) 19
2 MONTH_OPENING_PERIOD_DIM_ID INTEGER 4
3 FINANCIAL_YEAR_END_ID NUMERIC(38,0) 19
4 FINANCIAL_YEAR CHARACTER VARYING(401) 401
5 ACCOUNT_DIM_ID BIGINT 8
6 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
7 CUSTOMER_DIM_ID BIGINT 8
8 OWNER_OCCUPIED_INVESTMENT_IND CHARACTER VARYING(100) 100
9 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
10 OPENING_SOURCE_PRODUCT_DIM_ID BIGINT 8
11 CLOSING_SOURCE_PRODUCT_DIM_ID BIGINT 8
12 COMBINED_SOURCE_PRODUCT_DIM_ID BIGINT 8
13 OF_COST_CENTRE_SID BIGINT 8
14 ACCOUNT_STATUS_DIM_ID BIGINT 8
15 RTL_LND_BALANCE_TIER_DIM_ID INTEGER 4
16 RTL_LND_BALANCE_TIER CHARACTER VARYING(10) 10
17 PRINCIPLE_LIMIT DOUBLE PRECISION 8
18 OPENING_BALANCE NUMERIC(38,2) 19
19 CLOSING_BALANCE NUMERIC(38,2) 19
20 INTEREST DOUBLE PRECISION 8
21 CASHBACK DOUBLE PRECISION 8
22 DISBURSEMENT DOUBLE PRECISION 8
23 FEE DOUBLE PRECISION 8
24 INSURANCE DOUBLE PRECISION 8
25 PAYOUT DOUBLE PRECISION 8
26 REPAYMENT DOUBLE PRECISION 8
27 OPENING_SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
28 CLOSING_SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
29 OFFER_ID CHARACTER VARYING(30) 30
30 OPENING_BAL_SHEET_INDICATOR CHARACTER VARYING(5) 5
31 CLOSING_BAL_SHEET_INDICATOR CHARACTER VARYING(5) 5
32 ACCOUNT_SECURITY_DIM_ID BIGINT 8
33 LOAN_PURPOSE_DIM_ID BIGINT 8
34 LOAN_PURPOSE CHARACTER VARYING(400) 400
35 LOAN_SUB_PURPOSE CHARACTER VARYING(255) 255
36 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
37 DATE_CLOSED TIMESTAMP 8
38 DATE_OPEN TIMESTAMP 8
39 DATE_CLOSED_FINAL CHARACTER VARYING(1) 1
40 CHANNEL CHARACTER VARYING(30) 30
41 SALES_OFFICER CHARACTER VARYING(254) 254
42 SECONDARY_OFFICER CHARACTER VARYING(40) 40
43 CARDED_RATE DOUBLE PRECISION 8
44 PIT_RATE DOUBLE PRECISION 8
45 CUSTOMER_RATE DOUBLE PRECISION 8
46 MARGIN_RATE DOUBLE PRECISION 8
47 INTEREST_RATE_TYPE CHARACTER VARYING(30) 30
48 BRANCH_DIM_ID BIGINT 8
49 MIGRATED_DATE DATE 4
50 PAYOUT_DATE TIMESTAMP 8
51 30DAYS_PAYOUT DOUBLE PRECISION 8
52 30DAYS_REPAYMENT DOUBLE PRECISION 8
53 30DAYS_PRIOR_BALANCE NUMERIC(38,2) 19