DIM_OBP_LOAN_ACCOUNT_TYPE2_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..DIM_OBP_LOAN_ACCOUNT_TYPE2

Columns
# Name Data Type Length
1 ACCOUNT_NUMBER CHARACTER VARYING(128) 128
2 MGRT_STATUS CHARACTER VARYING(8) 8
3 PRODUCT_HOLDING_NUMBER CHARACTER VARYING(128) 128
4 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
5 ACCOUNT_TITLE CHARACTER VARYING(300) 300
6 PRIMARY_OBP_PARTY_ID CHARACTER VARYING(40) 40
7 SERVICE_BRANCH_CODE CHARACTER VARYING(10) 10
8 BANKING_TYPE CHARACTER VARYING(6) 6
9 BANK_CODE CHARACTER VARYING(10) 10
10 ACCOUNT_STATUS_CODE CHARACTER VARYING(50) 50
11 ACCOUNT_CREATION_DATE TIMESTAMP 8
12 ACCOUNT_OPENING_DATE TIMESTAMP 8
13 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
14 LAST_RESTRUCTURE_DATE TIMESTAMP 8
15 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
16 PRODUCT_CLASS CHARACTER VARYING(2) 2
17 PRODUCT_ID CHARACTER VARYING(30) 30
18 OFFER_ID CHARACTER VARYING(30) 30
19 SOURCE_PRODUCT_DESCRIPTION CHARACTER VARYING(358) 358
20 PRODUCT_DESCRIPTION CHARACTER VARYING(120) 120
21 OFFER_DESCRIPTION CHARACTER VARYING(120) 120
22 LOAN_PURPOSE CHARACTER VARYING(40) 40
23 LOAN_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
24 LOAN_SUB_PURPOSE CHARACTER VARYING(10) 10
25 LOAN_SUB_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
26 CREATED_BY CHARACTER VARYING(254) 254
27 CAMPAIGN_CODE CHARACTER VARYING(20) 20
28 OWNER_OCCUPIED CHARACTER VARYING(14) 14
29 CURRENCY_CODE CHARACTER VARYING(3) 3
30 APPROVED_AMOUNT DOUBLE PRECISION 8
31 REQUESTED_AMOUNT DOUBLE PRECISION 8
32 APPLICATION_ID CHARACTER VARYING(50) 50
33 FACILITY_ID CHARACTER VARYING(40) 40
34 ARRANGEMENT_ID CHARACTER VARYING(40) 40
35 BORROWING_ENTITY_ID CHARACTER VARYING(16) 16
36 SCHEDULE_CODE CHARACTER VARYING(40) 40
37 DISBURSEMENT_COUNT BIGINT 8
38 TERM_MONTHS BIGINT 8
39 FIRST_DISBURSEMENT_DATE TIMESTAMP 8
40 LAST_DISBURSEMENT_DATE TIMESTAMP 8
41 MATURITY_DATE TIMESTAMP 8
42 REGION CHARACTER VARYING(240) 240
43 COST_CENTRE_CODE CHARACTER VARYING(150) 150
44 COST_CENTRE_NAME CHARACTER VARYING(240) 240
45 BUNDLE_REFERENCE_ID CHARACTER VARYING(40) 40
46 BUNDLE_NAME CHARACTER VARYING(40) 40
47 HAS_HARDSHIP_RELIEF CHARACTER(1) 1
48 CREDIT_RISK_RATING_CODE CHARACTER VARYING(40) 40
49 FIXED_TERM_MONTHS DOUBLE PRECISION 8
50 FIXED_PERIOD_END_DATE TIMESTAMP 8
51 INTEREST_RATE_TYPE CHARACTER VARYING(30) 30
52 FV_FLAG CHARACTER VARYING(1) 1
53 CURRENT_INTEREST_RATE DOUBLE PRECISION 8
54 NEXT_DUE_DATE TIMESTAMP 8
55 NEXT_DUE_AMT DOUBLE PRECISION 8
56 EXPECTED_CODE CHARACTER VARYING(10) 10
57 EXPECTED_CODE_TYPE CHARACTER VARYING(14) 14
58 LOAN_REPAYMENT_TYPE CHARACTER VARYING(128) 128
59 MARGIN_RATE NUMERIC(8,5) 19
60 BASE_RATE NUMERIC(8,5) 19
61 CUSTOMER_RATE DOUBLE PRECISION 8
62 BILL_FREQUENCY CHARACTER VARYING(30) 30
63 STAFF_ACCOUNT_FLAG CHARACTER(1) 1
64 INTERNET_BANKING_ALLOWED_FLAG CHARACTER(1) 1
65 REDRAW_ALLOWED_FLAG CHARACTER(1) 1
66 MOBILE_BANKING_ALLOWED_FLAG CHARACTER(1) 1
67 PHONE_BANKING_ALLOWED_FLAG CHARACTER(1) 1
68 BRANCH_BANKING_ALLOWED_FLAG CHARACTER(1) 1
69 ACCELERATED_PAYMENT_ALLOWED_FLAG CHARACTER(1) 1
70 PRINCIPAL_OFFSET_ALLOWED_FLAG CHARACTER(1) 1
71 STATEMENT_ALLOWED_FLAG CHARACTER(1) 1
72 PRIMARY_REASON_FOR_CLOSURE CHARACTER VARYING(200) 200
73 SECONDARY_REASON_FOR_CLOSURE CHARACTER VARYING(200) 200
74 PAYOUT_REASON_CODE CHARACTER VARYING(401) 401
75 NEXT_REPAYMENT_REVIEW_DATE TIMESTAMP 8
76 BRAND_CODE CHARACTER VARYING(3) 3
77 APPLN_REQ_TYPE CHARACTER VARYING(100) 100
78 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
79 ADD_LOAN_DATE TIMESTAMP 8
80 NEW_OFFER_ID CHARACTER VARYING(30) 30
81 NEW_OFFER_NAME CHARACTER VARYING(250) 250
82 OLD_OFFER_ID CHARACTER VARYING(10) 10
83 OFFER_SWAP_DATE TIMESTAMP 8
84 OFFER_SWAP_PRIMARY_REASON_CODE CHARACTER VARYING(20) 20
85 OFFER_SWAP_SECONDARY_REASON_CODE CHARACTER VARYING(20) 20
86 OFFER_SWAP_INDICATOR CHARACTER VARYING(1) 1
87 LOAN_TO_VALUE_RATIO DOUBLE PRECISION 8
88 GROUP_LVR_MV DOUBLE PRECISION 8
89 FACILITY_REVIEWED_DATE TIMESTAMP 8
90 FACILITY_NEXT_REVIEW_DATE TIMESTAMP 8
91 BROKER_ID CHARACTER VARYING(20) 20
92 ACCREDITED_BROKER_CODE CHARACTER VARYING(20) 20
93 INTRODUCER_ID CHARACTER VARYING(20) 20
94 LOWDOC_FLAG CHARACTER VARYING(1) 1
95 RECORD_STATUS_TYPE CHARACTER VARYING(1) 1
96 APPLICATION_SUBMISSION_DATE TIMESTAMP 8
97 SUBMISSION_ID CHARACTER VARYING(50) 50
98 APPLICATION_BRANCH CHARACTER VARYING(10) 10
99 APPLICATION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
100 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
101 APPLICATION_LAST_UPDATED_BY CHARACTER VARYING(254) 254
102 APPLICATION_CHANNEL CHARACTER VARYING(10) 10
103 APPLICATION_CHANNEL_SOURCE CHARACTER VARYING(8) 8
104 APPLICATION_CHANNEL_DESCRIPTION CHARACTER VARYING(400) 400
105 FIRST_HOME_OWNER_GRANT_FLAG CHARACTER VARYING(1) 1
106 APPLICATION_ACTIVE_OR_CLOSED CHARACTER(1) 1
107 SALES_OFFICER_ID CHARACTER VARYING(254) 254
108 SALES_OFFICER_NAME CHARACTER VARYING(203) 203
109 SALE_OFF_DEPT_COST_CENTRE_CODE CHARACTER VARYING(100) 100
110 SALE_OFF_DEPT_COST_CENTRE_DESC CHARACTER VARYING(240) 240
111 MGRT_SALES_OFFICER_BRANCH CHARACTER VARYING(5) 5
112 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
113 ACCT_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
114 SOURCE_PROD_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
115 STATE_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
116 NP_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
117 SWAP_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
118 RATE_START_DATE TIMESTAMP 8
119 RATE_END_DATE TIMESTAMP 8
120 PREF_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
121 APP_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
122 CHANGE_END_OF_DAY_DATE DATE 4
123 IS_EOD_RECORD CHARACTER VARYING(1) 1
124 IS_CURRENT CHARACTER VARYING(1) 1
125 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
126 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
127 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
128 CDC_RECORD_TYPE CHARACTER VARYING(16) 16