RRAOOVERRIDES - Atoti Hub

The RRAOOVERRIDES table contains the Override definitions for RRAO categories.

Column Name	Type	Not Null
RRAOCATEGORY	STRING	Y
RISK_CLASS	STRING	Y
PARAMETER_SET	STRING	Y
RESIDUAL_RISK	STRING
EXOTIC_UNDERLYING	STRING
OTHER_RESIDUAL_RISK_TYPE	STRING
AS_OF_DATE	STRING	Y
EXEMPTION_REASON	STRING	Y
ASSET_CLASS	STRING	Y

Unique Key

Override Parameter	RRAO Table Field
OVERRIDE KEY FIELD	RRAOCATEGORY
OVERRIDE DATE FIELD	AS_OF_DATE

Where:

Override Parameter: The parameters to determine where to apply this override.
RRAO Table Field: The field in the RRAO base table for this override.

Create Base Store Tuples

See the Create Override Tuples section for an example of how to create the override tuples for the following override fields. These are the fields we want to override in the base override table, in this case the RRAO Table.

Override Table
RESIDUAL_RISK
EXOTIC_UNDERLYING
OTHER_RESIDUAL_RISK_TYPE

These fields form an intermediate table containing the Override’s base store fields and will be merged back into the Override base table: RRAO.

Map Override Fields to Base Table Fields

Once you create your tuples for each override field, you can then map the tuples back to the base store using the following relationship:

Override Table	RRAO Field	Note
OVERRIDE KEY FIELD	RRAOCATEGORY
OVERRIDE DATE FIELD	AS_OF_DATE
PARAMETER_SET		No mapping exists
RESIDUAL_RISK	RESIDUAL_RISK
EXOTIC_UNDERLYING	EXOTIC_UNDERLYING
OTHER_RESIDUAL_RISK_TYPE	OTHER_RESIDUAL_RISK_TYPE
EXEMPTION_REASON	EXEMPTION_REASON
ASSET_CLASS	ASSET_CLASS
	RISK_CLASS	No mapping exists

​Unique Key

​Create Base Store Tuples

​Map Override Fields to Base Table Fields

Unique Key

Create Base Store Tuples

Map Override Fields to Base Table Fields