bracket_entity - Bracket Entity

This holds bracket information used in loan searches. Each bracket entity falls in a category. The ID and parent ID are pre-defined constants from the API. Bracket item entities hold the information of each bracket range.

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)