INT_OBP_H_ORIGINATION_SUBMISSION_LN_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..INT_OBP_H_ORIGINATION_SUBMISSION_LN

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 SDW_IGNITE_SOURCE CHARACTER VARYING(1) 1
35 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
36 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
37 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
38 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
39 EFFECTIVE_START_TIMESTAMP TIMESTAMP 8
40 EFFECTIVE_END_TIMESTAMP TIMESTAMP 8
41 BUSINESS_END_OF_DAY_DATE DATE 4
42 IS_CURRENT_FOR_END_OF_DAY CHARACTER VARYING(1) 1
43 IS_CURRENT CHARACTER VARYING(1) 1