All Categories ​>​ ​Database

Database

Database Tables

This is our parent database article. Here, we list all database tables as a reference for those who have access to a read-only copy.

Updated 4 months ago by Jackson Stone

Database – Dashboard Entity (dashboard_entity)

This table shows database entities for agent dashboards.

Updated 4 months ago by Sloan

Database – Holding Account Investor Relations Info (holding_account__investor)

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

Updated 4 months ago by Sloan

Database – 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 4 months ago by Sloan

Database – Rules Applied, Customer Tools (rule_applied_customer_tools_entity)

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 4 months ago by Sloan

Database – Tenant Pricing Tier (tenant_pricing_tier_entity)

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 4 months ago by Sloan

Database – Loan Schedule Roll Entity (loan_schedule_roll_entity)

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

Updated 4 months ago by Sloan

Database – Escrow Analysis Process (escrow_analysis_process_entity)

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

Updated 4 months ago by Sloan

Database – Wizard Validation (wizard_process_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 4 months ago by Sloan

Database – Curtailment Template Entity (curtailment_template_entity)

This article shows the database entities for curtailment templates.

Updated 4 months ago by Cole

Database – Tenant Backup Logs (tenant_backup_log_entity)

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 4 months ago by Sloan

Database – Loan Days Past Due Adjustment Entity (loan_dpd_adjustment_entity)

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

Updated 4 months ago by Sloan

Database – 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 4 months ago by Sloan

Database – Data Dump Entity (data_dump_entity)

This table holds database entity information on CSV or PDF files generated.

Updated 4 months ago by Sloan

Database – Disbursement Entity (disbursement_entity)

Description. 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(1…

Updated 4 months ago by Sloan

Database – 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 4 months ago by Sloan

Database – Escrow Transaction Metadata (escrow__transactions)

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

Updated 4 months ago by Sloan

Database – Loan Curtailment Date Entity (loan_curtail_date_entity)

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

Updated 4 months ago by Sloan

Database – Rules Applied, AutoPay (rule_applied_autopay_entity)

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 4 months ago by Sloan

Database – Loan Document Entity (loan_document_entity)

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

Updated 4 months ago by Sloan

Database – Curtailment Template Lines Entity (curtailment_template_lines_entity)

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

Updated 4 months ago by Cole

Database – Loan Insurance Info (loan_insurance_entity)

Description. 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(25…

Updated 4 months ago by Sloan

Database – Defaults Escrow Calculator (defaults_escrow_calculator)

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

Updated 4 months ago by Sloan

Database – Email Tool - Loan Association (email_tool__loan)

Description. This table holds records of email tools and loans. Table Fields. Field Data Type Column Info Value Notes email_tool_id int(11) Email Tool ID loan_id int(11) The id of the associated loan…

Updated 4 months ago by Brinley Bushman

Database – 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

Database – View Module (view_module_entity)

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 2 years ago by Sloan

Database – Default Charges (defaults_charges)

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

Updated 1 year ago by Sloan

Database – Holding Account Settings Entity (holding_account_settings_entity)

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

Updated 1 year ago by Sloan

Database – Search Restriction Setting (search_restriction_setting_entity)

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 2 years ago by Sloan

Database – Admin Tool (admin_tool_entity)

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

Updated 1 year ago by Cole

Database – Merchant Processor Group Entity (merchant_processor_group_entity)

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

Updated 1 year ago by Sloan

Database – Customer Website Hompage Image Info (homepage_image_entity)

This table shows the database entities for the customer homepage image information.

Updated 1 year ago by Sloan

Database – Customer Reference Entity (customer_reference_entity)

This article shows the database entities for customer references and how to add references in the API.

Updated 11 months ago by Sloan

Database – Holding Account Status Entity (holding_account_status_entity)

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

Updated 4 months ago by Sloan

Database – Loan Child Entity (loan_child__entity)

Description. This table holds information for loans that have child relationships to other loans. Column Data Type Column Info Value Notes id int(11) The ID or identifier of the specific child entity…

Updated 4 months ago by Sloan

Database – Address Entity (address_entity)

This entity holds address information, including latitude and longitude conversions as well as verification status.

Updated 1 year ago by Jackson Stone

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 1 year ago by Sloan

Database – SBT Message Log (sbt_message_log)

Description. This table holds records of SBT messaging. Table Fields. Feld Data Type Column Info Value Notes id int(11) The id of the entity customer_id int(11) ID for the customer customer_phone_id…

Updated 4 months ago by Brinley Bushman

Database – 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

Database – Rule applied checklist - Loan Relations (loan__rule_applied_checklist)

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

Updated 1 year ago by Sloan

Database – Rules Applied Charge Off Entity (rule_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 2 years ago by Sloan

Database – Charges Table (charge_entity)

This database article shows the entities for the charges table.

Updated 1 year ago by Sloan

Database – Flag Status Archive (flag_status_archive)

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

Updated 1 year ago by Sloan

Database – Action & Result Note (action_result_note_entity)

This is the database article for action and results entities.

Updated 1 year ago by Sloan

Databases 101

This article explains databases for people who are unfamiliar with them. It may also be helpful for anyone who understands the basic concept of databases, but wants to make sure they have a full unde…

Updated 5 months ago by Andy

Database – Collateral Entity (collateral_entity)

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

Updated 1 year ago by Cole

Database – Default Billing Theme Entity (default_billing_theme_entity)

This table holds tenant-wide options for billing themes.

Updated 1 year ago by Sloan

Database – Loan Status Entity (loan_status_entity)

Description. Holds loan status information. Column Data Type Column Info Value Notes id int(11) The id of the status. title varchar(255) The name of the loan status. color char(32) The color for the…

Updated 1 year ago by Jackson Stone

Database – Rule applied Due Date - Loan Relations (loan__rule_applied_duedate)

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

Updated 1 year ago by Sloan

Database – Rules Applied APD Reset Entity (rule_applied_apd_reset_entity)

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

Updated 1 year ago by Sloan

Database – Email Delivery Entity (email_delivery_entity)

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

Updated 1 year ago by Sloan

Database – Form Section Info (form_section_entity)

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

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 2 years ago by Sloan

Database – 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 2 years ago by Cole

Database – Customer Credit Score Entity (customer_credit_score_entity)

This holds the database entities for customer credit score.

Updated 1 year ago by Sloan

Database – Linked loan info (linked_loan__entity)

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

Updated 1 year ago by Cole

Database – Email Template Entity (email_template_entity)

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

Updated 1 year ago by Sloan

Database – Loan Settings Entity (loan_settings_entity)

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

Updated 1 year ago by Sloan

Database – Holding Account AutoPay Info (holding_account_autopay_entity)

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

Updated 11 months ago by Sloan

Database – Holding Account Transaction Category (holding_account_transaction_category_entity)

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

Updated 1 year ago by Sloan

Database – Collector Queue Entity (collector_queue_entity)

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

Updated 1 year ago by Cole

Database – Loan Rule Applied (loan__rule_applied)

Loan Rule Applied. Column Data Type Column Info Value Note Other loan_id int(11) The ID for the loan linked to this table unsigned not null rule_applied_id int(11) The ID for the rule linked to this…

Updated 1 year ago by Megan Hill

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 1 year 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 5 months ago by Sloan

Database – Collector Queue Work Item Entity (collector_queue_work_item_entity)

This database article shows the collector queue work item entities.

Updated 10 months ago by Cole

Database – Loan Chargeoff Transaction (loan_chargeoff__transactions)

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

Updated 1 year ago by Sloan

Database – Checklist Entity (checklist_entity)

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

Updated 1 year ago by Cole

Database – Report Cache Metadata (report_cache)

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

Database – Cash Drawer Transaction Category Entity (cash_drawer_tx_category_entity)

This article shows the database entities for the cash drawer transaction category.

Updated 1 year ago by Cole

Database – Dashboard Widget Entity (dashboardwidget_entity)

This table shows database entities for dashboard widgets.

Updated 1 year ago by Sloan

Database – 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 2 years ago by Sloan

Database – Escrow Adjustment Entity (escrow_adjustment_entity)

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

Updated 1 year ago by Sloan

Database – Loan Funding (loan_funding_entity)

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

Updated 9 months ago by Sloan

Database – User Favorite Search Entity (user_favorite_search_entity)

This table holds information for favorite searches for users. Column Data Type Column Info Value Notes Other id int(11) The ID of the entity user_id int(11) The related user ID custom_search_id int(1…

Updated 1 year ago by Nate Christensen

Database – Collector Queue To Loan Map (collector_queue__loan)

Description. 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. Table Fields. Field Data Type Column Inf…

Updated 10 months ago by Brinley Bushman

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 2 years ago by Sloan

Database – 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 2 years ago by Sloan

Database – 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 2 years ago by Cole

Database – Credit Card Entity (credit_card_entity)

This article shows the database entities for credit cards.

Updated 1 year ago by Cole

Database – Dashboard Preferences (dashboardpreferences_entity)

This table shows the database entities for an agent users dashboard preferences.

Updated 1 year ago by Sloan

Database – 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

Database – Restriction Group Entry (restriction_group_entry_archive)

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

Updated 1 year ago by Sloan

Database – Defaults AutoPay (defaults_autopay)

Description. This table holds records of tenant-wide default options for new AutoPays. Table Fields. Field Data Type Column Info Value Notes id char(100) The id of the entity payment.methods.debit, p…

Updated 10 months ago by Brinley Bushman

Database – Pay Near Me Order Entity (pnm_order_entity)

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

Updated 1 year ago by Cole

Database – Cash Drawer Transaction Limits (source_company_cash_drawer_transaction_limits)

This table holds information on the transaction limits for your company's cash drawer.

Updated 1 year ago by Jackson Stone

Database – Payment Defaults (defaults_payments)

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

Updated 1 year ago by Sloan

Database – View Template to View Module Map (view_template__view_module)

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 2 years ago by Sloan

Database – Default Billing Template Entity (default_billing_template_entity)

This table holds the tenant-wide default options for billing templates.

Updated 1 year ago by Sloan

Database – Loan Customer Link Info (loan__customer)

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

Updated 1 year ago by Sloan

Database – Loan Stop/Resume Interest Entity (loan_stop_interest_date_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

Database – Comment Thread Topics (comment_thread_topics)

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

Updated 1 year ago by Cole

Database – Recurring Charge Entity (recurring_charge_entity)

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

Updated 1 year ago by Cole

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 2 years ago by Sloan

Database – Collateral Field Entity (collateral_field_entity)

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

Updated 1 year ago by Cole

Database – Credit Report Queue (credit_report_queue)

Description. This holds a queue for reports being generated to send to credit bureaus. Table Fields. Field Data Type Column Info Value Notes id int(11) The id of the entity entity_type varchar(100) T…

Updated 10 months ago by Cole

Database – Payment Portfolio Relations (payment__portfolio)

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

Database – Time Slot for Work Items (time_slot_entity)

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 2 years ago by Cole

Database – Rule Applied Settings - Loan Relations (loan__rule_applied_settings)

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

Updated 9 months ago by Sloan

Database – Loan Promise Info (loan_promise_entity)

Description. This table holds information for promises made on a loan. Column Data Type Column Info Value Notes id int(11) The ID of the entity loan_id int(11) The ID of the associated loan account s…

Updated 3 months ago by Sloan

Database – Secure Payments Processor Extender (mc_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 1 year ago by Sloan

Database – Result Notes (result__notes)

Description. 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 1 year ago by Sloan

Database – Preconfigured Loan and Sub-portfolio Relation (preconfigured_loan__sub_portfolio)

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

Updated 1 year ago by Sloan

Database – Sound Groups (sound_group_entity)

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 2 years ago by Sloan

Database – Loan Portfolio Relations (loan__portfolio)

Description. 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(1…

Updated 1 year ago by Sloan

Database – Rules Applied Settings Sub-Portfolio To Delete Relation (rule_applied_settings__sub_portfolio_to_delete)

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 2 years ago by Sloan

Database – Credit Category Entity (credit_category_entity)

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

Updated 1 year ago by Cole

Database – Rule Applied Amount Past Due - Loan relation (loan__rule_applied_apd_reset)

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

Updated 1 year ago by Sloan

Database – Custom payment Method Entity (custom_payment_method_entity)

This holds the database entities for custom payment method.

Updated 11 months ago by Cole

Database – Holding Account Category Info (holding_account_category_entity)

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

Updated 1 year ago by Sloan

Database – 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 2 years ago by Sloan

Database – Computation Field Entity (computation_field_entity)

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

Updated 1 year ago by Cole

Database – Source Company Entity (source_company_entity)

Description. Holds information for Source Companies. Table Values. Column Data Type Column Info Value Notes id int(11) The ID of the Source Company company_name varchar(255) The name of the Source Co…

Updated 9 months ago by Jackson Stone

Database – Customer Phone Entity (customer_phone_entity)

This article shows the database entities for customer phone number.

Updated 1 year ago by Sloan

Database – User Chart Settings (user_chart_settings_entity)

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 2 years ago by Cole

Database – Amount Past Due Adjustment (loan_apd_adjustment_entity)

This table holds information for Amount Past Due (APD) adjustments on loans.

Updated 1 year ago by Sloan

Database – Escrow Transaction Category (escrow_tx_category_entity)

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

Updated 1 year ago by Sloan

Database – Result Entity (result_entity)

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

Updated 1 year ago by Jackson Stone

Database – Linked Loan Option (linked_loan_option_entity)

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

Updated 1 year ago by Cole

Database – Preconfigured Loan Settings Entity (preconfigured_loan_settings_entity)

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

Updated 1 year ago by Sloan

Database – Rules Applied Stop Interest (rule_applied_stop_interest_entity)

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 2 years ago by Sloan

Database – Escrow Calculator (escrow_calculator_entity)

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

Updated 10 months ago by Sloan

Database – Customer Payment Method Entity (customer_payment_method_entity)

This article shows the customer payment method entities and how to create payment profiles in the API.

Updated 9 months ago by Sloan

Database – 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 2 years ago by Sloan

Database – Investment Portfolio (investment__portfolio)

Description. 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) Ass…

Updated 1 year ago by Sloan

Database – Loan Credit Entity (loan_credit_entity)

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

Updated 1 year ago by Sloan

Database – 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 2 years ago by Sloan

Database – Cash Drawer Transaction Reasons (source_company_labeling_cash_drawer_tx_reasons_entity)

Description. This table holds information about the different labels saved as reasons for cash drawer transactions. These labels are edited in the Source Company Tenant-Level Settings. Table Values.…

Updated 1 year ago by Jackson Stone

Database – Payment Reversed Transaction Snapshot (payment_reversed_tx_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

Database – Customer Document Entity (customer_document_entity)

This database holds entities for customer document.

Updated 1 year ago by Sloan

Database – Rule applied charge off - Loan Relations (loan__rule_applied_charge_off)

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

Updated 1 year ago by Sloan

Database – Loan Reverse Calculator Settings (loan_reverse_calc_settings)

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

Updated 1 year ago by Sloan

Database – GPS Link Info (gps_link_entity)

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

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 2 years ago by Sloan

Database – Wizard Group (wizard_group__wizard)

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 2 years 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 you're looking for almost any number or calculation setting used to create a loan, it will…

Updated 4 months ago by Sloan

Database – Comment Thread Comments (comment_thread_comments)

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

Updated 1 year ago by Cole

Database – Escrow Analysis Task Entity (escrow_analysis_task_entity)

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

Updated 1 year ago by Sloan

Database – Preconfigured Loan Portfolio Relation (preconfigured_loan__portfolio)

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

Updated 1 year ago by Sloan

Database – Notes Entity (note_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

Database – Rule Applied Entity (rule_applied_entity)

Rule Applied Entity. Column Data Type Column Info Value Note id int(11) The id for the rule unsigned not null name varchar(100) The name of the rule default null rule text The rule itself (a formula…

Updated 4 months ago by Megan Hill

Database – Custom Form Tool to Loan Map (custom_form_tool__loan)

This holds the database entities for custom form tool to loan map.

Updated 10 months ago by Brinley Bushman

Database – Rules Applied, Loan Settings Backup (rule_applied_loan_settings_entity_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 2 years ago by Sloan

Database – Loan Advancements (loan_advancement_entity)

Description. Holds information for loan advancements. We also have articles on how to log advancements with the LoanPro UI or through the API. Column Data Type Column Info Value Notes Other id int(11…

Updated 1 year ago by Sloan

Database – Customer Website FAQ Entry (faq_entry_entity)

This table shows the database entities for the customer website questions and answers.

Updated 4 months 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 – 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 – 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 1 year ago by Sloan

Database – Custom Onboarding Process Step Entity (custom_boarding_process_step_entity)

This holds the database entities for the custom onboarding process step.

Updated 1 year ago by Cole

Database – Link metadata (linked_info__entity)

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

Updated 1 year ago by Cole

Database – Custom Field Entity (custom_field)

This article holds the database entities for custom fields.

Updated 4 months ago by Cole

Database – Holding Account Archive Info (holding_account_archive_entity)

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

Updated 1 year ago by Sloan

Database – Tenant Checklist Entity (tenant_checklist_entity)

Holds checklists 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 4 months ago by Sloan

Database – 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 2 years ago by Sloan

Database – Source Company Document (source_company_document_entity)

Description. This table holds the values for Source Company Documents. Table Fields. Column Data Type Column Info Value Notes id int(11) The ID of the cash drawer. source_company_id int(11) The ID fo…

Updated 1 year ago by Jackson Stone

Database – Web Hook Delivery (web_hook_delivery_entity)

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

Updated 4 months ago by Jackson Stone

Database – Support Transaction (support_transaction_entity)

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 2 years ago by Sloan

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 1 year ago by Sloan

Database – Customer Status Entity (customer_status_entity)

This article shows the database entities for customer statuses.

Updated 1 year ago by Sloan

Database – 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 2 years ago by Sloan

Database – Notification Entity (notification_entity)

Description. This table holds records of notifications that have been sent to a user, and the status of the notification. Table Fields. Field Data Type Column Info Value Notes id int(11) The id of th…

Updated 10 months ago by Brinley Bushman

Database – Investment Position Entity (investment_position_entity)

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

Updated 1 year ago by Sloan

Database – Rules Applied, Bankruptcy (rule_applied_bankruptcy_entity)

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 2 years ago by Sloan

Database – Bracket Item Entity (bracket_item_entity)

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

Updated 1 year ago by Jackson Stone

Database – Restriction Group User Relation (restriction_group__user)

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 2 years ago by Sloan

Database – Loan Summary View Container Entity (loan_summary_view_container_entity)

Column Data Type Column Info Value Notes Other id int(11) ID of the entity name varchar(255) Name of the entity instance definition text Definition of the entity instance default tinyint(1) section_c…

Updated 4 months ago by Nate Christensen

Database – Escrow Subset Entity (escrow_subset_entity)

Description. 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) T…

Updated 1 year ago by Sloan

Database – Recurrent Charges on Loan Specific Settings (loan__recurrent_charge)

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 1 year ago by Sloan

Database – Base Variable (base_variable_entity)

Base variables are used as a base when setting a date through rules applied.

Updated 1 year ago by Jackson Stone

Database – Customer Employer Entity (customer_employer_entity)

This holds the database entities for customer employer.

Updated 1 year ago by Sloan

Database – Loan Sub Portfolio relations (loan__sub_portfolio)

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 4 months ago by Sloan

Database – Loan Active Time Transactions (loan_active_time_tx)

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

Updated 1 year ago by Sloan

Database – Investment Entity (investment_entity)

Description. 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/t…

Updated 1 year ago by Sloan

Database – Customer Login Attempts (customer_login_attempts)

This article holds database entities for customer login attempts.

Updated 1 year ago by Sloan

Database – Pre Configured Loan Entity (preconfigured_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 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 4 months ago by Sloan

Database – Custom Billing Theme Entity (custom_billing_theme_entity)

Description. 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) Enti…

Updated 1 year ago by Cole

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 11 months ago by Jackson Stone

Database – Collector Queue Question Entity (collector_queue_question_entity)

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

Updated 1 year ago by Cole

Database – Cash Drawer Entity (cash_drawer_entity)

Description. 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, se…

Updated 1 year ago by Cole

Database – 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 2 years ago by Cole

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 2 years ago by Sloan

Database – Custom Payment Type Entity (custom_payment_type_entity)

This holds the database entities for custom payment type.

Updated 3 months ago by Cole

Database – 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 2 years ago by Sloan

Database – Cash Drawer to Payment Method Map (cash_drawer__payment_method)

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

Updated 4 months ago by Cole

Database – Rules Applied Checklist Entity (rule_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 2 years ago by Sloan

Database – Category Collections (category_entity)

General. This article goes over the category collection entities in the API. Categories (category_entity). Column Data Type Column Info Value Notes id int(11) The id of the category you created title…

Updated 1 year ago by Megan Hill

Database – Rules Applied Settings Portfolio To Delete Relation (rule_applied_settings__portfolio_to_delete)

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 2 years ago by Sloan

Database – Portfolio entity (portfolio_entity)

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

Updated 1 year ago by Cole

Database – Loan Delinquency (loan_delinquency_entity)

Description. This table lists all the database columns for Loan Delinquencies. This lets you find information about delinquency on a loan — typically used to pull data on large quantities of loans. T…

Updated 1 month ago by Jackson Stone

Database – File attachment entity (file_attachment_entity)

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

Updated 1 year ago by Sloan

Database – System Notes Entity (system_note_entity)

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

Updated 7 months ago by Sloan

Database – Customer Social Profile Entity (customer_social_profile_entity)

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

Updated 4 months ago by Sloan

Database – Contract Signor Entity (contract_signer_entity)

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

Updated 4 months ago by Cole

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 2 years ago by Sloan

Database – TCN Queue Item Entity (tcn_queue_item_entity)

Description. This table holds records of TCN queue items. Table Fields. Column Data Type Column Info Value Notes id int(11) The id of the entity loan_id int(11) The id of the associated loan account…

Updated 10 months ago by Brinley Bushman

Database – Notification Category - Delivery Relation (notification_category__delivery)

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

Database – Customer Website Page Entity (page_entity)

This table holds database entities for the customer website page.

Updated 1 year ago by Sloan

Database – 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

Database – Loan To Admin Tool Map (admin_tool__loan)

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

Updated 10 months ago by Brinley Bushman

Database – 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 2 years ago by Sloan

Database – Bankruptcy Entity (bankruptcy_entity)

This table holds the information for loan bankruptcies.

Updated 11 months ago by Sloan

Database – Source Company Users (source_company__users)

Description. This is a mapping table to show the relationship between users and source companies. Table Values. Column Data Type Column Info Value Notes id int(11) The id of the record source_company…

Updated 1 year ago by Jackson Stone

Database – Custom Billing Template Entity (custom_billing_template_entity)

Description. 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) E…

Updated 1 year ago by Cole

Database – Data Import Entity (data_import_entity)

This table holds the data import entities.

Updated 1 year ago by Sloan

Database – 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

Database – Custom Form Section Entity (custom_form_section_entity)

This article holds the database entities for the custom form section.

Updated 1 year ago by Cole

Database – Loan Due Date Change (loan_duedate_change_entity)

Description. Holds information for due-date changes on a loan Column Data Type Column Info Value Notes id int(11) The ID of the due date change record entity_id int(11) ID of the associated entity en…

Updated 4 months ago by Jackson Stone

Database – 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 2 years ago by Sloan

Database – Portfolio Category Entity (portfolio_category_entity)

Description. 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(2…

Updated 1 year ago by Cole

Database – Search Indexing Error Log (search_index_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 2 years ago by Sloan

Database – Rules Applied, Account Tools (rule_applied_account_tools_entity)

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

Updated 4 months ago by Sloan

Database – 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

Database – Additional Payment Information (payment_info_entity)

This table holds additional information that is captured when payments are processed through Secure Payments.

Updated 1 year ago by Sloan

Database – Checklist item Entity (checklist_item_entity)

This database article shows the checklist item entities.

Updated 1 year ago by Cole

Database – Email Queue (email_queue)

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

Updated 1 year ago by Sloan

Database – Payment Sub Portfolio Relations (payment__sub_portfolio)

Description. 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) associa…

Updated 1 year ago by Sloan

Database – Rules Applied Settings Portfolio Relation (rule_applied_settings__portfolio)

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 2 years ago by Sloan

Database – User Search Settings (user_search_settings_entity)

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 2 years ago by Cole

Database – Company Profile (company_profile_entity)

This article shows the database entities for company profile.

Updated 6 months ago by Jackson Stone

Database – Loan Late Fee Buckets (loan_late_fee__buckets)

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

Updated 1 year ago by Sloan

Database – 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 2 years ago by Sloan

Database – Rules Applied Settings Sub-Portfolio Relation (rule_applied_settings__sub_portfolio)

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

Updated 1 year ago by Sloan

Database – Enhanced Funding (loan_funding_transaction_entity)

Description. This table holds information on transactions funding loans. Table Fields. Column Data Type Column Info Value Notes id int(10) The id of the loan funding transaction loan_id int(11) The i…

Updated 4 months ago by Jackson Stone

Database – 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 2 years ago by Sloan

Database – Notification Category (notification_category_entity)

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

Updated 1 year ago by Cole

Database – Bracket Entity (bracket_entity)

This table holds bracket information used in loan searches.

Updated 1 year ago by Cole

Database – Mail House Loan Old (mail_house_loan_old)

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 1 year ago by Sloan

Database – View Widget (view_widget_entity)

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 2 years ago by Sloan

Database – Document Section Entity (doc_section_entity)

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

Updated 1 year ago by Sloan

Database – 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 2 years ago by Sloan

Database – Loan Modification Info (loan_modification_entity)

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

Updated 1 year ago by Sloan

Database – 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 2 years ago by Sloan

Database – Action & Result Selection (action_result_selection_entity)

This table maps the relationship between actions and results selections.

Updated 1 year 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 1 year ago by Sloan

Database – Note Alert Rule (rules_note_alert_entity)

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

Updated 1 year ago by Sloan

Database – Custom Charge Type Entity (custom_charge_type_entity)

This article shows the database entities for custom charge types.

Updated 1 year ago by Cole

Database – Loan late fee bucket defaults (defaults_late_fee__buckets)

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

Updated 1 year 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 1 year ago by Sloan

Database – Dashboard Widget (dashboard__dashboardwidget)

This table shows the database entities for the dashboard widget.

Updated 1 year ago by Sloan

Database – Source Company Physical Check Account (source_company_physical_check_account_entity)

Description. This table holds information on a source company's physical checking account. Table Values. Column Data Type Column Info Value Notes Other id int(11) The ID of the entity, which must be…

Updated 1 year ago by Jackson Stone

Database – Rule applied Stop Interest - Loan Relations (loan__rule_applied_stop_interest)

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

Updated 1 year ago by Sloan

Database – Transaction Child Entity (transaction_child_entity)

Description. This table holds transaction information for loans with a child relationship to another loan. Column Data Type Column Info Value Examples id int(11) The system loan ID 911534 entity_type…

Updated 9 months ago by Sloan

Database – Note Category Info (note_category_entity)

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

Updated 1 year ago by Cole

Database – Custom Field Backup Entity (custom_field__entity_backup)

This article holds the database entities for custom field backup.

Updated 1 year ago by Sloan

Database – 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 2 years ago by Cole

Database – 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 2 years ago by Sloan

Database – Billing Tool Entity (billing_tool_entity)

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

Updated 4 months ago by Jackson Stone

Database – Default Billing Options Entity (default_billing_options_entity)

This table holds the tenant-wide default options for billing tools.

Updated 1 year ago by Sloan

Database – Funding Category (funding_category_entity)

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

Updated 1 year ago by Jackson Stone

Database – System Loan Defaults (defaults_system_loan)

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

Database – Action Entity (action_entity)

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

Updated 1 year ago by Jackson Stone

Database – 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

Database – Custom Form Entity (custom_form_entity)

Description. This holds information for custom form templates used to generate PDF forms about loans. For information on using custom forms in the API, see API - Custom Forms. Column Data Type Column…

Updated 1 year ago by Cole

Database – Checklist Item To Checklist Entity Map (checklist_item__entity)

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

Updated 1 year ago by Cole

Database – 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 2 years ago by Sloan

Database – Wizard Category (wizard_category_entity)

Shows information regarding Wizard Categories. Column Data Type Column Info Value Notes Other id int(11) The ID of the wizard category entity name char(100) Name of the wizard category active int(1)…

Updated 2 years ago by Cole

Database – Wizard Actions (wizard_actions_log_entity)

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 2 years ago by Sloan

Database – 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 2 years ago by Sloan

Database – Cash Drawer Transaction Entity (cash_drawer_transaction_entity)

This table holds a transaction line for a cash drawer.

Updated 1 year ago by Cole

Database – Loan Reverse Status Archive (loan_reverse_status_archive)

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

Updated 1 year ago by Sloan

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 4 months ago by Sloan

Database – Custom Search Entity (custom_search_entity)

This table holds custom search settings for agent users. Column Data Type Column Info Value Notes Other id int(11) The ID of the entity name varchar(255) The name of the entity instance access_type e…

Updated 1 year ago by Nate Christensen

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 1 year ago by Sloan

Database – Escrow Subset Options (escrow_subset_options_entity)

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 2 years ago by Sloan

Database – Checking account entity (checking_account_entity)

Description. This table holds Secure Payments bank account information. This entity stores the relationship between LoanPro accounts and Secure Payments accounts. Checking Account Entity. Column Data…

Updated 1 year ago by Cole

Database – Application Form (loan_application_form_entity)

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

Updated 1 year ago by Jackson Stone

Database – SBT Do Not Disturb Periods (sbt_dnd_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 2 years ago by Sloan

Database – 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 2 years ago by Sloan

Database – Rules to Category Relation (rule__category)

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 2 years ago by Sloan

Database – Investor status information (investor_status_entity)

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

Updated 1 year ago by Sloan

Database – Rule Category Entity (rule_category_entity)

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

Updated 1 year ago by Sloan

Database – 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

Database – Billing Tool to Loan Map (billing_tool__loan)

This article shows the database entities for the billing tool to the loan map.

Updated 1 year ago by Cole

Database – Flag Entity (flag_entity)

Description. Holds information for entity flags. Active flags are evaluated automatically and are set to true if the associated Clojure rule returns a truthy value when passed an entity. Otherwise, t…

Updated 1 year ago by Sloan

Database – Custom Field to Entity Map (custom_field__entity)

This article holds the database entities for custom field to entity map.

Updated 1 year ago by Cole

Database – Customer Website Testimonials (testimonial_entity)

This table shows the database entities for the customer website testimonials.

Updated 1 year ago by Cole

Database – Delivery Entity (delivery_entity)

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

Updated 1 month ago by Sloan

Database – Advancement Category Entity (advance_category_entity)

This article shows the database entities for the advancement category.

Updated 1 year ago by Cole

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 3 months ago by Sloan

Database – Wizards (wizard_entity)

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 2 years ago by Sloan

Database – Email Trigger entity (email_trigger_entity)

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

Updated 3 months ago by Sloan

Database – 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 2 years ago by Sloan

Database – Multiple Returns Entity (multiple_returns_entity)

Description. This table holds information for the multiple returns entity. Table Values. Column Data Type Column Info Value Notes Other id int(11) The id of the record name varchar(120) The name of t…

Updated 3 days ago by Jackson Stone

Database – Customer Payment Profile Information (payment_account_entity)

This article shows the database entities for customers payment profile information.

Updated 11 months ago by Jackson Stone

Database – Schedule Roll Template (schedule_roll_template_entity)

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 2 years ago by Sloan

Database – Tenant Settings (tenant_setting__entity)

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 2 years ago by Sloan

Database – Support Transaction Topic Relation (support_transaction__topic)

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 2 years ago by Sloan

Database – Custom Onboarding Process Entity (custom_boarding_process_entity)

This holds the database entities for the custom onboarding process.

Updated 1 year ago by Cole

Database – User Delivery Relation (user__delivery)

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 2 years ago by Cole

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 1 month ago by Darrin Wray

Database – 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 2 years ago by Sloan

Database – 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 2 years ago by Cole

Database – Holding Account Transaction (holding_account_transaction_entity)

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

Updated 1 year ago by Sloan

Database – Investment Sub Portfolio Relation (investment__sub_portfolio)

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

Updated 1 year ago by Sloan

Database – Credit Report History (credit_report_history)

Description. This holds records concerning generated reports to send to credit bureaus. Table Fields. Field Data Type Column Info Value Notes id int(11) The id of the entity entity_type varchar(100)…

Updated 10 months ago by Cole

Database – Rules Applied Settings (rule_applied_loan_settings_entity)

This table holds information for loan settings rules applied. These rules applied affect loan settings on loans. Column Data Type Column Info Value Notes id int(11) The id of the record; in this case…

Updated 1 year ago by Jackson Stone

Database – Custom Form Tool Entity (custom_form_tool_entity)

This holds the database entities for the custom form tool.

Updated 1 year ago by Cole

Database – User specific Loan Defaults (defaults_user_loan)

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

Database – 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 2 years ago by Sloan

Database - Mail House Loan (mail_house_loan)

Description. This table holds core mail house loan data, including IDs of associated entities and modification information. This is for the mail house tool. Table Fields. Field Data Type Column Info…

Updated 2 weeks ago by Brinley Bushman

Database – Interest Rate Adjustment (interest_rate_adjustment_entity)

General. This article goes over the interest rate adjustment collections in the API. Interest Rate Adjustment (interest_rate_adjustment_entity). Column Data Type Column Info Value Notes id int(11) Th…

Updated 1 year ago by Megan Hill

Database – Action and Results Mapping Table (action__result)

This article shows the database entities for action and results mapping table.

Updated 1 year ago by Sloan

Database – Action Notes Relationship Table (action__notes)

This table maps the relationship between actions and notes for those actions.

Updated 1 year ago by Sloan

Database – 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 2 years ago by Sloan

Database – Link Info (link_entity)

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

Database – Work Item - Question Relation (work_item__questions)

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 2 years ago by Sloan

Database – Rule Applied Rule Xref Entity (rule_applied_rule_xref_entity)

Rule Applied Rule Xref. Column Data Type Column Info Value Note Other id int(11) The ID for the entity unsigned not null rule_id int(11) The ID for the rule connected to this entity not null entity_t…

Updated 1 year ago by Megan Hill

Database – 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

Database – Rules Applied Due Date (rule_applied_duedate_entity)

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 2 years 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 1 year ago by Sloan

Database – Customer Main Table (customer_entity)

This article explains how to pull customer encrypted information from the API.

Updated 5 months ago by Sloan

Database – Loan SMS Queue Item Entity (loan_sms_queue_item_entity)

Description. This table holds records of a loan in an SMS queue. Table Fields. Field Data Type Column Info Value Notes id int(11) The id of the entity loan_id int(11) The id of the associated loan ac…

Updated 10 months ago by Brinley Bushman

Database – Notification Do Not Disturb Period Entity (notification_dnd_period_entity)

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

Updated 1 year ago by Cole

Database – 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 2 years ago by Sloan

Database – Loan Sub Status Entity (loan_sub_status_entity)

Description. 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 color char(32) rule t…

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

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 2 years ago by Sloan

Database – Escrow Transaction (escrow_transaction_entity)

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

Updated 1 year ago by Sloan

Database – 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 2 years ago by Sloan

Database – Rules Applied, Loan Setup (rule_applied_loans_setup_entity)

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 2 years ago by Sloan

Database – 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 2 years ago by Sloan

Database – Loan Interest Rate Change (loan_interest_rate_change_entity)

Description. This table holds information for interest rate changes on loans. Table Fields. Field Data Type Column Info Value Notes id int(11) This is the ID of the interest rate change. loan_id int(…

Updated 3 days ago by Nate Christensen

Powered by HelpDocs (opens in a new tab)