Database

Read-Only Database

These articles are only applicable to customers who have direct access to a read-only copy of their LoanPro database.

2 articles by 1 author

Database Tables

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

Updated 1 week ago by Sloan

Database – A sample of basic entity tables (sample_entity)

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

Updated 3 months ago by Sloan

Database – ACH Return Code Action Entity (ach_return_code_action_entity)

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

Updated 3 months ago by Cole

Database – Action & Result Note (action_result_note_entity)

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

Updated 3 months ago by Sloan

Database – Action & Result Selection (action_result_selection_entity)

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

Updated 3 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 functionality. Actions and Results are a type of uniform note that can be easily searche…

Updated 3 months ago by Sloan

Database – Action Notes Relationship Table (action__notes)

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

Updated 3 months ago by Sloan

Database – Action and Results Mapping Table (action__result)

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

Updated 3 months ago by Sloan

Database – Additional Payment Information (payment_info_entity)

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

Updated 3 months ago by Sloan

Database – Address Entity (address_entity)

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

Updated 3 months ago by Cole

Database – Admin Tool (admin_tool_entity)

This holds the information for current and past loan admin tools in the system. For information about loan admin tools, see Loan Admin Tools. Column Data Type Column Info Value Notes Other id INT(10)…

Updated 3 months ago by Cole

Database – Advancement Category Entity (advance_category_entity)

This holds category information for advancements on a loan. This allows classification of advancements upon application. Only active, non-deleted categories can be used when applying an advancement.…

Updated 3 months ago by Cole

Database – Amount Past Due Adjustment (loan_apd_adjustment_entity)

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

Updated 3 months ago by Sloan

Database – Application Form (loan_application_form_entity)

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

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

Database – Bank Account Entity (bank_account_entity)

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

Updated 3 months ago by Cole

Database – Bankruptcy Entity (bankruptcy_entity)

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

Updated 3 months ago by Sloan

Database – Base Variable (base_variable_entity)

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

Updated 3 months ago by Sloan

Database – Billing Tool Entity (billing_tool_entity)

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

Updated 3 months ago by Cole

Database – Billing Tool to Loan Map (billing_tool__loan)

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

Updated 3 months ago by Cole

Database – Bracket Entity (bracket_entity)

This holds bracket information used in loan searches. Each bracket entity falls in a category. The ID and parent ID are pre-defined constants from the API. Bracket item entities hold the information…

Updated 3 months ago by Cole

Database – Bracket Item Entity (bracket_item_entity)

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

Updated 3 months ago by Cole

Database – Cash Drawer Entity (cash_drawer_entity)

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

Updated 3 months ago by Cole

Database – Cash Drawer Transaction Category Entity (cash_drawer_tx_category_entity)

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

Updated 3 months ago by Cole

Database – Cash Drawer Transaction Entity (cash_drawer_transaction_entity)

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

Updated 3 months ago by Cole

Database – Cash Drawer Transaction Limits (source_company_cash_drawer_transaction_limits)

Description. This table holds information on the transaction limits for your company's cash drawer. Adding a transaction limit offers control over how large a transaction from the cash drawer can be.…

Updated 2 months ago by Jackson Stone

Database – Cash Drawer to Payment Method Map (cash_drawer__payment_method)

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

Updated 3 months ago by Cole

Database – Charges Table (charge_entity)

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

Updated 3 months ago by Sloan

Database – Checking account entity (checking_account_entity)

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

Updated 3 months ago by Cole

Database – Checklist Entity (checklist_entity)

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

Updated 3 months ago by Cole

Database – Checklist Item To Checklist Entity Map (checklist_item__entity)

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

Updated 3 months ago by Cole

Database – Checklist item Entity (checklist_item_entity)

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

Updated 3 months ago by Cole

Database – Collateral Entity (collateral_entity)

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

Updated 3 months ago by Cole

Database – Collateral Field Entity (collateral_field_entity)

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

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

