Touchstone 4.0 Database Documentation
tRRRR_DQ_IDB_ResultDetail Table
Description
Stores report details for the Data Quality - Industry Data Benchmark reports.
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 ResultDetailSID

Unique system-generated sequential identifier for the detailed results record.

For a complete list of records, see tAnalysisResult Table.

Integer4   
 CountryNameName of the country.VarChar255  
 AreaNameName of the area.VarChar255  
 SubAreaNameName of the subarea.VarChar255  
 CountryCode

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

For a complete list of codes, see tCountry Table.

VarChar15  
 AreaCode

Area code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 SubareaCode

Subarea code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 UserLineOfBusinessUser's Line of Business.VarChar60  
 ConstructionCode

Code that represents the construction type.

For a complete list of codes, see tAIRConstruction Table

Integer4  
 OccupancyCode

Code that represents the occupancy type.

For a complete list of codes, see tAIROccupancy Table . 

Integer4  
 RiskCountTotal number of risks in the corresponding location.Integer4  
 ExposureViewNameName of the exposure view.VarChar255  
 ExposureSetNameName of the exposure set.VarChar255  
 ContractIDUnique identifier for the contract.VarChar100  
 ExposureViewSID

Unique system-generated sequential identifier for the exposure view record.

For a complete list of records, see tExposureView Table.

Integer4  
 ExposureSetSID

Unique system-generated sequential identifier for the exposure set record.

For a complete list of records, see tExposureSet Table.

Integer4  
 ContractSID

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see tContract Table.

Integer4  
 guidAreaExternalGUID for the geography information. Same value as GeographySID.Binary16  
 UserReplacementValueAUser-supplied Coverage A replacement value.Double9  
 UserReplacementValueCUser-supplied Coverage C replacement value.Double9  
 UserReplacementValueDUser-supplied Coverage D replacement value.Double9  
 IndustryReplacementValueA

Industry replacement value for Coverage A.

Double9  
 IndustryReplacementValueC

Industry replacement value for Coverage C.

Double9  
 IndustryReplacementValueD

Industry replacement value for Coverage D.

Double9  
 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

Integer4  
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.