INT_OBP_H_ORIGINATION_OFFER_LN_PREP

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..INT_OBP_H_ORIGINATION_OFFER_LN_PREP_V

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(40) 40
34 OFFR_ACCOUNT_ID CHARACTER VARYING(40) 40
35 SPLIT_ACCOUNT_ID CHARACTER VARYING(40) 40
36 SPLIT_DATE TIMESTAMP 8
37 ACCOUNT_OPENING_DATE TIMESTAMP 8
38 ACCOUNT_CLOSURE_DATE TIMESTAMP 8
39 SCHEDULE_CODE CHARACTER VARYING(40) 40
40 FIRST_DISBURSEMENT_DATE DATE 4
41 FIRST_DISBURSEMENT_AMOUNT DOUBLE PRECISION 8
42 DISBURSEMENT_AMOUNT DOUBLE PRECISION 8
43 RUNNING_DISBURSEMENT_AMOUNT DOUBLE PRECISION 8
44 NET_DISBURSED_AMOUNT DOUBLE PRECISION 8
45 DISBURSEMENT_TO_SETTLE_AMOUNT DOUBLE PRECISION 8
46 CAMPAIGN_CODE CHARACTER VARYING(20) 20
47 SERVICING_BRANCH_CODE CHARACTER VARYING(10) 10
48 RELATIONSHIP_MANAGER CHARACTER VARYING(40) 40
49 DISBURSEMENT_COUNT BIGINT 8
50 SCHEDULED_SETTLEMENT_DATE TIMESTAMP 8
51 ACCOUNT_TERM_MONTHS BIGINT 8
52 FIXED_TERM_MONTHS DOUBLE PRECISION 8
53 OFFER_STAGE_CODE CHARACTER VARYING(120) 120
54 ARRANGEMENT_ID CHARACTER VARYING(40) 40
55 ACCOUNT_CREATION_DATE TIMESTAMP 8
56 LOAN_APPROVED_AMOUNT DOUBLE PRECISION 8
57 SWAP_LOAN_INDICATOR CHARACTER VARYING(1) 1
58 NEW_OFFER_ID CHARACTER VARYING(30) 30
59 NEW_OFFER_NAME CHARACTER VARYING(250) 250
60 OLD_OFFER_ID CHARACTER VARYING(10) 10
61 OFFER_SWAP_DATE TIMESTAMP 8
62 FIRST_ACCOUNT_ID CHARACTER VARYING(40) 40
63 SDW_IGNITE_SOURCE CHARACTER VARYING(1) 1
64 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
65 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
66 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
67 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
68 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
69 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
70 IS_CURRENT_FOR_END_OF_DAY CHARACTER VARYING(1) 1
71 IS_CURRENT CHARACTER VARYING(1) 1
72 BUSINESS_END_OF_DAY_DATE DATE 4
73 ACCT_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
74 LNDG_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
75 OFFR_EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
76 KEY2 CHARACTER VARYING(50) 50