Database – Collateral Entity (collateral_entity)
Description
This holds collateral information for loans, such as automobile or property information useful for identification in the case of reposession or foreclosure. Not all loans will have collateral.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
loan_id | int(11) | The id of the associated loan account | ||
a | varchar(100) | Collateral field A | ||
b | varchar(100) | Collateral field B | ||
c | varchar(100) | Collateral field C | ||
d | varchar(100) | Collateral field D | ||
additional | varchar(500) | Additional collateral info | ||
collateral_type | varchar(100) | Collection for the type of the associated collateral | collateral.type.car, collateral.type.consumer, collateral.type.mortgage, collateral.type.other | |
vin | char(17) | Collateral VIN number | ||
distance | int(11) | Distance on odometer | ||
book_value | decimal(11,2) | Collateral book value | ||
color | varchar(50) | stoplight color | stoplight.color.* | |
gps_status | char(40) | Status of a GPS on the collateral | collateral.gpsstatus.installed, collateral.gpsstatus.none, collateral.gpsstatus.notinstalled | |
gps_code | varchar(100) | Code of a GPS on the collateral | ||
license_plate | varchar(100) | License plate number for the collateral | ||
gap | varchar(500) | Amount covered by GAP insurance | ||
warranty | varchar(500) | Amount covered by warranty | ||
active | tinyint(1) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
lastUpdated | timestamp | Timestamp of when the entity was last updated |