All Categories ​>​ ​Database

Database

funding_category_entity - Funding Category

Holds info on funding categories. Column Data Type Column Info Value Notes Other id int(11) The ID of the funding category name char(100) The funding category name. This is defined by the user. activ…

Updated 4 days ago by Jackson Stone

Database Tables

General. This is the parent database article, which shows all the database tables. This article and the articles about the individual database tables will only be relevant to customers who have acces…

Updated 4 days ago by Sloan

Database - Loan Status Archive (loan_status_archive)

Description. This table holds the daily record of a loan's status, numbers, and other information that changes often. The snapshot will show the information as it was the last time a loan was changed…

Updated 4 days ago by Darrin Wray

sbt_message_log - SBT Message Log

Holds a log of SBT messaging Column Data Type Column Info Value Notes Other id int(11) The id of the entity customer_id int(11) ID for the customer customer_phone_id int(11) associated customer phone…

Updated 4 days ago by Sloan

Database - Mail House Loan (mail_house_loan)

Description. The mail-house tool lets you send mailers from LoanPro Software to your customers. Common Uses. Table Fields. Column Data Type Column Info Value Notes loan_id int(11) The ID or identifie…

Updated 4 days ago by Sloan

Database - Loan Setup (loan_setup_entity)

Description. This table is associated to a loan, and holds the numbers and settings that define the loan. If your looking for almost any number or calculation setting used to create a loan, it will b…

Updated 1 week ago by Sloan

Database - Loan Table (loan_entity)

Description. This table holds core loan information, including IDs of associated entities and modification information. This is only the information required to create the loan, and does not contain…

Updated 3 weeks ago by Sloan

Database - Additional Payment Information (payment_info_entity)

Description. This table holds additional information that is captured when payments are processed through Secure Payments (formerly PCI Wallet). Common Uses. This table is commonly used to find: Secu…

Updated 2 months ago by Sloan

Database - Payments (payment_entity)

Description. This table holds the information for payments made on loans. This is the primary record for payments in the database. Common Uses. This table is commonly used to find: Payments that were…

Updated 2 months ago by Sloan

Database - Customer Main Table (customer_entity)

Description. This table holds the primary customer data. Some associated data like address, phone number, employer, etc. is found in other tables. Note: Because some of the values in this table are,…

Updated 3 months ago by Sloan

Database Payment Information

General. Some customers choose the optional feature of access to a read-only database replica. This is usually a good choice for large companies that need to pull reports on large data sets, because…

Updated 3 months ago by Sloan

escrow_analysis_task_entity - Escrow Analysis Task Entity

Holds information about current and past escrow analysis tasks. Column Data Type Column Info Value Notes Other process_id int(11) ID of the escrow analysis process account_id int(11) ID of the accoun…

Updated 3 months ago by Sloan

Database - Customer Payment Profile Information (payment_account_entity)

Description. This table holds information about payment accounts that are linked to customers. Each account is associated with a payment profile. Primary payment profile data is stored in Secure Paym…

Updated 3 months ago by Sloan

Database - Loan Transactions (loan_tx)

Description. This table holds a record of all transactions that are currently applying to a loan. If a transaction has been reversed or deleted, it will not appear in this table. Records from this ta…

Updated 4 months ago by Sloan

loan_funding_entity - Loan Funding

Holds funding information for a loan. Column Data Type Column Info Value Notes Other id int(11) The id of the entity loan_id int(11) The id of the associated loan account status varchar(45) Status co…

Updated 5 months ago by Sloan

LoanPro Database - Retrieve Sent Email Information

General. Note: This article is only applicable to customers who have direct access to a read-only copy of their LoanPro database. Sometimes it's useful to pull information from the database about ema…

Updated 5 months ago by Sloan

loan_duedate_change_entity - Loan Due Date Change

Holds information for due-date changes on a loan Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_id int(11) ID of the associated entity entity_type varchar(100)…

Updated 6 months ago by Sloan

preconfigured_loan_entity - Pre Configured loan entity

Holds core settings and calculation numbers to use when creating a loan from a preconfigured-loan template. Column Data Type Column Info Value Notes Other id int(11) The id of the entity settings_id…

Updated 7 months ago by Sloan

checking_account_entity - Checking Account Entity

This holds Secure Payments (formerly PCI Wallet) bank account information. This entity stores the relationship between LoanPro accounts and Secure Payments accounts. Column Data Type Column Info Valu…

Updated 7 months ago by Cole

bank_account_entity - Bank Account Entity

Deprecated! Deprecated, handled by Secure Payments (formerly PCI Wallet). Column Data Type Column Info Value Notes Other id INT(11) The id of the entity account_number VARBINARY(1200) Account Number…

Updated 8 months ago by Cole

ach_return_code_action_entity - ACH Return Code Action Entity

Deprecated! Deprecated. Now handled by Secure Payments (formerly PCI Wallet). Column Data Type Column Info Value Notes Other id char(32) The id of the entity return_code char(4) ACH return code actio…

Updated 8 months ago by Cole

mc_processor_extender - Secure Payments Processor Extender

Holds information for Secure Payments (formerly PCI Wallet) processor extenders. Column Data Type Column Info Value Notes Other id int(11) The id of the entity mc_id int(11) Secure Payments ID proces…

Updated 8 months ago by Sloan

credit_card_entity - Credit Card Entity

This stores Secure Payments (formerly PCI Wallet) credit card account information. This entity stores the relationship between LoanPro accounts and Secure Payments accounts. Column Data Type Column I…

Updated 8 months ago by Cole

Database - AutoPay Main Table (loan_autopay_entity)

Description. This table holds the core information for automatic payments ( AutoPays ). Common Uses. This table is commonly used to find: AutoPay IDs. AutoPay Status. Historical AutoPay Information.…

Updated 8 months ago by Sloan

rule_applied_autopay_entity - Rules Applied, Autopay

Shows information regarding Autopay Rules Applied. Column Data Type Column Info Value Notes Other id int(11) The ID of the entity name varchar(100) The name of the entity rule text Associated Clojure…

Updated 9 months ago by Sloan

wizard_actions_log_entity - Wizard Actions

Shows information regarding wizard actions. Column Data Type Column Info Value Notes Other id int(11) The ID of the entity wizard_id int(11) The ID of the associated wizard name char(100) The name of…

Updated 9 months ago by Sloan

wizard_group__wizard - Wizard Group

Shows information regarding Wizard Groups. Column Data Type Column Info Value Notes Other wizard_id int(11) The ID of the specific wizard wizard_group_id int(11) The ID of the group the wizard is ass…

Updated 9 months ago by Sloan

wizard_process_validation - Wizard Validation

Shows information regarding Wizard Validation. Column Data Type Column Info Value Notes Other id int(11) The ID of the entity user_id int(11) The related user ID search_entity_type char(50) The searc…

Updated 9 months ago by Sloan

wizard_step_item - Wizard Step Item

Shows information regarding Wizard Step Items. Column Data Type Column Info Value Notes Other id int(11) The ID of the entity reference_id int(11) The reference ID name varchar(200) The name of the w…

Updated 9 months ago by Sloan

web_hook_delivery_entity - Web Hook Delivery

Shows information regarding Web Hook Deliveries. Column Data Type Column Info Value Notes Other id int(11) The ID of the webhook deliery entity delivery_id int(11) The ID of the delivery entity url v…

Updated 9 months ago by Sloan

restriction_group_entry_archive - Restriction Group Entry

Holds restriction group entry archive data. Column Data Type Column Info Value Notes Other loan_id int(11) The ID of the loan restriction_group_id int(11) restriction_group_entry_id int(11) date date…

Updated 9 months ago by Sloan

Database - Merchant Processor Group (merchant_processor_group__item_entity)

Description. A merchant processor group lets you assign a group of processors to a loan. Common Uses. Table Fields. Column Data Type Column Info Value Notes id char(32) The ID of the entity merchant_…

Updated 9 months ago by Sloan

Database - Mail House Tool (mail_house_tool_entity)

Description. The mail-house tool lets you send mailers from LoanPro Software to your customers. Common Uses. Table Fields. Column Data Type Column Info Value Notes id int(11) The ID of the entity use…

Updated 9 months ago by Sloan

Database - Mail House (mail_house_entity)

Description. The mail-house tool lets you send mailers from LoanPro Software to your customers. Common Uses. Table Fields. Column Data Type Column Info Value Notes id int(11) The ID or identifier of…

Updated 9 months ago by Sloan

Database - Mail House Delivery (mail_house_delivery_entity)

Description. The mail-house tool lets you send mailers from LoanPro Software to your customers. Common Uses. Table Fields. Column Data Type Column Info Value Notes id int(11) The ID or identifier of…

Updated 9 months ago by Sloan

Database - Application Form (loan_application_form_entity)

Description. The application form allows potential borrowers the option to fill out an application form Common Uses. Table Fields. Column Data Type Column Info Value Notes id int(11) The ID or identi…

Updated 9 months ago by Sloan

delivery_entity - Delivery Entity

