Database Tables

General

This is the parent database article, which shows all the database tables. This article and the articles about the individual database tables will only be relevant to customers who have access to a read-only copy of their company database. To purchase dedicated database hardware and gain database access, contact Simnang Sales at sales@simnang.com.

Primary Tables

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

Active Tables

Deprecated Tables

Catagorized Tables

Loan

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_delinquency_history_entity - Loan Delinquency 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_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

my_applications_setting_entity

my_loans_setting_entity

Customer

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

Transaction

custom_payment_method_entity - Custom Payment Method Entity

custom_payment_type_entity - Custom Payment Type 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

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

loan_tx - Loan Transaction Entity

mc_processor_extender - PCI Wallet Processor Extender

merchant_processor_group__item_entity

merchant_processor_group_entity - Merchant Processor Group 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

transaction_child_entity

transaction_entity - Transaction Entity

Tenant

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

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

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

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

gps_link_entity - GPS Link Info

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

lockbox_settings_entity - Lockbox Converter Settings

mail_house_delivery_entity

mail_house_entity

mail_house_loan

mail_house_tool_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

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

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

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

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


How did we do?


Powered by HelpDocs (opens in a new tab)