Database Tables

Introduction

This is our parent database article. Here, we list all database tables. However, this article and the articles about the individual database tables will only be relevant to customers who have access to a read-only copy of their company database. To purchase dedicated database hardware and gain database access, please contact our sales team at sales@loanpro.io.

Primary Tables

Some database tables hold important information, while others map relationships between tables. This section will list the tables that are referenced most by database users and give a brief list of the information they contain.

• loan_entity - This table is the primary table for loans. It doesn't hold the specifics of a loan contract, but it contains the IDs for loans and loan-associated entities.
• loan_setup_entity - This table contains the primary loan terms. The following is included:
  • Loan Amount
  • Interest Rate
  • Contract Date
  • First Payment Date
  • Loan Term
  • Payment Amount
  • Underwriting Fee
  • APR
  • Grace Period
  • Late Fee
• loan_tx - This table shows the transactions that are currently applying to the loan.
  • Payments
  • Charges
  • Credits
  • Advancements
  • Payment Date Adjustments
  • Suspend/Resume Interest
• loan_status_archive - This table shows a daily snapshot of the status of each loan. This includes things such as the following:
  • Principal Balance
  • Amount Due
  • Due Breakdown
  • Payoff Amount
  • Loan Age
  • Escrow Balance
• payment_entity - This table shows payments that have been made on loans including things like payment amounts and apply dates.
• charge_entity - This table shows fees assessed on loans including things like dates, amounts, amount paid, etc.
• loan_credit_entity - This table shows credits that have been logged for loans, including things like amounts and apply dates.
• loan_advancement_entity - This table shows advancements that have been issued for loans including things like amounts and apply dates.
• escrow_adjustment_entity - This table shows escrow adjustments on loans.

Active Tables

These are the tables that are currently active in the database.