Database – Collection Item (collection_item)

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

Updated 3 months ago by Cole

Database – Collector Queue Entity (collector_queue_entity)

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

Updated 3 months ago by Cole

Database – Collector Queue Question Entity (collector_queue_question_entity)

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

Updated 3 months ago by Cole

Database – Collector Queue To Loan Map (collector_queue__loan)

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

Updated 3 months ago by Cole

Database – Collector Queue Work Item Entity (collector_queue_work_item_entity)

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

Updated 3 months ago by Cole

Database – Comment Thread Comments (comment_thread_comments)

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

Updated 3 months ago by Cole

Database – Comment Thread Topics (comment_thread_topics)

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

Updated 3 months ago by Cole

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

Database – Company Profile (company_profile_entity)

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

Updated 3 months ago by Sloan

Database – Computation Field Entity (computation_field_entity)

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

Updated 3 months ago by Cole

Database – Contract Signor Entity (contract_signer_entity)

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

Updated 3 months ago by Cole

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

Database – Credit Card Entity (credit_card_entity)

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

Updated 3 months ago by Cole

Database – Credit Category Entity (credit_category_entity)

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

Updated 3 months ago by Cole

Database – Credit Report History (credit_report_history)

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

Updated 3 months ago by Cole

Database – Credit Report Queue (credit_report_queue)

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

Updated 3 months ago by Cole

Database – Curtailment Template Entity (curtailment_template_entity)

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

Updated 3 months ago by Cole

Database – Curtailment Template Lines Entity (curtailment_template_lines_entity)

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

Updated 3 months ago by Cole

Database – Custom Billing Template Entity (custom_billing_template_entity)

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

Updated 3 months ago by Cole

Database – Custom Billing Theme Entity (custom_billing_theme_entity)

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

Updated 3 months ago by Cole

Database – Custom Charge Type Entity (custom_charge_type_entity)

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

Updated 3 months ago by Cole

Database – Custom Field Backup Entity (custom_field__entity_backup)

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

Updated 3 months ago by Sloan

Database – Custom Field Entity (custom_field)

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

Updated 3 months ago by Cole

Database – Custom Field to Entity Map (custom_field__entity)

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

Updated 3 months ago by Cole

Database – Custom Form Entity (custom_form_entity)

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

Updated 3 months ago by Cole

Database – Custom Form Section Entity (custom_form_section_entity)

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

Updated 3 months ago by Cole

Database – Custom Form Tool Entity (custom_form_tool_entity)

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

Updated 3 months ago by Cole

Database – Custom Form Tool to Loan Map (custom_form_tool__loan)

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

Updated 3 months ago by Cole

Database – Custom Onboarding Process Entity (custom_boarding_process_entity)

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

Updated 3 months ago by Cole

Database – Custom Onboarding Process Step Entity (custom_boarding_process_step_entity)

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

Updated 3 months ago by Cole

Database – Custom Payment Type Entity (custom_payment_type_entity)

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

Updated 3 months ago by Cole

Database – Custom payment Method Entity (custom_payment_method_entity)

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

Updated 3 months ago by Cole

Database – Customer Credit Score Entity (customer_credit_score_entity)

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

Updated 3 months ago by Sloan

Database – Customer Document Entity (customer_document_entity)

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

Updated 3 months ago by Sloan

Database – Customer Employer Entity (customer_employer_entity)

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

Updated 3 months ago by Sloan

Database – Customer Login Attempts (customer_login_attempts)

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

Updated 3 months ago by Sloan

Database – Customer Main Table (customer_entity)

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

Updated 3 months ago by Sloan

Database – Customer Payment Method Entity (customer_payment_method_entity)

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

Updated 3 months ago by Sloan

Database – Customer Payment Profile Information (payment_account_entity)

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

Updated 3 months ago by Sloan

Database – Customer Phone Entity (customer_phone_entity)

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

Updated 3 months ago by Sloan

