Touchstone 4.0 Database Documentation
tRRRR_CMPLOSS_GeoKey Table
Description

Stores information about the location used during the Comparative Loss analysis.    

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 GeoRowIDSystem-assigned table row identifier for the location.BigInt8   
 GeoLevel

Code that represents the geography level of the exposure.

For a complete list of codes, see .

SmallInt2  
 ExposureDataSourceSID

Unique system-generated sequential identifier for the exposure data source record in which the EPTargetSID can be found .

For a complete list of records, see dbo.tDataSource Table.

Integer4  
 LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see dbo.tLocation Table.

Integer4  
 ExposureSetName

Unique user-defined name for the exposure set.

For a complete list of exposure sets, see dbo.tExposureSet Table.

VarChar255  
 ContractID

Unique user-defined identifier for the contract.

For a complete list of contracts, see dbo.tContract Table

VarChar100  
 LocationID

Unique user-defined identifier for the location.

Corresponds to the identifier in LocationSID

VarChar100  
 CountryGeographySID

Unique system-generated sequential identifier for the country record.

For a complete list of identifiers, see dbo.tGeography Table.

Integer4  
 AreaGeographySID

Unique system-generated sequential identifier for the area record.

For a complete list of identifiers, see dbo.tGeography Table.

Integer4  
 SubAreaGeographySID

Unique system-generated sequential identifier for the subarea record.

For a complete list of identifiers, see dbo.tGeography Table.

Integer4  
 PostalGeographySID

Unique system-generated sequential identifier for the postal code record.

For a complete list of identifiers, see dbo.tGeography Table.

Integer4  
Objects that depend on tRRRR_CMPLOSS_GeoKey
 Database ObjectObject TypeDescriptionDep Level
tRRRR_TTTT_CMPLOSS_GeoAAL tabletRRRR_TTTT_CMPLOSS_GeoAALTable

Stores the deltas for the aggregate average annual losses by location that are calculated during a Comparative Loss analysis.

tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.
1
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.