FCT_OBP_RETAIL_LENDING_WEEKLY_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..FCT_OBP_RETAIL_LENDING_WEEKLY

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