INT_OBP_H_ORIGINATION_SUBMISSION_DECISION_LN

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..INT_OBP_H_ORIGINATION_SUBMISSION_DECISION_LN_V

Columns
# Name Data Type Length
1 SUBMISSION_ID CHARACTER VARYING(50) 50
2 SUBMISSION_CREATION_DATE TIMESTAMP 8
3 FACILITY_CREATION_DATE TIMESTAMP 8
4 SUBMISSION_DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
5 SUBMISSION_CREATED_BY CHARACTER VARYING(254) 254
6 SUBMISSION_BRANCH CHARACTER VARYING(10) 10
7 SUBMISSION_DATE TIMESTAMP 8
8 SUBMISSION_STATUS CHARACTER VARYING(50) 50
9 SUBMISSION_TYPE CHARACTER VARYING(50) 50
10 SUBMISSION_REQUEST_TYPE CHARACTER VARYING(50) 50
11 SUBMISSION_ACTIVE_OR_CLOSED CHARACTER(1) 1
12 SUBMISSION_LAST_UPDATE_TIMESTAMP TIMESTAMP 8
13 SUBMISSION_WITHDRAW_DATE TIMESTAMP 8
14 SUBMISSION_EXPIRY_DATE TIMESTAMP 8
15 HEADER_ID CHARACTER VARYING(50) 50
16 APPLICATION_CHANNEL CHARACTER VARYING(10) 10
17 APPLICATION_CHANNEL_CODE CHARACTER VARYING(400) 400
18 APPLICATION_CHANNEL_SOURCE CHARACTER VARYING(8) 8
19 ACCREDITED_BROKER_ID CHARACTER VARYING(20) 20
20 BROKER_CODE CHARACTER VARYING(40) 40
21 SUBMISSION_PRIORITY CHARACTER VARYING(50) 50
22 MARKET_ENTITY_ID CHARACTER VARYING(40) 40
23 BUSINESS_SEGMENT_ID CHARACTER VARYING(40) 40
24 PREAPPROVAL_STATUS_TYPE CHARACTER VARYING(1) 1
25 PREAPPROVAL_DATE TIMESTAMP 8
26 PREAPPROVAL_REQUEST_AMOUNT DOUBLE PRECISION 8
27 PREAPPROVED_AMOUNT DOUBLE PRECISION 8
28 PREAPPROVED_BY CHARACTER VARYING(254) 254
29 PRIMARY_APPLICANT_ID CHARACTER VARYING(50) 50
30 PRIMARY_APPLICANT_PARTY_ID CHARACTER VARYING(40) 40
31 PRIMARY_APPLICANT_PARTY_TYPE CHARACTER VARYING(50) 50
32 IS_PRIMARY_APPLICANT CHARACTER(1) 1
33 IS_EXISTING_CUSTOMER CHARACTER(1) 1
34 SUBMISSION_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
35 FIRST_SUBMISSION_DECISION_STATUS_TYPE CHARACTER VARYING(50) 50
36 AUTH_DECISION_STATUS CHARACTER VARYING(50) 50
37 MAN_DECISION_STATUS CHARACTER VARYING(50) 50
38 SUBMISSION_DECISION_ID CHARACTER VARYING(50) 50
39 SUBMISSION_DECISION_DATE TIMESTAMP 8
40 SUBMISSION_CDTL_APPROVAL_DATE TIMESTAMP 8
41 SUBMISSION_UNCDTL_APPROVAL_DATE TIMESTAMP 8
42 SUBMISSION_CDTL_APPROVAL_OFFICER CHARACTER VARYING(40) 40
43 SUBMISSION_UNCDTL_APPROVAL_OFFICER CHARACTER VARYING(40) 40
44 REFER_REASON_1_CODE CHARACTER VARYING(20) 20
45 REFER_REASON_1_DESCRIPTION CHARACTER VARYING(255) 255
46 DECLINE_REASON_1_CODE CHARACTER VARYING(20) 20
47 DECLINE_REASON_1_DESCRIPTION CHARACTER VARYING(255) 255
48 CREDIT_MEMO_REQ CHARACTER(1) 1
49 CREDIT_MEMO_ID CHARACTER VARYING(50) 50
50 SUB_CALL_REF_NUM CHARACTER VARYING(50) 50
51 DOWNSELL_STATUS CHARACTER VARYING(50) 50
52 OVERVIEW_REQ CHARACTER(1) 1
53 OVERVIEW_DONE CHARACTER(1) 1
54 OVERVIEW_DATE TIMESTAMP 8
55 APPROVER_ID CHARACTER VARYING(50) 50
56 FRAUD_STATUS_TYPE CHARACTER VARYING(50) 50
57 FRAUD_REASON CHARACTER VARYING(50) 50
58 MANUAL_FRAUD_STATUS CHARACTER VARYING(50) 50
59 CONDITION_WAIVED CHARACTER(1) 1
60 COVENANT_WAIVED CHARACTER(1) 1
61 VALUATION_WAIVED CHARACTER(1) 1
62 VERIFICATION_WAIVED CHARACTER(1) 1
63 AGGREGATE_LIMIT DOUBLE PRECISION 8
64 PERSONAL_AAA_AGGR DOUBLE PRECISION 8
65 PERSONAL_EXCESS DOUBLE PRECISION 8
66 CREATED_BY CHARACTER VARYING(254) 254
67 CREATION_DATE TIMESTAMP 8
68 SUBMISSION_DECISION_LAST_UPDATED_BY CHARACTER VARYING(254) 254
69 SUBMISSION_DECISION_LAST_UPDATE_DATE TIMESTAMP 8
70 DECISION_ACTIVE_OR_CLOSED CHARACTER(1) 1
71 OUTSIDE_AMOUNT_PRE_LOAN DOUBLE PRECISION 8
72 OUTSIDE_AMOUNT_PRE_LOAN_CCY CHARACTER VARYING(5) 5
73 OUTSIDE_AMOUNT_POST_LOAN DOUBLE PRECISION 8
74 OUTSIDE_AMOUNT_POST_LOAN_CCY CHARACTER VARYING(5) 5
75 WITHIN_AMOUNT_PRE_LOAN DOUBLE PRECISION 8
76 WITHIN_AMOUNT_PRE_LOAN_CCY CHARACTER VARYING(5) 5
77 WITHIN_AMOUNT_POST_LOAN DOUBLE PRECISION 8
78 WITHIN_AMOUNT_POST_LOAN_CCY CHARACTER VARYING(5) 5
79 SDW_IGNITE_SOURCE CHARACTER VARYING(1) 1
80 EFFECTIVE_START_TIMESTAMP_SUB TIMESTAMP 8
81 EFFECTIVE_START_TIMESTAMP_CDSUB TIMESTAMP 8
82 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
83 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
84 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
85 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
86 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
87 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
88 BUSINESS_END_OF_DAY_DATE DATE 4
89 IS_CURRENT_FOR_END_OF_DAY CHARACTER VARYING(1) 1
90 IS_CURRENT CHARACTER VARYING(1) 1