FCT_BNK_BROKER_TRAIL_ARREARS_INSIGHT
Description
OBP Broker originated open loans that are in arrears with balance and days past due
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | DT_LOAN_ADDED | CHARACTER VARYING(200) | 200 |
| 2 | BORR_SHRT_NM | CHARACTER VARYING(101) | 101 |
| 3 | BROKER_CD | CHARACTER VARYING(40) | 40 |
| 4 | LOAN_NBR | CHARACTER VARYING(40) | 40 |
| 5 | NBR_DAY_PDUE | SMALLINT | 2 |
| 6 | LOAN_STAT | CHARACTER VARYING(50) | 50 |
| 7 | CALC_CURR_BAL | CHARACTER VARYING(200) | 200 |
| 8 | TOTAL_CURR_BAL | CHARACTER VARYING(200) | 200 |
| 9 | SUBMISSION_ID | CHARACTER VARYING(50) | 50 |