INT_OBP_H_ORIGINATION_OFFER_FACILITY_LN

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..INT_OBP_H_ORIGINATION_OFFER_FACILITY_LN_V

Columns
# Name Data Type Length
1 FACILITY_ID CHARACTER VARYING(40) 40
2 APPLICATION_ID CHARACTER VARYING(50) 50
3 PROD_GRP_SERIAL_NO BYTEINT 1
4 ACCOUNT_ID CHARACTER VARYING(100) 100
5 SPLIT_ACCOUNT_ID CHARACTER VARYING(40) 40
6 SUBMISSION_ID CHARACTER VARYING(50) 50
7 FACILITY_TYPE CHARACTER VARYING(3) 3
8 LIMIT_AMOUNT DOUBLE PRECISION 8
9 EMPLOYEE_FLAG CHARACTER VARYING(1) 1
10 REQ_LIMIT_AMOUNT DOUBLE PRECISION 8
11 PRODUCT_GRP_CODE CHARACTER VARYING(16) 16
12 APPROVER_ID CHARACTER VARYING(50) 50
13 APPROVER_NAME CHARACTER VARYING(50) 50
14 APPROVAL_TYPE CHARACTER VARYING(3) 3
15 APPROVAL_TYPE_DESCRIPTION CHARACTER VARYING(3) 3
16 BRANCH_CODE CHARACTER VARYING(10) 10
17 FACILITY_CATEGORY_CODE CHARACTER VARYING(50) 50
18 LENDING_CATEGORY_CODE CHARACTER VARYING(16) 16
19 BUSINESS_UNIT CHARACTER VARYING(40) 40
20 ACCREDITED_BROKER_ID CHARACTER VARYING(20) 20
21 BROKER_CODE CHARACTER VARYING(40) 40
22 LOWDOC_FLAG CHARACTER VARYING(1) 1
23 REQ_NUMBER_OF_YEARS DOUBLE PRECISION 8
24 REQ_NUMBER_OF_MONTHS DOUBLE PRECISION 8
25 APPR_NUMBER_OF_YEARS DOUBLE PRECISION 8
26 APPR_NUMBER_OF_MONTHS DOUBLE PRECISION 8
27 FACILITY_ACTIVE_OR_CLOSED CHARACTER VARYING(1) 1
28 OFFER_ID CHARACTER VARYING(40) 40
29 OFFER_NAME CHARACTER VARYING(120) 120
30 OFFER_SERIAL_NUMBER BYTEINT 1
31 PRODUCT_CODE CHARACTER VARYING(50) 50
32 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
33 PRODUCT_GROUP_ID CHARACTER VARYING(50) 50
34 PRODUCT_GROUP_NAME CHARACTER VARYING(105) 105
35 PRODUCT_CLASS CHARACTER VARYING(40) 40
36 SIMULATION_ID CHARACTER VARYING(50) 50
37 OPPORTUNITY_ID CHARACTER VARYING(40) 40
38 LOAN_PURPOSE CHARACTER VARYING(40) 40
39 LOAN_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
40 LOAN_SUB_PURPOSE CHARACTER VARYING(255) 255
41 LOAN_SUB_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
42 BASE_LOAN_AMOUNT DOUBLE PRECISION 8
43 TOTAL_FUNDING_AMOUNT DOUBLE PRECISION 8
44 TOTAL_LOAN_AMOUNT DOUBLE PRECISION 8
45 LOAN_VALUE_TIER CHARACTER VARYING(50) 50
46 FACILITY_REPORTING_AMOUNT DOUBLE PRECISION 8
47 CCY_CODE CHARACTER VARYING(3) 3
48 CONTRIBUTION_AMOUNT DOUBLE PRECISION 8
49 BORROWING_ENTITY_ID CHARACTER VARYING(50) 50
50 TOTAL_CAPITALISED_FEE_AMOUNT DOUBLE PRECISION 8
51 TOTAL_CAPITALISED_INS_AMOUNT DOUBLE PRECISION 8
52 INSURANCE_PRODUCT_TYPE CHARACTER VARYING(4) 4
53 PERS_INV_USAGE_TYPE CHARACTER VARYING(14) 14
54 BANKING_TYPE CHARACTER VARYING(6) 6
55 ACCOUNT_OPENING_DATE TIMESTAMP 8
56 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
57 SCHEDULE_CODE CHARACTER VARYING(40) 40
58 FIRST_DISBURSEMENT_DATE DATE 4
59 DISBURSEMENT_AMOUNT DOUBLE PRECISION 8
60 NET_DISBURSED_AMOUNT DOUBLE PRECISION 8
61 DISBURSEMENT_TO_SETTLE_AMOUNT DOUBLE PRECISION 8
62 CAMPAIGN_CODE CHARACTER VARYING(20) 20
63 SERVICING_BRANCH_CODE CHARACTER VARYING(10) 10
64 RELATIONSHIP_MANAGER CHARACTER VARYING(40) 40
65 DISBURSEMENT_COUNT BIGINT 8
66 SCHEDULED_SETTLEMENT_DATE TIMESTAMP 8
67 ACCOUNT_TERM_MONTHS BIGINT 8
68 INITIAL_RATE_TYPE_CODE CHARACTER VARYING(22) 22
69 FIXED_PERIOD_END_DATE TIMESTAMP 8
70 FIXED_RATE_TERM_MONTHS DOUBLE PRECISION 8
71 FIXED_RATE_TERM_YEARS NUMERIC(33,0) 19
72 INTEREST_RATE_TYPE CHARACTER VARYING(8) 8
73 FV_FLAG CHARACTER VARYING(1) 1
74 SOURCE_PRODUCT_CODE CHARACTER VARYING(95) 95
75 OFFER_STAGE_CODE CHARACTER VARYING(120) 120
76 ARRANGEMENT_ID CHARACTER VARYING(40) 40
77 ACCOUNT_CREATION_DATE TIMESTAMP 8
78 LOAN_APPROVED_AMOUNT DOUBLE PRECISION 8
79 SPLIT_DATE TIMESTAMP 8
80 SWAP_LOAN_INDICATOR TIMESTAMP 8
81 NEW_OFFER_ID CHARACTER VARYING(40) 40
82 NEW_OFFER_NAME CHARACTER VARYING(120) 120
83 OLD_OFFER_ID CHARACTER VARYING(10) 10
84 OFFER_SWAP_DATE TIMESTAMP 8
85 FIRST_ACCOUNT_ID CHARACTER VARYING(100) 100
86 CD_APPLICATION_ID CHARACTER VARYING(50) 50
87 FACILITY_DECISION_DATE TIMESTAMP 8
88 FACILITY_DECISION_ID CHARACTER VARYING(50) 50
89 FACILITY_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
90 FACILITY_APPROVED_AMOUNT DOUBLE PRECISION 8
91 LOAN_VALUE_RATIO DOUBLE PRECISION 8
92 LVR_GROUP CHARACTER VARYING(50) 50
93 CAPACITY_TO_REPAY_MONTHLY_AMOUNT NUMERIC(20,2) 19
94 SDW_IGNITE_SOURCE CHARACTER VARYING(1) 1
95 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
96 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
97 EFFECTIVE_START_TIMESTAMP_FAC TIMESTAMP 8
98 EFFECTIVE_START_TIMESTAMP_OFFER TIMESTAMP 8
99 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
100 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
101 BUSINESS_END_OF_DAY_DATE DATE 4
102 IS_CURRENT_FOR_END_OF_DAY CHARACTER VARYING(1) 1
103 IS_CURRENT CHARACTER VARYING(1) 1