INT_OBP_H_ORIGINATION_OFFER_LN_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..INT_OBP_H_ORIGINATION_OFFER_LN

Columns
# Name Data Type Length
1 SUBMISSION_ID CHARACTER VARYING(50) 50
2 FACILITY_ID CHARACTER VARYING(40) 40
3 APPLICATION_ID CHARACTER VARYING(50) 50
4 PROD_GRP_SERIAL_NO BYTEINT 1
5 OFFER_ID CHARACTER VARYING(40) 40
6 OFFER_NAME CHARACTER VARYING(120) 120
7 OFFER_SERIAL_NUMBER BYTEINT 1
8 PRODUCT_CODE CHARACTER VARYING(50) 50
9 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
10 SIMULATION_ID CHARACTER VARYING(50) 50
11 PRODUCT_GROUP_ID CHARACTER VARYING(50) 50
12 PRODUCT_GROUP_NAME CHARACTER VARYING(105) 105
13 PRODUCT_CLASS CHARACTER VARYING(40) 40
14 OPPORTUNITY_ID CHARACTER VARYING(40) 40
15 LOAN_PURPOSE CHARACTER VARYING(40) 40
16 LOAN_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
17 LOAN_SUB_PURPOSE CHARACTER VARYING(255) 255
18 LOAN_SUB_PURPOSE_DESCRIPTION CHARACTER VARYING(200) 200
19 BASE_LOAN_AMOUNT DOUBLE PRECISION 8
20 TOTAL_FUNDING_AMOUNT DOUBLE PRECISION 8
21 TOTAL_LOAN_AMOUNT DOUBLE PRECISION 8
22 LOAN_VALUE_TIER CHARACTER VARYING(50) 50
23 FACILITY_REPORTING_AMOUNT DOUBLE PRECISION 8
24 CCY_CODE CHARACTER VARYING(3) 3
25 CONTRIBUTION_AMOUNT DOUBLE PRECISION 8
26 BORROWING_ENTITY_ID CHARACTER VARYING(50) 50
27 TOTAL_CAPITALISED_FEE_AMOUNT DOUBLE PRECISION 8
28 TOTAL_CAPITALISED_INS_AMOUNT DOUBLE PRECISION 8
29 INSURANCE_PRODUCT_TYPE CHARACTER VARYING(4) 4
30 PERS_INV_USAGE_TYPE CHARACTER VARYING(14) 14
31 BANKING_TYPE CHARACTER VARYING(6) 6
32 OFFER_BUNDLE_REF_ID CHARACTER VARYING(40) 40
33 ACCOUNT_ID CHARACTER VARYING(100) 100
34 SPLIT_ACCOUNT_ID CHARACTER VARYING(40) 40
35 SPLIT_DATE TIMESTAMP 8
36 ACCOUNT_OPENING_DATE TIMESTAMP 8
37 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
38 SCHEDULE_CODE CHARACTER VARYING(40) 40
39 FIRST_DISBURSEMENT_DATE DATE 4
40 FIRST_DISBURSEMENT_AMOUNT DOUBLE PRECISION 8
41 DISBURSEMENT_AMOUNT DOUBLE PRECISION 8
42 NET_DISBURSED_AMOUNT DOUBLE PRECISION 8
43 DISBURSEMENT_TO_SETTLE_AMOUNT DOUBLE PRECISION 8
44 CAMPAIGN_CODE CHARACTER VARYING(20) 20
45 SERVICING_BRANCH_CODE CHARACTER VARYING(10) 10
46 RELATIONSHIP_MANAGER CHARACTER VARYING(40) 40
47 DISBURSEMENT_COUNT BIGINT 8
48 SCHEDULED_SETTLEMENT_DATE TIMESTAMP 8
49 ACCOUNT_TERM_MONTHS BIGINT 8
50 INITIAL_RATE_TYPE_CODE CHARACTER VARYING(22) 22
51 FIXED_PERIOD_END_DATE TIMESTAMP 8
52 FIXED_TERM_MONTHS DOUBLE PRECISION 8
53 FIXED_RATE_TERM_MONTHS DOUBLE PRECISION 8
54 FIXED_RATE_TERM_YEARS NUMERIC(33,0) 19
55 INTEREST_RATE_TYPE CHARACTER VARYING(8) 8
56 FV_FLAG CHARACTER VARYING(1) 1
57 SOURCE_PRODUCT_CODE CHARACTER VARYING(95) 95
58 OFFER_STAGE_CODE CHARACTER VARYING(120) 120
59 ARRANGEMENT_ID CHARACTER VARYING(40) 40
60 ACCOUNT_CREATION_DATE TIMESTAMP 8
61 LOAN_APPROVED_AMOUNT DOUBLE PRECISION 8
62 SWAP_LOAN_INDICATOR CHARACTER VARYING(1) 1
63 NEW_OFFER_ID CHARACTER VARYING(30) 30
64 NEW_OFFER_NAME CHARACTER VARYING(250) 250
65 OLD_OFFER_ID CHARACTER VARYING(10) 10
66 OFFER_SWAP_DATE TIMESTAMP 8
67 FIRST_ACCOUNT_ID CHARACTER VARYING(40) 40
68 SDW_IGNITE_SOURCE CHARACTER VARYING(1) 1
69 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
70 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
71 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
72 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
73 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
74 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
75 IS_CURRENT_FOR_END_OF_DAY CHARACTER VARYING(1) 1
76 IS_CURRENT CHARACTER VARYING(1) 1
77 BUSINESS_END_OF_DAY_DATE DATE 4
78 ACCT_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
79 LNDG_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
80 OFFR_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8