FSO Core Banking tables
This section describes the banking tables in FSO Core and shows how they store and manage banking information.
Banking tables installed
| Label | Table name | Description |
|---|---|---|
| Auto Loan | sn_bom_auto_loan | Stores all auto loans records. This table extends the Loan Account [sn_bom_loan_account] table. |
| Bond | sn_bom_bond | Stores all bond information. Extends the Security [sn_bom_security] table. |
| Business Certificate of Deposit | sn_bom_b2b_certificate_of_deposit | Stores all certificate of deposit account records, a type of financial account that allows businesses to deposit money for a fixed period and earn a fixed interest on it. |
| Business Checking Account | sn_bom_b2b_checking_account | Stores all checking account records for consumers. Extends the Deposit Account [sn_bom_deposit_account] table. |
| Business Credit Card | sn_bom_b2b_credit_card | Stores all business credit card records, a type of credit card that is designed for businesses to purchase goods or services on credit with benefits tailored to their needs. |
| Business Line of Credit | sn_bom_b2b_line_of_credit | Stores all line of credit records for business loan customers. Extends the Line of Credit table. |
| Business Saving Account | sn_bom_b2b_saving_account | Stores all saving account (a type of deposit account) records for business customers. Extends the Deposit Account [sn_bom_deposit_account] table. |
| Chargeback Reason Codes | sn_bom_chargeback_reason_codes | Stores all chargeback reason code records. Chargeback reason codes are numerical codes used to categorize the reasons why a cardholder disputes a transaction. These are provided by card networks like Visa, Mastercard, American Express. |
| Commercial Real Estate Loan | sn_bom_commercial_real_estate_loan | Stores all commercial real estate loan records. Extends the Loan Account [sn_bom_loan_account] table. |
| Commercial Vehicle Loan | sn_bom_commercial_vehicle_loan | Stores all commercial vehicle loan records. Extends the Loan Account [sn_bom_loan_account] table. |
| Covenant | sn_bom_b2b_covenant | Stores all covenant records for business customers. |
| Covenant | sn_bom_covenant | Stores all covenant records for consumers. |
| Covenant | sn_bom_covenant_base | Stores all covenant base records. The [sn_bom_b2b_covenant] and [sn_bom_covenant_base] tables extend the Covenant Base table. |
| Coverage Specification | sn_bom_coverage_specification | Stores all coverage specification records that define the product coverage types and their options. |
| Coverage Type | sn_bom_coverage_type | Stores all coverage type records across all products. |
| Coverage Type Option | sn_bom_coverage_type_option | Stores all coverage type option records for each coverage type across all products. |
| Currency ISO Code Association | currency_iso_code_association | |
| Stores all location records for customer property. | sn_bom_customer_property | Stores all customer property records with details of the properties that a customer has. For example, it stores the vehicles and property locations that a customer holds. |
| Data Fix Backup | sn_bom_data_fix_backup | Stores all backup records during data migration from one table to another. |
| Deposit Account | sn_bom_deposit_account | Stores all deposit accounts – Checking and Saving records. Extends the Financial Account [sn_bom_financial_account] table. |
| Equipment Loan | sn_bom_equipment_loan | Stores all equipment loan records. This table extends the Loan Account [sn_bom_loan_account] table. |
| ETF | sn_bom_etf | Stores all ETF information. This table extends the Security [sn_bom_security] table. |
| Exchange | sn_bom_exchange | |
| Financial Account | sn_bom_financial_account | Stores all financial accounts – deposit accounts, loan accounts, credit card account, line of credit accounts, and insurance policy accounts. Extends the Sold Product [sn_install_base_sold_product] table. |
| Financial Institution | sn_bom_financial_institution | Stores all financial institution records. Extends the Company [core_company] table. |
| Financial Service | sn_bom_service | Stores all financial services – RDC service and wire transfer service. Extends the Sold Product [sn_install_base_sold_product] table. |
| Stores all RDC financial account records. Links RDC services to financial accounts. | sn_bom_m2m_service_financial_account | Stores all financial accounts – deposit accounts, loan accounts, credit card account, line of credit accounts, and insurance policy accounts. Extends the Sold Product [sn_install_base_sold_product] table |
| Financial Service User | sn_bom_m2m_service_user | Stores details of users for a financial service account |
| Financial Services Base | sn_bom_case | Stores all financial services base records and serves as the parent table for all types of financial case records within a system. It acts as a central repository that provides a unified structure for managing various financial cases, such as disputes, fraud investigations, loan applications, insurance servicing, claims and other financial inquiries or issues. Each record represents a unique financial case, with associated metadata that links to more specific case details stored in related child tables. |
| Financial Services Case | sn_bom_financial_service | Stores all financial services cases. Extends the financial services base Case [sn_bom_case] table. |
| Financial Services Task | sn_bom_financial_task | Stores all financial services tasks. Extends the Financial Task [sn_bom_task] table. |
| Financial Task | sn_bom_task | Stores all financial tasks such as inquiry tasks, claim tasks, credit tasks and loan tasks. Extends the Industry Task [sn_ind_task] table. |
| Financial Transaction | sn_bom_transaction | Stores all financial transactions for deposit, loan, and credit card accounts. Extends the Industry Data Entity [sn_ind_data_entity] table. |
| Financial Transaction Authorization | sn_bom_transaction_authorization | Stores authorization-related details for financial transactions. |
| Group Member Info | sn_bom_group_member_info | Stores all group member info records and is an extension of customer property table which can contain the group member details applicable to a customer. For example, in employer provided life insurance policy scenario, this table can hold the group member details of the employer. |
| Holding | sn_bom_holding | Stores all holding information records. |
| Holding lot | sn_bom_holding_lot | Stores all holding lot information records. |
| Insured Property | sn_bom_insured_property | Stores all insured property records that reference customer property and contain the properties of a customer which are covered by an insurance policy. |
| Investment account | sn_bom_investment_account | Stores all investment account records. Extends the Financial Account [sn_bom_financial_account] table. |
| Line | sn_bom_line | Stores all line records and is a parent table which holds the case lines of a case when requests are made on the line items belonging to a sold product. For example, in an insurance servicing case, when a request is made to change policy coverages, the coverage line items for the policy can be held in the line tables extended from this table in the servicing app. This ensures that the changes are not made directly on the insurance policy coverage records when the case is being processed and the updates are made only after the case is approved and closed. |
| Line of Credit | sn_bom_line_of_credit | Stores all line of credit account records. Extends the Financial Account [sn_bom_financial_account] table. |
| Loan Account | sn_bom_loan_account | Stores all loan account records. Extends the Financial Account [sn_bom_financial_account] table. |
| Location | sn_bom_location | Stores all vehicle records for customer property. |
| Merchant Category Code | sn_bom_merchant_category_code | |
| Mortgage | sn_bom_mortgage | Stores all mortgage account records. Extends the Loan Account [sn_bom_loan_account] table. |
| Operating instruction | sn_bom_b2b_operating_instruction | Stores all operating instruction records on a business account. For example, on a business checking account who are the signatories who are allowed to sign and their financial limits. |
| Operating instruction | sn_bom_operating_instruction | Stores all operating instruction records on a personal account. For example, on a personal checking account who are the signatories who are allowed to sign or provide instructions to operate the account. |
| Option | sn_bom_option | Stores all options information. Extends the Security [sn_bom_security] table. |
| Payment Network | sn_bom_payment_network | Stores all payment network records with information about the payment processing networks in the context of cards. For example, Visa interlink, Pulse. |
| Personal Certificate of Deposit | sn_bom_certificate_of_deposit | Stores all personal certificate of deposit account records, a type of financial account that allows individuals to deposit money for a fixed period and earn a fixed interest on it. |
| Personal Checking Account | sn_bom_checking_account | Stores all checking account records for consumers. Extends the Deposit Account [sn_bom_deposit_account] table. |
| Personal Credit Card | sn_bom_credit_card | Stores all personal credit card records, a type of credit card that allows individuals to purchase goods or services on credit. |
| Personal Line of Credit | sn_bom_b2c_line_of_credit | Stores all line of credit records for consumers. |
| Personal Loan | sn_bom_personal_loan | Stores all personal loan account records. Extends the Loan Account [sn_bom_loan_account] table. |
| Personal Saving Account | sn_bom_saving_account | Stores all personal saving account records, a type of bank account that allows customers to deposit money and earn interest on it. |
| Policy Coverage | sn_bom_policy_coverage | Stores all policy coverage records with the defined coverages on the insurance policy. |
| Policy Participant | sn_bom_policy_participant | Stores all policy participant records with the defined participants on the insurance policy. |
| Policy Participant Role | sn_bom_policy_participant_insured_property | Stores all policy participant role records with the roles played by the participants who have been defined on the insurance policy. |
| Product Coverage Type | sn_bom_product_coverage_type | Stores all product coverage type records with the product coverage types defined for the product. |
| Product Coverage Type Option | sn_bom_product_coverage_type_option | Stores all product coverage type option records with the product coverage type options defined for a coverage type within the product. |
| RDC Financial Account | sn_bom_m2m_rdc_financial_account | Stores all wire transfer financial account records. Links wire transfer services to financial accounts. |
| RDC Service | sn_bom_rdc | Stores all RDC treasury service records. Extends the Financial Service [sn_bom_service] table. |
| RDC User | sn_bom_m2m_rdc_user | Stores details of users who are authorized to request for a remote deposit capture facility on a business deposit account |
| Renters Policy | sn_bom_renters_ins_policy | Stores all renters policy records for insurance personal renters policies. Extends the insurance policy table. |
| SBA Loan | sn_bom_sba_loan | Stores all SBA (Small Business Administration) loan account records. Extends the Loan Account [sn_bom_loan_account] table. |
| Security | sn_bom_security | Stores all security information. Extends the Security [sn_bom_security] table. |
| Security Exchange | sn_bom_m2m_security_exchange | Stores all security exchange records with details of security exchange (a marketplace where securities, such as stocks, bonds, and derivatives, are bought and sold). For example, NYSE- New York Stock Exchange, Nasdaq. |
| Service Definition | sn_bom_service_definition | Stores all service definitions configured for all workflows across Financial Services Operations applications. |
| Service Definition has Agent Criteria | n_csm_case_types_service_user_criteria | Stores all service definition and agent criteria relationship records. An m2m table between Service Definition and Agent Criteria (user_criteria). |
| Service Definition has Entity Criteria | sn_csm_case_types_service_customer_criteria | Stores all service definition and entity criteria relationship records. An m2m table between Service Definition and Entity Criteria (sn_req_criteria_customer_condition). |
| Standing Order | sn_bom_b2b_standing_order | Stores all standing instruction records which are pre-authorized payment instructions given by a business customer to the bank. For example, auto bill payments. |
| Standing Order | sn_bom_standing_order | Stores all standing instruction records which are pre-authorized payment instructions given by a an individual customer to the bank. For example, auto bill payments. |
| Stock | sn_bom_stock | Stores all stock information. Extends the Security [sn_bom_security] table. |
| Student Loan | sn_bom_student_loan | Stores all student loan account records. Extends the Loan Account [sn_bom_loan_account] table. |
| Term Loan | sn_bom_term_loan | Stores all term loan account records. Extends the Loan Account [sn_bom_loan_account] table. |
| Trade | sn_bom_trad | Stores all trade records with information related to individual stock orders placed by investors. |
| Transaction | sn_bom_card_transaction | Stores all card transaction records. Extends the Financial Transaction [sn_bom_transaction] table. |
| Transaction | sn_bom_deposit_transaction | Stores all deposit transaction records. Extends the Financial Transaction [sn_bom_transaction] table. |
| Transaction | sn_bom_ins_policy_transaction | Stores all policy transaction records. Extends the Financial Transaction [sn_bom_transaction] table. |
| Transaction | sn_bom_investment_transaction | Stores all investment transaction records. Extends the Financial Transaction [sn_bom_transaction] table. |
| Transaction | sn_bom_line_of_credit_transaction | Stores all line of credit transaction records. Extends the Financial Transaction [sn_bom_transaction] table. |
| Transaction | sn_bom_loan_transaction | Stores all loan transaction records. Extends the Financial Transaction [sn_bom_transaction] table. |
| Vehicle | sn_bom_vehicle | Customer Property |
| Wire Transfer Financial Account | sn_bom_m2m_wire_transfer_financial_account | Financial Service Financial Account |
| Wire Transfer Service | sn_bom_wire_transfer | Stores all wire transfer treasury service records. Extends the Financial Service [sn_bom_service] table. |
| Wire Transfer User | sn_bom_m2m_wire_transfer_user | Stores details of users who are authorized to request for a wire transfer facility on a business deposit account |
Parent Topic:Financial Services Operations Core