Touchstone 4.0 Database Documentation
tRRRR_LOSS_AnnualEPSummary Table
Description
Stores annual exceedance probability summary losses. This table is created for each analysis. By default, the table will contain rows for each financial perspective for which results are saved, one row each for aggregate EP, occurrence EP, aggregate TVAR, and occurrence TVAR. The table may contain additional rows if the user requests additional EP curves for subsets of the results.
Properties
Creation Date5/31/2016 9:46 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 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 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 EPTypeCode

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 FinancialPerspectiveCode

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

For a complete list of codes, see tFinancialPerspective Table.

VarChar10   
Primary Key EPTargetTypeCode

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 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 losses were aggregated

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

Integer4   
 ExpectedValueThe 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.Double9   
 StandardDeviationStandard deviation from the mean annual expected loss (EV).Double9   
 EP1LossLoss for the first user-specified point on the exceedance probability curve.Double9  
 EP2LossLoss for the second user-specified point on the exceedance probability curve.Double9  
 EP3LossLoss for the third user-specified point on the exceedance probability curve.Double9  
 EP4LossLoss for the fourth user-specified point on the exceedance probability curve.Double9  
 EP5LossLoss for the fifth user-specified point on the exceedance probability curve.Double9  
 EP6LossLoss for the sixth user-specified point on the exceedance probability curve.Double9  
 EP7LossLoss for the seventh user-specified point on the exceedance probability curve.Double9  
 EP8LossLoss for the eighth user-specified point on the exceedance probability curve.Double9  
 EP9LossLoss for the ninth user-specified point on the exceedance probability curve.Double9  
 EP10LossLoss for the tenth user-specified point on the exceedance probability curve.Double9  
 EP11LossLoss for the eleventh user-specified point on the exceedance probability curve.Double9  
 EP12LossLoss for the twelfth user-specified point on the exceedance probability curve.Double9  
 EP13LossLoss for the thirteenth user-specified point on the exceedance probability curve.Double9  
 EP14LossLoss for the fourteenth user-specified point on the exceedance probability curve.Double9  
 EP15LossLoss for the fifteenth user-specified point on the exceedance probability curve.Double9  
See Also

Related Objects

AIRExposureSummary Database

 

 


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.