tRRRR_CMPLOSS_AnnualEPKey Table

Description

Stores annual exceedance probability losses to be used a Comparative Loss analysis. This table is created for each comparative Loss analysis. By default, for each year in the analysis that experienced loss, the table will contain at most one Aggregate row and one Occurrence row per financial perspective for the Standard EP curve. But if losses for a particular financial perspective in that year were 0, no row is generated. The table may contain additional rows if the user requests additional EP curves for subsets of the results.

Properties

Creation Date	4/11/2022 5:46 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	0
Data Space Used	0.00 KB
Index Space Used	0.00 KB

Columns

Column Name	Description	Datatype	Length
AnnualEPRowID	System-assigned table row identifier for the annual EP.	int	4
EPAnnualTypeCode	Code that indicates whether the corresponding losses are based on all events that occurred during a year (aggregate) or on the single largest loss caused by all events in a year (occurrence). For a complete list of codes, see dbo.tEPAnnualType Table.	varchar	10
EPCurveTypeCode	Code that indicates whether the losses are based on AIR’s default EP curve or on user-specified loss uncertainty percentiles. For a complete list of codes, see dbo.tEPCurveType Table	varchar	10
FinancialPerspectiveCode	Code that represents the financial perspective used to display the losses. For a complete list of codes, see dbo.tFinancialPerspective Table	varchar	10
EPTargetTypeCode	Code that represents the target of the analysis for which losses were produced. For a complete list of codes, see tEPTargetType Table.	varchar	10
ExposureDataSourceSID	Unique system-generated sequential identifier for the exposure data source record in which the EPTargetSID can be found . For a complete list of records, see tDataSource Table.	int	4
EPTargetSID	Unique system-generated sequential identifier for the target record for which the losses were aggregated For example, if the EP target type is Contract, then this is the ContractSID.	int	4

Objects that depend on tRRRR_CMPLOSS_AnnualEPKey

	Database Object	Object Type	Description	Dep Level
	tRRRR_TTTT_CMPLOSS_AnnualEP	Table	Stores the deltas for the aggregate annual exceedance probability losses that are calculated during a Comparative Loss analysis. tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.	1
	tRRRR_TTTT_CMPLOSS_AnnualEPSummary	Table	Stores the deltas for the aggregate annual exceedance probability summary that are calculated during a Comparative Loss analysis. tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.	1

Related Objects