FCT_BNK_COL_SUMMARY_REPORT_INSIGHT
Description
OBP CLMS and Hogan Collateral with description address charges registration number registration date and end date and account
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | REGISTRATION_NUMBER | CHARACTER VARYING(20) | 20 |
| 2 | REGISTRATION_DATE | TIMESTAMP | 8 |
| 3 | REGISTRATION_END_DATE | TIMESTAMP | 8 |
| 4 | TOKEN | CHARACTER VARYING(50) | 50 |
| 5 | COLLATERAL_ID | CHARACTER VARYING(18) | 18 |
| 6 | COLLATERAL_STATUS | CHARACTER(1) | 1 |
| 7 | COLLATERAL_ASSET_DESCRIPTION | CHARACTER VARYING(255) | 255 |
| 8 | VIN_NUMBER | CHARACTER VARYING(30) | 30 |
| 9 | ADDRESS_LINE1 | CHARACTER VARYING(35) | 35 |
| 10 | ADDRESS_LINE2 | CHARACTER VARYING(35) | 35 |
| 11 | ADDRESS_CITY | CHARACTER VARYING(50) | 50 |
| 12 | ADDRESS_STATE | CHARACTER VARYING(30) | 30 |
| 13 | ADDRESS_ZIP | CHARACTER VARYING(30) | 30 |
| 14 | CHARGE_ID | CHARACTER VARYING(18) | 18 |
| 15 | FACILITY_STATUS | CHARACTER VARYING(1) | 1 |
| 16 | FACILITY_ID | CHARACTER VARYING(40) | 40 |
| 17 | EXTERNAL_ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 18 | EXTERNAL_ACCOUNT_SYSTEM | CHARACTER VARYING(20) | 20 |
| 19 | EXTERNAL_ACCOUNT_STATUS | CHARACTER VARYING(50) | 50 |