Touchstone Re 2022 Database Reference
tRRRR_LOSS_ByReAnnualEPSummary_ZonePeril Table
AIRResultRe Database : tRRRR_LOSS_ByReAnnualEPSummary_ZonePeril Table
Description

Stores annual exceedance probability summary losses for one analysis by each combination of geographic zone and peril.

For each year that generated loss, Touchstone Re creates multiple rows. Each row represents one combination of financial perspective and aggregate EP, occurrence EP, aggregate TVAR, or occurrence TVAR. If losses for a given financial perspective in a given year are zero, Touchstone Re does not generate a row for the losses.

Properties
Creation Date4/11/2022 6:17 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

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 tEPAnnualType Table.

varchar10   
Primary Key 

Code that indicates whether the loss is based on AIR’s default EP curve.

Currently, Touchstone Re supports only AIR's default EP curve.

For a complete list of codes, see tEPCurveType Table.

varchar10   
Primary Key 

Code that indicates whether the losses represent exceedance probability losses or TVAR losses.

For a complete list of codes, see tEPType Table.

varchar10   
Primary Key 

Code that represents the financial perspective used to display the losses.

For a complete list of codes, see tFinancialPerspective Table.

varchar10   
Primary Key 

Code that represents the target of the analysis for which losses were produced.

For a complete list of codes, see tEPTargetType Table.

varchar10   
Primary Key 

Numeric code for the single peril or set of perils associated with the losses.

For a complete list of codes, see tPerilSet Table.

int4   
Primary Key 

Unique system-provided identifier for the geographic zone that generated the losses.

int4   
Primary Key 

Unique system-generated sequential identifier for the exposure data source that includes the analysis target.

For a complete list of records, see tDataSource Table.

int4   
Primary Key 

Unique system-generated sequential identifier for the analysis target that generated the losses.

int4   
 Mean annual expected loss, which is the sum of all expected losses for the simulation divided by the number of years of the simulation.float9   
 Standard deviation from the ExpectedValue.float9   
 Loss for the first user-specified point on the exceedance probability curve.float9  
 Loss for the second user-specified point on the exceedance probability curve.float9  
 Loss for the third user-specified point on the exceedance probability curve.float9  
 Loss for the fourth user-specified point on the exceedance probability curve.float9  
 Loss for the fifth user-specified point on the exceedance probability curve.float9  
 Loss for the sixth user-specified point on the exceedance probability curve.float9  
 Loss for the seventh user-specified point on the exceedance probability curve.float9  
 Loss for the eighth user-specified point on the exceedance probability curve.float9  
 Loss for the ninth user-specified point on the exceedance probability curve.float9  
 Loss for the tenth user-specified point on the exceedance probability curve.float9  
 Loss for the eleventh user-specified point on the exceedance probability curve.float9  
 Loss for the twelfth user-specified point on the exceedance probability curve.float9  
 Loss for the thirteenth user-specified point on the exceedance probability curve.float9  
 Loss for the fourteenth user-specified point on the exceedance probability curve.float9  
 Loss for the fifteenth user-specified point on the exceedance probability curve.float9  
See Also

Related Objects

AIRResultRe Database