FCT_BNK_MLS_SENT_TO_DOCS_INSIGHT
Description
OBP Origination with details of who all have worked on submitted subimissions for home loans and small business loans
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | TITLE | CHARACTER VARYING(500) | 500 |
| 2 | SUBMISSION_ID | CHARACTER VARYING(19) | 19 |
| 3 | APPLICATION_ID | CHARACTER VARYING(19) | 19 |
| 4 | VERSION | INTEGER | 4 |
| 5 | STATE | CHARACTER VARYING(100) | 100 |
| 6 | SUBSTATE | CHARACTER VARYING(20) | 20 |
| 7 | OUTCOME | CHARACTER VARYING(100) | 100 |
| 8 | UPDATEDBY | CHARACTER VARYING(254) | 254 |
| 9 | USER_NAME | CHARACTER VARYING(201) | 201 |
| 10 | ACTION_DATE | TIMESTAMP | 8 |
| 11 | PRODUCT_GROUP_NAME | CHARACTER VARYING(105) | 105 |
| 12 | TEAM_NAME | CHARACTER VARYING(100) | 100 |