FCT_BNK_LENDING_SERVICES_LODGEMENT_INSIGHT
Description
OBP Origination Lodgements SLA pipeline report with counts of lodgements sent and outstanding by date for Lending Services team
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | NO_LODGED | CHARACTER VARYING(20) | 20 |
| 2 | NO_FILES_SHOWSTOPPED | CHARACTER VARYING(20) | 20 |
| 3 | NO_OUTSTANDING_SHOWSTOPPED_FILES | CHARACTER VARYING(20) | 20 |
| 4 | NO_FILES_SENT_GEN_LS | CHARACTER VARYING(20) | 20 |
| 5 | COUNT_NO_LODGED | INTEGER | 4 |
| 6 | COUNT_NO_FILES_SHOWSTOPPED | INTEGER | 4 |
| 7 | COUNT_NO_OUTSTANDING_SHOWSTOPPED_FILES | INTEGER | 4 |
| 8 | COUNT_NO_FILES_SENT_GEN_LS | INTEGER | 4 |
| 9 | LODGED_UPDATEDDATE | DATE | 4 |
| 10 | FILES_SHOWSTOPPED_UPDATEDDATE | DATE | 4 |
| 11 | OUTSTANDING_FILES_SHOWSTOPPED_UPDATEDDATE | DATE | 4 |
| 12 | FILES_SENT_GEN_LS_UPDATEDDATE | DATE | 4 |
| 13 | MAIN_UPDATEDDATE | DATE | 4 |
| 14 | PERIOD_DT | TIMESTAMP | 8 |
| 15 | PROTECTEDFORMATTRIBUTE1 | CHARACTER VARYING(20) | 20 |