Touchstone 4.0 Database Documentation
tEXPS_ByPeril Table
Description

Stores the data displayed on the Exposure Summary Dashboard when "Peril - Distribution of Replacement Values by Peril" is selected from the View 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 ResultSID

Unique system-generated sequential identifier for the results record.

For a complete list of records, see tAnalysisResult Table.

Integer4   
Primary Key PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
 PerilSetName of the peril.VarChar255   
 Locations

Total number of locations within the designated peril.

BigInt8  
 PercentOfLocations

Number of locations within the designated peril, expressed as a percent of all the locations.

Single4  
 TotalReplacementValue

Accumulated replacement value for all locations.

Double9  
 PercentOfTRV

Total combined replacement value for all locations within the designated peril, expressed as a percent of the total replacement value.

Single4  
 AvgReplacementValue

Average replacement value of all locations within the designated peril.

Double9  
 MaxReplacementValue

Highest replacement value of all locations within the designated peril.

Double9  
 MinReplacementValue

Lowest replacement value of all locations within the designated peril.

Double9  
 ReplacementValueAAccumulated  Coverage A replacement value for all locations within the designated peril.Double9  
 ReplacementValueBAccumulated  Coverage B replacement value for all locations within the designated peril.Double9  
 ReplacementValueCAccumulated  Coverage C replacement value for all locations within the designated peril.Double9  
 ReplacementValueDAccumulated  Coverage D replacement value for all locations within the designated peril.Double9  
 Premium

Combined premiums for all locations within the designated peril.

Double9  
 RiskCount

Total number of risks within the designated peril. May differ from the Location Count value if any of your location records represent aggregate data.

BigInt8  
 Limit1Accumulated Coverage A limit for all locations within the designated peril.Double9  
 Limit2Accumulated Coverage B limit for all locations within the designated peril.Double9  
 Limit3Accumulated Coverage C limit for all locations within the designated peril.Double9  
 Limit4Accumulated Coverage D limit for all locations within the designated peril.Double9  
 Deductible1Accumulated Coverage A deductible amount for all locations within the designated peril.Double9  
 Deductible2Accumulated Coverage B deductible amount for all locations within the designated peril.Double9  
 Deductible3Accumulated Coverage C deductible amount for all locations within the designated peril.Double9  
 Deductible4Accumulated Coverage D deductible amount for all locations within the designated peril.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.