Database – Bracket Entity (bracket_entity)
General
This table holds bracket information used in loan searches. Each bracket entity falls into a category. Both the ID and parent ID fields are pre-defined constants from the API. The brack_item_entities table holds the information of each bracket range. To see how brackets function within the UI, see our Brackets article.
Bracket Entity
Column | Data Type | Column Info | Value Notes | Other |
id | CHAR(100) | The id of the entity | companySettings.brackets.aging, companySettings.brackets.amountPastDue, companySettings.brackets.daysPastDue, companySettings.brackets.delinquentBucket, companySettings.brackets.humanActivity, companySettings.brackets.loanRecency, companySettings.brackets.originalLoanAmount, companySettings.brackets.payoff, companySettings.brackets.principalBalance, customerSettings.brackets.age, customerSettings.brackets.creditScore, loansettings.alerts.usury.ageofcollateral.bracket, loansettings.alerts.usury.loanamount.bracket, loansettings.charges.bracket.cpb, loansettings.charges.bracket.ndd, loansettings.charges.bracket.opb, loansettings.charges.bracket.pa, loansettings.setupnewloan.bracket.loanamount | |
parent_id | CHAR(100) | ID of parent category | ||
label | VARCHAR(255) | The label of the entity instance | ||
description | VARCHAR(255) | The description of the entity instance | ||
has_additional_value | TINYINT(1) | Whether or not this bracket has additional value information | 1 - yes, 0 - no | |
deleted | TINYINT(4) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
active | TINYINT(1) | Whether or not the entity is active | 1 - yes, 0 - no | |
created | TIMESTAMP | Timestamp of when the entity was created | ||
lastUpdated | TIMESTAMP | Timestamp of when the entity was last updated |