Touchstone 2022 Database Reference
tRRRR_LOSS_ByMAOLGeo Table
AIRExposureSummary Database : tRRRR_LOSS_ByMAOLGeo Table
Description
Stores Maximum Any One Life (MAOL) and geographic loss results from a detailed Loss analysis. This table is created when the user specifies "Save Loss By Geography" and selects MAOL in the analysis Output Options.
Properties
Creation Date4/11/2022 6:15 PM
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 

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

For a complete list of codes, see tCatalogType Table.

varchar10   
Primary Key 

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

int4   
Primary Key 

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.

smallint2   
Primary Key Unique system-provided identifier of the event that produced the loss.int4   
Primary Key Unique identifier that tracks the scenario. In multi-year catalogs, each scenario actually consists of five modeled years.int4   
Primary Key 

Unique system-generated sequential identifier for the geographic record.

For a complete set of records, see tGeography Table.

int4   
 Total loss value resulting from workers' compensation minor medical injury.float9  
 Total loss value resulting from workers' compensation moderate medical injury.float9  
 Total loss value resulting from workers' compensation major medical injury.float9  
 Total loss value resulting from workers' compensation fatal medical injury.float9  
See Also

Related Objects

AIRExposureSummary Database