Database – Customer Reference Entity (customer_reference_entity)

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

Updated 3 months ago by Sloan

Database – Customer Social Profile Entity (customer_social_profile_entity)

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

Updated 3 months ago by Sloan

Database – Customer Status Entity (customer_status_entity)

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

Updated 3 months ago by Sloan

Database – Customer Website FAQ Entry (faq_entry_entity)

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

Updated 3 months ago by Sloan

Database – Customer Website Hompage Image Info (homepage_image_entity)

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

Updated 3 months ago by Sloan

Database – Customer Website Page Entity (page_entity)

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

Updated 3 months ago by Sloan

Database – Customer Website Testimonials (testimonial_entity)

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

Updated 3 months ago by Cole

Database – Dashboard Entity (dashboard_entity)

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

Updated 3 months ago by Sloan

Database – Dashboard Preferences (dashboardpreferences_entity)

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

Updated 3 months ago by Sloan

Database – Dashboard Widget (dashboard__dashboardwidget)

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

Updated 3 months ago by Sloan

Database – Dashboard Widget Entity (dashboardwidget_entity)

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

Updated 3 months ago by Sloan

Database – Data Dump Entity (data_dump_entity)

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

Updated 3 months ago by Sloan

Database – Data Import Entity (data_import_entity)

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

Updated 3 weeks ago by Sloan

Database – Default Billing Options Entity (default_billing_options_entity)

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

Updated 3 months ago by Sloan

Database – Default Billing Template Entity (default_billing_template_entity)

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

Updated 3 months ago by Sloan

Database – Default Billing Theme Entity (default_billing_theme_entity)

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

Updated 3 months ago by Sloan

Database – Default Charges (defaults_charges)

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

Updated 3 months ago by Sloan

Database – Defaults Autopay (defaults_autopay)

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

Updated 2 months ago by Sloan

Database – Defaults Escrow Calculator (defaults_escrow_calculator)

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

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

Database – Delivery Entity (delivery_entity)

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

Updated 3 months ago by Sloan

Database – Disbursement Entity (disbursement_entity)

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

Updated 3 months ago by Sloan

Database – Document Section Entity (doc_section_entity)

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

Updated 3 months ago by Sloan

Database – Email Delivery Entity (email_delivery_entity)

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

Updated 3 months ago by Sloan

Database – Email Queue (email_queue)

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

Updated 3 months ago by Sloan

Database – Email Template Entity (email_template_entity)

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

Updated 3 months ago by Sloan

Database – Email Tool - Loan Association (email_tool__loan)

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

Updated 3 months ago by Sloan

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

Database – Email Trigger entity ( email_trigger_entity)

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

Updated 3 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 Other id int(10) The id of the loan funding transaction loan_id int(11)…

Updated 1 week ago by Jackson Stone

Database – Escrow Adjustment Entity (escrow_adjustment_entity)

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

Updated 3 months ago by Sloan

Database – Escrow Analysis Process (escrow_analysis_process_entity)

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

Updated 3 months ago by Sloan

Database – Escrow Analysis Task Entity (escrow_analysis_task_entity)

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

Updated 3 months ago by Sloan

Database – Escrow Subset Entity (escrow_subset_entity)

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

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

Database – Escrow Transaction (escrow_transaction_entity)

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

Updated 3 months ago by Sloan

Database – Escrow Transaction Category (escrow_tx_category_entity)

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

Updated 3 months ago by Sloan

Database – Escrow Transaction Metadata (escrow__transactions)

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

Updated 3 months ago by Sloan

Database – Escrow calculator (escrow_calculator_entity)

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

Updated 3 months ago by Sloan

Database – File attachment entity (file_attachment_entity)

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

Updated 3 months ago by Sloan

Database – Flag Entity (flag_entity)

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, the flag is ma…

Updated 3 months ago by Sloan

Database – Flag Status Archive (flag_status_archive)

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

Updated 3 months ago by Sloan

