FCT_BNK_RESTRUCTURED_LOAN_INSIGHT
Description
OBP loans that have been restructured with their restructure date balance product arrears amount and arrears days
Source Object (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | LOAN_NUMBER | CHARACTER VARYING(40) | 40 |
| 2 | PRODUCT_CODE | CHARACTER VARYING(30) | 30 |
| 3 | CURRENT_BALANCE | DOUBLE PRECISION | 8 |
| 4 | ARREARS_IN_DAYS | SMALLINT | 2 |
| 5 | ARREARS_AMOUNT | NUMERIC(36,18) | 19 |
| 6 | ACCOUNT_SHORT_NAME | CHARACTER VARYING(300) | 300 |
| 7 | RESTRUCTURE_EVENT | DOUBLE PRECISION | 8 |
| 8 | RESCHEDULE_OPTION_FLAG | CHARACTER(1) | 1 |
| 9 | RES_EVENT_DESC_REP | CHARACTER VARYING(120) | 120 |
| 10 | RESTRUCTURE_DATE | TIMESTAMP | 8 |