Database – Admin Tool (admin_tool_entity)
General
This holds the information for current and past loan admin tools in the system. For information about loan admin tools, see Loan Admin Tools.
Column | Data Type | Column Info | Value Notes | Other |
id | INT(10) | The id of the entity | ||
user_id | INT(10) | ID of the associated agent user | ||
tool_definition | TEXT | Encoding of admin tool action | ||
status | VARCHAR(100) | Status code of the entity | adminTool.pending, adminTool.done | |
done | TINYINT(1) | Whether or not the tool is complete | 1 - yes, 0 - no | |
query | TEXT | Query used to select entities to process | ||
lastUpdated | TIMESTAMP | Timestamp of when the entity was last updated | ||
deleted | TINYINT(1) | Whether or not the entity was deleted | 1 - yes, 0 - no |