FCT_BNK_SWAP_LOAN_OFFER_ARREARS_INSIGHT
Description
OBP loan product offer swaps with old and new offer date arrears actioner and approver
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | LOAN_ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 2 | PRODUCT_DESC | CHARACTER VARYING(120) | 120 |
| 3 | PREV_PRODUCT_OFFER_CODE | CHARACTER VARYING(10) | 10 |
| 4 | SUBSEQUENT_PRODUCT_OFFER_CODE | CHARACTER VARYING(30) | 30 |
| 5 | DATE_OF_OFFER_SWAP | TIMESTAMP | 8 |
| 6 | ARREARS_AT_DATE_OF_SWAP | DOUBLE PRECISION | 8 |
| 7 | USER_ID_OF_EVENT_ACTIONER | CHARACTER VARYING(36) | 36 |
| 8 | NAME_OF_ACTIONER | CHARACTER VARYING(201) | 201 |
| 9 | USER_ID_APPROVER | CHARACTER VARYING(36) | 36 |
| 10 | NAME_OF_APPROVER | CHARACTER VARYING(201) | 201 |