collateral_entity - Collateral Entity

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


How did we do?


Powered by HelpDocs (opens in a new tab)