Touchstone 2022 Database Reference
tRRRR_IMPACT_AnnualEPSummary Table
AIRExposureSummary Database : tRRRR_IMPACT_AnnualEPSummary Table
Description
Stores annual exceedance probability summary losses for a marginal impact assessment.
Properties
Creation Date4/11/2022 6:15 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 

Identifier for the administrative boundary and peril combination associated with the results.

For a complete list of combinations, see tImpactAdminBoundaryPerilSetXref Table.

smallint2   
Primary Key 

Numeric code for the single peril or set of perils which impact the region.

For a complete list of codes, see tPerilSet Table.

varchar10   
Primary Key 

Code that represents the perspective used to display the losses.

For a complete list of codes, see tFinancialPerspective Table.

varchar10   
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 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 tEPCurveType Table.

varchar10   
Primary Key 

Code that represents the type of Exceedance Probability curve.

For a complete list of codes, see tEPType Table.

varchar10   
Primary Key 

Code that represents type of data represented in the EP curve.

For a complete list of codes, see tEPTargetType Table.

varchar10   
Primary Key 

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.

int4   
Primary Key 

Unique system-generated sequential identifier for the target  record for which the losses were aggregated

For example, f the EP target type is Contract, then this is the ContractSID.

int4   
 Mean annual expected loss ("expected value"), which is determined by taking the sum of all expected losses for the simulation and dividing by the number of years of the simulation.float9   
 Standard deviation from the mean annual expected loss (EV).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.thierfloat9  
 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

AIRExposureSummary Database