Holds metadata about how to notify agent users when an event happens. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(255) Entity name description varchar(…

Updated 9 months ago by Sloan

tenant_setting__entity - Tenant Settings

Holds setting information for the tenant Column Data Type Column Info Value Notes Other id char(100) The id of the entity type char(15) settings type label varchar(255) The label of the entity instan…

Updated 9 months ago by Sloan

special_report_entity - Special Report Entity

Holds information for custom queries. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(100) Entity name description varchar(250) The description of the enti…

Updated 9 months ago by Sloan

rules_note_alert_entity - Note Alert Rule

Shows information regarding Note Alert Rules. Column Data Type Column Info Value Notes Other id int(11) The ID of the entity title varchar(100) The title of the rule applied rule text The Clojure rul…

Updated 9 months ago by Sloan

rule_applied_loans_setup_entity - Rules Applied, Loan Setup

Shows information regarding Loan Setup Rules Applied. Column Data Type Column Info Value Notes Other id int(11) Id of the entity name varchar(100) Name of the rule applied rule text Clojure rule loan…

Updated 9 months ago by Sloan

rule_applied_loan_settings_entity_backup - Rules Applied, Loan Settings Backup

Holds information for loan settings rules applied backup. These rules applied affect loan settings on loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varcha…

Updated 9 months ago by Sloan

rule_applied_loan_settings_entity - Rules Applied Settings

Holds information for loan settings rules applied. These rules applied affect loan settings on loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(100)…

Updated 9 months ago by Sloan

rule_applied_duedate_entity - Rules Applied Due Date

Holds information for due date rules applied. These rules applied affect due date on loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(100) Entity nam…

Updated 9 months ago by Sloan

rule_applied_customer_tools_entity - Rules Applied, Customer Tools

Shows information regarding Customer Tools Rules Applied. Column Data Type Column Info Value Notes Other id int(11) Id of the entity name varchar(100) Entity name rule text Associated Clojure Rule us…

Updated 9 months ago by Sloan

rule_applied_checklist_entity - Rules Applied Checklist Entity

Holds information for checklist rules applied. These rules applied affect checklist on loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(100) Entity n…

Updated 9 months ago by Sloan

rule_applied_charge_off_entity - Rules Applied Charge Off Entity

Holds information for charge off rules applied. These rules applied affect charge off on loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(100) Entity…

Updated 9 months ago by Sloan

rule_applied_bankruptcy_entity - Rules Applied, Bankruptcy

Shows information regarding Bankruptcy Rules Applied. Column Data Type Column Info Value Notes Other id int(11) The Id of the entity name varchar(100) Name of the entity rule text Associated Clojure…

Updated 9 months ago by Sloan

rule_applied_apd_reset_entity - Rules Applied APD Reset Entity

Holds information for APD rules applied. These rules applied affect APD on loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(100) Entity name rule tex…

Updated 9 months ago by Sloan

rule_applied_account_tools_entity - Rules Applied, Account Tools

Shows information regarding the Account Tools Rules Applied. Column Data Type Column Info Value Notes Other id int(11) The Id of the rule applied. name varchar(100) The name of the rule applied. rule…

Updated 9 months ago by Sloan

result_entity - Result Entity

Shows information regarding the result entity. Column Data Type Column Info Value Notes Other id int(11) The Id of the result. title char(100) The title of the result. description varchar(400) The de…

Updated 9 months ago by Sloan

result__notes - Result Notes

Holds information regarding the note of a result. Column Data Type Column Info Value Notes Other note_id int(11) The Id of the note. result_id int(11) The Id of the result.

Updated 9 months ago by Sloan

recurring_charge_entity - Recurring Charge Entity

Holds recurring charge information. Column Data Type Column Info Value Notes Other id int(11) The id of the entity charge_application_type char(25) charge application type loan.pastdue.standard, loan…

Updated 9 months ago by Cole

loan_schedule_roll_entity - Loan Schedule Role Entity

Holds information concerning schedule rolls for a loan. Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_id int(11) ID of the associated entity entity_type varcha…

Updated 9 months ago by Sloan

Database - Loan Lock (loan_lock)

Description. If data is being written to a loan record, the record will be locked, so if other data is submitted, an error will be returned. This ensures that conflicting data doesn't cause any datab…

Updated 9 months ago by Sloan

Database - Loan Charge Sequence (loan_charge_seq)

Description. Common Uses. Table Fields. Column Data Type Column Info Value Notes entity_id int(10) The ID or identifier of the loan charge sequence. entity_type varchar(100) The entity type tied to t…

Updated 9 months ago by Sloan

loan__recurrent_charge - Recurrent Charges (Loan Specific Settings)

Provides a many-to-many relationship between loans and recurrent charges. Column Data Type Column Info Value Notes Other loan_id int(11) The id of the associated loan account recurrent_charge_id int(…

Updated 9 months ago by Sloan

escrow_transaction_entity - Escrow Transaction

Holds transaction information for escrow buckets (withdrawals or deposits) Column Data Type Column Info Value Notes Other id int(11) The id of the entity loan_id int(11) The id of the associated loan…

Updated 9 months ago by Sloan

defaults_escrow_calculator - Defaults Escrow Calculator

This holds tenant-wide default options for new escrow calculators. Column Data Type Column Info Value Notes Other id int(11) The id of the entity parent_type char(30) Type of parent Entity.DefaultsSy…

Updated 9 months ago by Sloan

defaults_autopay - Defaults Autopay

This holds tenant-wide default options for new autopays. Column Data Type Column Info Value Notes Other id char(100) The id of the entity payment.methods.debit, payment.methods.echeck, payment.method…

Updated 9 months ago by Sloan

default_billing_options_entity - Default Billing Options Entity

This holds tenant-wide default options for billing tools. Column Data Type Column Info Value Notes Other id int(11) The id of the entity default_template_id int(11) ID of default billing template cus…

Updated 9 months ago by Sloan

Database - Dashboard Widget Entity (dashboardwidget_entity)

Description. Dashboard Widgets provide snippets of information from LoanPro to populate a user dashboard with a preview of the company standing and related information saved in LoanPro. Common Uses.…

Updated 9 months ago by Sloan

customer_payment_method_entity - Customer Payment Method Entity

This holds information for registered payment methods for customers, such as registered credit card or bank account information. Column Data Type Column Info Value Notes Other id int(11) The id of th…

Updated 9 months ago by Sloan

customer_login_attempts - Customer Login Attempts

This holds the login attempts into the customer portal. It serves as an audit trail of account access. Column Data Type Column Info Value Notes Other id int(11) The id of the entity customer_id int(1…

Updated 9 months ago by Sloan

customer_employer_entity - Customer Employer Entity

This holds employer information for customers, as well as payroll information. Column Data Type Column Info Value Notes Other id int(11) The id of the entity company_name varchar(255) Company name fo…

Updated 9 months ago by Sloan

customer_document_entity - Customer Document Entity

This holds information concerning documents that are attached to a customer. Column Data Type Column Info Value Notes Other id int(11) The id of the entity customer_id int(11) ID for the customer sec…

Updated 9 months ago by Sloan

customer_credit_score_entity - Customer Credit Score Entity

This holds credit score information for a customer. These scores can either be pulled from the credit bureau, or they can be manually entered. Column Data Type Column Info Value Notes Other id int(11…

Updated 9 months ago by Sloan

custom_form_tool_entity - Custom Form Tool Entity

This holds information about forms that have been or are being generated for loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity user_id int(11) ID of the associated…

Updated 9 months ago by Cole

custom_field - Custom Field Entity

Custom fields hold static information that needs to be updated manually. Use computation fields for information that needs automated updating. Column Data Type Column Info Value Notes Other id int(11…

Updated 9 months ago by Cole

collector_queue_entity - Collector Queue Entity

This holds collector queue information. For more information on collector queues, see Collector Queue Tool. Column Data Type Column Info Value Notes Other id int(11) The id of the entity user_id int(…

Updated 9 months ago by Cole

collateral_entity - Collateral Entity

This holds collateral information for loans, such as automobile or property information useful for identification in the case of reposession or foreclosure. Not all loans will have collateral. Column…

Updated 9 months ago by Cole

checklist_item__entity - Checklist Item To Checklist Entity Map

This holds the many-to-many mapping information between checklist entities and checklist item entities. Column Data Type Column Info Value Notes Other entity_id int(11) ID of the associated entity en…

Updated 9 months ago by Cole

checklist_entity - Checklist Entity

This entity holds the meta-data for checklists. This includes the checklist name, description, and status. Checklist items are stored in 'checklist_item_entity'. Column Data Type Column Info Value No…

Updated 9 months ago by Cole

Database - Charges Table (charge_entity)

Description. This table holds core information about charges assessed on loans. This is the main table for charges and holds the dates amounts, etc. Common Uses. This table is commonly used to find:…

Updated 9 months ago by Sloan

cash_drawer_transaction_entity - Cash Drawer Transaction Entity

This holds a transaction line for a cash drawer. Transaction lines can be in the form of a withdrawal or a deposit. Furthermore, they can either be reconciled or unreconciled. Column Data Type Column…

Updated 9 months ago by Cole

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…

Updated 9 months ago by Cole

billing_tool_entity - Billing Tool Entity

The billing tool is used to create billing statements for loans. This entity holds the information for current and past billing tools used to create billing statements as PDFs. Column Data Type Colum…

Updated 9 months ago by Cole

Database - Base Variable (base_variable_entity)

Description. Base variables are used as a base when setting a date through rules applied. Common Uses. Table Fields. Column Data Type Column Info Value Notes id INT(11) The ID or identifier of the ba…

Updated 9 months ago by Sloan

Database - Bankruptcy Entity (bankruptcy_entity)

Description. This table holds the information for loan bankruptcies. Common Uses. This table is commonly used to find: Bankruptcy Status. Bankruptcy Court Information. Table Fields. Column Data Type…

Updated 9 months ago by Sloan

admin_tool_entity - Admin Tool

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)…

Updated 9 months ago by Cole

Database - Action & Result Selection (action_result_selection_entity)

Description. This allows for the linking of an action to a result and a note. Common Uses. Table Fields. Column Data Type Column Info Value Notes id INT(11) The ID of the action & result selection en…

Updated 9 months ago by Sloan

Database - Deletion Audit Table (deletion_audit)

Description. For some tables, the database marks records as deleted in the 'deleted' field. For others, records are completely removed. This table keeps a record of what was completely removed from t…

Updated 9 months ago by Sloan

loan_reverse_calc_settings - Loan Reverse Calculator Settings

Holds reverse calculator settings for a loan. Column Data Type Column Info Value Notes Other id int(11) The id of the entity query text Query used to select entities to process loans text Loan IDs (c…

Updated 11 months ago by Sloan

computation_field_entity - Computation Field Entity

A computation field is a piece of data that is computed dynamically. This allows for calculations that need to be updated as loan values change (such as the remaining balance). Static field data shou…

Updated 11 months ago by Cole

tenant_pricing_tier_entity - Tenant Pricing Tier

Deprecated! Holds pricing tier information Column Data Type Column Info Value Notes Other id int(11) The id of the entity begin int(11) Beginning amount end int(11) end time price decimal(11,3) price…

Updated 1 year ago by Sloan

security_group__user - Security Group User

Deprecated! Column Data Type Column Info Value Notes Other id int(11) The id of the entity security_group_id int(11) ID of security group tenant_user_id int(11) ID of tenant user lastUpdated timestamp

Updated 1 year ago by Sloan

security_group - Security Group

Deprecated! Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(50) Entity name description varchar(255) The description of the entity instance active tinyint(…

Updated 1 year ago by Sloan

search_index_error_log - Search indexing error log

Useful for LoanPro Developers Only! Use of this table by 3rd parties is not officially supported!. Holds information used by LoanPro developers to verify integrity of indexes. Use of this table by 3r…

Updated 1 year ago by Sloan

support_transaction__topic - Support Transaction - Topic Relation

Maps support transactions to a support topic. Column Data Type Column Info Value Notes Other support_transaction_id int(10) associated support transaction topic_id int(10) associated topic lastUpdate…

Updated 1 year ago by Sloan

schema_version - Schema Version

Useful for LoanPro Developers Only! Use of this table by 3rd parties is not officially supported!. Holds information used by LoanPro developers to verify integrity of databases. Use of this table by…

Updated 1 year ago by Sloan

sample_entity - A sample of basic entity tables

Unused! Column Data Type Column Info Value Notes Other id int(11) The id of the entity active tinyint(1) Whether or not the entity is active 1 - yes, 0 - no deleted tinyint(1) Whether or not the enti…

Updated 1 year ago by Sloan

Database - Dashboard Widget (dashboard__dashboardwidget)

Description. Widgets are related to Agent Dashboards. Widgets are used to populate the dashboard with useful and relevant snapshot information. Common Uses. Table Fields. Column Data Type Column Info…

Updated 1 year ago by Sloan

Database - Dashboard Entity (dashboard_entity)

Description. Agent Dashboards can be used as a brief overview of the company. It can show snapshots of information from LoanPro. Common Uses. Table Fields. Column Data Type Column Info Value Notes id…

Updated 1 year ago by Sloan

Database - Action & Result Note (action_result_note_entity)

Description. This is the note of the action/result. For more information regarding actions and results see this article: Actions & Results. Common Uses. Table Fields. Column Data Type Column Info Val…

Updated 1 year ago by Sloan

restriction_group_entity - Restriction Group Entity

Deprecated! Holds user access restriction information for agent users. Column Data Type Column Info Value Notes Other id int(11) The id of the entity access tinyint(1) access level 1 - yes, 0 - no na…

Updated 1 year ago by Sloan

restriction_group__user - Restriction Group User Relation

Deprecated! Maps restriction groups to agent users. Column Data Type Column Info Value Notes Other user_id int(11) ID of the associated agent user restriction_group_id int(11) associated group id cre…

Updated 1 year ago by Sloan

note_entity - Notes Entity

Note information for notes created by agent users. Column Data Type Column Info Value Notes Other id int(11) The id of the entity parent_type char(100) Type of parent parent_id int(11) ID of parent c…

Updated 1 year ago by Cole

loan__rule_applied_apd_reset - Rule Applied Amount Past Due - Loan relation

Provides a many-to-many relationship between loans and APD reset rules applied. Column Data Type Column Info Value Notes Other loan_id int(11) The id of the associated loan account rule_applied_apd_r…

Updated 1 year ago by Sloan

escrow_subset_options_entity_backup - Escrow Subset Options Entity - Backup

Useful for LoanPro Developers Only! Use of this table by 3rd parties is not officially supported!. Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_id int(11) ID…

Updated 1 year ago by Sloan

web_delivery_entity - Web Delivery Entity

This holds information about notifications delivered through a web notification. Column Data Type Column Info Value Notes Other id int(11) The id of the entity delivery_id int(11) ID of associated de…

Updated 1 year ago by Sloan

preconfigured_loan__portfolio - Pre configured loan Portfolio Relation

Provides a many-to-many mapping between preconfigured loans and portfolios, allowing portfolios to be used with preconfigured loans. Column Data Type Column Info Value Notes Other preconfigured_setti…

Updated 1 year ago by Sloan

Database - IP Restrictions (iprestriction_entity)

Description. Holds IP restriction information, allowing the restriction of site access to specific IP addresses. Common Uses. Table Fields. Column Data Type Column Info Value Notes Other id int(10) T…

Updated 1 year ago by Cole

investment__portfolio - Investment Portfolio

Provides a many-to-many mapping between investments and portfolios. Column Data Type Column Info Value Notes Other investment_id int(11) Associated investment id portfolio_id int(11) Associated portf…

Updated 1 year ago by Sloan

Database - Transaction Child Entity (transaction_child_entity)

Description. Common Uses. Table Fields. Column Data Type Column Info Value Notes id int(11) entity_type char(100) entity_id int(11) child_entity_id int(11) loan_child_id int(11) amount decimal(11,2)…

Updated 1 year ago by Sloan

Database - Settings for "My Loans" (my_loans_setting_entity )

Description. Common Uses. Table Fields. Unused! Column Data Type Column Info Value Notes Other id char(100) The id of the entity type char(15) Loans settings type label varchar(255) The label of the…

Updated 1 year ago by Sloan

Database - Settings for "My Applications" (my_applications_setting_entity)

Description. Common Uses. Table Fields. Unused! Holds information for borrower applications. Column Data Type Column Info Value Notes Other id char(100) The id of the entity type char(15) Application…

Updated 1 year ago by Sloan

Database - Rules Applied Customer Tools (loan__rule_applied_customer_tools)

Description. The Customer Tools rules application lets you use customer tools based on rules you enter. This includes things like pulling credit, social profile lookup, address verification, and OFAC…

Updated 1 year ago by Sloan

Database - Rules Applied Bankruptcy (loan__rule_applied_bankruptcy)

Description. The bankruptcy rules applied specifically lets you update the active bankruptcy on an account when the rules that you set up here evaluate to true. Common Uses. Table Fields. Column Data…

Updated 1 year ago by Sloan

Database - Rules Applied Autopay (loan__rule_applied_autopay)

Description. Common Uses. Table Fields. Column Data Type Column Info Value Notes loan_id int(11) The ID of the associated loan. rule_applied_id int(11) The ID or identifier of the specific rule appli…

Updated 1 year ago by Sloan

Database - Rules Applied Account Tools (loan__rule_applied_account_tools)

Description. The Account Tools rules application lets you automatically use account tools based on rules you enter. This includes account activation, deactivation, archive, and delete. Common Uses. T…

Updated 1 year ago by Sloan

Database - Loan Payment Sequence (loan_payment_seq )

Description. Common Uses. Table Fields. Deprecated! Holds information for loan payment sequences Column Data Type Column Info Value Notes Other entity_id int(10) ID of the associated entity entity_ty…

Updated 1 year ago by Sloan

Database - Loan Child Entity (loan_child__entity)

Description. Common Uses. Table Fields. Column Data Type Column Info Value Notes id int(11) The ID or identifier of the specific child entity. loan_id int(11) The ID of the associated loan. child_id…

Updated 1 year ago by Sloan

Database - IP Restriction Entry (iprestriction_entry_entity)

Description. Holds IP addresses that are for associated IP Restriction Entities. Common Uses. Table Fields. Column Data Type Column Info Value Notes Other id int(10) The id of the entity iprestrictio…

Updated 1 year ago by Sloan

Database - Investor Information (investor_entity)

Deprecated! Column Data Type Column Info Value Notes Other id int(11) The id of the entity custom_id varchar(255) Custom investor id customer_type char(100) Investor type customer.type.* status varch…

Updated 1 year ago by Sloan

Database - Dashboard Preferences (dashboardpreferences_entity)

Description. Common Uses. Table Fields. Column Data Type Column Info Value Notes id int(11) dashboard_id int(11) The ID of the associated dashboard. user_id int(11) The ID of the user associated with…

Updated 1 year ago by Sloan

Database - Custom Field Backup Entity (custom_field__entity_backup)

Description. This allows the mapping of custom fields to other entities, such as loans, customers, collateral, etc. Common Uses. Table Fields. Column Data Type Column Info Value Notes id int(11) The…

Updated 1 year ago by Sloan

Database - Company Profile (company_profile_entity)

Description. This refers to the company profile found inside My Account > Company Profile. The Company Profile stores important company information such as contact information. Common Uses. Table Fie…

Updated 1 year ago by Sloan

Database - Company Directory (company_directory_entity)

Description. This table is related to the associated company directory. Associated companies are types of custom fields and can be added to directories of similar companies. Common Uses. Table Fields…

Updated 1 year ago by Sloan

Database - Action Notes Relationship Table (action__notes)

Description. This table maps the relationship between actions and notes for those actions. Table Fields. Column Data Type Column Info Value Notes Other note_id INT(11) The ID of the note associated w…

Updated 1 year ago by Sloan

Database - Action Entity (action_entity)

Description. The action entity holds information on the actions created as part of LoanPro's Actions & Results functionality. Actions and Results are a type of uniform note that can be easily searche…

Updated 1 year ago by Sloan

Database - Action and Results Mapping Table (action__result)

Description. This table maps the relationship between actions and results for those actions. Table Fields. Column Data Type Column Info Value Notes Other id INT(11) The ID for the relationship betwee…

Updated 1 year ago by Sloan

custom_boarding_process_entity - Custom Onboarding Process Entity

This holds meta-data for custom onboarding processes. Custom onboarding processes allow loans to be created by through a wizard. See Custom Onboarding Process for more information. Column Data Type C…

Updated 1 year ago by Cole

cash_drawer_tx_category_entity - Cash Drawer Transaction Category Entity

This holds category information, allowing the categorization of cash drawer transactions. See Create New Cash Drawer Transaction Category for more information. Column Data Type Column Info Value Note…

Updated 1 year ago by Cole

cash_drawer_entity - Cash Drawer Entity

A cash drawer holds information about categorized transactions, and it has a reconciliation feature. Cash drawers serve an accounting purpose. For more information about cash drawers, see the followi…

Updated 1 year ago by Cole

advance_category_entity - Advancement Category Entity

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.…

Updated 1 year ago by Cole

admin_tool__loan - Loan To Admin Tool Map

This table does the many-to-many mapping between admin tools and loans. It allows for admin tools to affect multiple loans and loans to be affected by multiple admin tools. This allows for mapping sp…

Updated 1 year ago by Cole

user_tenant_configuration - User Tenant Configuration

Tenant-specific agent user settings. 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 default_user_loan_id int(10) ID of…

Updated 1 year ago by Cole

user_search_settings_entity - User Search Settings

Settings for agent user searches. Column Data Type Column Info Value Notes Other id int(11) The id of the entity user_id int(11) ID of the associated agent user search_entity_type char(50) Search ent…

Updated 1 year ago by Cole

user_chart_settings_entity - User Chart Settings

Settings for displaying user charts. Column Data Type Column Info Value Notes Other id int(11) The id of the entity chart_id char(100) Chart ID user_id int(11) ID of the associated agent user chart_s…

Updated 1 year ago by Cole

user__delivery - User Delivery Relation

Maps agent users to notification deliveries. Column Data Type Column Info Value Notes Other id int(11) The id of the entity parent_id int(11) ID of parent category user_id int(11) ID of the associate…

Updated 1 year ago by Cole

vendor_entity - Vendor Entity

Information about vendors Column Data Type Column Info Value Notes Other id int(11) The id of the entity vendor_name varchar(255) vendor name contact_name varchar(255) contact name contact_phone char…

Updated 1 year ago by Sloan

work_item__questions - Work Item - Question Relation

This maps the relationship between Collector Queues and questions asked/answered during a collector queue. Column Data Type Column Info Value Notes Other question_id int(11) The ID of the associated…

Updated 1 year ago by Sloan

wizard_step_video - Wizard Step Video

Shows information regarding Wizard Step Videos. Column Data Type Column Info Value Notes Other id int(11) The ID or identifier of the wizard video. wizard_step_id int(11) The ID of the associated wiz…

Updated 1 year ago by Sloan

wizard_step_entity - Wizard Step Entity

Shows information regarding Wizard Steps. Column Data Type Column Info Value Notes Other id int(11) The ID of the specific wizard step name char(100) The name of the wizard step type char(50) The typ…

Updated 1 year ago by Sloan

wizard_group_entity - Wizard Group Entity

Shows information regarding Wizard Group Entities. Column Data Type Column Info Value Notes Other id int(11) The ID of the wizard group entity name char(100) Name of the wizard group description varc…

Updated 1 year ago by Sloan

wizard_entity - Wizards

Shows information regarding Process Wizards. Column Data Type Column Info Value Notes Other id int(11) The ID of the wizard entity title char(100) Title of the wizard description varchar(300) Descrip…

Updated 1 year ago by Sloan

view_widget_entity - View Widget

Widgets to display to the module. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(255) Entity name description varchar(255) The description of the entity i…

Updated 1 year ago by Sloan

view_template_entity - View Template Entity

Template viewing modes. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(255) Entity name active tinyint(1) Whether or not the entity is active 1 - yes, 0 -…

Updated 1 year ago by Sloan

transaction_entity - Transaction Entity

Holds basic transaction information. Column Data Type Column Info Value Notes Other id int(11) The id of the entity amount decimal(11,2) transaction amount balance decimal(11,2) transaction balance t…

Updated 1 year ago by Cole

view_template__view_module - View Template to View Module Map

Maps viewing templates to module viewing. Column Data Type Column Info Value Notes Other view_template_id int(11) ID of associated view template view_module_id int(11) view moduel ID deleted tinyint(…

Updated 1 year ago by Sloan

view_module_entity - View Module

Information regarding how to display modules. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(255) Entity name display_mode enum display mode view.displayM…

Updated 1 year ago by Sloan

topic_entity - Topic Entity

Topics for messaging thread communication. Column Data Type Column Info Value Notes Other id int(10) The id of the entity topic_name varchar(50) Topic Name parent_topic int(10) Parent Topic ID delete…

Updated 1 year ago by Cole

time_slot_entity - Time Slot for work items

Useful for LoanPro Developers Only!. Use of this table by 3rd parties is not officially supported!. Holds approximate time slot information for scheduled tasks. Column Data Type Column Info Value Not…

Updated 1 year ago by Cole

testimonial_entity - Customer Website Testimonials

Testimonials to display on the Borrower Portal Column Data Type Column Info Value Notes Other id int(11) The id of the entity from varchar(255) Who it's from location varchar(255) testimonial locatio…

Updated 1 year ago by Cole

report_cache - Report Cache Metadata

Holds cached information for reports Column Data Type Column Info Value Notes Other user_id varchar(250) ID of the associated agent user report varchar(100) report information query text Query used t…

Updated 1 year ago by Cole

tenant_plugins_contract_entity - Tenant Plugins Contract Entity

Holds plugin information for the tenant. Column Data Type Column Info Value Notes Other id int(11) The id of the entity user_id int(11) ID of the associated agent user user_ip char(20) IP address of…

Updated 1 year ago by Sloan

tenant_checklist_entity - Tenant Checklist Entity

Holds checlists for the tenant Column Data Type Column Info Value Notes Other id int(11) The id of the entity category_id int(11) category id title varchar(255) The name/title of the entity instance…

Updated 1 year ago by Sloan

tenant_checklist_category_entity - Tenant Checklist Category Entity

Holds checklist categories for the tenant. 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) Wh…

Updated 1 year ago by Sloan

tenant_bulk_purchase_entity - Tenant Bulk Purchase Entity

Holds tenant bulk purchase information. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(100) The name/title of the entity instance price decimal(11,2) pri…

Updated 1 year ago by Sloan

tenant_backup_log_entity - Tenant Backup Logs

Useful for LoanPro Developers Only! Use of this table by 3rd parties is not officially supported! Column Data Type Column Info Value Notes Other id int(11) The id of the entity batch_id char(20) Batc…

Updated 1 year ago by Sloan

tcn_queue_item_entity - TCN Queue Item Entity

Holds TCN queue items. Column Data Type Column Info Value Notes Other id int(11) The id of the entity loan_id int(11) The id of the associated loan account cust_primary tinyint(1) Whether or not to s…

Updated 1 year ago by Sloan

tcn_campaign_entity - TCN Campaign Entity

Holds TCN campaign information. Column Data Type Column Info Value Notes Other id int(11) The id of the entity broadcast_id int(11) TCN broadcast ID broadcast_start timestamp TCN broadcast start last…

Updated 1 year ago by Sloan

system_note_entity - System Notes Entity

Holds system generated note information. Column Data Type Column Info Value Notes Other id int(11) The id of the system note. entity_type char(50) The entity type that the system note is about. There…

Updated 1 year ago by Sloan

support_transaction_entity - Support Transaction

Holds support transaction information. Column Data Type Column Info Value Notes Other id int(10) The id of the entity title varchar(100) The name/title of the entity instance support_date datetime su…

Updated 1 year ago by Sloan

sub_portfolio_entity - Sub Portfolio Entity

Holds sub-portfolio information. 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 parent int(11) parent portfoli…

Updated 1 year ago by Sloan

stoplight_entity - Stoplight Entity

Holds stoplight information. Column Data Type Column Info Value Notes Other id int(11) The id of the entity rule text Associated Clojure Rule used in entity evaluation display varchar(100) display st…

Updated 1 year ago by Sloan

source_company_entity - Source Company Entity

Holds information for source companies Column Data Type Column Info Value Notes Other id int(11) The id of the entity company_name varchar(255) company name contact_name varchar(255) contact name con…

Updated 1 year ago by Sloan

sound_group_item_entity - Sound Group Item Entity

Sound items and associated action for audio notifications in the UI Column Data Type Column Info Value Notes Other id int(11) The id of the entity sound_group_id int(11) associated sound group id eve…

Updated 1 year ago by Sloan

sound_group_entity - Sound Groups

Shows information regarding Sound Groups. Column Data Type Column Info Value Notes Other id int(11) The ID of the specific sound group name varchar(100) Name of the sound group active tinyint(1) Whet…

Updated 1 year ago by Sloan

sms_trigger_entity - SMS trigger Entity

SMS notification trigger settings. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(100) The name/title of the entity instance sbt_template_id int(11) sbt…

Updated 1 year ago by Sloan

sms_delivery_entity - SMS delivery entity

Holds information concerning notification deliveries between SMS Column Data Type Column Info Value Notes Other id int(11) The id of the entity delivery_id int(11) id of delivery draft text draft sms…

Updated 1 year ago by Sloan

shortcut_set_entity - Shortcut Set Entity

Holds information about which shortcuts are set when viewing a Loan in the UI. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(255) Entity name log_payment…

Updated 1 year ago by Sloan

search_restriction_setting_entity - Search Restriction Setting

Settings for search restriction groups. Column Data Type Column Info Value Notes Other id int(11) The id of the entity search_restriction_group_id int(11) associated search restriction id name char(6…

Updated 1 year ago by Sloan

search_restriction_group_entity - Search Restriction Group Entity

Allows search restriction of agent users. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(255) Entity name search_type varchar(50) search type deleted tiny…

Updated 1 year ago by Sloan

scheduled_report_entity - Scheduled Report Entity

Holds information for scheduled reports. Column Data Type Column Info Value Notes Other id int(11) The id of the entity report_name varchar(255) report name report_type varchar(255) report type repor…

Updated 1 year ago by Sloan

scheduled_action_entity - Scheduled Action Entity

Holds information for scheduled actions. Column Data Type Column Info Value Notes Other id int(11) The id of the entity uuid text UUID series_id text series id trigger_key text trigger key ui_state t…

Updated 1 year ago by Sloan

schedule_template_lines_entity - Schedule template lines entity

Holds custom schedule line template information Column Data Type Column Info Value Notes Other id int(11) The id of the entity template_id int(11) associated template id term int(11) template line te…

Updated 1 year ago by Sloan

schedule_roll_template_entity - Schedule Roll Template

Holds schedule roll template information. 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 prorate_1st_payment t…

Updated 1 year ago by Sloan

sbt_template_mapping - SBT template mapping

Holds mapping information between SBT variables. Column Data Type Column Info Value Notes Other id int(11) The id of the entity template_id int(11) associated template id template_variable varchar(25…

Updated 1 year ago by Sloan

sbt_dnd_periods - SBT Do Not Disturb Periods

Holds information for Solutions by Text (SBT) Do Not Disturb (DND) periods. Column Data Type Column Info Value Notes Other id int(11) The id of the entity start_time time start time stop_time time st…

Updated 1 year ago by Sloan

saved_search_entity - Saved search entity

Holds saved search settings for agent users 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 entity_type char(50…

Updated 1 year ago by Sloan

rule_entity - Rule Entity

Holds Clojure rule information. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(100) The name/title of the entity instance type varchar(100) rule type rul…

Updated 1 year ago by Sloan

rule_category_entity - Rule Category Entity

Holds category information for Clojure rules. 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)…

Updated 1 year ago by Sloan

rule_applied_stop_interest_entity - Rules Applied Stop Interest

Holds information for stop interest rules applied. These rules applied affect stop interest dates on loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar…

Updated 1 year ago by Sloan

rule_applied_settings__sub_portfolio_to_delete - Rules Applied Settings Sub-Portfolio To Delete Relation

Holds information for deleting sub-portfolios rules applied. These rules applied delete associated sub-portfolios on loans. Column Data Type Column Info Value Notes Other rule_id int(11) associated r…

Updated 1 year ago by Sloan

rule_applied_settings__sub_portfolio - Rules Applied Settings Sub-Portfolio Relation

Holds information for sub-portfolio rules applied. These rules applied add sub-portfolios to loans. Column Data Type Column Info Value Notes Other rule_id int(11) associated rule id sub_portfolio_id…

Updated 1 year ago by Sloan

rule_applied_settings__portfolio_to_delete - Rules Applied Settings Portfolio To Delete Relation

Holds information for deleting portfolios rules applied. These rules applied delete associated portfolios on loans. Column Data Type Column Info Value Notes Other rule_id int(11) associated rule id p…

Updated 1 year ago by Sloan

rule_applied_settings__portfolio - Rules Applied Settings Portfolio Relation

Holds information for portfolio rules applied. These rules applied add portfolios to loans. Column Data Type Column Info Value Notes Other rule_id int(11) associated rule id portfolio_id int(11) asso…

Updated 1 year ago by Sloan

rule__category - Rules to Category Relation

Maps rules to categories Column Data Type Column Info Value Notes Other rule_id int(11) associated rule id category_id int(11) Associated category id created timestamp Timestamp of when the entity wa…

Updated 1 year ago by Sloan

restriction_group_entry_entity - Restriction Group Entry Entity

Holds restriction group entry entity data. Column Data Type Column Info Value Notes Other id int(10) restriction_group_id int(10) entity_type varchar(255) access int(11) rule text ui_state text error…

Updated 1 year ago by Sloan

quick_note_entity - Quick Note entity

Holds quick note entity information. Column Data Type Column Info Value Notes Other id int(11) The id of the entity note_name varchar(255) note name note_category_id int(11) note category id note_con…

Updated 1 year ago by Cole

portfolio_entity - Portfolio entity

Holds portfolio information used to categorize loans. 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 num_prefi…

Updated 1 year ago by Cole

portfolio_category_entity - Portfolio Category Entity

Allows the categorization of portfolios. Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_type char(32) Type of the associated entity title varchar(255) The name/…

Updated 1 year ago by Cole

pnm_order_entity - Pay Near Me Order Entity

PayNearMe order information. Column Data Type Column Info Value Notes Other id int(10) The id of the entity loan_id int(10) The id of the associated loan account customer_id int(11) ID for the custom…

Updated 1 year ago by Cole

preconfigured_loan_settings_entity - Preconfigured loan settings entity

Holds information about loan settings to use when creating a loan from a preconfigured template. Column Data Type Column Info Value Notes Other id int(11) The id of the entity card_fee_amount decimal…

Updated 1 year ago by Sloan

preconfigured_loan__sub_portfolio - Preconfigured loan and sub portfolio relation

Provides a many-to-many mapping between preconfigured loans and sub-portfolios, allowing sub-portfolios to be used with preconfigured loans. Column Data Type Column Info Value Notes Other preconfigur…

Updated 1 year ago by Sloan

payment_reversed_tx_snapshot - Payment Reversed Transaction Snapshot

Holds transaction snapshot information for reversed payments. Column Data Type Column Info Value Notes Other id int(11) The id of the entity mod_id int(11) The id of the associated loan modification…

Updated 1 year ago by Sloan

payment__sub_portfolio - Payment Sub portfolio Relations

Holds a many-to-many mapping between payments and sub-portfolios. Column Data Type Column Info Value Notes Other payment_id int(11) associated payment id sub_portfolio_id int(11) associated sub portf…

Updated 1 year ago by Sloan

payment__portfolio - Payment Portfolio Relations

Holds a many-to-many mapping between payments and portfolios. Column Data Type Column Info Value Notes Other payment_id int(11) associated payment id portfolio_id int(11) associated protfolio id crea…

Updated 1 year ago by Sloan

page_entity - Customer Website Page Entity

Holds information - including custom code - to use in the creation of pages on the Customer Website. Column Data Type Column Info Value Notes Other id int(11) The id of the entity type varchar(100) P…

Updated 1 year ago by Sloan

notification_entity - Notification Entity

Holds a notification that has been sent to a user, and the status of the notification. Column Data Type Column Info Value Notes Other id int(11) The id of the entity user_id int(11) ID of the associa…

Updated 1 year ago by Cole

notification_dnd_period_entity - Notification Do Not Disturb Period Entity

Sets up Do Not Disturb (DND) periods for notifications. During a DND no notifications will be sent out. Column Data Type Column Info Value Notes Other id int(11) The id of the entity notification_typ…

Updated 1 year ago by Cole

notification_category_entity - Notification Category

Provides categorization of notifications. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(100) The name/title of the entity instance icon varchar(100) ico…

Updated 1 year ago by Cole

notification_category__delivery - Notification Category - Delivery Relation

Provides a many-to-many relationship between notification categories and delivery methods. Column Data Type Column Info Value Notes Other category_id int(11) Associated category id delivery_id int(11…

Updated 1 year ago by Cole

note_category_entity - Note Category Info

Holds category information for notes created by agent users. 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 en…

Updated 1 year ago by Cole

merchant_processor_group_entity - Merchant Processor Group Entity

Holds information about merchant processor groups. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(255) Name of the processor group description mediumtext…

Updated 1 year ago by Sloan

lockbox_settings_entity - Lockbox Converter Settings

Holds tenant information for the desktop-based lockbox to import file converter. Column Data Type Column Info Value Notes Other id int(11) The id of the entity label text The label of the entity inst…

Updated 1 year ago by Sloan

loan_sub_status_entity - Loan Sub Status Entity

Loan sub-status information. 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 rule text parent int(11) parent st…

Updated 1 year ago by Sloan

loan_stop_interest_date_entity - Loan Stop/Resume Interest Entity

Stop interest date information for loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_id int(11) ID of the associated entity entity_type varchar(100) Type of…

Updated 1 year ago by Sloan

loan_status_entity - Loan Status Entity

Holds loan status information. 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…

Updated 1 year ago by Sloan

loan_sms_queue_item_entity - Loan SMS Queue Item Entity

Represents a loan in an SMS queue. Column Data Type Column Info Value Notes Other id int(11) The id of the entity loan_id int(11) The id of the associated loan account template_id int(11) Associated…

Updated 1 year ago by Sloan

loan_settings_entity - Loan Settings Entity

Holds search, categorization and metadata settings for a loan. Column Data Type Column Info Value Notes Other id int(11) The id of the entity loan_id int(11) The id of the associated loan account car…

Updated 1 year ago by Sloan

loan_reverse_status_archive - Loan Reverse Status Archive

Holds archived status change information for reverse calculation of history. Column Data Type Column Info Value Notes Other loan_id int(11) The id of the associated loan account date date Reversal da…

Updated 1 year ago by Sloan

loan_promise_entity - Loan Promise info

Holds promise information for a loan Column Data Type Column Info Value Notes Other id int(11) The id of the entity loan_id int(11) The id of the associated loan account subject varchar(100) Promise…

Updated 1 year ago by Sloan

loan_modification_entity - Loan Modification Info

Holds modification information for a loan. Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_id int(11) ID of the associated entity entity_type varchar(100) Type o…

Updated 1 year ago by Sloan

loan_late_fee__buckets - Loan Late Fee Buckets

Holds a relationship mapping between loans and late fee buckets. Column Data Type Column Info Value Notes Other loan_id int(11) The id of the associated loan account subset int(11) Late fee subset ID…

Updated 1 year ago by Sloan

loan_insurance_entity - Loan Insurance Info

Holds insurance information for a loan. Column Data Type Column Info Value Notes Other id int(11) The id of the entity company_name varchar(255) Insurance Company Name insured varchar(255) Name of in…

Updated 1 year ago by Sloan

loan_dpd_adjustment_entity - Loan Days Past Due Adjustment Entity

Holds Days Past Due (DPD) adjustment information for loans Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_id int(11) ID of the associated entity entity_type var…

Updated 1 year ago by Sloan

loan_document_entity - Loan Document Entity

Holds loan document information for a loan Column Data Type Column Info Value Notes Other id int(11) The id of the entity loan_id int(11) The id of the associated loan account user_id int(11) ID of t…

Updated 1 year ago by Sloan

loan_delinquency_history_entity - Loan Delinquency History

Holds delinquency history for a loan Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_id int(11) ID of the associated entity entity_type varchar(100) Type of the…

Updated 1 year ago by Sloan

loan_curtail_date_entity - Loan Curtailment Date Entity

Holds curtailment information for a loan Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_id int(11) ID of the associated entity entity_type varchar(100) Type of…

Updated 1 year ago by Sloan

loan_credit_entity - Loan Credit Entity

Holds credit information for a loan Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_id int(11) ID of the associated entity entity_type varchar(100) Type of the a…

Updated 1 year ago by Sloan

loan_chargeoff_entity - Loan Chargeoff Entity

Holds charge-off information for a loan. Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_id int(11) ID of the associated entity entity_type varchar(100) Type of…

Updated 1 year ago by Sloan

loan_chargeoff__transactions - Loan Chargeoff Transaction

Holds information concerning which payments/credits attached to a loan count as chargeoff payments, and by how much they are considered chargeoff payments. Column Data Type Column Info Value Notes Ot…

Updated 1 year ago by Sloan

loan_apd_adjustment_entity - Amount Past Due Adjustment

Holds information for Amount Past Due (APD) adjustments on loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_id int(11) ID of the associated entity entity_t…

Updated 1 year ago by Sloan

loan_advancement_entity - Loan Advancements

Holds information for loan advancements. Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_id int(11) ID of the associated entity entity_type varchar(100) Type of…

Updated 1 year ago by Sloan

loan_active_time_tx - Loan Active Time Transactions

Holds transaction information spanning a period of time in which the loan was active. Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_id int(11) ID of the associ…

Updated 1 year ago by Sloan

loan__sub_portfolio - Loan Sub Portfolio relations

Provides a many-to-many relationship between loans and sub portfolio Column Data Type Column Info Value Notes Other loan_id int(11) The id of the associated loan account sub_portfolio_id int(11) ID o…

Updated 1 year ago by Sloan

loan__rule_applied_stop_interest - Rule applied Stop Interest - Loan Relations

Provides a many-to-many relationship between loans and stop interest rules applied Column Data Type Column Info Value Notes Other loan_id int(11) The id of the associated loan account rule_applied_st…

Updated 1 year ago by Sloan

loan__rule_applied_settings - Rule applied Settings - Loan Relations

Provides a many-to-many relationship between loans and settings rules applied. Column Data Type Column Info Value Notes Other loan_id int(11) The id of the associated loan account rule_applied_settin…

Updated 1 year ago by Sloan

loan__rule_applied_duedate - Rule applied Due Date - Loan Relations

Provides a many-to-many relationship between loans and due date rules applied. Column Data Type Column Info Value Notes Other loan_id int(11) The id of the associated loan account rule_applied_duedat…

Updated 1 year ago by Sloan

loan__rule_applied_checklist - Rule applied checklist - Loan Relations

Provides a many-to-many relationship between loans and checklist rules applied. Column Data Type Column Info Value Notes Other loan_id int(11) The id of the associated loan account rule_applied_check…

Updated 1 year ago by Sloan

loan__rule_applied_charge_off - Rule applied charge off - Loan Relations

Provides a many-to-many relationship between loans and charge off rules applied. Column Data Type Column Info Value Notes Other loan_id int(11) The id of the associated loan account rule_applied_char…

Updated 1 year ago by Sloan

loan__portfolio - Loan Portfolio Relations

Provides a many-to-many relationship between portfolios and loans. Column Data Type Column Info Value Notes Other loan_id int(11) The id of the associated loan account portfolio_id int(11) Associated…

Updated 1 year ago by Sloan

loan__customer - Loan Customer Link Info

Provides a many-to-many relationship between customers and loans. Column Data Type Column Info Value Notes Other id int(10) loan_id int(11) The id of the associated loan account customer_id int(11) I…

Updated 1 year ago by Sloan

linked_loan_option_entity - Linked loan option

Holds options over various linked loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(100) The name/title of the entity instance description varchar(25…

Updated 1 year ago by Cole

linked_loan__entity - Linked loan info

Holds information for links between various loan entities. Column Data Type Column Info Value Notes Other id int(11) The id of the entity loan int(11) Primary loan ID linked_loan int(11) Linked loan…

Updated 1 year ago by Cole

linked_info__entity - Link metadata

Provides a many-to-many relationship between links and various entities. Column Data Type Column Info Value Notes Other id int(10) The id of the entity linked_loan int(11) Linked loan id entity_type…

Updated 1 year ago by Cole

link_entity - Link Info

Description. Information for various links. Table Fields. Column Data Type Column Info Value Notes Other id int(11) The id of the entity type varchar(100) Identifier for the entity type title varchar…

Updated 1 year ago by Cole

investor_status_entity - Investor status information

Holds status information for investors. 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 slug varchar(255) Statu…

Updated 1 year ago by Sloan

investor_document_entity - Investor document entity

Holds document information for investment entities. Column Data Type Column Info Value Notes Other id int(11) The id of the entity investment_id int(11) Associated investment id user_id int(11) ID of…

Updated 1 year ago by Sloan

investment_position_entity - Investment Position Entity

Holds information concerning an investment and its position on holding accounts and loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity holding_account_id int(11) As…

Updated 1 year ago by Sloan

investment_entity - Investment Entity

Holds information concerning various investments. Column Data Type Column Info Value Notes Other id int(11) The id of the entity display_id char(25) Display ID title char(255) The name/title of the e…

Updated 1 year ago by Sloan

investment_document_entity - Investment Document Entity

Holds document information for investment entities. Column Data Type Column Info Value Notes Other id int(11) The id of the entity investment_id int(11) Associated investment id user_id int(11) ID of…

Updated 1 year ago by Sloan

investment__sub_portfolio - Investment Sub Portfolio Relation

Provides a many-to-many mapping between investments and sub-portfolios. Column Data Type Column Info Value Notes Other investment_id int(11) Associated investment id sub_portfolio_id int(11) ID of as…

Updated 1 year ago by Sloan

homepage_image_entity - Customer website hompage image info

Holds information for the homepage image for the Borrower Portal. Includes information concerning how the image is displayed. Column Data Type Column Info Value Notes Other id int(11) The id of the e…

Updated 1 year ago by Sloan

holding_account_transaction_entity - Holding Account Transaction

Holds transaction information for a holding account. Column Data Type Column Info Value Notes Other id int(11) The id of the entity holding_account_id int(11) ID of associated holding account amount…

Updated 1 year ago by Sloan

holding_account_transaction_category_entity - Holding Account Transaction Category

Holds category information for holding account transactions. Allows organizing transactions by category. Column Data Type Column Info Value Notes Other id int(11) The id of the entity category_name v…

Updated 1 year ago by Sloan

holding_account_sub_status_entity - Holding Account Sub Status Entity

Holds substatus information and settings for holding accounts. 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…

Updated 1 year ago by Sloan

holding_account_status_entity - Holding Account status entity

Holds status information for holding accounts. 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…

Updated 1 year ago by Sloan

holding_account_settings_entity - Holding account settings entity

Holds setting information for holding accounts. Column Data Type Column Info Value Notes Other id int(11) The id of the entity account_id int(11) Holding account ID account_type char(64) Holding acco…

Updated 1 year ago by Sloan

holding_account_category_entity - Holding Account Category Info

Holds category information for holding accounts, allows a categorization of holding accounts. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(255) The nam…

Updated 1 year ago by Sloan

holding_account_autopay_entity - Holding Account - Autopay Info

Holds autopay information for holding accounts. Column Data Type Column Info Value Notes Other id int(10) The id of the entity holding_account_id int(10) Holding Account ID name varchar(255) Entity n…

Updated 1 year ago by Sloan

holding_account_archive_entity - Holding Account Archive Info

Holds archived information for holding accounts. Column Data Type Column Info Value Notes Other id int(11) The id of the entity holding_account_id int(11) Holding Account ID date date Date of archiva…

Updated 1 year ago by Sloan

holding_account__investor - Holding Account Investor Relations Info

Provides a many-to-many mapping between various holding accounts and investors, as well as access restrictions for each relationship. Column Data Type Column Info Value Notes Other holding_account_id…

Updated 1 year ago by Sloan

gps_link_entity - GPS Link Info

This holds GPS Link information. Column Data Type Column Info Value Notes Other id int(11) The id of the entity url varchar(500) The link to the generated file active tinyint(1) Whether or not the en…

Updated 1 year ago by Sloan

form_section_entity - Form Section Info

This provides categorization of various custom forms that can be used on entities. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(255) The name/title of…

Updated 1 year ago by Sloan

flag_status_archive - Flag Status Archive

An archive of various flag statuses that have been evaluated in the past for different entities. Column Data Type Column Info Value Notes Other flag_id int(11) ID of associated flag date date Date of…

Updated 1 year ago by Sloan

file_attachment_entity - File attachment entity

Holds information for files attached to various entities Column Data Type Column Info Value Notes Other id int(11) The id of the entity parent_type char(100) Type of parent parent_id int(11) ID of pa…

Updated 1 year ago by Sloan

faq_entry_entity - Customer Website FAQ Entry

Holds questions and answers to display on the Customer website (also referred to as "Borrower Portal", "Customer Portal", "Customer-facing website") Column Data Type Column Info Value Notes Other id…

Updated 1 year ago by Sloan

escrow_tx_category_entity - Escrow Transaction Category

Holds categorical information for escrow transactions, allowing escrow transactions to be categorized Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(255)…

Updated 1 year ago by Sloan

escrow_subset_options_entity - Escrow Subset Options

Options for calculation and triggers in regards to an escrow subset. This includes inclusion in APR calculations, payoff options, cushioning, deficiency actions, shortage actions, surplus actions, et…

Updated 1 year ago by Sloan

escrow_subset_entity - Escrow Subset Entity

Holds Escrow Subset options and information. This includes subset names as well as default calculation options for the subset. Column Data Type Column Info Value Notes Other id int(11) The id of the…

Updated 1 year ago by Sloan

escrow_calculator_entity - Escrow calculator

Holds information about how to calculate escrow for loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_id int(11) ID of the associated entity entity_type var…

Updated 1 year ago by Sloan

escrow_analysis_process_entity - Escrow Analysis Process

Holds information about current and past escrow analysis processes. Column Data Type Column Info Value Notes Other id int(11) The id of the entity created timestamp Timestamp of when the entity was c…

Updated 1 year ago by Sloan

escrow_adjustment_entity - Escrow Adjustment Entity

This holds adjustment information for escrows. This allows for an escrow amount to be adjusted after the time of contract. Column Data Type Column Info Value Notes Other id int(11) The id of the enti…

Updated 1 year ago by Sloan

escrow__transactions - Escrow Transaction Metadata

Provides a many-to-many mapping between escrows and transactions. Column Data Type Column Info Value Notes Other id int(11) The id of the entity loan_id int(11) The id of the associated loan account…

Updated 1 year ago by Sloan

email_trigger_entity - Email Trigger entity

This holds email trigger information. When the trigger is matched, an email is sent out to the specified recepients. Column Data Type Column Info Value Notes Other id int(11) The id of the entity com…

Updated 1 year ago by Sloan

email_tool_entity - Email Tool Entity

Email tools generate and send out emails to different customers, generally about information for a loan. Column Data Type Column Info Value Notes Other id int(11) The id of the entity user_id int(11)…

Updated 1 year ago by Sloan

email_tool__loan - Email Tool - Loan Association

Provides a many-to-many map between email tools and loans. Column Data Type Column Info Value Notes Other email_tool_id int(11) Email Tool ID loan_id int(11) The id of the associated loan account las…

Updated 1 year ago by Sloan

email_template_entity - Email Template Entity

Holds template information for emails, such as formatting and variables to use from different entities. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(100…

Updated 1 year ago by Sloan

email_queue - Email Queue

A queue of emails that are in the process of being sent out. Column Data Type Column Info Value Notes Other id int(11) The id of the entity recipients text TCN recipients recipients_bcc text Blind Ca…

Updated 1 year ago by Sloan

email_delivery_entity - Email Delivery Entity

Holds information for various email delivery attempts. Column Data Type Column Info Value Notes Other id int(11) The id of the entity delivery_id int(11) Associated delivery id subject varchar(255) e…

Updated 1 year ago by Sloan

doc_section_entity - Document Section Entity

Holds section information for documents attached to loans or customers, thus allowing categorization for documents. Column Data Type Column Info Value Notes Other id int(11) The id of the entity titl…

Updated 1 year ago by Sloan

disbursement_entity - Disbursement Entity

Holds information about escrow disbursement. Column Data Type Column Info Value Notes Other id int(11) The id of the entity account_type char(32) Associated account type account_id int(11) ID of the…

Updated 1 year ago by Sloan

defaults_user_loan - User specific Loan Defaults

Defaults for newly created loans. 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 loan_class char(30) The class…

Updated 1 year ago by Sloan

defaults_system_loan - System Loan Defaults

This holds tenant-wide default options for new loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity loan_class char(30) The classification for the loan loan.class.* l…

Updated 1 year ago by Sloan

defaults_payments - Payment Defaults

This holds tenant-wide default options for new payments. Column Data Type Column Info Value Notes Other id int(11) The id of the entity loan_class char(30) The classification for the loan loan.class.…

Updated 1 year ago by Sloan

defaults_late_fee__buckets - Loan late fee bucket defaults

This holds tenant-wide default options for new late fee buckets. Column Data Type Column Info Value Notes Other loan_id int(11) The id of the associated loan account subset int(11) Holds late fee buc…

Updated 1 year ago by Sloan

defaults_charges - Default Charges

This holds tenant-wide default options for new charges. Column Data Type Column Info Value Notes Other id int(11) The id of the entity loan_class char(30) The classification for the loan loan.class.*…

Updated 1 year ago by Sloan

default_billing_theme_entity - Default Billing Theme Entity

This holds tenant-wide default options for billing themes Column Data Type Column Info Value Notes Other id int(11) The id of the entity default_billing_template_id int(11) ID of default billing temp…

Updated 1 year ago by Sloan

default_billing_template_entity - Default Billing Template Entity

This holds tenant-wide default options for billing templates. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(100) Entity name deleted tinyint(4) Whether o…

Updated 1 year ago by Sloan

custom_payment_type_entity - Custom Payment Type Entity

This allows the definition of custom payment types that can be used when creating a payment. These types do affect the application of payments. Column Data Type Column Info Value Notes Other id int(1…

Updated 1 year ago by Cole

custom_payment_method_entity - Custom Payment Method Entity

This allows the definition of custom payment methods that can be used when creating a payment. Column Data Type Column Info Value Notes Other id int(11) The id of the entity static tinyint(1) Whether…

Updated 1 year ago by Cole

custom_form_tool__loan - Custom Form Tool to Loan Map

This provides a many-to-many map of custom form tools generating forms to loans to generate forms for. Column Data Type Column Info Value Notes Other loan_id int(11) The id of the associated loan acc…

Updated 1 year ago by Cole

custom_form_section_entity - Custom Form Section Entity

This holds section information for custom forms, allowing custom forms to be categorized by section. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(100)…

Updated 1 year ago by Cole

custom_form_entity - Custom Form Entity

This holds information for custom form templates used to generate PDF forms about loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_type char(100) Type of t…

Updated 1 year ago by Cole

custom_field__entity - Custom Field to Entity Map

This allows the mapping of custom fields to other entities, such as loans, customers, collateral, etc. Column Data Type Column Info Value Notes Other id int(11) The ID of the entity. entity_id int(11…

Updated 1 year ago by Cole

custom_charge_type_entity - Custom Charge Type Entity

This allows the definition of custom charge types that can be used when creating a charge. Column Data Type Column Info Value Notes Other id int(11) The id of the entity static tinyint(1) Whether or…

Updated 1 year ago by Cole

custom_boarding_process_step_entity - Custom Onboarding Process Step Entity

This holds information for a single step in a custom on-boarding process. Column Data Type Column Info Value Notes Other id int(11) The id of the entity custom_boarding_process_id int(11) ID of assoc…

Updated 1 year ago by Cole

custom_billing_theme_entity - Custom Billing Theme Entity

This holds custom billing theme information used when generating billing statements. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(100) Entity name sourc…

Updated 1 year ago by Cole

custom_billing_template_entity - Custom Billing Template Entity

This holds custom billing template information used when generating billing statements. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(100) Entity name ac…

Updated 1 year ago by Cole

curtailment_template_lines_entity - Curtailment Template Lines Entity

This holds curtailment line template information used when creating flooring loans. These lines are attached to a curtailment template. Column Data Type Column Info Value Notes Other id int(11) The i…

Updated 1 year ago by Cole

curtailment_template_entity - Curtailment Template Entity

This holds curtailment template information used when creating flooring loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(255) The name/title of the…

Updated 1 year ago by Cole

credit_report_queue - Credit Report Queue

This holds a queue for reports being generated to send to credit bureaus. Column Data Type Column Info Value Notes Other id int(11) The id of the entity status varchar(45) Status code of the entity t…

Updated 1 year ago by Cole

credit_report_history - Credit Report History

This holds records concerning generated reports to send to credit bureaus. Column Data Type Column Info Value Notes Other id int(11) The id of the entity time_completed timestamp Time report was comp…

Updated 1 year ago by Cole

credit_category_entity - Credit Category Entity

This holds category information for credits on a loan. This allows classification of credits upon application. Only active, non-deleted categories can be used when applying a credit. If a category is…

Updated 1 year ago by Cole

credit_breakdown_report - Credit Breakdown Report

Deprecated! Column Data Type Column Info Value Notes Other entity_id int(11) ID of the associated entity entity_type varchar(100) Type of the associated entity credit_id int(11) Associated credit id…

Updated 1 year ago by Cole

contract_signer_entity - Contract Signer Entity

This holds information about which agent user signed the SAS contract. Column Data Type Column Info Value Notes Other id int(11) The id of the entity user_id int(11) ID of the associated agent user c…

Updated 1 year ago by Cole

Database - Rules Applied Loan Setup (loan__rule_applied_loan_setup)

Description. Common Uses. Table Fields. Column Data Type Column Info Value Notes loan_id int(11) The ID of the associated loan. rule_applied_id int(11) The ID of the specific rule applied. enabled ti…

Updated 1 year ago by Sloan

data_import_entity - Data Import Entity

This holds record information for various data import entities. Column Data Type Column Info Value Notes Other id int(10) The id of the entity entity varchar(255) Encoded information about the entity…

Updated 1 year ago by Sloan

data_dump_entity - Data Dump Entity

This holds information about various CSV or PDF files generated holding entity information. Column Data Type Column Info Value Notes Other id int(11) The id of the entity entity_type char(100) Type o…

Updated 1 year ago by Sloan

comment_thread_topics - Comment Thread Topics

This holds topic information for comment threads (in the UI they are called Messaging Threads). This specifies topics that comments can be made to. Column Data Type Column Info Value Notes Other id i…

Updated 1 year ago by Cole

comment_thread_comments - Comment Thread Comments

This holds comment information for comment threads (in the UI they are called Messaging Threads). These allow inter-office communication concerning different topics. Column Data Type Column Info Valu…

Updated 1 year ago by Cole

collector_queue_work_item_entity - Collector Queue Work Item Entity

This holds information concerning work that has been done on a collector queue. This includes information about the loan worked on, when work started, and when work ended. Column Data Type Column Inf…

Updated 1 year ago by Cole

customer_status_entity - Customer Status Entity

This holds categories for different statuses a customer can be in. This allows categorization of various customers. Column Data Type Column Info Value Notes Other id int(11) The id of the entity titl…

Updated 1 year ago by Sloan

collector_queue_question_entity - Collector Queue Question Entity

This holds information for questions that agent users are asked when going through a collector queue. Column Data Type Column Info Value Notes Other id int(11) The id of the entity question text Ques…

Updated 1 year ago by Cole

customer_social_profile_entity - Customer Social Profile Entity

This holds social profile information for customers, such as Facebook, Google+, Twitter, etc. Column Data Type Column Info Value Notes Other id int(11) The id of the entity customer_id int(11) ID for…

Updated 1 year ago by Sloan

customer_reference_entity - Customer Reference Entity

This holds information about references for customers. Column Data Type Column Info Value Notes Other id int(11) The id of the entity name varchar(255) Entity name relation char(100) Customer relatio…

Updated 1 year ago by Sloan

customer_phone_entity - Customer Phone Entity

This holds information concerning customer phone numbers, such as the number, carrier, and whether or not it is subscribed for text messages. Column Data Type Column Info Value Notes Other id int(11)…

Updated 1 year ago by Sloan

collector_queue__loan - Collector Queue To Loan Map

This provides a many-to-many map of collector queues to loans. This allows for a collector queue to hold specific loans rather than just queries. Column Data Type Column Info Value Notes Other collec…

Updated 1 year ago by Cole

collection_item - Collection Item

Deprecated! No longer used. Values are stored in the API instead. Column Data Type Column Info Value Notes Other id varchar(100) The id of the entity role_id int(11) ID of the associated Role item_la…

Updated 1 year ago by Cole

collection - Collection

Deprecated! No longer used. Values are stored in the API instead. Column Data Type Column Info Value Notes Other id varchar(100) The id of the entity label varchar(100) The label of the entity instan…

Updated 1 year ago by Cole

collateral_field_entity - Collateral Field Entity

This holds meta-data about the four primary fields available to all collateral types (labelled "A","B","C","D"). The id and collateral_type fields have values that come from the API. Column Data Type…

Updated 1 year ago by Cole

checklist_item_entity - Checklist Item Entity

This holds the information for items on a checklist. These are the items that can be marked as checked or unchecked. Column Data Type Column Info Value Notes Other id int(11) The id of the entity tit…

Updated 1 year ago by Cole

cash_drawer__payment_method - Cash Drawer to Payment Method Map

This provides a many-to-many map of cash drawers to payment methods. This determines which payment methods (eg. cash, check, card) are allowed to affect specific cash drawers. Column Data Type Column…

Updated 1 year ago by Cole

bracket_item_entity - Bracket Item Entity

Bracket item entities hold bracket ranges for search brackets. A '0.00' in the bracket_item_end symbolizes an infinite boundary. The additional_value field is reserved for future use. Column Data Typ…

Updated 1 year ago by Cole

billing_tool__loan - Billing Tool to Loan Map

This maps billing tools to loans, allowing a billing tool to apply to specific loan accounts. Column Data Type Column Info Value Notes Other billing_tool_id INT(11) Billing tool id loan_id INT(11) Th…

Updated 1 year ago by Cole

address_entity - Address Entity

This entity holds address information, including Latitude and Longitude conversions as well as verification status. Column Data Type Column Info Value Notes Other id INT(11) The id of the entity addr…

Updated 1 year ago by Cole

Powered by HelpDocs (opens in a new tab)