Database – Collector Queue Work Item Entity (collector_queue_work_item_entity)
Updated 1 week ago
Description
This holds information concerning work that has been done on a collector queue. This includes information about the loan worked on, when work started, and when work ended.
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 | ||
collector_queue_id | int(11) | ID of associated collector queue | ||
started | timestamp | Time work item was started | ||
completed | timestamp | Whether or not has been completed | ||
owner | tinyint(1) | owner ID | 1 - yes, 0 - no | Deprecated |
security | char(3) | security ID | Deprecated | |
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 | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |