Touchstone 4.0 Database Documentation
tRRRR_TTTT_CMPLOSS_AnnualEPSummary Table
Description

Stores the deltas for the aggregate annual exceedance probability summary that are calculated during a Comparative Loss analysis. 

tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.
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 AnnualEPRowIDSystem-assigned table row identifier for the annual EP.Integer4   
 ExpectedValueThe delta in the mean annual expected loss (“expected value”).Double9  
 StandardDeviationStandard deviation delta.Double9  
 EP1LossLoss delta for the first user-specified point on the exceedance probability curve.Double9  
 EP2LossLoss delta for the second user-specified point on the exceedance probability curve.Double9  
 EP3LossLoss delta  for the third user-specified point on the exceedance probability curve.Double9  
 EP4LossLoss delta for the fourth user-specified point on the exceedance probability curve.Double9  
 EP5LossLoss delta for the fifth user-specified point on the exceedance probability curve.Double9  
 EP6LossLoss delta for the sixth user-specified point on the exceedance probability curve.Double9  
 EP7LossLoss delta for the seventh user-specified point on the exceedance probability curve.Double9  
 EP8LossLoss delta for the eighth user-specified point on the exceedance probability curve.Double9  
 EP9LossLoss delta for the ninth user-specified point on the exceedance probability curve.Double9  
 EP10LossLoss delta for the tenth user-specified point on the exceedance probability curve.Double9  
 EP11LossLoss delta for the eleventh user-specified point on the exceedance probability curve.Double9  
 EP12LossLoss delta for the twelfth user-specified point on the exceedance probability curve.Double9  
 EP13LossLoss delta for the thirteenth user-specified point on the exceedance probability curve.Double9  
 EP14LossLoss delta for the fourteenth user-specified point on the exceedance probability curve.Double9  
 EP15LossLoss delta for the fifteenth user-specified point on the exceedance probability curve.Double9  
Objects that tRRRR_TTTT_CMPLOSS_AnnualEPSummary depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_CMPLOSS_AnnualEPKey tabletRRRR_CMPLOSS_AnnualEPKeyTable

Stores annual exceedance probability losses to be used a Comparative Loss analysis. This table is created for each comparative Loss analysis. By default, for each year in the analysis that experienced loss, 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.    

1
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.