Database – TCN Queue Item Entity (tcn_queue_item_entity)
Description
This table holds records of TCN queue items.
Table Fields
Column | 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 |
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 |