Touchstone 4.0 Database Documentation
tRRRR_LOSS_AnnualEP_ByModel Table
Description
Stores annual exceedance probability losses by model. This table is created for each analysis. By default, for each year in the analysis that experienced loss for a specified model, 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 Date5/31/2016 9:45 AM
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 EPAnnualTypeCode

Code that indicates whether the model 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 EPCurveTypeCode

Code that indicates whether the model losses are based on AIR’s default EP curve or on user-specified loss uncertainty percentiles.

For a complete list of codes, see tEPCurveType Table

VarChar10   
Primary Key FinancialPerspectiveCode

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

For a complete list of codes, see tFinancialPerspective Table.

VarChar10   
Primary Key EPTargetTypeCode

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

For a complete list of codes, see tEPTargetType Table.

VarChar10   
Primary Key ModelCode

Code that represents the catastrophe model.

For a complete list of codes, see tModel Table.

UnsignedTinyInt1   
Primary Key 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.

Integer4   
Primary Key EPTargetSID

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

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

Integer4   
Primary Key RankUnique identifier of the event that produced the highest model loss in the simulated year.Integer4   
 EventIDIdentifier of the event that produced the highest model loss in the simulated yearInteger4  
 YearIDIn multi-year catalogs, each scenario actually consists of five modeled years. The unique identifier tracks the scenario.Integer4  
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
 ExceedanceProbabilityProbability that the loss for the simulated year will be equaled or exceeded in any other year.Double9  
 ReturnPeriodYearsExpected value of the interval of time (in years) between years having greater or equal loss.Double9  
 EPLossExpected annual loss for the corresponding point on the exceedance probability curve.Double9  
 TVARLossAverage annual loss for the years beyond the corresponding point on the EP curve (i.e., Tail Value at Risk [TVAR]).Double9  
 MaxLossMaximum annual loss for the corresponding point on the exceedance probability curve. Used to calculate confidence intervals.Double9  
 SDLossStandard deviation from the mean annual expected loss (EV).Double9  
See Also

Related Objects

AIRResult
Locating Results for a Specific Analysis

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.