Database – Advancement Category Entity (advance_category_entity)
Description
This holds category information for advancements on a loan. This allows classification of advancements upon application. Only active, non-deleted categories can be used when applying an advancement. If a category is deleted or inactivated, the record is not removed to prevent breaking of references by existing advancements. For more information on advancements in the API, see API - Advancement/Credit.
Table Fields
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
title | varchar(255) | The name/title of the entity instance | ||
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 |