Touchstone 4.0 Database Documentation
tEXPS_ControlTotal Table
Description

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

Unique system-generated sequential identifier for the results record.

For a complete list of records, see tAnalysisResult Table.

Integer4   
Primary Key ExposureDataSourceSID

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

For a complete list of records, see tDataSource Table.

Integer4   
 ExposureDataSourceNameName of the source for the exposure data.VarChar255  
Primary Key ContractSIDUnique system-generated sequential identifier for the contract record.Integer4   
 Contracts

Total number of contracts.

Integer4  
 Locations

Total number of locations.

BigInt8   
 TotalReplacementValue

Accumulated replacement value for all locations.

Double9   
 TotalLimits

Total combined limits for all locations

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.