INT_OBP_RETAIL_LENDING_WEEKLY_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..INT_OBP_RETAIL_LENDING_WEEKLY

Columns
# Name Data Type Length
1 ACCOUNT_DIM_ID BIGINT 8
2 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
3 WEEK_END_ID NUMERIC(38,0) 19
4 WEEK_OPENING_PERIOD_DIM_ID INTEGER 4
5 WEEKLY_OPENING_PIT_PERIOD_ID BIGINT 8
6 WEEKLY_CLOSING_PIT_PERIOD_ID BIGINT 8
7 SECONDARY_OFFICER CHARACTER VARYING(40) 40
8 MANAGER_ID CHARACTER VARYING(50) 50
9 BASE_RATE DOUBLE PRECISION 8
10 MARGIN_RATE DOUBLE PRECISION 8
11 CUSTOMER_RATE DOUBLE PRECISION 8
12 STAGE_CODE CHARACTER VARYING(128) 128
13 DISBURSEMENT DOUBLE PRECISION 8
14 CASHBACK DOUBLE PRECISION 8
15 FEE DOUBLE PRECISION 8
16 INTEREST DOUBLE PRECISION 8
17 REPAYMENT DOUBLE PRECISION 8
18 PAYOUT DOUBLE PRECISION 8
19 INSURANCE DOUBLE PRECISION 8
20 30DAYS_PAYOUT DOUBLE PRECISION 8
21 30DAYS_REPAYMENT DOUBLE PRECISION 8