This section provides information about the Policy Assets tables in the Oracle Insurance Data Foundation application, and step-by-step instructions to use this section.
Topics:
· About Policy Assets Dimension Tables
· About Policy Assets T2T (Result Table)
· Deploying Policy Assets Table on Hive
· Populating Policy Assets Dimension Tables
· Populating Policy Assets T2T Result Table
Policy Assets is an asset with an insurance policy. An insured asset is one for which an insurance company compensates the policyholder if the asset is damaged or destroyed. Companies and individuals have insurance policies on their assets, or at least their tangible assets, to transfer the risk associated with owning them. There are two types of Policy Asset types. The type under the movable category includes automobiles, and so on. The type under the immovable category includes real estate, equipment, and so on.
Policy Assets Dimension table names and their description are given here.
Table 162: Policy Assets Dimension table names and their description
Logical Dimension Table Name |
Dimension Table Description |
Hazard Risk Level Dimension |
Stores code details
of the Hazard Risk Level. |
Hazard Risk Override Type Dimension |
Stores code details
of the Hazard Grade Override. This is a shorthand representation
of the risk average degree assigned by a Rater or Underwriter
to the standard Hazard Grade Code. |
Policy Asset Sub Type Dimension |
Stores details
of the asset subtype of a policy. |
Policy Asset Valuation Type Dimension |
Stores details
of the code that identifies the method used to determine the policy
asset value. This table uses the ValuationMethod code list. |
Policy Covered Asset Dimension |
Stores details of the assets covered in the policy. |
Policy Asset Type Dimension |
Stores details of the type of asset covered in the policy. The types of policy assets are Real Estate, Equipment, Automobiles, and so on. The type under the movable category includes automobiles, and so on. The type under the immovable category includes real estate, equipment, and so on. |
Risk Qualifier Type Dimension |
Stores details
of the risk qualifier type that is either applicable or not for
the insurance. |
The mapping details for the Policy Assets Dimension tables are given here.
Table 163: The mapping details for the Policy Assets Dimension tables
Map Reference Number |
Source Table Name |
Logical Stage Table Name |
Dimension Table Name |
Logical Dimension Table Name |
801 |
STG_HAZARD_RISK_LEVEL_MASTER |
Stage Hazard Risk Level Master |
DIM_HAZARD_RISK_LEVEL |
Hazard Risk Level Dimension |
802 |
STG_HAZ_RISK_OVRDE_TYPE_MASTER |
Stage Hazard Risk Override Type Master |
DIM_HAZ_RISK_OVRDE_TYPE |
Hazard Risk Override Type Dimension |
807 |
STG_POL_ASSET_SUB_TYPE_MASTER |
Stage Policy Asset Sub Type Master |
DIM_POL_ASSET_SUB_TYPE |
Policy Asset Sub Type Dimension |
808 |
STG_POL_ASSET_VAL_TYPE_MASTER |
Stage Policy Asset Valuation Type Master |
DIM_POL_ASSET_VAL_TYPE |
Policy Asset Valuation Type Dimension |
809 |
STG_POL_COV_ASSET_MASTER |
Stage Policy Covered Asset Master |
DIM_POL_COV_ASSET |
Policy Covered Asset Dimension |
810 |
STG_POLICY_ASSET_TYPE_MASTER |
Stage Policy Asset Type Master |
DIM_POLICY_ASSET_TYPE |
Policy Asset Type Dimension |
811 |
STG_RISK_QUALIFIER_TYPE_MASTER |
Stage Risk Qualifier Type Master |
DIM_RISK_QUALIFIER_TYPE |
Risk Qualifier Type Dimension |
Policy Assets T2T and its description are given here.
Table 164: Policy Assets T2T and its description
T2T Name |
T2T Description |
T2T_FCT_POL_COV_ASSET_DTLS |
Stores details of the assets covered in the policy. |
T2T_FCT_POLICY_COV_ASSET_MAP |
Stores the mapping identification information between the policy and the covered asset. |
The mapping details for Policy Assets T2T is given here.
Table 165: The mapping details for Policy Assets T2T
Source Table Name |
Logical Stage Table Name |
Fact Table Name |
Logical Fact Table Name |
T2T Name |
STG_POL_COV_ASSET_DTLS |
Stage Policy Covered Asset Details |
FCT_POL_COV_ASSET_DTLS |
Fact Policy Covered Asset Details |
T2T_FCT_POL_COV_ASSET_DTLS |
STG_POLICY_COV_ASSET_MAP |
Stage Policy Coverage Asset Map |
FCT_POLICY_COV_ASSET_MAP |
Fact Policy Coverage Asset Map |
T2T_FCT_POLICY_COV_ASSET_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.0.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.