• action__notes
• action__result
• action_entity
• action_result_note_entity
• action_result_selection_entity
• address_entity - Address Entity
• admin_tool__loan - Loan To Admin Tool Map
• admin_tool_entity - Admin Tool
• advance_category_entity - Advancement Category Entity
• bankruptcy_entity
• base_variable_entity
• billing_tool__loan - Billing Tool to Loan Map
• billing_tool_entity - Billing Tool Entity
• bracket_entity - Bracket Entity
• bracket_item_entity - Bracket Item Entity
• cash_drawer__payment_method - Cash Drawer to Payment Method Map
• cash_drawer_entity - Cash Drawer Entity
• cash_drawer_transaction_entity - Cash Drawer Transaction Entity
• cash_drawer_tx_category_entity - Cash Drawer Transaction Category Entity
• charge_entity - Charge Entity
• checking_account_entity - Checking Account Entity
• checklist_entity - Checklist Entity
• checklist_item__entity - Checklist Item To Checklist Entity Map
• checklist_item_entity - Checklist Item Entity
• collateral_entity - Collateral Entity
• collateral_field_entity - Collateral Field Entity
• collector_queue__loan - Collector Queue To Loan Map
• collector_queue_entity - Collector Queue Entity
• collector_queue_question_entity - Collector Queue Question Entity
• collector_queue_work_item_entity - Collector Queue Work Item Entity
• company_directory_entity
• company_profile_entity
• comment_thread_comments - Comment Thread Comments
• comment_thread_topics - Comment Thread Topics
• computation_field_entity - Computation Field Entity
• contract_signer_entity - Contract Signer Entity
• credit_card_entity - Credit Card Entity
• credit_category_entity - Credit Category Entity
• credit_report_history - Credit Report History
• credit_report_queue - Credit Report Queue
• curtailment_template_entity - Curtailment Template Entity
• curtailment_template_lines_entity - Curtailment Template Lines Entity
• custom_billing_template_entity - Custom Billing Template Entity
• custom_billing_theme_entity - Custom Billing Theme Entity
• custom_boarding_process_entity - Custom Onboarding Process Entity
• custom_boarding_process_step_entity - Custom Onboarding Process Step Entity
• custom_charge_type_entity - Custom Charge Type Entity
• custom_field - Custom Field Entity
• custom_field__entity - Custom Field to Entity Map
• custom_field__entity_backup
• custom_form_entity - Custom Form Entity
• custom_form_section_entity - Custom Form Section Entity
• custom_form_tool__loan - Custom Form Tool to Loan Map
• custom_form_tool_entity - Custom Form Tool Entity
• custom_payment_method_entity - Custom Payment Method Entity
• custom_payment_type_entity - Custom Payment Type Entity
• customer_credit_score_entity - Customer Credit Score Entity
• customer_document_entity - Customer Document Entity
• customer_employer_entity - Customer Employer Entity
• customer_entity - Customer Entity
• customer_login_attempts - Customer Login Attempts
• customer_payment_method_entity - Customer Payment Method Entity
• customer_phone_entity - Customer Phone Entity
• customer_reference_entity - Customer Reference Entity
• customer_social_profile_entity - Customer Social Profile Entity
• customer_status_entity - Customer Status Entity
• dashboard__dashboardwidget
• dashboard_entity
• dashboardpreferences_entity
• dashboardwidget_entity
• data_dump_entity - Data Dump Entity
• data_import_entity - Data Import Entity
• default_billing_options_entity - Default Billing Options Entity
• default_billing_template_entity - Default Billing Template Entity
• default_billing_theme_entity - Default Billing Theme Entity
• defaults_autopay - Defaults Autopay
• defaults_charges - Default Charges
• defaults_escrow_calculator - Defaults Escrow Calculator
• defaults_late_fee__buckets - Loan late fee bucket defaults
• defaults_payments - Payment Defaults
• defaults_system_loan - System Loan Defaults
• defaults_user_loan - User specific Loan Defaults
• deletion_audit
• delivery_entity - Delivery Entity
• disbursement_entity - Disbursement Entity
• doc_section_entity - Document Section Entity
• email_delivery_entity - Email Delivery Entity
• email_queue - Email Queue
• email_template_entity - Email Template Entity
• email_tool__loan - Email Tool - Loan Association
• email_tool_entity - Email Tool Entity
• email_trigger_entity - Email Trigger entity
• escrow__transactions - Escrow Transaction Metadata
• escrow_adjustment_entity - Escrow Adjustment Entity
• escrow_analysis_process_entity - Escrow Analysis Process
• escrow_analysis_task_entity - Escrow Analysis Task Entity
• escrow_calculator_entity - Escrow calculator
• escrow_subset_entity - Escrow Subset Entity
• escrow_subset_options_entity - Escrow Subset Options
• escrow_transaction_entity - Escrow Transaction
• escrow_tx_category_entity - Escrow Transaction Category
• faq_entry_entity - Customer Website FAQ Entry
• file_attachment_entity - File attachment entity
• flag_entity - Flag Entity
• flag_status_archive - Flag Status Archive
• form_section_entity - Form Section Info
• funding_category_entity - Funding Category
• gps_link_entity - GPS Link Info
• holding_account__investor - Holding Account Investor Relations Info
• holding_account_archive_entity - Holding Account Archive Info
• holding_account_autopay_entity - Holding Account - Autopay Info
• holding_account_category_entity - Holding Account Category Info
• holding_account_settings_entity - Holding account settings entity
• holding_account_status_entity - Holding Account status entity
• holding_account_sub_status_entity - Holding Account Sub Status Entity
• holding_account_transaction_category_entity - Holding Account Transaction Category
• holding_account_transaction_entity - Holding Account Transaction
• homepage_image_entity - Customer website hompage image info
• investment__portfolio - Investment Portfolio
• investment__sub_portfolio - Investment Sub Portfolio Relation
• investment_document_entity - Investment Document Entity
• investment_entity - Investment Entity
• investment_position_entity - Investment Position Entity
• investor_document_entity - Investor document entity
• investor_entity
• investor_status_entity - Investor status information
• iprestriction_entity - IP Restrictions
• iprestriction_entry_entity - IP Restriction Entry
• link_entity - Link Info
• linked_info__entity - Link metadata
• linked_loan__entity - Linked loan info
• linked_loan_option_entity - Linked loan option
• loan__customer - Loan Customer Link Info
• loan__portfolio - Loan Portfolio Relations
• loan__recurrent_charge - Recurrent Charges (Loan Specific Settings)
• loan__rule_applied_account_tools
• loan__rule_applied_apd_reset - Rule Applied Amount Past Due - Loan relation
• loan__rule_applied_autopay
• loan__rule_applied_bankruptcy
• loan__rule_applied_charge_off - Rule applied charge off - Loan Relations
• loan__rule_applied_checklist - Rule applied checklist - Loan Relations
• loan__rule_applied_customer_tools
• loan__rule_applied_duedate - Rule applied Due Date - Loan Relations
• loan__rule_applied_loan_setup
• loan__rule_applied_settings - Rule applied Settings - Loan Relations
• loan__rule_applied_stop_interest - Rule applied Stop Interest - Loan Relations
• loan__sub_portfolio - Loan Sub Portfolio relations
• loan_active_time_tx - Loan Active Time Transactions
• loan_advancement_entity - Loan Advancements
• loan_apd_adjustment_entity - Amount Past Due Adjustment
• loan_application_form_entity
• loan_autopay_entity - Loan AutoPay entity
• loan_charge_seq
• loan_chargeoff__transactions - Loan Chargeoff Transaction
• loan_chargeoff_entity - Loan Chargeoff Entity
• loan_child__entity
• loan_credit_entity - Loan Credit Entity
• loan_curtail_date_entity - Loan Curtailment Date Entity
• loan_delinquecy_entity - Loan Deqlinquency History
• loan_document_entity - Loan Document Entity
• loan_dpd_adjustment_entity - Loan Days Past Due Adjustment Entity
• loan_duedate_change_entity - Loan Due Date Change
• loan_entity - Loan Entity
• loan_funding_entity - Loan Funding
• loan_funding_transaction_entity - Enhanced Funding
• loan_insurance_entity - Loan Insurance Info
• loan_late_fee__buckets - Loan Late Fee Buckets
• loan_lock
• loan_modification_entity - Loan Modification Info
• loan_payment_seq
• loan_promise_entity - Loan Promise info
• loan_reverse_calc_settings - Loan Reverse Calculator Settings
• loan_reverse_status_archive - Loan Reverse Status Archive
• loan_schedule_roll_entity - Loan Schedule Role Entity
• loan_settings_entity - Loan Settings Entity
• loan_setup_entity - Loan Setup Entity
• loan_sms_queue_item_entity - Loan SMS Queue Item Entity
• loan_status_archive - Loan Status Archive
• loan_status_entity - Loan Status Entity
• loan_stop_interest_date_entity - Loan Stop/Resume Interest Entity
• loan_sub_status_entity - Loan Sub Status Entity
• loan_tx - Loan Transaction Entity
• mail_house_delivery_entity
• mail_house_entity
• mail_house_loan
• mail_house_tool_entity
• mc_processor_extender - PCI Wallet Processor Extender
• merchant_processor_group__item_entity
• merchant_processor_group_entity - Merchant Processor Group Entity
• multiple_returns_entity - Muliple Returns Entity
• my_applications_setting_entity
• my_loans_setting_entity
• note_category_entity - Note Category Info
• note_entity - Notes Entity
• notification_category__delivery - Notification Category - Delivery Relation
• notification_category_entity - Notification Category
• notification_dnd_period_entity - Notification Do Not Disturb Period Entity
• notification_entity - Notification Entity
• page_entity - Customer Website Page Entity
• payment__portfolio - Payment Portfolio Relations
• payment__sub_portfolio - Payment Sub portfolio Relations
• payment_account_entity - Payment Account Entity
• payment_entity - Payment Entity
• payment_info_entity - Payment Metadata Entity
• payment_reversed_tx_snapshot - Payment Reversed Transaction Snapshot
• pnm_order_entity - Pay Near Me Order Entity
• portfolio_category_entity - Portfolio Category Entity
• portfolio_entity - Portfolio entity
• preconfigured_loan__portfolio - Pre configured loan Portfolio Relation
• preconfigured_loan__sub_portfolio - Preconfigured loan and sub portfolio relation
• preconfigured_loan_entity - Pre Configured loan entity
• preconfigured_loan_settings_entity - Preconfigured loan settings entity
• product_autopay_default
• quick_note_entity - Quick Note entity
• recurring_charge_entity - Recurring Charge Entity
• report_cache - Report Cache Metadata
• restriction_group_entry_archive
• restriction_group_entry_entity
• result__notes
• result_entity
• rule__category - Rules to Category Relation
• rule_applied_account_tools_entity
• rule_applied_apd_reset_entity - Rules Applied APD Reset Entity
• rule_applied_autopay_entity
• rule_applied_bankruptcy_entity
• rule_applied_charge_off_entity - Rules Applied Charge Off Entity
• rule_applied_checklist_entity - Rules Applied Checklist Entity
• rule_applied_customer_tools_entity
• rule_applied_duedate_entity - Rules Applied Due Date
• rule_applied_loan_settings
• rule_applied_loan_settings_entity - Rules Applied Settings
• rule_applied_loan_settings_entity_backup
• rule_applied_loans_setup_entity
• rule_applied_settings__portfolio - Rules Applied Settings Portfolio Relation
• rule_applied_settings__portfolio_to_delete - Rules Applied Settings Portfolio To Delete Relation
• rule_applied_settings__sub_portfolio - Rules Applied Settings Sub-Portfolio Relation
• rule_applied_settings__sub_portfolio_to_delete - Rules Applied Settings Sub-Portfolio To Delete Relation
• rule_applied_stop_interest_entity - Rules Applied Stop Interest
• rule_category_entity - Rule Category Entity
• rule_entity - Rule Entity
• rules_note_alert_entity
• saved_search_entity - Saved search entity
• sbt_dnd_periods - SBT Do Not Disturb Periods
• sbt_message_log - SBT Message Log
• sbt_template_mapping - SBT template mapping
• schedule_roll_template_entity - Schedule Roll Template
• schedule_template_lines_entity - Schedule template lines entity
• scheduled_action_entity - Scheduled Action Entity
• scheduled_report_entity - Scheduled Report Entity
• search_restriction_group_entity - Search Restriction Group Entity
• search_restriction_setting_entity - Search Restriction Setting
• shortcut_set_entity - Shortcut Set Entity
• sms_delivery_entity - SMS delivery entity
• sms_trigger_entity - SMS trigger Entity
• sound_group_entity
• sound_group_item_entity - Sound Group Item Entity
• source_company_entity - Source Company Entity
• source_company__users - Source Company Users
• source_company_cash_drawer_transaction_limits - Cash Drawer Transaction Limits
• source_company_document_entity - Source Company Documents
• source_company_labeling_cash_drawer_tx_reasons_entity - Cash Drawer Transactions Reasons
• source_company_physical_check_account_entity - Source Company Physical Check Account
• special_report_entity - Special Report Entity
• stoplight_entity - Stoplight Entity
• sub_portfolio_entity - Sub Portfolio Entity
• support_transaction__topic - Support Transaction - Topic Relation
• support_transaction_entity - Support Transaction
• system_note_entity - System Notes Entity
• tcn_campaign_entity - TCN Campaign Entity
• tcn_queue_item_entity - TCN Queue Item Entity
• tenant_bulk_purchase_entity - Tenant Bulk Purchase Entity
• tenant_checklist_category_entity - Tenant Checklist Category Entity
• tenant_checklist_entity - Tenant Checklist Entity
• tenant_plugins_contract_entity - Tenant Plugins Contract Entity
• tenant_setting__entity - Tennant Settings
• testimonial_entity - Customer Website Testimonials
• topic_entity - Topic Entity
• transaction_child_entity
• transaction_entity - Transaction Entity
• user__delivery - User Delivery Relation
• user_chart_settings_entity - User Chart Settings
• user_search_settings_entity - User Search Settings
• user_tenant_configuration - User Tenant Configuration
• vendor_entity - Vendor Entity
• view_module_entity - View Module
• view_template__view_module - View Template to View Module Map
• view_template_entity - View Template Entity
• view_widget_entity - View Widget
• web_delivery_entity - Web Delivery Entity
• web_hook_delivery_entity
• wizard_actions_log_entity
• wizard_category_entity
• wizard_entity
• wizard_group__wizard
• wizard_group_entity
• wizard_process_validation
• wizard_step_entity
• wizard_step_item
• wizard_step_video
• work_item__questions - Work Item - Question Relation

Deprecated Tables

The following tables have been deprecated.

• ach_return_code_action_entity - ACH Return Code Action Entity
• bank_account_entity - Bank Account Entity
• collection - Collection
• collection_item - Collection Item
• credit_breakdown_report - Credit Breakdown Report
• escrow_subset_options_entity_backup - Escrow Subset Options Entity - Backup
• investor_entity - Investor Information
• loan_delinquency_history_entity - Loan Delinquency History
• loan_payment_seq - Loan Payment Sequence
• lockbox_settings_entity - Lockbox Converter Settings
• my_applications_setting_entity - Settings for "My Applications"
• my_loans_setting_entity - Settings for "My Loans"
• restriction_group__user - Restriction Group User Relation
• restriction_group_entity - Restriction Group Entity
• sample_entity - A sample of basic entity tables
• schema_version - Schema Version
• search_index_error_log - Search indexing error log
• security_group - Security Group
• security_group__user - Security Group User
• tenant_backup_log_entity - Tenant Backup Logs
• tenant_pricing_tier_entity - Tenant Pricing Tier
• time_slot_entity - Time Slot for work items

Tables by Category

These are the same active tables from above, but here we have categorized them.