The OFS LDM is organized into a small set of high-level subject areas, each of which represents a key category of data that is produced by the business processes in a bank.
Subject Areas and their definitions:
Subject Area Name |
Subject Area Definition |
Accounting |
This subject area deals with the structure of the internal accounting of a financial institution, which includes budget , GL & GL mapping to budgets. |
Application |
This subject area covers various aspects of application across different products. The section helps to analyze potentially risky customers and performance of different sourcing channels. |
Calendar |
This subject area deals with entities that contain the details for Calendar & Fiscal Date, Month, Quarter, Half year & Year. |
Campaign |
This subject area provides the information on the campaigns, which are organized by the financial institutions. It covers the details of the campaign treatment, offers given on a campaign, response & delivery status and so on, which helps in analyzing the profitability of a campaign. |
Channel |
This subject area caters to all the variety of channels, which are involved in the functioning of financial institution in terms of advertisement or collecting response or sending message, or so on. |
Claim |
This subject area covers the details of claims originated from insurance contracts. It also captures the various claim events, the settlement history & the claim recovery process. |
Collateral |
This subject area records the details of various physical & financial collateral and also helps in analyzing the quality of the each collateral. |
Collections and Recovery |
This section captures performance of collection & recovery activities. The section helps ascertain the amount and quality of the collections and the recovery that was made using the secondary means of collecting money (by selling collaterals, and so on). |
Common |
This subject area covers the entities that are common across subject areas like currency, data origin, and so on. |
Contract |
This subject area captures contract & account details of various banking & insurance products, which includes Loans, Cards, CASA, TD, Collection, Insurance, Merchant Card, Overdraft, Commitment, Prepaid Cards, Reinsurance, and so on. |
Coverage |
This subject area deals with the presentation of the Insurance policy that defines and limits the provisions and obligations under an Insurance Policy. Components of the coverage are the provisions, benefits, options, terms and condition specific to offered insurance to an insured party. |
Geography |
This subject area deals with entities that contain the physical address of the party and offices where they are located or contacted. |
Instrument |
This subject area captures the details of various instrument financial organization deals with like Certificate of deposit, common stock, derivatives, equity, fixed income securities, repo, and so on |
Limit |
This subject area defines the generic limit, which can be associated with an account access restriction, acceptance tolerance on amount difference, age of contribution, approval workflow, number of transactions allowed, lending and credit. |
Market |
This subject area identifies entities that are of importance with respect to capturing data feed from Order Management and Order Execution systems along with the entities that are involved in the clearing and settlement processes. |
Organization |
This subject area deals with entities that can perform one or many business functions and it is a unit of a financial institution that can be consolidated in both a managerial and legal hierarchy. |
Party |
This subject area deals with the entities, which can interact with the Financial Organization for any kind of business/non‐business activity and on the same lines the entities with which the bank interacts with. It also includes Bank as a whole and various internal units of the bank mutually involved in certain set of transactions. Party in different con‐ texts can play different roles i.e. Customer for a particular contract and a Vendor in some business relationship (servicing the bank). |
Product |
This subject area deals with entities which stores the features & details of the products, which are offered by the financial institutions. |
Reinsurance |
This subject area covers the details of reinsurance contract, which is a contract between reinsurer & an insurer. |
Securitization |
This subject area covers the details & the complete process of securitization, it also covers on mortgage servicing rights. |
Trade |
This subject area covers the details of order management, trade execution & trade settlement which helps in analyzing the trade life cycle. |
Transaction |
This subject area deals with entities and relationships that capture any kind of activity (financial or non‐financial) including those on an account or between accounts. |
Within the above subject areas, the FS LDM has 800+ entities. The various naming conventions used in OFSDF Logical Data Model are explained in Appendix A. For column-level details, see the Technical Whitepaper on Data Model Document Generation, which details how to extract the data dictionary from erwin section.