Database – TCN Queue Item Entity (tcn_queue_item_entity)

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

cust_primary

tinyint(1)

Whether or not to send to primary customer

1 - yes, 0 - no

cust_primary_phone

tinyint(1)

Whether or not to send to primary customer's primary phone

1 - yes, 0 - no

cust_primary_phone_sec

tinyint(1)

Whether or not to send to primary customer's secondary phone

1 - yes, 0 - no

cust_secondary

tinyint(1)

Whether or not to send to secondary customer

1 - yes, 0 - no

cust_secondary_phone

tinyint(1)

Whether or not to send to secondary customer's primary phone

1 - yes, 0 - no

cust_secondary_phone_sec

tinyint(1)

Whether or not to send to secondary customer's secondary phone

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