Database – Form Section Info (form_section_entity)

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

Updated 3 months ago by Sloan

Database – Funding Category (funding_category_entity)

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

Updated 3 months ago by Jackson Stone

Database – GPS Link Info (gps_link_entity)

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

Updated 3 months ago by Sloan

Database – Holding Account Archive Info (holding_account_archive_entity)

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

Updated 3 months ago by Sloan

Database – Holding Account Autopay Info (holding_account_autopay_entity)

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

Updated 3 months ago by Sloan

Database – Holding Account Category Info (holding_account_category_entity)

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

Updated 3 months ago by Sloan

Database – Holding Account Investor Relations Info (holding_account__investor)

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

Updated 3 months ago by Sloan

Database – Holding Account Settings Entity (holding_account_settings_entity)

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

Updated 3 months ago by Sloan

Database – Holding Account Status Entity (holding_account_status_entity)

Holds status information for holding accounts. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(255) The name/title of the entity instance active tinyint(1…

Updated 3 months ago by Sloan

Database – Holding Account Sub Status Entity (holding_account_sub_status_entity)

Holds substatus information and settings for holding accounts. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(255) The name/title of the entity instance…

Updated 3 months ago by Sloan

Database – Holding Account Transaction (holding_account_transaction_entity)

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

Updated 3 months ago by Sloan

Database – Holding Account Transaction Category (holding_account_transaction_category_entity)

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

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

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

Database – Investment Entity (investment_entity)

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

Updated 3 months ago by Sloan

Database – Investment Portfolio (investment__portfolio)

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

Updated 3 months ago by Sloan

Database – Investment Position Entity (investment_position_entity)

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

Updated 3 months ago by Sloan

Database – Investment Sub Portfolio Relation (investment__sub_portfolio)

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

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

Database – Investor document entity (investor_document_entity)

Updated 3 months ago by Sloan

Database – Investor status information (investor_status_entity)

Holds status information for investors. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(255) The name/title of the entity instance slug varchar(255) Statu…

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

Database – Link metadata (linked_info__entity)

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

Updated 3 months ago by Cole

Database – Linked Loan Option (linked_loan_option_entity)

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

Updated 3 months ago by Cole

Database – Linked loan info (linked_loan__entity)

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

Updated 3 months ago by Cole

Database – Loan Active Time Transactions (loan_active_time_tx)

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

Updated 3 months ago by Sloan

Database – Loan Advancements (loan_advancement_entity)

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) The id of t…

Updated 3 months ago by Sloan

Database – Loan Charge Sequence (loan_charge_seq)

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

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

Database – Loan Chargeoff Transaction (loan_chargeoff__transactions)

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

Updated 3 months ago by Sloan

Database – Loan Child Entity (loan_child__entity)

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

Updated 3 months ago by Sloan

Database – Loan Credit Entity (loan_credit_entity)

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

Updated 3 months ago by Sloan

Database – Loan Curtailment Date Entity (loan_curtail_date_entity)

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

Updated 3 months ago by Sloan

Database – Loan Customer Link Info (loan__customer)

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

Updated 3 months ago by Sloan

Database – Loan Days Past Due Adjustment Entity (loan_dpd_adjustment_entity)

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

Updated 3 months ago by Sloan

Database – Loan Delinquency (loan_delinquency_entity)

Description. This table lists all the database columns for Loan Delinquencies. Common Uses. Used to get information about delinquency of loans. Typically used to pull data on a large quantity of loan…

Updated 3 months ago by Jackson Stone

Database – Loan Delinquency History (loan_delinquency_history_entity)

Deprecated! Deprecated. This information is now found in the loan_delinquency_entity. Holds delinquency history for a loan Column Data Type Column Info Value Notes Other id int(11) The id of the enti…

Updated 3 months ago by Sloan

Database – Loan Document Entity (loan_document_entity)

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

Updated 3 months ago by Sloan

Database – Loan Due Date Change (loan_duedate_change_entity)

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

