Touchstone 4.0 Database Documentation

Stores the deltas for the aggregate annual exceedance probability losses 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.
Creation Date5/31/2016 9:45 AM
Text File Group
System Object
Published for Replication
Data Space Used0.00 KB
Index Space Used0.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AnnualEPRowIDSystem-assigned table row identifier for the annual EP. Integer4   
Primary Key RankUnique identifier of the highest annual exceedance probability loss in the simulated year.Integer4   

System-assigned table row identifier for the event

 ExceedanceProbabilityExceedance probability delta for the simulated year.Double9  
 ReturnPeriodYearsValue of the interval of time (in years) between years.Double9  
 EPLossAnnual loss delta for the corresponding point on the exceedance probability curve.Double9  
 TVARLossAverage annual loss delta for the years beyond the corresponding point on the EP curve (i.e., Tail Value at Risk [TVAR]).Double9  
 MaxLossMaximum annual loss delta for the corresponding point on the exceedance probability curve.Double9  
 SDLossStandard deviation delta of the mean annual expected loss (EV).Double9  
Objects that tRRRR_TTTT_CMPLOSS_AnnualEP depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_CMPLOSS_AnnualEPKey tabletRRRR_CMPLOSS_AnnualEPKeyTableStores 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
tRRRR_CMPLOSS_EventKey tabletRRRR_CMPLOSS_EventKeyTableStores information about the events used during the Comparative Loss analysis.1
See Also

Related Objects

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.