DIM_OBP_H_ACCOUNT_CS

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..DIM_OBP_H_ACCOUNT_CS_V

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
3 PRODUCT_HOLDING_NUMBER CHARACTER VARYING(40) 40
4 BUSINESS_DEVELOPMENT_MANAGER CHARACTER VARYING(40) 40
5 COST_CENTRE_CODE CHARACTER VARYING(150) 150
6 SERVICE_BRANCH_CODE CHARACTER VARYING(10) 10
7 ACCOUNT_STATUS_CODE CHARACTER VARYING(40) 40
8 SYSTEM_ACCOUNT_STATUS_CODE CHARACTER VARYING(20) 20
9 SYSTEM_ACCOUNT_STATUS_REASON_CODE CHARACTER VARYING(50) 50
10 USER_DEFINED_STATUS_CODE CHARACTER VARYING(500) 500
11 ACCOUNT_TITLE CHARACTER VARYING(500) 500
12 PRODUCT_ID CHARACTER VARYING(30) 30
13 OFFER_ID CHARACTER VARYING(40) 40
14 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
15 PRODUCT_CLASS CHARACTER VARYING(2) 2
16 PRODUCT_DESCRIPTION CHARACTER VARYING(120) 120
17 OFFER_DESCRIPTION CHARACTER VARYING(120) 120
18 SOURCE_PRODUCT_CODE CHARACTER VARYING(71) 71
19 SOURCE_PRODUCT_CODE_DESCRIPTION CHARACTER VARYING(120) 120
20 BRAND_CODE CHARACTER VARYING(3) 3
21 BANK_CODE CHARACTER VARYING(10) 10
22 BANKING_TYPE CHARACTER VARYING(6) 6
23 RESTRICTED_FLAG CHARACTER(1) 1
24 APPLICATION_ID CHARACTER VARYING(40) 40
25 APPLICATION_CHANNEL CHARACTER VARYING(10) 10
26 APPLICATION_CHANNEL_SOURCE CHARACTER VARYING(8) 8
27 APPLICATION_CHANNEL_DESCRIPTION CHARACTER VARYING(400) 400
28 SUBMISSION_DATE TIMESTAMP 8
29 PRIMARY_OBP_PARTY_ID CHARACTER VARYING(40) 40
30 ACCOUNT_CREATION_DATE TIMESTAMP 8
31 ACCOUNT_OPENING_DATE TIMESTAMP 8
32 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
33 STAFF_ACCOUNT_FLAG CHARACTER(1) 1
34 EMP_PARTNER_ACCOUNT_FLAG CHARACTER(1) 1
35 APPLICATION_BRANCH_CODE CHARACTER VARYING(10) 10
36 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
37 APPLICATION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
38 APPLICATION_LAST_UPDATED_BY CHARACTER VARYING(254) 254
39 APPLICATION_RECORD_ACTIVE_OR_CLOSED CHARACTER(1) 1
40 BROKER_FLAG CHARACTER(1) 1
41 BUNDLE_REFERENCE_ID CHARACTER VARYING(40) 40
42 BUNDLE_ID CHARACTER VARYING(40) 40
43 BUNDLE_NAME CHARACTER VARYING(40) 40
44 MOBILE_BANKING_ALLOWED_FLAG CHARACTER(1) 1
45 INTERNET_BANKING_ALLOWED_FLAG CHARACTER(1) 1
46 TELE_BANKING_ALLOWED_FLAG CHARACTER(1) 1
47 ATM_BANKING_ALLOWED_FLAG CHARACTER(1) 1
48 ATM_CARD_FLAG CHARACTER(1) 1
49 POINT_OF_SALE_ALLOWED_FLAG CHARACTER(1) 1
50 STATEMENT_FLAG CHARACTER(1) 1
51 DEBIT_INT_RATE CHARACTER VARYING(1) 1
52 CREDIT_INT_RATE DOUBLE PRECISION 8
53 PASSBOOK_HOLDER_FLAG CHARACTER(1) 1
54 CURRENCY_ID CHARACTER VARYING(10) 10
55 STATEMENT_FREQUENCY CHARACTER VARYING(20) 20
56 INT_CAPITALISATION_FREQ CHARACTER VARYING(40) 40
57 STATEMENT_DELIVERY_TYPE CHARACTER VARYING(20) 20
58 FACILITY_ID CHARACTER VARYING(1) 1
59 OPPORTUNITY_ID CHARACTER VARYING(40) 40
60 LAST_CREDIT_DATE TIMESTAMP 8
61 TEMP_EXCESS_EXPIRY_DATE TIMESTAMP 8
62 TEMP_EXCESS_START_DATE TIMESTAMP 8
63 SUBMISSION_ID CHARACTER VARYING(50) 50
64 REGION CHARACTER VARYING(1) 1
65 DEBIT_INTEREST_PAYMENT_CYC_CODE CHARACTER VARYING(1) 1
66 DEBIT_INTEREST_WAIVE_CODE CHARACTER VARYING(1) 1
67 ACCOUNT_INTEREST_TYPE_FLAG CHARACTER VARYING(1) 1
68 ACCOUNT_INTEREST_TYPE CHARACTER VARYING(1) 1
69 INTEREST_RATE_START_DATE CHARACTER VARYING(1) 1
70 INTEREST_RATE_END_DATE CHARACTER VARYING(1) 1
71 APPLN_REQ_TYPE CHARACTER VARYING(1) 1
72 BROKER_ID CHARACTER VARYING(1) 1
73 INTRODUCER_ID CHARACTER VARYING(1) 1
74 PRIMARY_REASON_FOR_CLOSURE CHARACTER VARYING(1) 1
75 SECONDARY_REASON_FOR_CLOSURE CHARACTER VARYING(1) 1
76 SERVICE_CHARGE_CALC_METHOD_CODE CHARACTER VARYING(1) 1
77 SERVICE_CHARGE_CYC_CODE CHARACTER VARYING(1) 1
78 SERVICE_CHARGE_WAIVER_CODE CHARACTER VARYING(1) 1
79 SERVICE_FEE_WAIVE_APPLIED_DATE CHARACTER VARYING(1) 1
80 SERVICE_FEE_WAIVE_EXPIRY_DATE CHARACTER VARYING(1) 1
81 RESERVE_WAIVE_CODE CHARACTER VARYING(1) 1
82 RESERVE_WAIVE_CODE_EXPIRY_DATE CHARACTER VARYING(1) 1
83 OFFSET_ASSOCIATED_ACCT_NUM CHARACTER VARYING(1) 1
84 OFFSET_START_DATE CHARACTER VARYING(1) 1
85 PENDING_MORTGAGE_OFFSET_FLG CHARACTER VARYING(1) 1
86 BUSINESS_MORTGAGE_OFFSET_CODE CHARACTER VARYING(1) 1
87 WRITE_OFF_AMT CHARACTER VARYING(1) 1
88 WRITE_OFF_REASON_CODE CHARACTER VARYING(1) 1
89 BALANCE_POSTING_TYPE_CODE CHARACTER VARYING(1) 1
90 PROMOTIONAL_BONUS_INTEREST_RATE CHARACTER VARYING(1) 1
91 PROMOTIONAL_BONUS_START_DATE CHARACTER VARYING(1) 1
92 PROMOTIONAL_BONUS_END_DATE CHARACTER VARYING(1) 1
93 PROMOTIONAL_INTEREST_RATE_CODE CHARACTER VARYING(1) 1
94 ACCOUNT_LAST_UPDATED_TIMESTAMP TIMESTAMP 8
95 CHANGE_END_OF_DAY_DATE DATE 4
96 IS_EOD_RECORD CHARACTER VARYING(1) 1
97 IS_CURRENT CHARACTER VARYING(1) 1
98 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
99 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
100 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
101 CDC_RECORD_TYPE CHARACTER VARYING(16) 16