Updated 3 months ago by Sloan

Database – Loan Funding (loan_funding_entity)

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

Updated 3 months ago by Sloan

Database – Loan Insurance Info (loan_insurance_entity)

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

Updated 3 months ago by Sloan

Database – Loan Late Fee Buckets (loan_late_fee__buckets)

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

Updated 3 months ago by Sloan

Database – Loan Lock (loan_lock)

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

Updated 3 months ago by Sloan

Database – Loan Modification Info (loan_modification_entity)

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

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

Database – Loan Portfolio Relations (loan__portfolio)

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

Updated 3 months ago by Sloan

Database – Loan Promise Info (loan_promise_entity)

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

Updated 3 weeks ago by Sloan

Database – Loan Reverse Calculator Settings (loan_reverse_calc_settings)

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

Updated 3 months ago by Sloan

Database – Loan Reverse Status Archive (loan_reverse_status_archive)

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

Updated 3 months ago by Sloan

Database – Loan SMS Queue Item Entity (loan_sms_queue_item_entity)

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

Updated 3 months ago by Sloan

Database – Loan Schedule Role Entity (loan_schedule_roll_entity)

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

Updated 3 months ago by Sloan

Database – Loan Settings Entity (loan_settings_entity)

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

Updated 2 months ago by Sloan

Database – Loan Setup (loan_setup_entity)

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

Updated 1 week ago by Sloan

Database – Loan 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 3 months ago by Darrin Wray

Database – Loan Status Entity (loan_status_entity)

Holds loan status information. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(255) The name/title of the entity instance active tinyint(1) Whether or not…

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

Database – Loan Sub Status Entity (loan_sub_status_entity)

Loan sub-status information. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(255) The name/title of the entity instance rule text parent int(11) parent st…

Updated 3 months ago by Sloan

Database – Loan Table (loan_entity)

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

Updated 3 months ago by Sloan

Database – Loan To Admin Tool Map (admin_tool__loan)

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

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

Database – Loan late fee bucket defaults (defaults_late_fee__buckets)

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

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

Database – Mail House Delivery (mail_house_delivery_entity)

Updated 3 months ago by Sloan

Database – Mail House Loan (mail_house_loan)

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

Updated 3 months ago by Sloan

Database – Mail House Tool (mail_house_tool_entity)

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

Database – Merchant Processor Group Entity (merchant_processor_group_entity)

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

Updated 3 months 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 2 months ago by Jackson Stone

Database – Note Alert Rule (rules_note_alert_entity)

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

Updated 3 months ago by Sloan

Database – Note Category Info (note_category_entity)

Holds category information for notes created by agent users. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(255) The name/title of the entity instance en…

Updated 3 months ago by Cole

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

Database – Notification Category (notification_category_entity)

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

Updated 3 months ago by Cole

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

Database – Notification Do Not Disturb Period Entity (notification_dnd_period_entity)

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

Updated 3 months ago by Cole

Database – Notification Entity (notification_entity)

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

Updated 3 months ago by Cole

Database – Pay Near Me Order Entity (pnm_order_entity)

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

Updated 3 months ago by Cole

Database – Payment Defaults (defaults_payments)

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

Updated 3 months ago by Sloan

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

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

Database – Payment Sub Portfolio Relations (payment__sub_portfolio)

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

Updated 3 months ago by Sloan

Database – Payments (payment_entity)

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

Updated 1 month ago by Sloan

Database – Portfolio Category Entity (portfolio_category_entity)

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

Updated 3 months ago by Cole

Database – Portfolio entity (portfolio_entity)

Holds portfolio information used to categorize loans. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(255) The name/title of the entity instance num_prefi…

Updated 3 months ago by Cole

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

Database – Preconfigured Loan Portfolio Relation (preconfigured_loan__portfolio)

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

Updated 3 months ago by Sloan

Database – Preconfigured Loan Settings Entity (preconfigured_loan_settings_entity)

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

