FCT_OBP_ROFT_OPPORTUNITIES

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_ROFT_OPPORTUNITIES_V

Columns
# Name Data Type Length
1 OPPORTUNITY_ID CHARACTER VARYING(30) 30
2 LATEST_SALES_STAGE CHARACTER VARYING(30) 30
3 LATEST_STAGE_DATE TIMESTAMP 8
4 CLOSE_STATUS CHARACTER VARYING(10) 10
5 APPLICATION_ID CHARACTER VARYING(50) 50
6 PRODUCT_GROUP_ID CHARACTER VARYING(50) 50
7 PRODUCT_GROUP_NAME CHARACTER VARYING(105) 105
8 OPP_CREATED_DATE TIMESTAMP 8
9 OPPORTUNITY_CNT NUMERIC(38,0) 19
10 NEW_OPPORTUNITY_CNT NUMERIC(38,0) 19
11 INTERVIEW_CONTACTED_CNT NUMERIC(38,0) 19
12 QUOTE_SOLUTION_CNT NUMERIC(38,0) 19
13 APPLICATION_ACCEPTANCE_CNT NUMERIC(38,0) 19
14 APPROVED_ASSESSED_CNT NUMERIC(38,0) 19
15 DOCUMENTED_DELIVERED_CNT NUMERIC(38,0) 19
16 CLOSED_WIN_CNT NUMERIC(38,0) 19
17 CLOSED_LOST_CNT NUMERIC(38,0) 19
18 SALES_AMOUNT DOUBLE PRECISION 8
19 NEW_OPPORTUNITY_DATE TIMESTAMP 8
20 INTERVIEW_CONTACTED_DATE TIMESTAMP 8
21 QUOTE_SOLUTION_DATE TIMESTAMP 8
22 APPLICATION_ACCEPTANCE_DATE TIMESTAMP 8
23 APPROVED_ASSESSED_DATE TIMESTAMP 8
24 DOCUMENTED_DELIVERED_DATE TIMESTAMP 8
25 CLOSED_WIN_DATE TIMESTAMP 8
26 CLOSED_LOST_DATE TIMESTAMP 8
27 ENTERPRISE_OWNER_ID CHARACTER VARYING(40) 40
28 ENTERPRISE_OWNER_NAME CHARACTER VARYING(40) 40
29 CUSTOMER_SEGMENT CHARACTER VARYING(30) 30
30 OPPORTUNITY_TYPE CHARACTER VARYING(40) 40
31 EXPECTED_CLOSE_DATE TIMESTAMP 8
32 APPROVED_PRIORITY CHARACTER VARYING(30) 30
33 APPROVED_PROBABILITY CHARACTER VARYING(20) 20
34 FIRST_PRIORITY CHARACTER VARYING(30) 30
35 FIRST_PROBABILITY CHARACTER VARYING(20) 20
36 FORECAST_AMOUNT DOUBLE PRECISION 8
37 FORECAST_DATE TIMESTAMP 8
38 SALES_OFFICER_CODE CHARACTER VARYING(254) 254
39 SALES_OFFICER_NAME CHARACTER VARYING(201) 201
40 SECTION_NAME CHARACTER VARYING(100) 100
41 TEAM_NAME CHARACTER VARYING(100) 100
42 POSITION_TITLE CHARACTER VARYING(256) 256
43 POSITION_FTE NUMERIC(18,2) 19
44 EMPLOYEE_FTE NUMERIC(18,6) 19
45 OPPORTUNITY_SETTLED_CNT INTEGER 4
46 CONVERTED_AMT_ACCOUNT_PRESENT DOUBLE PRECISION 8
47 CONVERTED_AMT_CONTACT_CREATED DOUBLE PRECISION 8
48 CONVERTED_AMT_DEAL_REG DOUBLE PRECISION 8
49 PRODUCT_CODE CHARACTER VARYING(50) 50
50 PRODUCT_DESC CHARACTER VARYING(120) 120
51 OFFER_ID CHARACTER VARYING(40) 40
52 OFFER_DESC CHARACTER VARYING(120) 120
53 BRANCH_CODE CHARACTER VARYING(10) 10
54 COST_CENTRE_NAME CHARACTER VARYING(240) 240
55 REGION CHARACTER VARYING(240) 240
56 GEOGRAPHIC_STATE CHARACTER VARYING(3) 3
57 APPLICATION_CHANNEL CHARACTER VARYING(400) 400
58 LOAN_PURPOSE CHARACTER VARYING(200) 200
59 LVR_GROUP CHARACTER VARYING(50) 50
60 PERS_INV_USAGE_TYPE CHARACTER VARYING(14) 14
61 INTEREST_RATE_TYPE CHARACTER VARYING(8) 8
62 BUSINESS_LENDING_SEGMENT_L2 CHARACTER VARYING(240) 240
63 BUSINESS_LENDING_SEGMENT_L3 CHARACTER VARYING(240) 240
64 SOURCE_PRODUCT_L2 CHARACTER VARYING(100) 100