DIM_OBP_H_ACCOUNT_TD

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..DIM_OBP_H_ACCOUNT_TD_V

Target Objects (CTAS)

INSNZP05_BANK..DIM_OBP_H_ACCOUNT_TD_INSIGHT

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
3 DEPOSIT_NUMBER DOUBLE PRECISION 8
4 PRODUCT_HOLDING_NUMBER CHARACTER VARYING(40) 40
5 BUSINESS_DEVELOPMENT_MANAGER CHARACTER VARYING(254) 254
6 COST_CENTRE_CODE CHARACTER VARYING(150) 150
7 SERVICE_BRANCH_CODE CHARACTER VARYING(10) 10
8 ACCOUNT_STATUS_CODE CHARACTER VARYING(40) 40
9 DEPOSIT_STATUS CHARACTER VARYING(40) 40
10 DEPOSIT_OPENING_DATE TIMESTAMP 8
11 DEPOSIT_CLOSURE_DATE TIMESTAMP 8
12 TERM_MNTHS DOUBLE PRECISION 8
13 EXTRACT_TERM INTEGER 4
14 EXTRACT_TERM_CODE CHARACTER VARYING(1) 1
15 DEPOSIT_TERM_DAYS DOUBLE PRECISION 8
16 DEPOSIT_TERM_MNTHS DOUBLE PRECISION 8
17 DEPOSIT_TERM_YEARS DOUBLE PRECISION 8
18 DEBIT_INT_RATE INTEGER 4
19 CREDIT_INT_RATE DOUBLE PRECISION 8
20 PARENT_DEPOSIT_ID DOUBLE PRECISION 8
21 RENEWAL_COUNTER DOUBLE PRECISION 8
22 STMT_FREQUENCY CHARACTER VARYING(40) 40
23 INT_PAYOUT_FREQ CHARACTER VARYING(40) 40
24 INTEREST_WITHHELD_FLAG CHARACTER VARYING(1) 1
25 NET_INTEREST_RATE DOUBLE PRECISION 8
26 BASE_INTEREST_RATE DOUBLE PRECISION 8
27 MARGIN_RATE DOUBLE PRECISION 8
28 PRODUCT_ID CHARACTER VARYING(30) 30
29 ACCOUNT_TITLE CHARACTER VARYING(300) 300
30 OFFER_ID CHARACTER VARYING(30) 30
31 BANK_CODE CHARACTER VARYING(10) 10
32 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
33 PRODUCT_CLASS CHARACTER VARYING(2) 2
34 PRODUCT_DESCRIPTION CHARACTER VARYING(120) 120
35 OFFER_DESCRIPTION CHARACTER VARYING(120) 120
36 SOURCE_PRODUCT_CODE CHARACTER VARYING(61) 61
37 SOURCE_PRODUCT_CODE_DESCRIPTION CHARACTER VARYING(120) 120
38 BRAND_CODE CHARACTER VARYING(3) 3
39 BANKING_TYPE CHARACTER VARYING(6) 6
40 APPLICATION_CHANNEL CHARACTER VARYING(10) 10
41 APPLICATION_CHANNEL_SOURCE CHARACTER VARYING(10) 10
42 APPLICATION_CHANNEL_DESCRIPTION CHARACTER VARYING(400) 400
43 SUBMISSION_DATE TIMESTAMP 8
44 PRIMARY_OBP_PARTY_ID CHARACTER VARYING(40) 40
45 ACCOUNT_INTEREST_TYPE_FLAG CHARACTER VARYING(1) 1
46 ACCOUNT_INTEREST_TYPE CHARACTER VARYING(5) 5
47 ACCOUNT_CREATION_DATE TIMESTAMP 8
48 ACCOUNT_OPENING_DATE TIMESTAMP 8
49 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
50 MATURITY_DATE TIMESTAMP 8
51 STAFF_ACCOUNT_FLAG CHARACTER(1) 1
52 EMP_PARTNER_ACCOUNT_FLAG CHARACTER(1) 1
53 APPLICATION_ID CHARACTER VARYING(50) 50
54 APPLICATION_BRANCH_CODE CHARACTER VARYING(10) 10
55 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
56 APPLICATION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
57 APPLICATION_LAST_UPDATED_BY CHARACTER VARYING(254) 254
58 APPLICATION_RECORD_ACTIVE_OR_CLOSED CHARACTER(1) 1
59 BROKER_ID CHARACTER VARYING(1) 1
60 BLOCK_FLAG CHARACTER(1) 1
61 MOBILE_BANKING_ALLOWED_FLAG CHARACTER(1) 1
62 INTERNET_BANKING_ALLOWED_FLAG CHARACTER(1) 1
63 PHONE_BANKING_ALLOWED_FLAG CHARACTER(1) 1
64 BROKER_FLAG CHARACTER(1) 1
65 BRANCH_BANKING_ALLOWED_FLAG CHARACTER(1) 1
66 ATM_BANKING_ALLOWED_FLAG CHARACTER(1) 1
67 ATM_CARD_FLAG CHARACTER(1) 1
68 BUNDLE_REFERENCE_ID CHARACTER VARYING(40) 40
69 BUNDLE_ID CHARACTER VARYING(40) 40
70 BUNDLE_NAME CHARACTER VARYING(40) 40
71 CURRENCY_ID CHARACTER VARYING(3) 3
72 OLD_BRANCH_CODE CHARACTER VARYING(20) 20
73 PRINCIPAL_AMOUNT DOUBLE PRECISION 8
74 ACCOUNT_CREATED_BY CHARACTER VARYING(254) 254
75 ACCOUNT_LAST_UPDATED_TIMESTAMP TIMESTAMP 8
76 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
77 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
78 ACCT_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
79 DEPOSIT_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
80 APP_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
81 CHANGE_END_OF_DAY_DATE DATE 4
82 IS_EOD_RECORD CHARACTER VARYING(1) 1
83 IS_CURRENT CHARACTER VARYING(1) 1
84 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
85 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8