Updated 2 months ago by Sloan

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

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

Updated 3 months ago by Sloan

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

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

Database – Recurring Charge Entity (recurring_charge_entity)

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

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

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

Database – Restriction Group Entry (restriction_group_entry_archive)

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

Updated 3 months ago by Sloan

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

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

Database – Result Entity (result_entity)

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

Updated 3 months ago by Sloan

Database – Result Notes (result__notes)

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

Updated 3 months ago by Sloan

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

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

Updated 3 months ago by Sloan

Database – Rule Category Entity (rule_category_entity)

Holds category information for Clojure rules. Column Data Type Column Info Value Notes Other id int(11) The id of the entity title varchar(255) The name/title of the entity instance active tinyint(1)…

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

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

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

Updated 3 months ago by Sloan

Database – Rule applied Settings - Loan Relations (loan__rule_applied_settings)

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

Updated 3 months ago by Sloan

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

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

Updated 3 months ago by Sloan

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

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

Updated 3 months ago by Sloan

Database – Rule applied checklist - Loan Relations (loan__rule_applied_checklist)

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

Updated 3 months ago by Sloan

Database – Rules Applied APD Reset Entity (rule_applied_apd_reset_entity)

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

Updated 3 months ago by Sloan

Database – Rules Applied Account Tools (loan__rule_applied_account_tools)

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

Updated 3 months ago by Sloan

Database – Rules Applied Autopay (loan__rule_applied_autopay)

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

Updated 3 months ago by Sloan

Database – Rules Applied Bankruptcy (loan__rule_applied_bankruptcy)

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

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

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

Database – Rules Applied Customer Tools (loan__rule_applied_customer_tools)

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

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

Database – Rules Applied Settings (rule_applied_loan_settings_entity)

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

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

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

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

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

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

Database – Rules Applied, Account Tools (rule_applied_account_tools_entity)

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

Updated 3 months ago by Sloan

Database – Rules Applied, Autopay (rule_applied_autopay_entity)

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

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

Database – Rules Applied, Customer Tools (rule_applied_customer_tools_entity)

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

Updated 3 months ago by Sloan

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

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

Database – SBT Message Log (sbt_message_log)

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

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

Database – SMS Delivery Entity (sms_delivery_entity)

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

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

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

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

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

Database – Scheduled Report Entity (scheduled_report_entity)

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

Updated 3 months ago by Sloan

Database – Schema Version (schema_version)

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

Updated 3 months ago by Sloan

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

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

Database – Secure Payments Processor Extender (mc_processor_extender)

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

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

Database – Settings for "My Loans" (my_loans_setting_entity )

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

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

Database – Sound Group Item Entity (sound_group_item_entity)

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

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

Database – Source Company Entity (source_company_entity)

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

Updated 3 months ago by Sloan

Database – Source Company Physical Check Account (source_company_physical_check_account_entity)

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

Updated 2 weeks ago by Jackson Stone

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 Other id int(11) The id of the record source_c…

Updated 2 months ago by Jackson Stone

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

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

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

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

Database – System Notes Entity (system_note_entity)

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

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

Database – TCN Queue Item Entity (tcn_queue_item_entity)

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

Updated 3 months ago by Sloan

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

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

Database – Tenant Checklist Entity (tenant_checklist_entity)

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

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

Database – Tenant Pricing Tier (tenant_pricing_tier_entity)

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

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

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

Database – Transaction Child Entity (transaction_child_entity)

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

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

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

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

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

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

Database – Web Hook Delivery (web_hook_delivery_entity)

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

Updated 3 months ago by Sloan

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

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

Database – Wizard Step Entity (wizard_step_entity)

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

Updated 3 months ago by Sloan

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

Database – Wizard Validation (wizard_process_validation)

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

Updated 3 months ago by Sloan

Database – Wizards (wizard_entity)

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

Updated 3 months ago by Sloan

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 3 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 9 seconds ago by Andy