FCT_OBP_CL_LOAN_PH_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

OBP Customer Layer Loan Account detils with product offer channel open and close dates channel broker bundle rates days past due etc

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_CL_LOAN_PH

Columns
# Name Data Type Length
1 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
2 PRODUCT_HOLDING_NUMBER CHARACTER VARYING(128) 128
3 ACCOUNT_NUMBER CHARACTER VARYING(128) 128
4 BANK_CODE CHARACTER VARYING(10) 10
5 PRODUCT_ID CHARACTER VARYING(30) 30
6 PRODUCT_DESCRIPTION CHARACTER VARYING(120) 120
7 OFFER_ID CHARACTER VARYING(30) 30
8 OFFER_DESCRIPTION CHARACTER VARYING(120) 120
9 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
10 SOURCE_PRODUCT_DESCRIPTION CHARACTER VARYING(358) 358
11 BRAND_CODE CHARACTER VARYING(3) 3
12 BANKING_TYPE CHARACTER VARYING(6) 6
13 APPLICATION_CHANNEL CHARACTER VARYING(10) 10
14 APPLICATION_CHANNEL_SOURCE CHARACTER VARYING(8) 8
15 APPLICATION_CHANNEL_DESCRIPTION CHARACTER VARYING(400) 400
16 APPROVED_AMOUNT DOUBLE PRECISION 8
17 ANZSIC_CODE CHARACTER VARYING(4) 4
18 SUBMISSION_ID CHARACTER VARYING(50) 50
19 APPLICATION_ID CHARACTER VARYING(50) 50
20 APPLICATION_SUBMISSION_DATE TIMESTAMP 8
21 BORROWING_ENTITY_ID CHARACTER VARYING(16) 16
22 PRIMARY_OBP_PARTY_ID CHARACTER VARYING(40) 40
23 ACCOUNT_TITLE CHARACTER VARYING(300) 300
24 FV_FLAG CHARACTER VARYING(1) 1
25 INTEREST_RATE_TYPE CHARACTER VARYING(30) 30
26 COST_CENTRE_CODE CHARACTER VARYING(150) 150
27 APPROVER_ID CHARACTER VARYING(40) 40
28 DEPARTMENT CHARACTER VARYING(240) 240
29 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
30 MATURITY_DATE TIMESTAMP 8
31 ADD_LOAN_DATE TIMESTAMP 8
32 ACCOUNT_OPENING_DATE TIMESTAMP 8
33 LOAN_PURPOSE CHARACTER VARYING(40) 40
34 LOAN_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
35 LOAN_SUB_PURPOSE CHARACTER VARYING(10) 10
36 LOAN_SUB_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
37 ACCOUNT_STATUS_CODE CHARACTER VARYING(50) 50
38 ACCOUNT_STATUS_DESC CHARACTER VARYING(256) 256
39 ADD_LOAN_FLAG CHARACTER VARYING(1) 1
40 APPLICATION_BRANCH CHARACTER VARYING(10) 10
41 APPLICATION_BRANCH_NAME CHARACTER VARYING(105) 105
42 STAFF_ACCOUNT_FLAG CHARACTER(1) 1
43 TERM_MONTHS BIGINT 8
44 APPLICATION_CREATED_BY CHARACTER VARYING(254) 254
45 OWNER_OCCUPIED CHARACTER VARYING(14) 14
46 CREDIT_RISK_RATING_CODE CHARACTER VARYING(40) 40
47 SERVICE_BRANCH_CODE CHARACTER VARYING(10) 10
48 SERVICE_BRANCH_NAME CHARACTER VARYING(105) 105
49 APPROVAL_DATE TIMESTAMP 8
50 BROKER_ID CHARACTER VARYING(20) 20
51 LOAN_TO_VALUE_RATIO DOUBLE PRECISION 8
52 ORIGINATION_COLLATERAL_VALUE DOUBLE PRECISION 8
53 LATEST_COLLATERAL_VALUE DOUBLE PRECISION 8
54 OFFER_SWAP_INDICATOR CHARACTER VARYING(1) 1
55 NEW_OFFER_ID CHARACTER VARYING(30) 30
56 OFFER_SWAP_DATE TIMESTAMP 8
57 FIRST_DISBURSEMENT_AMOUNT DOUBLE PRECISION 8
58 PRINCIPAL_OFFSET_ALLOWED_FLAG CHARACTER(1) 1
59 MOBILE_BANKING_ALLOWED_FLAG CHARACTER(1) 1
60 INTERNET_BANKING_ALLOWED_FLAG CHARACTER(1) 1
61 PHONE_BANKING_ALLOWED_FLAG CHARACTER(1) 1
62 REDRAW_ALLOWED_FLAG CHARACTER(1) 1
63 BRANCH_BANKING_ALLOWED_FLAG CHARACTER(1) 1
64 ACCELERATED_PAYMENT_ALLOWED_FLAG CHARACTER(1) 1
65 STATEMENT_ALLOWED_FLAG CHARACTER(1) 1
66 BUNDLE_REFERENCE_ID CHARACTER VARYING(40) 40
67 BUNDLE_NAME CHARACTER VARYING(40) 40
68 POUT_RSN_DESC CHARACTER VARYING(401) 401
69 FIRST_DISBURSEMENT_DATE TIMESTAMP 8
70 CURRENT_INTEREST_RATE DOUBLE PRECISION 8
71 RATE_START_DATE TIMESTAMP 8
72 RATE_END_DATE TIMESTAMP 8
73 BILL_FREQUENCY CHARACTER VARYING(30) 30
74 NEXT_DUE_AMT DOUBLE PRECISION 8
75 NEXT_DUE_DATE TIMESTAMP 8
76 SCHEDULE_CODE CHARACTER VARYING(40) 40
77 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
78 REQUESTED_AMOUNT DOUBLE PRECISION 8
79 HAS_HARDSHIP_RELIEF CHARACTER(1) 1
80 FIXED_TERM_MONTHS DOUBLE PRECISION 8
81 FIXED_PERIOD_END_DATE TIMESTAMP 8
82 EXPECTED_CODE_TYPE CHARACTER VARYING(14) 14
83 LOAN_REPAYMENT_TYPE CHARACTER VARYING(128) 128
84 MARGIN_RATE NUMERIC(8,5) 19
85 BASE_RATE NUMERIC(8,5) 19
86 IN_COLLECTIONS CHARACTER(1) 1
87 IS_DELINQUENT CHARACTER(1) 1
88 DELINQUENCY_START_DATE TIMESTAMP 8
89 DELINQUENCY_END_DATE TIMESTAMP 8
90 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
91 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
92 CHANGE_END_OF_DAY_DATE DATE 4
93 IS_EOD_RECORD CHARACTER VARYING(1) 1
94 IS_CURRENT CHARACTER VARYING(1) 1
95 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
96 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
97 SALES_OFFICER_ID CHARACTER VARYING(254) 254
98 SALES_OFFICER_NAME CHARACTER VARYING(203) 203
99 SALE_OFF_DEPT_COST_CENTRE_CODE CHARACTER VARYING(100) 100
100 SALE_OFF_DEPT_COST_CENTRE_DESC CHARACTER VARYING(240) 240
101 MGRT_SALES_OFFICER_BRANCH CHARACTER VARYING(5) 5
102 MGRT_STATUS CHARACTER VARYING(8) 8
103 LAST_DISBURSEMENT_DATE TIMESTAMP 8
104 DAYS_PAST_DUE DOUBLE PRECISION 8
105 DELINQUENT_AMT DOUBLE PRECISION 8
106 THRESHOLD_BREACHED_DATE TIMESTAMP 8
107 IS_ACCOUNT_DELINQUENT CHARACTER(1) 1
108 D_G INTEGER 4
109 D30 INTEGER 4
110 D60 INTEGER 4
111 D90 INTEGER 4
112 D120 INTEGER 4
113 AGENT_DESC CHARACTER VARYING(250) 250
114 INSURANCE_TYPE CHARACTER VARYING(20) 20
115 INSURANCE_PROVIDER_ID CHARACTER VARYING(50) 50
116 INSURANCE_START_DATE TIMESTAMP 8
117 INSURANCE_END_DATE TIMESTAMP 8
118 LIFE_INSURED_1 CHARACTER VARYING(250) 250
119 INSURANCE_COVER_CODE_1 CHARACTER VARYING(100) 100
120 INSURANCE_POLICY_NUMBER_1 CHARACTER VARYING(50) 50
121 LIFE_INSURED_2 CHARACTER VARYING(250) 250
122 INSURANCE_COVER_CODE_2 CHARACTER VARYING(100) 100
123 INSURANCE_POLICY_NUMBER_2 CHARACTER VARYING(50) 50