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


How did we do?


Powered by HelpDocs (opens in a new tab)