FCT_OBP_CL_TD_PH_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 PRODUCT_HOLDING_NUMBER CHARACTER VARYING(40) 40
3 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
4 DEPOSIT_NUMBER DOUBLE PRECISION 8
5 PRODUCT_SYSTEM_PRODUCT_CODE CHARACTER VARYING(30) 30
6 BANK_CODE CHARACTER VARYING(10) 10
7 PRODUCT_ID CHARACTER VARYING(30) 30
8 PRODUCT_DESCRIPTION CHARACTER VARYING(120) 120
9 OFFER_ID CHARACTER VARYING(30) 30
10 OFFER_DESCRIPTION CHARACTER VARYING(120) 120
11 PRINCIPLE_ACCOUNT_NUMBER CHARACTER VARYING(40) 40
12 SOURCE_PRODUCT_CODE CHARACTER VARYING(61) 61
13 BRAND_CODE CHARACTER VARYING(3) 3
14 BANKING_TYPE CHARACTER VARYING(6) 6
15 APPLICATION_CHANNEL CHARACTER VARYING(10) 10
16 APPLICATION_CHANNEL_TYPE CHARACTER VARYING(10) 10
17 APPLICATION_CHANNEL_DESCRIPTION CHARACTER VARYING(400) 400
18 ANZSIC_CODE CHARACTER VARYING(4) 4
19 SUBMISSION_ID CHARACTER VARYING(50) 50
20 APPLICATION_ID CHARACTER VARYING(50) 50
21 SUBMISSION_DATE TIMESTAMP 8
22 PRIMARY_OBP_PARTY_ID CHARACTER VARYING(40) 40
23 ACCOUNT_TITLE CHARACTER VARYING(500) 500
24 FV_FLAG CHARACTER VARYING(1) 1
25 INTEREST_RATE_TYPE CHARACTER VARYING(5) 5
26 STMT_FREQUENCY CHARACTER VARYING(40) 40
27 SETTLEMENT_TYPE CHARACTER VARYING(5) 5
28 INTEREST_PAYOUT_FREQUENCY CHARACTER VARYING(40) 40
29 COST_CENTRE_CODE CHARACTER VARYING(150) 150
30 DEPARTMENT CHARACTER VARYING(240) 240
31 ACCOUNT_CREATION_DATE TIMESTAMP 8
32 ACCOUNT_OPENING_DATE TIMESTAMP 8
33 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
34 DEPOSIT_TERM_MNTHS DOUBLE PRECISION 8
35 DEPOSIT_OPENING_DATE TIMESTAMP 8
36 DEPOSIT_CLOSURE_DATE TIMESTAMP 8
37 DEPOSIT_MATURITY_DATE TIMESTAMP 8
38 DEPOSIT_PRINCIPLE_AMOUNT DOUBLE PRECISION 8
39 CURRENCY_ID CHARACTER VARYING(3) 3
40 PARENT_DEPOSIT_ID DOUBLE PRECISION 8
41 RENEWAL_COUNTER DOUBLE PRECISION 8
42 ACCOUNT_STATUS_CODE CHARACTER VARYING(40) 40
43 DEPOSIT_STATUS_CODE CHARACTER VARYING(40) 40
44 APPLICATION_BRANCH_CODE CHARACTER VARYING(10) 10
45 APPLICATION_BRANCH_NAME CHARACTER VARYING(105) 105
46 STAFF_ACCOUNT_FLAG CHARACTER(1) 1
47 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
48 SERVICE_BRANCH_CODE CHARACTER VARYING(10) 10
49 BROKER_ID CHARACTER VARYING(1) 1
50 MOBILE_BANKING_ALLOWED_FLAG CHARACTER(1) 1
51 INTERNET_BANKING_ALLOWED_FLAG CHARACTER(1) 1
52 PHONE_BANKING_ALLOWED_FLAG CHARACTER(1) 1
53 BRANCH_BANKING_ALLOWED_FLAG CHARACTER(1) 1
54 ATM_BANKING_ALLOWED_FLAG CHARACTER(1) 1
55 BUNDLE_REFERENCE_ID CHARACTER VARYING(40) 40
56 BUNDLE_NAME CHARACTER VARYING(40) 40
57 INTEREST_WITHHELD_FLAG CHARACTER VARYING(1) 1
58 CURRENT_INTEREST_RATE DOUBLE PRECISION 8
59 EFFECTIVE_FROM_TIMESTAMP TIMESTAMP 8
60 EFFECTIVE_TO_TIMESTAMP TIMESTAMP 8
61 CHANGE_END_OF_DAY_DATE DATE 4
62 IS_EOD_RECORD CHARACTER VARYING(1) 1
63 IS_CURRENT CHARACTER VARYING(1) 1
64 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
65 CDC_RECORD_TYPE CHARACTER VARYING(16) 16