INT_OBP_LOAN_ORIGINATION_1_SECT2_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 SUBMISSION_ID CHARACTER VARYING(50) 50
2 APPLICATION_ID CHARACTER VARYING(50) 50
3 HEADER_ID CHARACTER VARYING(50) 50
4 APPLICATION_BRANCH CHARACTER VARYING(10) 10
5 APPLN_TYPE CHARACTER VARYING(20) 20
6 DATA_ENTRY_BRANCH CHARACTER VARYING(10) 10
7 APP_SUBMITTED TIMESTAMP 8
8 APP_AUTO_APPROVED TIMESTAMP 8
9 AUTO_REFERRED TIMESTAMP 8
10 AUTO_REJECTED TIMESTAMP 8
11 MANUAL_ACCEPTED TIMESTAMP 8
12 MANUAL_REJECTED TIMESTAMP 8
13 MANUAL_FRAUD_DECLINED TIMESTAMP 8
14 OFFER_LTR_GENERATED TIMESTAMP 8
15 OFFER_LTR_DISPATCHED TIMESTAMP 8
16 OFFER_LTR_ACCEPTED TIMESTAMP 8
17 OFFER_LTR_REJECTED TIMESTAMP 8
18 REJECT_LTR_GENERATED TIMESTAMP 8
19 DECLINE_LTR_DISPATCHED TIMESTAMP 8
20 STRUCTURE_SOLN_CONFIRMED TIMESTAMP 8
21 FIRST_STRUCTURE_SOLN_CONFIRMED TIMESTAMP 8
22 ACCOUNT_OPENED TIMESTAMP 8
23 FULFILLED TIMESTAMP 8
24 APP_WITHDRAWN TIMESTAMP 8
25 APP_EXPIRED TIMESTAMP 8