Touchstone 4.0 Database Documentation
tRRRR_DQ_AUG_ResultDetail Table
Description
Report detail results for the Data Quality - Augmentation 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 result details 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 source of the exposure data.VarChar255  
 AreaNameName of the area.VarChar255  
 CountryCode

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

For a complete list of codes, see tCountry Table.

VarChar15  
 SubareaCode

Subarea code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 SubAreaNameName of the subarea.VarChar255  
 CountryNameName of the country.VarChar255  
 LocationIDUnique user-provided identifier for the location.VarChar100  
 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  
 AreaCode

Area code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 PostalCode

Postal code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 PostalNameName of the postal code.VarChar255  
 ContractSID

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see tContract Table.

Integer4  
 ExposureViewNameName of the exposure view.VarChar255  
 ExposureSetSID

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

For a complete list of records, see tExposureSet Table.

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

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

For a complete list of records, see tExposureView Table.

Integer4  
 ConstructionCode

Code that represents the construction type.

For a complete list of codes, see tAIRConstruction Table

Integer4  
 AddressStreet address for the location.VarChar255  
 OccupancyCode

Code that represents the occupancy type.

For a complete list of codes, see tAIROccupancy Table

Integer4  
 OccupancyNameName of the occupancy type.VarChar255  
 OriginalCurrency

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

Char3  
 ReplacementValueACoverage A replacement value for the location.Double9  
 StoriesHeight of the building.SmallInt2  
 ReplacementValueDCoverage D replacement value for the location.Double9  
 CityCity in which the location residesVarChar255  
 ConstructionNameName of the construction type.VarChar255  
 FormLOBSID

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

Integer4  
 ReplacementValueCCoverage C replacement value for the location.Double9  
 TotalInsuredValue(TIV) Monetary value of coverage (across all coverages) paid out as a result of a catastrophe for the corresponding location.Double9  
 TotalReplacementValueSum of replacement value for all coverages.Double9  
 GrossAreaTotal area of the location.Double9  
 LatitudeLatitude coordinate for the city.  Values will be positive for locations north of the equator and negative south of the equator.Numeric9 (9,6)  
 PolicyFormName of the policy form.  VarChar60  
 ExposureSetNameName of the exposure set.VarChar255  
 ReplacementValueBCoverage B replacement value for the location.Double9  
 LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

Integer4  
 ISOBINUnique ISO Building Identification Number (BIN) corresponding to the location.VarChar14  
 NewBINISOBIN after augmentation.Boolean1  
 YearBuiltYear the building corresponding to the location was built.SmallInt2  
 ContractIDUnique user-provided identifier for the contract.VarChar100  
 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  
 LocPhyPropsBinDataLocation’s physical properties.Binary512  
 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

Integer4  
 AuditStatusCode

Code that represents the status of exposure data import.

For a complete list of codes, see tAuditStatus Table.

Integer4  
Objects that depend on tRRRR_DQ_AUG_ResultDetail
 Database ObjectObject TypeDescriptionDep Level
tRRRR_DQ_AUG_ResultValues tabletRRRR_DQ_AUG_ResultValuesTableDefines actual values referenced by the augmentation rules. Stores both user and industry value for easy comparison and augmentation. Referenced by the  tRRRR_DQ_AUG_ResultDetail Table to provide multiple values per location. Each location affected by the augmentation should have an ISOBIN record within this table to keep track of the augmentation data source.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.