FCT_OBP_ROFT_SALES_MTH

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_ROFT_SALES_MTH_V

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 SALES_MEASURE_DATE DATE 4
3 SALES_MEASURE CHARACTER VARYING(256) 256
4 ACCOUNT_ID CHARACTER VARYING(128) 128
5 PRODUCT_GROUP CHARACTER VARYING(30) 30
6 PRODUCT_GROUP_DESC CHARACTER VARYING(120) 120
7 PRODUCT_CODE CHARACTER VARYING(30) 30
8 PRODUCT_DESC CHARACTER VARYING(120) 120
9 OFFER_CODE CHARACTER VARYING(30) 30
10 OFFER_DESC CHARACTER VARYING(120) 120
11 SOURCE_PRODUCT_L2 CHARACTER VARYING(100) 100
12 GEOGRAPHIC_STATE CHARACTER VARYING(3) 3
13 REGION CHARACTER VARYING(240) 240
14 BRANCH_NAME CHARACTER VARYING(105) 105
15 COST_CENTRE_CODE CHARACTER VARYING(150) 150
16 COST_CENTRE_NAME CHARACTER VARYING(240) 240
17 BUSINESS_LENDING_SEGMENT_L2 CHARACTER VARYING(240) 240
18 BUSINESS_LENDING_SEGMENT_L3 CHARACTER VARYING(240) 240
19 LOAN_PURPOSE CHARACTER VARYING(200) 200
20 LOAN_SUB_PURPOSE CHARACTER VARYING(200) 200
21 LOAN_TO_VALUE_RATIO DOUBLE PRECISION 8
22 LVR_GROUP CHARACTER VARYING(50) 50
23 INTEREST_RATE_TYPE CHARACTER VARYING(30) 30
24 PERS_INV_USAGE_TYPE CHARACTER VARYING(14) 14
25 APPLICATION_CHANNEL CHARACTER VARYING(400) 400
26 SALES_OFFICER_CODE CHARACTER VARYING(254) 254
27 SALES_OFFICER_NAME CHARACTER VARYING(201) 201
28 SECTION_NAME CHARACTER VARYING(100) 100
29 TEAM_NAME CHARACTER VARYING(100) 100
30 ACT_AMT_MTD DOUBLE PRECISION 8
31 BDGT_AMT_MTD NUMERIC(38,0) 19
32 DISBURSEMENT_AMT DOUBLE PRECISION 8
33 REAL_GROWTH DOUBLE PRECISION 8
34 PORTFOLIO_GROWTH DOUBLE PRECISION 8
35 RUN_OFF DOUBLE PRECISION 8
36 PAYOUTS DOUBLE PRECISION 8
37 REPAYMENTS DOUBLE PRECISION 8
38 WRITE_OFF DOUBLE PRECISION 8
39 UNCLASSIFIED DOUBLE PRECISION 8
40 PREV_MONTH_ACT DOUBLE PRECISION 8