This section provides information about Placed Collateral Result tables in the Oracle Insurance Data Foundation application and step-by-step instructions to use this section.
Topics:
· About Placed Collateral Dimension Table
· About Placed Collateral T2Ts (Result Tables)
· Deploying Placed Collateral Tables on Hive
· Populating Placed Collateral Dimension Table
· Populating Placed Collateral T2T Result Tables
Financial Institutions place collateral in derivative transactions, reinsurance issued, or similar use cases where the risk of obligations not being served by reporting entity are perceived high and are secured by seeking agreed collateral in lieu to reduce the risk. Therefore, Placed Collateral refers to the collateral placed by reporting entity to other entities. The Mitigant reflect collateral received and collateral placed functions exactly opposite as of Mitigant.
In Data Foundation, assets hold on books and collateral placed are treated differently. For example, assume a use case where Insurance Company has purchased a lot of Government securities with a market value of 10 Million USD. When they write a reinsurance contract, Insurance Company has sought collateral comprising of government securities worth 4 million USD. In this case, stage investments hold data reflecting 6 million USD, whereas stage placed collateral holds data of 4 million USD.
Placed Collateral Dimension table name and its description are given here.
Logical Dimension Table Name |
Dimension Table Description |
|---|---|
Placed Collateral Dimension |
This table stores the details of master collaterals that are placed by the Insurance entity with other Insurance entities in order to secure its borrowings. |
The mapping details for the Placed Collateral Dimension table is given here.
Map Reference Number |
Source Table Name |
Logical Stage Table Name |
Dimension Table Name |
Logical Dimension Table Name |
|---|---|---|---|---|
202 |
STG_PLACED_COLLATERAL_MASTER |
Stage Placed Collateral Master |
DIM_PLACED_COLLATERAL |
Placed Collateral Dimension |
Placed Collateral T2Ts and their description are given here.
T2T Name |
T2T Description |
|---|---|
T2T_FCT_PLACED_COLLATERAL |
This T2T stores the details of collateral that are placed against an account. |
T2T_FCT_ACCT_PLACED_COLL_MAP |
This T2T stores account to placed collateral mapping details. It is an intersection table to denote that a placed collateral can be used in multiple accounts and an account contains multiple collaterals. |
T2T_FCT_RI_ISSUED_PLCD_COLL_MAP |
This T2T stores the mapping between the Placed Collateral and Reinsurance Contract. Reinsurers provide security to Insurance companies to make sure that they are adequately covered. |
The mapping details for the Placed Collateral T2Ts are given here.
Source Table Name |
Logical Stage Table Name |
Fact Table Name |
Logical Fact Table Name |
T2T Name |
|---|---|---|---|---|
STG_PLACED_COLLATERAL |
Stage Placed Collateral |
FCT_PLACED_COLLATERAL |
Fact Placed Collateral |
T2T_FCT_PLACED_COLLATERAL |
STG_ACCT_PLACED_COLL_MAP |
Stage Account Placed Collateral Map |
FCT_ACCT_PLACED_COLL_MAP |
Fact Account Placed Collateral Map |
T2T_FCT_ACCT_PLACED_COLL_MAP |
STG_RI_ISSUED_PLACED_COLL_MAP |
Stage Reinsurance Issued Placed Collateral Map |
FCT_RI_ISSUED_PLACED_COLL_MAP |
Fact Reinsurance Issued Placed Collateral Map |
T2T_FCT_RI_ISSUED_PLCD_COLL_MAP |
All RDBMS related Result tables can also be deployed on Hive (Stage and Results). Deploy the Hive T2Ts using the Rules Run Framework. For more information, see the Rules Run Framework section in the Oracle Financial Services Advanced Analytical Applications Infrastructure User Guide Release 8.1.1.0.0.
NOTE:
In general, Stage and Result tables are also supported in Hive. However, there are some exceptions. For a list of tables that are not supported in Hive, see List of Unsupported T2Ts
Follow this SCD process to populate data into a Dimension table:
NOTE:
You can also follow this SCD process to populate data into any Hive-related Dimension table.
1. To populate data into a Dimension table, execute the SCD batch. For a detailed procedure, see the Slowly Changing Dimension (SCD) Process.
2. To check the SCD batch execution status of a Dimension table, follow the procedure Check the Execution Status of the SCD Batch.
3. To verify log files, and check the error messages (if any), follow the procedure Verify Log Files and Check Error Messages.
Follow this T2T process to populate data into any T2T Result table:
NOTE:
Only RDBMS T2Ts can be executed using the PMF.
1. To populate data into any T2T Result table, execute the PMF process for that T2T. For a detailed procedure, see the following sections:
a. Prerequisites for loading T2T.
b. Select the Run Parameters and Execute the Run.
2. To check the T2T execution status and verify the log files of any Result table, follow the procedure in the Verify the Run Execution section.
3. To check the error messages, if any, follow the procedure in the Check Error Messages section.
You can see the following topics related to other function-specific tables: