Touchstone 4.0 Database Documentation
tRRRR_DQ_DVA_ResultDetail Table
Description
Stores result details for the Data Quality - Validation reports. Each table contains detail data for one report and every location in the report is represented by a record. See tRRRR_DQ_DVA_Violations Table to review the multiple rule violations for each location record.
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   
 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  
 LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

Integer4  
 LocationIDUnique identifier of the location flagged as being in violation of the rule(s).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  
 AddressAddress 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  
 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  
 UserLineOfBusinessName of the user'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  
 ContractIDUnique user-provided identifier for the contract.VarChar100   
 ReplacementValueACoverage A replacement value for the location.Double9  
 ReplacementValueBCoverage B replacement value for the location.Double9  
 ReplacementValueCCoverage C replacement value for the location.Double9  
 ReplacementValueDCoverage D replacement value for the location.Double9  
 TotalReplacementValueSum of replacement value for all coverages.Double9  
 TotalInsuredValue(TIV) Monetary value of coverage (across all coverages) paid out as a result of a catastrophe for the corresponding location.Double9  
 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)  
 SubmitStatus

Code for the submission status.

For a complete list of codes, see tSubmitStatus Table.

VarChar60  
 ConstructionCode

Code that represents the construction type.

For a complete list of codes, see tAIRConstruction Table

Integer4  
 ConstructionNameName of the construction type.VarChar255  
 OccupancyCode

Code that represents the occupancy type.

For a complete list of codes, see tAIROccupancy Table

Integer4  
 OccupancyNameName of the occupancy type.VarChar255  
 TotalWeightedScoreReserved for future use.Integer4  
 InceptionDateInception date of the contract.  Also referred to as the Effective FROM Date.DBTimeStamp4  
 ExpirationDateContract expiration date. Also referred to as the Effective TO Date.DBTimeStamp4  
 StoriesHeight of the building.SmallInt2  
 GrossAreaTotal area of the location.Double9  
 ISOBINUnique ISO Building Identification Number (BIN) corresponding to the location.VarChar14  
 PremiumCombined premiums of flagged locations in the corresponding location.Double9  
 RiskCountTotal number of risks in the corresponding location.Integer4  
 YearBuiltYear the building corresponding to the location was built.SmallInt2  
 StatusNameName corresponds to the SubmitStatus value.VarChar200  
 PerilSet

Name corresponds to the PerilSetCode value.

VarChar255  
 GeoMatchLevelCode

Code for the level at which geocode match occurred.

For a complete list of codes, see tGeoMatchLevel Table.

VarChar10  
 GeoMatchLevel

Name for the level at which geocode match occurred.

VarChar50  
 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  
 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

Integer4  
Objects that depend on tRRRR_DQ_DVA_ResultDetail
 Database ObjectObject TypeDescriptionDep Level
tRRRR_DQ_DVA_ResultDetailTerms tabletRRRR_DQ_DVA_ResultDetailTermsTableStores detailed term result for the Data Quality - Validation reports.1
tRRRR_DQ_DVA_Violations tabletRRRR_DQ_DVA_ViolationsTableStores all Data Quality - Validation rule violations for each location record in tRRRR_DQ_DVA_ResultDetail Table. Each single table contains detail data for one report and each row represents a failed rule for specific location. The ViolationDescription attribute combines the information from rule and rule set for easy access. (For example "RV A is less than 50000")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.