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


How did we do?


Powered by HelpDocs (opens in a new tab)