FCT_BNK_CONVERTED_OPPORTUNITIES_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

Ignite Accounts from KYC opportunities with sales users and dates

Source Object (CTAS)

SDSNZP05_BANK..FCT_BNK_CONVERTED_OPPORTUNITIES

Columns
# Name Data Type Length
1 OPPORTUNITY_ID CHARACTER VARYING(40) 40
2 OPPORTUNITY_CREATION_DATE TIMESTAMP 8
3 OPPORTUNITY_CLOSE_DATE TIMESTAMP 8
4 OPPORTUNITY_PRODUCT_STATUS CHARACTER VARYING(30) 30
5 ORIGINATION_USER_ID CHARACTER VARYING(100) 100
6 ORIGINATION_USER_POSITION CHARACTER VARYING(50) 50
7 ORIGINATION_USER_COST_CENTRE NUMERIC(38,0) 19
8 ORIGINATION_USER_BRANCH_NUMBER BIGINT 8
9 OPPORTUNITY_OWNER_ID CHARACTER VARYING(100) 100
10 CAMPAIGN_ID CHARACTER VARYING(20) 20
11 IGNITE_ACCOUNT_NUMBER CHARACTER VARYING(40) 40
12 ACCOUNT_ORIGINATION_BRANCH CHARACTER VARYING(10) 10
13 ACCOUNT_OPENING_DATE TIMESTAMP 8
14 ACCOUNT_STATUS CHARACTER VARYING(50) 50
15 ACCOUNT_SERVICING_BRANCH CHARACTER VARYING(105) 105
16 PRODUCT_GROUP CHARACTER VARYING(30) 30
17 PRODUCT CHARACTER VARYING(120) 120
18 OFFER CHARACTER VARYING(120) 120
19 PURPOSE CHARACTER VARYING(400) 400
20 SUB_PURPOSE CHARACTER VARYING(255) 255
21 DISBURSEMENT_AMT DOUBLE PRECISION 8
22 IGNITE_ACCOUNT_BALANCE DOUBLE PRECISION 8
23 SALES_USER_ID CHARACTER VARYING(1) 1
24 SALES_USER_NAME CHARACTER VARYING(1) 1
25 SALES_USER_COST_CENTRE CHARACTER VARYING(1) 1
26 SALES_USER_BRANCH CHARACTER VARYING(1) 1
27 IGNITE_USER_ID CHARACTER VARYING(50) 50
28 IGNITE_USER_NAME CHARACTER VARYING(201) 201
29 IGNITE_USER_COST_CENTRE CHARACTER VARYING(100) 100
30 IGNITE_USER_POSITION CHARACTER VARYING(256) 256
31 IGNITE_USER_BRANCH CHARACTER VARYING(10) 10
32 IGNITE_USER_AREA CHARACTER VARYING(240) 240
33 IGNITE_USER_REGION CHARACTER VARYING(240) 240
34 IGNITE_USER_STATE CHARACTER VARYING(5) 5