FCT_BNK_ACT_OPN_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

Hogan and OBP Account Applications with Customer name address occupation and broker details per Branch

Source Object (CTAS)

SDSNZP05_BANK..FCT_BNK_ACT_OPN

Columns
# Name Data Type Length
1 SUBMISSION_ID CHARACTER VARYING(20) 20
2 COMPONENTNAME CHARACTER VARYING(500) 500
3 STATE CHARACTER VARYING(100) 100
4 UPDATEDDATE TIMESTAMP 8
5 BUNDLE_ID CHARACTER VARYING(40) 40
6 BUNDLE_DESC CHARACTER VARYING(120) 120
7 APPLICATION_ID CHARACTER VARYING(19) 19
8 HOGAN_EDO_ACC CHARACTER VARYING(100) 100
9 OFFSET_ACC CHARACTER VARYING(16) 16
10 PARTY_ID CHARACTER VARYING(40) 40
11 PARTY_NAME CHARACTER VARYING(250) 250
12 PREFIX_NAME CHARACTER VARYING(120) 120
13 DOB CHARACTER VARYING(200) 200
14 RESI_ADDRESS_LINE_1 CHARACTER VARYING(120) 120
15 RESI_ADDRESS_LINE_2 CHARACTER VARYING(120) 120
16 RESI_ADDRESS_LINE_3 CHARACTER VARYING(120) 120
17 CITY CHARACTER VARYING(50) 50
18 STATE_HOME CHARACTER VARYING(30) 30
19 POST_CODE CHARACTER VARYING(30) 30
20 ACCOMMODATION_TYPE CHARACTER VARYING(30) 30
21 POST_ADDRESS_LINE_1 CHARACTER VARYING(120) 120
22 POST_ADDRESS_LINE_2 CHARACTER VARYING(120) 120
23 POST_ADDRESS_LINE_3 CHARACTER VARYING(120) 120
24 CITY2 CHARACTER VARYING(50) 50
25 STATE2 CHARACTER VARYING(30) 30
26 POST_CODE2 CHARACTER VARYING(30) 30
27 GENDER CHARACTER VARYING(6) 6
28 OCCUPATION CHARACTER VARYING(150) 150
29 BRANCH_NO CHARACTER VARYING(10) 10
30 BRANCH_NAME CHARACTER VARYING(105) 105
31 BKR_NAME CHARACTER VARYING(250) 250
32 MOBILE_NUMBER CHARACTER VARYING(45) 45
33 GCIS_ID CHARACTER VARYING(400) 400
34 OFFER_ID CHARACTER VARYING(40) 40
35 PRODUCT_CODE CHARACTER VARYING(50) 50
36 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
37 PROD_GROUP_DESC CHARACTER VARYING(120) 120
38 IN_PRINCIPAL_APPROVAL CHARACTER VARYING(1) 1