Touchstone 4.0 Database Documentation
tRRRR_DQ_SCR_ResultDetail Table
Description
Stores result details for the Data Quality - Scoring reports.  Each single table contains detail data for one report.
Properties
Creation Date5/31/2016 9:45 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   
 LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

Integer4  
 LocationIDUser-defined identifier for the location.VarChar100   
 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  
 AreaCode

Area code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 AreaNameName of the area.VarChar255  
 SubareaCode

Subarea code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 SubAreaNameName of the subarea.VarChar255  
 PostalCode

Postal code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 PostalNameName for the postal code.VarChar255  
 AddressStreet address for the location.VarChar255  
 ExposureSetSID

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

For a complete list of records, see tExposureSet Table.

Integer4  
 ExposureSetNameName of the exposure set.VarChar255   
 ExposureViewSID

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

For a complete list of records, see tExposureView Table.

Integer4  
 ExposureViewNameName of the exposure view.VarChar255  
 ScorePerilName of the peril that serves as the basis for the loss cost used to calculate hazard-specific component of the risk score.VarChar50  
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4  
 UserLOBSID

Unique system-generated sequential identifier for the user's Line of Business record.

Integer4  
 UserLineOfBusinessUser's Line of Business.VarChar60  
 FormLOBSID

Unique system-generated sequential identifier for the contract's Line of Business record.

Integer4  
 PolicyFormName of the policy form.  VarChar60  
 ContractSID

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see tContract Table.

Integer4  
 ContractIDUser-provided identifier for the contract.VarChar100   
 ScoreDQS

Data Quality score that is calculated based on the scoring data provided by the AIR DQIndustry database.

This score is combined with ScoreARI, ScoreDQU, and ScoreBRI values to determine the Overall Risk score and Data Quality Score.

Double9  
 ScoreARI

Referred to on the user interface as the Overall Risk Score, this is the adjusted risk index score that is calculated based on the scoring data provided by the AIR DQIndustry database.

This score is combined with ScoreDQS, ScoreDQU and ScoreBRI values to determine the Overall Risk score and Data Quality Score.

A higher Overall Risk Score indicates greater risk based on geography, replacement value, and the primary attributes of each location.

Double9  
 ScoreBRI

Base risk index score that is calculated based on the scoring data provided by the AIR DQIndustry database

This score is combined with ScoreDQS, ScoreDQU, and ScoreARI values to determine the Overall Risk score and Data Quality Score.

Double9  
 ScoreDQU

Data Quality Uncertainty score that is calculated based on the scoring data provided by the AIR DQIndustry database

This score is calculated by subtracting the ScoreBRI from ScoreARI.

Double9  
 ScoreRFReserved for future use.Double9  
 ReplacementValueACombined Coverage A replacement value of flagged location(s).Double9  
 ReplacementValueBCombined Coverage B replacement value of flagged location(s).Double9  
 ReplacementValueCCombined Coverage C replacement value of flagged location(s).Double9  
 ReplacementValueDCombined Coverage D replacement value of flagged location(s).Double9  
 TotalReplacementValueSum of replacement value for all coverages.Double9  
 ScoreConstructionConstruction class description.VarChar50  
 ScoreOccupancyOccupancy class description.VarChar50  
 ScoreHeightHeight of the structure.Integer4  
 ScoreYearBuiltYear the structure was built.Integer4  
 GeoCodeGeocode values for the location.VarChar50  
 CityCity in which the location resides.VarChar255  
 LatitudeLatitude coordinate for the city.  Values will be positive for locations north of the equator and negative south of the equator.Numeric9 (9,6)  
 LongitudeLongitude coordinate for the city.  Values will be negative for locations west of the prime meridian up to the international date line. They will be positive for locations east of the prime meridian.Numeric9 (9,6)  
 OriginalCurrency

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

Char3  
 AreaFips

FIPS code where the location resides.  FIPS is an acronym for Federal Information Processing Standards.

For a complete list of codes, see tGeography Table.

VarChar15  
 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 database that stores the exposure information.VarChar255  
 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

Integer4  
See Also

Related Objects

AIRResult
Locating Results for a Specific Analysis

 

 


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.