Touchstone 4.0 Database Documentation
tRRRR_LOSS_ByGeo Table
Description
Stores geography-level loss results from a detailed Loss analysis. This table is created when the user selects a geographic area from the "Geography" drop-down box in the analysis Output Options.
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 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 EventIDUnique system-provided identifier of the event that produced the loss.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 YearIDUnique identifier that tracks the scenario. In multi-year catalogs, each scenario actually consists of five modeled years.Integer4   
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 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete set of records, see tGeography Table.

Integer4   
 GroundUpLossGround-Up loss value prior to the application of terms. For reinsurance, this is the ground-up loss for the treaty.Double9  
 RetainedLossRetained loss value, which is the Ground-Up loss minus the insured Gross loss.Double9  
 PreLayerGrossLossPre-layer Gross loss value, which is the expected gross loss value before the application of layer-level terms.Double9  
 GrossLossGross loss value, which is the loss after layer-level terms are applied.Double9  
 NetOfPreCATLossNet-of-Pre Catastrophe loss value, which is the expected net loss value before the application of catastrophe excess of loss reinsurance.Double9  
 PostCATNetLossNet-of-Post Catastrophe loss value, which is the expected net loss value after the application of catastrophe excess of loss reinsurance.Double9  
 TotalPerRiskReRecoveryLossTotal expected per-risk reinsurance recovery loss value.Double9  
 GroundUpSDStandard deviation of the Ground-Up loss value.Double9  
 RetainedSDStandard deviation of the Retained loss value.Double9  
 PreLayerGrossSDStandard deviation of the pre-layer Gross loss value.Double9  
 GrossSDStandard deviation of the Gross loss value.Double9  
 GroundUpMaxLossMaximum Ground-up loss value.Double9  
 RetainedMaxLossMaximum Retained loss value.Double9  
 PreLayerGrossMaxLossMaximum pre-layer Gross loss value.Double9  
 GrossMaxLossMaximum Gross loss value.Double9  
 GroundUpLoss_MinorGround-Up loss value for workers' compensation minor medical injury.Double9  
 GroundUpLoss_ModerateGround-Up loss value for workers' compensation moderate medical injury.Double9  
 GroundUpLoss_MajorGround-Up loss value for workers' compensation major medical injury.Double9  
 GroundUpLoss_FatalGround-Up loss value for workers' compensation fatal medical injury.Double9  
 GrossLoss_MinorGross loss value for workers' compensation minor medical injury.Double9  
 GrossLoss_ModerateGross loss value for workers' compensation moderate medical injury.Double9  
 GrossLoss_MajorGross loss value for workers' compensation major medical injury.Double9  
 GrossLoss_FatalGross loss value for workers' compensation fatal medical injury.Double9  
 NetOfPreCATLoss_MinorNet-of-Pre Catastrophe loss value for workers' compensation minor medical injury.Double9  
 NetOfPreCATLoss_ModerateNet-of-Pre Catastrophe loss value for workers' compensation moderate medical injury.Double9  
 NetOfPreCATLoss_MajorNet-of-Pre Catastrophe loss value for workers' compensation major medical injury.Double9  
 NetOfPreCATLoss_FatalNet-of-Pre Catastrophe loss value for workers' compensation fatal medical injury.Double9  
 PostCATNetLoss_MinorNet-of-Post Catastrophe loss value for workers' compensation minor medical injury.Double9  
 PostCATNetLoss_ModerateNet-of-Post Catastrophe loss value for workers' compensation moderate medical injury.Double9  
 PostCATNetLoss_MajorNet-of-Post Catastrophe loss value for workers' compensation major medical injury.Double9  
 PostCATNetLoss_FatalNet-of-Post Catastrophe loss value for workers' compensation fatal medical injury.Double9  
 InjuryCount_MinorNumber of workers' compensation minor medical injuries.Double9  
 InjuryCount_ModerateNumber of workers' compensation moderate medical injuries.Double9  
 InjuryCount_MajorNumber of workers' compensation major medical injuries.Double9  
 InjuryCount_FatalNumber of workers' compensation fatal medical injuries.Double9  
 GroundUpLoss_AGround-Up loss value for Coverage A.Double9  
 GroundUpLoss_BGround-Up loss value for Coverage B.Double9  
 GroundUpLoss_CGround-Up loss value for Coverage C.Double9  
 GroundUpLoss_DGround-Up loss value for Coverage D.Double9  
 RetainedLoss_ARetained loss value for Coverage A.Double9  
 RetainedLoss_BRetained loss value for Coverage B.Double9  
 RetainedLoss_CRetained loss value for Coverage C.Double9  
 RetainedLoss_DRetained loss value for Coverage D.Double9  
 PreLayerGrossLoss_APre-layer Gross loss value for Coverage A.Double9  
 PreLayerGrossLoss_BPre-layer Gross loss value for Coverage B.Double9  
 PreLayerGrossLoss_CPre-layer Gross loss value for Coverage C.Double9  
 PreLayerGrossLoss_DPre-layer Gross loss value for Coverage D.Double9  
 GrossLoss_AGross loss value for Coverage A.Double9  
 GrossLoss_BGross loss value for Coverage B.Double9  
 GrossLoss_CGross loss value for Coverage C.Double9  
 GrossLoss_DGross loss value for Coverage D.Double9  
 NetOfPreCATLoss_ANet-of-Pre Catastrophe loss value for Coverage A.Double9  
 NetOfPreCATLoss_BNet-of-Pre Catastrophe loss value for Coverage B.Double9  
 NetOfPreCATLoss_CNet-of-Pre Catastrophe loss value for Coverage C.Double9  
 NetOfPreCATLoss_DNet-of-Pre Catastrophe loss value for Coverage D.Double9  
 GroundUpSD_AGround-Up loss standard deviation for Coverage A.Double9  
 GroundUpSD_BGround-Up loss standard deviation for Coverage B.Double9  
 GroundUpSD_CGround-Up loss standard deviation for Coverage C.Double9  
 GroundUpSD_DGround-Up loss standard deviation for Coverage D.Double9  
 RetainedSD_ARetained loss standard deviation for Coverage A.Double9  
 RetainedSD_BRetained loss standard deviation for Coverage B.Double9  
 RetainedSD_CRetained loss standard deviation for Coverage C.Double9  
 RetainedSD_DRetained loss standard deviation for Coverage D.Double9  
 PreLayerGrossSD_APre-layer Gross loss standard deviation for Coverage A.Double9  
 PreLayerGrossSD_BPre-layer Gross loss standard deviation for Coverage B.Double9  
 PreLayerGrossSD_CPre-layer Gross loss standard deviation for Coverage C.Double9  
 PreLayerGrossSD_DPre-layer Gross loss standard deviation for Coverage D.Double9  
 GrossSD_AGross loss standard deviation for Coverage A.Double9  
 GrossSD_BGross loss standard deviation for Coverage B.Double9  
 GrossSD_CGross loss standard deviation for Coverage C.Double9  
 GrossSD_DGross loss standard deviation for Coverage D.Double9  
 GroundUpMaxLoss_AMaximum Ground-Up loss for Coverage A.Double9  
 GroundUpMaxLoss_BMaximum Ground-Up loss for Coverage B.Double9  
 GroundUpMaxLoss_CMaximum Ground-Up loss for Coverage C.Double9  
 GroundUpMaxLoss_DMaximum Ground-Up loss for Coverage D.Double9  
 RetainedMaxLoss_AMaximum Retained loss for Coverage A.Double9  
 RetainedMaxLoss_BMaximum Retained loss for Coverage B.Double9  
 RetainedMaxLoss_CMaximum Retained loss for Coverage C.Double9  
 RetainedMaxLoss_DMaximum Retained loss for Coverage D.Double9  
 PreLayerGrossMaxLoss_AMaximum pre-layer Gross loss for Coverage A.Double9  
 PreLayerGrossMaxLoss_BMaximum pre-layer Gross loss for Coverage B.Double9  
 PreLayerGrossMaxLoss_CMaximum pre-layer Gross loss for Coverage C.Double9  
 PreLayerGrossMaxLoss_DMaximum pre-layer Gross loss for Coverage D.Double9  
 GrossMaxLoss_AMaximum Gross loss for Coverage A.Double9  
 GrossMaxLoss_BMaximum Gross loss for Coverage B.Double9  
 GrossMaxLoss_CMaximum Gross loss for Coverage C.Double9  
 GrossMaxLoss_DMaximum Gross loss for Coverage D.Double9  
 ClaimsCountValue of the number of claims caused by the simulated event. Since the application calculates the claims count by estimating the loss in excess of location deductibles, it considers the uncertainty in the damage estimates.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.