Touchstone 4.0 Database Documentation
tRRRR_LOSS_ByMAOL Table
Description
Stores Maximum Any One Life (MAOL) loss results from a detailed Loss analysis. This table is created when the user selects MAOL in the analysis Output Options.
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 CatalogTypeCode

Code that represents the type of catalog used to produced the loss.

For a complete list of codes, see tCatalogType Table.

VarChar10   
Primary Key PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
Primary Key ModelCode

Code that represents the AIR model, associated with the event that produced the highest loss in the simulated year.

For a complete list of codes, see tModel Table.

UnsignedTinyInt1   
Primary Key EventIDUnique system-provided identifier of the event that produced the loss.Integer4   
Primary Key YearIDUnique identifier that tracks the scenario. In multi-year catalogs, each scenario actually consists of five modeled years.Integer4   
 MinorInjuryLossTotal loss value resulting from workers' compensation minor medical injury.Double9  
 ModerateInjuryLossTotal loss value resulting from workers' compensation moderate medical injury.Double9  
 MajorInjuryLossTotal loss value resulting from workers' compensation major medical injury.Double9  
 FatalInjuryLossTotal loss value resulting from workers' compensation fatal medical injury.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.