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 2 weeks ago by Jackson Stone

Database – Dashboard Entity (dashboard_entity)

This table shows database entities for agent dashboards.

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

Database – Curtailment Template Entity (curtailment_template_entity)

This article shows the database entities for curtailment templates.

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

Database – Data Dump Entity (data_dump_entity)

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

Updated 2 weeks 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 2 weeks 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 2 weeks 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 2 weeks 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 2 weeks 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 2 weeks 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 2 weeks 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 2 weeks 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 2 weeks 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 2 weeks 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 2 weeks 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 11 months 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 1 year 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 11 months 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 11 months 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 1 year 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 11 months 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 11 months 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 8 months 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 7 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 2 weeks 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 2 weeks ago by Sloan

Database – Address Entity (address_entity)

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

Updated 9 months 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 11 months 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 2 weeks 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 11 months 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 11 months 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 1 year ago by Sloan

Database – Charges Table (charge_entity)

This database article shows the entities for the charges table.

Updated 8 months 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 11 months ago by Sloan

Database – Action & Result Note (action_result_note_entity)

This is the database article for action and results entities.

Updated 8 months 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 1 month 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 11 months ago by Cole

Database – Default Billing Theme Entity (default_billing_theme_entity)

This table holds tenant-wide options for billing themes.

Updated 8 months 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 8 months 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 11 months 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 11 months 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 11 months 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 11 months 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 – 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

Database – Customer Credit Score Entity (customer_credit_score_entity)

This holds the database entities for customer credit score.

Updated 8 months 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 11 months 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 11 months 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 11 months 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 7 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 11 months 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 11 months 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 11 months 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 11 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 1 month 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 6 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 11 months 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 11 months 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 11 months 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 8 months ago by Cole

Database – Dashboard Widget Entity (dashboardwidget_entity)

This table shows database entities for dashboard widgets.

Updated 8 months 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 1 year 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 11 months 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 5 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 6 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 1 year 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 1 year 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 1 year ago by Cole

Database – Credit Card Entity (credit_card_entity)

This article shows the database entities for credit cards.

Updated 8 months ago by Cole

Database – Dashboard Preferences (dashboardpreferences_entity)

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

Updated 8 months 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 11 months 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 11 months 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 6 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 11 months 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 9 months 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 11 months 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 1 year ago by Sloan

Database – Default Billing Template Entity (default_billing_template_entity)

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

Updated 8 months 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 11 months 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 11 months 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 11 months 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 11 months 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 1 year 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 11 months 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 6 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 11 months 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 1 year 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 5 months ago by Sloan

Database – Loan Promise Info (loan_promise_entity)

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

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

Database – Custom payment Method Entity (custom_payment_method_entity)

This holds the database entities for custom payment method.

Updated 7 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 11 months 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 1 year 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 11 months 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 5 months ago by Jackson Stone

Database – Customer Phone Entity (customer_phone_entity)

This article shows the database entities for customer phone number.

Updated 8 months 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 1 year 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 8 months 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 11 months 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 8 months 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 11 months 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 11 months 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 1 year 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 6 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 5 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 1 year 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 11 months 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 11 months 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 1 year 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 11 months 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 11 months ago by Sloan

Database – Customer Document Entity (customer_document_entity)

This database holds entities for customer document.

Updated 8 months 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 11 months 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 11 months 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 11 months 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 – 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 1 year 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 2 weeks 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 11 months 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 11 months 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 11 months 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 11 months 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 1 week 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 6 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 1 year 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 11 months 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 2 weeks 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 11 months 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 11 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 11 months 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 8 months 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 11 months ago by Cole

Database – Custom Field Entity (custom_field)

This article holds the database entities for custom fields.

Updated 2 weeks 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 11 months 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 1 week 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 1 year 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 11 months 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 1 week 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 1 year 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 11 months ago by Sloan

Database – Customer Status Entity (customer_status_entity)

This article shows the database entities for customer statuses.

Updated 8 months 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 1 year 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 6 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 11 months 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 1 year 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 9 months 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 1 year 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 1 week 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 11 months 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 11 months ago by Sloan

Database – Base Variable (base_variable_entity)

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

Updated 9 months ago by Jackson Stone

Database – Customer Employer Entity (customer_employer_entity)

This holds the database entities for customer employer.

Updated 8 months 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 1 week 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 11 months 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 11 months ago by Sloan

Database – Customer Login Attempts (customer_login_attempts)

