Table: Collector Queue Work Item Entity

Table: Collector Queue Work Item Entity

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
idint(11)The id of the entity
loan_idint(11)The id of the associated loan account
collector_queue_idint(11)ID of associated collector queue
startedtimestampTime work item was started
completedtimestampWhether or not has been completed
ownertinyint(1)owner ID1 - yes, 0 - noDeprecated
securitychar(3)security IDDeprecated
activetinyint(1)Whether or not the entity is active1 - yes, 0 - no
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no
createdtimestampTimestamp of when the entity was created
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List