FCT_OBP_CL_LOAN_PH

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_CL_LOAN_PH_V

Target Objects (CTAS)

INSNZP05_BANK..FCT_OBP_CL_LOAN_PH_INSIGHT

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