INT_OBP_LOAN_ORIGINATION_1_SECT2_V
Description
Target Objects (CTAS)
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 |