Touchstone 4.0 Database Documentation
tRRRR_IMPACT_AnnualEPSummary Table
Description
Stores annual exceedance probability summary losses for a marginal impact assessment.
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 ImpactRegionPerilSetCode

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

For a complete list of codes, see tPerilSet Table.

SmallInt2   
Primary Key OutputTypeCode

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 FinancialPerspectiveCode

Code that represents the perspective used to display the losses.

For a complete list of codes, see tFinancialPerspective Table.

VarChar10   
Primary Key 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 tEPAnnualType Table

VarChar10   
Primary Key EPCurveTypeCode

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 EPTypeCode

Code that represents the type of Exceedance Probability curve.

For a complete list of codes, see tEPType Table.

VarChar10   
Primary Key EPTargetTypeCode

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

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, f the EP target type is Contract, then this is the ContractSID.

Integer4   
 ExpectedValueMean 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.thierDouble9  
 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.