Database – Collector Queue Work Item Entity (collector_queue_work_item_entity)
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.
Table Fields
Field | Data Type | Column Info | Value Notes |
id | int(11) | The ID of the entity | |
loan_id | int(11) | The ID of the associated loan account | |
loan_type | varchar(100) | The loan type | Default is set to: Entity.Loan |
collector_queue_id | int(11) | The ID of an associated collector queue | |
started | timestamp | The time the work item was started | |
completed | timestamp | Whether or not has been completed | |
owner | tinyint(1) | The ID of the owner | 1 - yes, 0 - no |
security | char(3) | The security ID | |
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 |