Touchstone 2022 Database Reference
tEXPS_LOSSExcludedControlTotal Table
AIRExposureSummary Database : tEXPS_LOSSExcludedControlTotal Table
Description
Stores information about locations that Touchstone excluded from a loss analysis. Touchstone uses this information to generate the AIR Modeled Exposure Statistics Summary report.
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 ResultSID

Unique system-generated sequential identifier for the results record.

For a complete list of records, see tAnalysisResult Table.

int4   
Primary Key ExposureDataSourceSID

Unique system-generated sequential identifier for the exposure data source record.

For a complete list of records, see tDataSource Table.

int4   
 ExposureDataSourceNameName of the source for the exposure data.varchar255  
Primary Key LossExcludedExposureTypeCode

Indicates why Touchstone excluded the location:

  • 1 = Location not compatible with event set
  • 2 = Location in unlicensed country
  • 3 = Location missing geocode
  • 4 = Location has invalid features
smallint2   
 ContractsTotal number of excluded contracts.int4  
 LocationsTotal number of excluded locations.bigint8   
 TotalReplacementValueAccumulated replacement value for all excluded locations.float9   
 TotalLimitsTotal combined limits for all excluded locations.float9  
See Also

Related Objects

AIRExposureSummary Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.