This article holds database entities for customer login attempts.

Updated 8 months 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 9 months 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 week 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 11 months 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 7 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 11 months 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 11 months 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 1 year 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 1 year ago by Sloan

Database – Custom Payment Type Entity (custom_payment_type_entity)

This holds the database entities for custom payment type.

Updated 8 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 1 year 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 1 week 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 1 year 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 11 months 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 1 year 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 11 months 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 week 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 11 months 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 3 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 1 week 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 1 week 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 1 year 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 6 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 11 months ago by Cole

Database – Customer Website Page Entity (page_entity)

This table holds database entities for the customer website page.

Updated 8 months 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 11 months 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 6 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 1 year ago by Sloan

Database – Bankruptcy Entity (bankruptcy_entity)

This table holds the information for loan bankruptcies.

Updated 7 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 11 months 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 11 months ago by Cole

Database – Data Import Entity (data_import_entity)

This table holds the data import entities.

Updated 8 months 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 11 months ago by Sloan

Database – Custom Form Section Entity (custom_form_section_entity)

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

Updated 8 months 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 5 days 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 1 year 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 11 months 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 1 year 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 5 days 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 11 months 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 8 months ago by Sloan

Database – Checklist item Entity (checklist_item_entity)

This database article shows the checklist item entities.

Updated 8 months 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 11 months 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 11 months 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 1 year 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 1 year ago by Cole

Database – Company Profile (company_profile_entity)

This article shows the database entities for company profile.

Updated 2 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 11 months 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 1 year 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 11 months 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 3 days 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 1 year 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 11 months ago by Cole

Database – Bracket Entity (bracket_entity)

This table holds bracket information used in loan searches.

Updated 8 months 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 9 months 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 1 year 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 11 months 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 1 year 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 11 months 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 1 year ago by Sloan

Database – Action & Result Selection (action_result_selection_entity)

This table maps the relationship between actions and results selections.

Updated 8 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 11 months 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 11 months ago by Sloan

Database – Custom Charge Type Entity (custom_charge_type_entity)

This article shows the database entities for custom charge types.

Updated 8 months 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 11 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 11 months ago by Sloan

Database – Dashboard Widget (dashboard__dashboardwidget)

This table shows the database entities for the dashboard widget.

Updated 8 months 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 11 months 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 11 months 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 5 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 11 months ago by Cole

Database – Custom Field Backup Entity (custom_field__entity_backup)

This article holds the database entities for custom field backup.

Updated 8 months 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 1 year 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 1 year 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 2 days 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 8 months 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 11 months 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 9 months 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 9 months 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 11 months 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 8 months 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 11 months 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 1 year 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 1 year 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 1 year 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 1 year ago by Sloan

Database – Cash Drawer Transaction Entity (cash_drawer_transaction_entity)

This table holds a transaction line for a cash drawer.

Updated 8 months 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 11 months 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 2 days 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 11 months 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 1 year 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 8 months 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 9 months 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 1 year 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 1 year 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 1 year 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 11 months 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 11 months 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 11 months 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 8 months 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 11 months 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 8 months ago by Cole

Database – Customer Website Testimonials (testimonial_entity)

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

Updated 8 months ago by Cole

Database – Delivery Entity (delivery_entity)

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

Updated 11 months ago by Sloan

Database – Advancement Category Entity (advance_category_entity)

This article shows the database entities for the advancement category.

Updated 8 months 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 11 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 1 year 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 recepients. Column Data Type Column Info Value Notes Other id int(11) The id of t…

Updated 11 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 1 year 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(100) The name of t…

Updated 11 months ago by Jackson Stone

Database – Customer Payment Profile Information (payment_account_entity)

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

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

Database – Custom Onboarding Process Entity (custom_boarding_process_entity)

This holds the database entities for the custom onboarding process.

Updated 8 months 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 1 year 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 1 year 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 1 year 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 11 months 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 11 months 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 6 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 8 months ago by Jackson Stone

Database – Custom Form Tool Entity (custom_form_tool_entity)

This holds the database entities for the custom form tool.

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

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

Database – Action Notes Relationship Table (action__notes)

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

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

Database – Customer Main Table (customer_entity)

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

Updated 1 month 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 6 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 11 months 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 1 year 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 11 months 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 11 months 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 1 year 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 11 months 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 1 year 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 1 year 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 1 year ago by Sloan

Powered by HelpDocs (opens in a new tab)