Touchstone 2022 Database Reference
tEXPS_ByCountryLOBOccupancy Table
AIRResult : tEXPS_ByCountryLOBOccupancy Table
Description
Stores the data displayed on the Exposure Summary Dashboard when “LOB- Distribution of Replacement value by User Line of Business” option  is selected from the View Options.
Properties
Creation Date4/11/2022 5:46 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 UserLineOfBusinessUser's Line of Business.varchar60   
Primary Key CountryCode

ISO 2-character code for the country in which the location resides. 

For a complete list of codes, see tCountry Table.

varchar15   
 CountryNameName of the country.varchar255  
Primary Key OccupancyCategory

Description of the occupancy class.

varchar40   
Primary Key ContractTypeCode

Code for the contract type.

For a complete list of codes, see tContractType Table.

varchar10   
 TotalReplacementValue

Accumulated replacement value for all locations.

float9  
 Locations

Total number of locations within the designated category.

bigint8  
See Also

Related Objects

AIRResult
Locating Results for a Specific Analysis

 

 

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.