Touchstone 4.0 Database Documentation
What's New (previous versions)

 

What's New in Touchstone 3.1.0

The following database changes have been introduced in Touchstone 3.1.0, including:

New Table

AIR has added the following database table for Touchstone 3.1.0.

Table Details

 [AIRReference].[dbo].[tSSDepth]

Stores the possible measurement ranges used to define the storm surge depth.

       

Modified Tables

AIR has made modifications to the following database tables for Touchstone 3.1.0.

Table Details

[AIRReference].[dbo].[tFloodSource]

Added code:

  • 0 = No Data

[AIRReference].[dbo].[tHazardAttribute]                                           

Added codes:

  • 220 = SS Flood Zone Category
  • 221 = Shortest Distance to 100-year SSFlood Plain
  • 222 = Shortest Distance to 250-year SSFlood Plain
  • 223 = Shortest Distance to 500-year SSFlood Plain
  • 224 = Depth For 100 Year Flood Plain
  • 225 = Depth For 250 Year Flood Plain
  • 226 = Depth For 500 Year Flood Plain

[AIRReference].[dbo].[tHazardAttributeTableReference]

Added code:

[AIRReference].[dbo].[tLicenseRegion]

Added code:

  • 7 = Africa

Corrected spelling of Caribbean for LicenseRegionCode 2.

What's New in Touchstone 3.0.0

The following database changes have been introduced in Touchstone 3.0.0, including:

New Tables

AIR has added the following database tables for Touchstone 3.0.0.

Table Details

[AIRResult].[dbo].[tRRRR_CMPLOSS_AnnualEPKey]

Stores annual exceedance probability losses to be used a comparative analysis. This table is created for each comparative Loss analysis. By default, for each year in the analysis that experienced loss, the table will contain at most one Aggregate row and one Occurrence row per financial perspective for the Standard EP curve. But if losses for a particular financial perspective in that year were 0, no row is generated. The table may contain additional rows if the user requests additional EP curves for subsets of the results.

[AIRResult].[dbo].[tRRRR_CMPLOSS_ContractKey]

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

[AIRResult].[dbo].[tRRRR_CMPLOSS_EventKey]

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

[AIRResult].[dbo].[tRRRR_CMPLOSS_GeoKey]

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

[AIRResult].[dbo].[tRRRR_CMPLOSS_LOBKey]

Stores information about the Line of Business used during the Comparative Loss analysis.

[AIRResult].[dbo].[tRRRR_HAZ_Intensity]

Stores detailed hazard information for events that cause loss to specific locations during a hazard analysis.

[AIRResult].[dbo].[tRRRR_TTTT_CMPLOSS_AnnualEP]

Stores the deltas for the aggregate annual exceedance probability losses that are calculated during a comparative loss analysis.

[AIRResult].[dbo].[tRRRR_TTTT_CMPLOSS_AnnualEPSummary]

Stores the deltas for the aggregate annual exceedance probability summary that are calculated during a Comparative Loss analysis. 

[AIRResult].[dbo].[tRRRR_TTTT_CMPLOSS_ByEvent]

Stores the deltas for the aggregate event losses that are calculated during a Comparative Loss analysis.

[AIRResult].[dbo].[tRRRR_TTTT_CMPLOSS_ContractLOBAAL]

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

[AIRResult].[dbo].[tRRRR_TTTT_CMPLOSS_GEOAAL]

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

[AIRProject].[dbo].[tActivityHpcJob]

Stores information about each activity that is submitted to the HPC server.

[AIRProject].[dbo].[tComparativeLossAnalysisOption]

Stores the values used to generate the results in a Comparative Loss analysis.

[AIRProject].[dbo].[tComparativeLossAnalysisTargetOption]

Stores information regarding the target analysis in a Comparative Loss analysis.

[AIRProject].[dbo].[tHazardAnalysisOption]

Stores information regarding the options selected for a Hazard analysis.

[AIRProject].[dbo].[tIntensityAttributeOption]

Stores information regarding the intensity attribute used during a Hazard analysis.

[AIRReference].[dbo].[tActivityFailureAction]

Stores the options that define how HPC responds in regards to processing the parent activity when a child activity fails.

[AIRReference].[dbo].[tActivityResourceType]

Defines the location of the resources used to complete an activity, specifically if it occurs in the cloud or on premises.

[AIRReference].[dbo].[tActivityTypeRestrictedActivityTypeXref]

Stores the activities types that are restricted for Azure cloud provisioning/deprovisioning.

[AIRReference].[dbo].[tCopyStatus]

Stores the status options when a user copies/moves contracts to an exposure set.

[AIRReference].[dbo].[tHPCJobPriorityType]

Stores the priority level options that can be assigned to an activity. This table is for reference only, the  job priority values are actually set in HPC job priority settings.

[AIRReference].[dbo].[tIBHSFortified]

Stores certification levels as defined by the Institute for Business and Home Safety, which defines a structure's ability to withstand load resistance.

[AIRReference].[dbo].[tIntensityAttribute]

Stores information about the intensity attributes that may be used during a Hazard analysis.

[AIRReference].[dbo].[tIntensityAttributeType]

Stores parameter options for the intensity attribute.

[AIRReference].[dbo].[tISOConstruction]

Stores ISO construction class information.

[AIRReference].[dbo].[tLossCostType]

Stores the lost cost options for a non-catastrophe loss analysis.

[AIRReference].[dbo].[tMainPerilSubPerilXref]

Stores information about the sub-perils that are associated with a primary peril set. 

[AIRReference].[dbo].[tNonCatPerilGroup]

Stores the ISO peril groups.  These are applicable for commercial, non-catastrophe analyses only.

[AIRReference].[dbo].[tNonCatTemplateRule]

Used for a Non-catastrophe analysis, this table stores information about the defined template rules (filter).

[AIRReference].[dbo].[tObjectBUDefinition]

Stores the options used to define how the map layer wizard is to retrieve the object(s) association with a business unit. This is used for managing custom map layers.

[AIRReference].[dbo].[tProvisionStatus]

Stores the possible provisioning status options, which represent the stage in the configuration process for preparing a client's Azure account to run analytics in the cloud.

[AIRUserSetting].[dbo].[tDefaultDatabaseOption]

Stores the database name prefix for the AIRResult and AIRExposure databases. When defined in the Business Unit Management section of the Administration Console, Touchstone automatically assigns the prefix to the user-defined database name.

[AIRUserSetting].[dbo].[tLossModTemplateRuleConstructionCode]

Used for a Loss analysis, this table stores information about the construction class filter in the rule definition. These custom, user-defined rules identify the Ground-Up losses to which the Loss analysis engine applies the specified loss modification factor. The engine applies the factor to losses from the events that satisfy the rules.

[AIRUserSetting].[dbo].[tLossModTemplateRuleOccupancyCode]

Used for a Loss analysis, this table stores information about the occupancy class filter in the rule definition.  These custom, user-defined rules identify the Ground-Up losses to which the Loss analysis engine applies the specified loss modification factor. The engine applies the factor to losses from the events that satisfy the rules.

[AIRUserSetting].[dbo].[tModelInfo]

Stores information regarding the models currently avaible with Touchstone. 

[AIReinsurance].[dbo].[tProgramExposureViewXref]

A reference table used to identify the relationship between the program and exposure views.

[AIRExposureSummary].[dbo].[tRRRR_CMPLOSS_AnnualEPKey]

Stores annual exceedance probability losses to be used a Comparative Loss analysis. This table is created for each comparative Loss analysis. By default, for each year in the analysis that experienced loss, the table will contain at most one Aggregate row and one Occurrence row per financial perspective for the Standard EP curve. But if losses for a particular financial perspective in that year were 0, no row is generated. The table may contain additional rows if the user requests additional EP curves for subsets of the results.

[AIRExposureSummary].[dbo].[tRRRR_CMPLOSS_ContractKey]

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

[AIRExposureSummary].[dbo].[tRRRR_CMPLOSS_EventKey]

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

[AIRExposureSummary].[dbo].[tRRRR_CMPLOSS_GeoKey]

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

[AIRExposureSummary].[dbo].[tRRRR_CMPLOSS_LOBKey]

Stores information about the Line of Business used during the Comparative Loss analysis.

[AIRExposureSummary].[dbo].[tRRRR_HAZ_Intensity]

Stores detailed hazard information for events that cause loss to specific locations during a hazard analysis.

[AIRExposureSummary].[dbo].[tRRRR_TTTT_CMPLOSS_AnnualEP]

Stores the deltas for the aggregate annual exceedance probability losses that are calculated during a Comparative Loss analysis.

[AIRExposureSummary].[dbo].[tRRRR_TTTT_CMPLOSS_AnnualEPSummary]

Stores the deltas for the aggregate annual exceedance probability summary that are calculated during a Comparative Loss analysis. 

[AIRExposureSummary].[dbo].[tRRRR_TTTT_CMPLOSS_ByEvent]

Stores the deltas for the aggregate event losses that are calculated during a Comparative Loss analysis.

[AIRExposureSummary].[dbo].[tRRRR_TTTT_CMPLOSS_ContractLOBAAL]

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

[AIRExposureSummary].[dbo].[tRRRR_TTTT_CMPLOSS_GEOAAL]

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

[AIRSpatial].[dbo].[xtSpatialDatasetHazardAttributeXref]

A reference table used to identify the hazard attribute associated with a spatial dataset.

[AIRSpatial].[dbo].[xtSpatialDataset{XXX}Grid]

Stores grid information relevant to a spatial dataset.

[AIRGeography].[dbo].[tblAreaMOdel_Before Table]

Stores the mapping between an area and its corresponding model for previous versions of Touchstone.

[AIRGeography].[dbo].[TblSourceTargetMap_BRA]

Maps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Brazil, as well as the weight for each of those locations.

[AIRGeography].[dbo].[TblSourceTargetMap_US]

Stores geographic information specific to the United States.

[AIRGeography].[dbo].[tDisaggregatedGeoLevel]

Stores the geographic resolution to which Touchstone disaggregates for each country.

[AIRGeography].[dbo].[tGeography_Upgradelist]

Stores the geography SIDS that have changed between versions.

Modified Tables

AIR has made modifications to the following database tables for Touchstone 3.0.0.

Table Details

[AIRExposure].[dbo].[tLocation]

Added column: NonCATGroundUpLoss.

[AIRExposure].[dbo].[tLocFeature]

Added columns: PPCCode, ISFireSprinklerAvailable, ISO OccupancyCode, ISOConstruction Code, and IBHSFortifiedCode.

[AIRResult].[dbo].[tDQAnalysisResultStatistics]

Added column: ScoreDataQualityUncertainty.

[AIRResult].[dbo].[tLossAnalysisDemandSurgeOption]
[AIRResult].[dbo].[tLossAnalysisFloodOption]
[AIRResult].[dbo].[tLossAnalysisPerilSetULOBOption]
[AIRResult].[dbo].[tLossAnalysisSTStormOption]
[AIRResult].[dbo].[tLossAnalysisTerrorismOption]

Added column: RowVersion.

[AIRResult].[dbo].[tRRRR_CLSH_LocationByContract]

Added column: ClashTRV.

[AIRResult].[dbo].[tLossAnalysisOption]

Added columns: RowVersion, StatusCode, EventSetStandardName, EventSetProductVersion, and AnalysisProductVersion.

[AIRResult].[dbo].[tRRRR_DQ_SCR_ResultDetail]

Added column: ScoreDQU.

Expanded the following field descriptions to accommodate the Data Quality Uncertainty feature:

  • DataQualityScore
  • ScoreDQS
  • ScoreARI
  • ScoreBRI

[AIRResult].[dbo].[tRRRR_DQ_SCR_ResultSummary]

Added column: DataQualityUncertainty.

[AIRResult].[dbo].[tRRRR_HAZ_AttributeSummary]

Added column: PercentTRV.

[AIRResult].[dbo].[tRRRR_NONCAT_DimContract]

Added columns: ExposureSetName, UserLineofBusiness, PolicyForm, UserDefined1, UserDefined2, UserDefined3, UserDefined4, UserDefined5, SubmitStatusCode, InceptionDate, and ExpirationDate.

[AIRResult].[dbo].[tRRRR_NONCAT_DimLayer]

Added column: OccLimitTypeCode.

[AIRResult].[dbo].[tRRRR_NONCAT_DimLocation]

Added columns: AIRConstructionCode, AIROccupancyCode, GeographySID, GeoMatchLevelCode, Latitude, Longitude, Stories, YearBuilt, Premium, GrossArea, Territory, UserDefined1, UserDefined2, UserDefined3, UserDefined4, UserDefined5, ReplacementValueA, ReplacementValueB, ReplacementValueC, ReplacementValueD, TotalReplacementValue, InceptionDate, and ExpirationDate.

[AIRProject].[dbo].[tActivity]

 

Added columns: ScheduledDate, HPCJobPriorityTypeCode, ActivityResourceTypeCode, and ActivityFailureActionCode.

[AIRProject].[dbo].[tActivityOutputDetail]

Added column: HPCJobID

[AIRProject].[dbo].[tAnalysis]

Added column: AnalysisProductVersion.

[AIRProject].[dbo].[tAnalysisTargetXref]

Added column: AnalysisTargetAliasName.

[AIRProject].[dbo].[tExportActivityOption]

Added columns: IsSingleExposureSet, ExposureSetName, and ExposureDataSourceSID.

[AIRProject].[dbo].[tNonCatAnalysisOption]

Added columns: PerilGroupCode and PreserveNonCATGroundUpLoss.

Updated the LossCostType field description to reference the loss cost type options from [AIRReference].[dbo].[tLossCostType]

[AIRReference].[dbo].[tAccumulatorType]

Added code: HBOUN = Hazard boundary

[AIRReference].[dbo].[tActivityType]

Added column: ISSystem.

Added codes:

  • AZ_DEPROV = Azure Cloud Deprovisioning
  • AZ_PROV = Azure Cloud Provisioning
  • CLOUD_USE = Cloud Usage Report
  • CMPLOSS = Comparative Loss            
  • CMPLOSSEXP = Comparative Loss Export to CSV
  • RSPEXPORT = RSP Export
  • RSPIMPORT = RSP Import

 [AIRReference].[dbo].[tAIRConstruction]

Added codes:

  • 2010 = Unknown Bridge
  • 2011 = Multi-span simply supported CONCRETE
  • 2012 = Multi-span simply supported STEEL
  • 2013 = Single Span Bridge
  • 2015 = General Concrete
  • 2016 = General Steel
  • 2021 = Multi-span continuous CONCRETE
  • 2022 = Multi-span continuous STEEL
  • 2031 = Major Bridge
  • 2131 = Alluvium Tunnels
  • 2132 = Alluvial Bored  Tunnels
  • 2141 = Rock Tunnels
  • 2142 = Rock Bored Tunnels
  • 2150 = Unknown Tunnel
  • 2151 = Rock Cut and Cover Tunnels
  • 2152 = Alluvial Cut and Cover Tunnels
  • 2210 = Unknown Tanks
  • 2211 = Underground Liquid Tanks
  • 2221 = Underground Solid Tanks
  • 2231 = On Ground Liquid Tanks
  • 2232 = On Ground Steel liquid Tanks
  • 2233 = On Ground Concrete  liquid Tanks
  • 2241 = On Ground Solid Tanks
  • 2242 = On Ground Steel solid Tanks
  • 2243 = On Ground Concrete solid  Tanks
  • 2251 = Elevated  Liquid Tanks
  • 2252 = Elevated Steel liquid Tanks
  • 2253 = Elevated Concrete liquid Tanks
  • 2261 = Elevated Solid Tanks
  • 2262 = Elevated Steel solid Tanks
  • 2263 = Elevated Concrete solid  Tanks
  • 2270 = Unknown Pipeline
  • 2271 = General Underground Pipelines
  • 2272 = Underground Cast Iron Pipelines
  • 2273 = Underground Asbestos Cement Pipelines
  • 2274 = Underground Concrete Pipelines
  • 2275 = Underground PVC Pipelines
  • 2276 = Underground Ductile Iron Pipelines
  • 2281 = General At Grade Pipelines
  • 2282 = At Grade Cast Iron Pipelines
  • 2283 = At Grade Asbestos Cement Pipelines
  • 2284 = At Grade Concrete Pipelines
  • 2285 = At Grade PVC Pipelines
  • 2286 = At Grade Ductile Iron Pipelines

[AIRReference].[dbo].[tAnalysisType]

Added code: CMPLOSS = Comparative Loss

[AIRReference].[dbo].[tCatalogType]

Added column: CatalogTypeID.

Added code: EXT = External.

[AIRReference].[dbo].[tConvertEDCConstruction]

Added codes:

  • EURO = Euro Codes
  • USER = User Codes

[AIRReference].[dbo].[tConvertEDCCountry]

Added columns: CountryCode, CountryName, RMSCountryScheme, RMSCountryCode, AliasIsCountryCode, and IsIFMSupported.

[AIRReference].[dbo].[tConvertEDCOccupancy]

Added codes:

  • SIC = Standard Industrial Classification (SIC) codes  
  • NCCI = National Council on Compensation Insurance (NCCI) codes
  • WCOCC = Workers Comp Occupancy codes (RMS specific)  

[AIRReference].[dbo].[tConvertISOOccupancy]

Added the ISOOccupancy code options.

[AIRReference].[dbo].[tEnhancedGeoMatchLevel]

Added code: SUB2 = Subarea 2 Centroid

[AIRReference].[dbo].[tEventSetType]

Added code: 9 = External

[AIRReference].[dbo].[tExportTargetType]

Added code: CON = Contract

[AIRReference].[dbo].[tExportType]

Added codes:

  • CLOUD = Cloud Usage Report
  • RINT – Results Export - INT

[AIRReference].[dbo].[tGeoMatchLevel]

Added code: SUB2 = Subarea 2

[AIRReference].[dbo].[tIndustryLineOfBusiness]

Added code: 22 = Residential Building and Contents

[AIRReference].[dbo].[tModel]

Added codes:

  • 20 = AIR Severe Thunderstorm Model for the U.S. and Canada
  • 30 = AIR Tropical Cyclone Model for Canada
  • 42 = AIR Winter Storm Model  for Canada
  • 70 = AIR Earthquake Model for South America
  • 90 = AIR Inland Flood Model for Central Europe
  • 95 = AIR Inland Flood Model for Austria, Czechoslovakia, and Switzerland
  • 230 = ERN Earthquake model for Mexico
  • 231 =  ERN Tropical Cyclone Model for Mexico

[AIRReference].[dbo].[tObjectType]

Added column: ObjectBUDefinitionCode.

Added codes:

  • AIR_SPTL_LYR = AIR Spatial Layer
  • CSTM_SPTL_LYR = Custom Spatial Layer
  • AIR_MapLegend = AIR MapLegend
  • CSTM_MapLegend = Custom MapLegend
  • AIR_SPTL_Group = AIR Spatial Group
  • CSTM_SPTL_Group = Custom Spatial Group
  • BURST_POLICY = Burst Policy
  • IMPACT_WDGT = Marginal Impact Widget

[AIRReference].[dbo].[tObjectBUDefinition]

Added column: PSOLDProtectionCode.

[AIRReference].[dbo].[tAIROccupancy]

Added codes:

  • 483 =    IFM: Communication Systems  - General
  • 484 =    IFM: Agriculture Systems  - General
  • 485 =    IFM: Bus Systems  - General
  • 909 =    Pipelines

[AIRReference].[dbo].[tOutputType]

Added codes:

  • CMPLOSS_1 = Comparative Portfolio Event Loss
  • CMPLOSS_2 = Comparative Geography Event Loss/LocationAAL
  • CMPLOSS_3 = Comparative LOB Event Loss
  • CMPLOSS_4 = Comparative LOB, Geography Event Loss/LocationAAL
  • CMPLOSS_5 = Comparative Contract/LOB Event Loss
  • CMPLOSS_6 = Comparative Contract/LOB, Geography Event Loss/LocationAAL
  • CON = Contract Event Loss
  • HAZIT = Hazard Intensity
  • HAZITA = Hazard Intensity Analysis

[AIRReference].[dbo].[tResultTemplate]

Added column: SortBy.

[AIRReference].[dbo].[tResultViewBy]

Added column: IsNonCatEnabled.

Added codes:

  • 127 = Event Loss by Geography and Injury
  • 128 = Hazard Intensity
  • 129 = Comparative Event Loss by Portfolio
  • 130 = Comparative Average Annual Loss by Contract
  • 131 = Comparative Average Annual Loss by LOB
  • 132 = Comparative Average Annual Loss by Contract and LOB
  • 133 = Comparative Average Annual Loss by Geography
  • 134 = Comparative Annual EP Detail
  • 135 = Comparative Average Annual Loss by Location

[AIRReference].[dbo].[tRingCriteria]

Added code: DRING = Dynamic Ring

[AIRReference].[dbo].[tStatus]

Added code: HID = Hidden

[AIRReference].[dbo].[tUNICEDE2LineofBusiness]

Added code: 95 = CML (Commercial)

[AIRReference].[dbo].[tWidgetType]

Added code: IMPACT_WDGT = Marginal Impact Widget

[AIRUserSetting].[dbo].[tCatalog]

Added columns: EnteredDate, EditedDate, and StatusCode.

[AIRUserSetting].[dbo].[tDefaultNonCatAnalysisOption]

Added columns: DefaultBGILossCostTemplateSID and DefaultSCLLossCostTemplateSID.

[AIRUserSetting].[dbo].[tDefaultUWAnalysisSetting]

Added column: TargetSID.

[AIRUserSetting].[dbo].[tEventSet]

Added column: EventSetProductVersion.

[AIRUserSetting].[dbo].[tHazardWidgetTemplate]

Added column: IsPercentTRVAvailable.

[AIRUserSetting].[dbo].[tLossModTemplateRule]

Added columns: YearBuilt, Stories, ContractIDSQLString, and LocationIDSQLString.

[AIRUserSetting].[dbo].[tLossWidgetTemplate]

Added column: LossWidgetTemplateSID.

[AIRExposureSummary].[dbo].[tDQAnalysisResultStatistics]

Added column: ScoreDataQualityUncertainty.

[AIRExposureSummary].[dbo].[tLossAnalysisDemandSurgeOption]
[AIRExposureSummary].[dbo].[tLossAnalysisFloodOption]
[AIRExposureSummary].[dbo].[tLossAnalysisPerilSetULOBOption]
[AIRExposureSummary].[dbo].[tLossAnalysisSTStormOption]
[AIRExposureSummary].[dbo].[tLossAnalysisTerrorismOption]

Added column: RowVersion.

[AIRExposureSummary].[dbo].[tLossAnalysisOption]

Added columns: RowVersion, StatusCode, EventSetStandardName, EventSetProductVersion, and AnalysisProductVersion.

[AIRExposureSummary].[dbo].[tRRRR_CLSH_LocationByContract]

Added column: ClashTRV.

[AIRExposureSummary].[dbo].[tRRRR_DQ_SCR_ResultDetail]

Added column: ScoreDQU. 

Expanded the following field descriptions to accommodate the Data Quality Uncertainty feature:

  • DataQualityScore
  • ScoreDQS
  • ScoreARI
  • ScoreBRI

[AIRExposureSummary].[dbo].[tRRRR_DQ_SCR_ResultSummary]

Added column: DataQualityUncertainty.

[AIRExposureSummary].[dbo].[tRRRR_HAZ_AttributeSummary]

Added column: PercentTRV.

[AIRExposureSummary].[dbo].[tRRRR_NONCAT_DimContract]

Added columns: ExposureSetName, UserLineofBusiness, PolicyForm, UserDefined1, UserDefined2, UserDefined3, UserDefined4, UserDefined5, SubmitStatusCode, InceptionDate, and ExpirationDate.

[AIRExposureSummary].[dbo].[tRRRR_NONCAT_DimLayer]

Added column: OccLimitTypeCode.

[AIRExposureSummary].[dbo].[tRRRR_NONCAT_DimLocation]

Added columns: AIRConstructionCode, AIROccupancyCode, GeographySID, GeoMatchLevelCode, Latitude, Longitude, Stories, YearBuilt, Premium, GrossArea, Territory, UserDefined1, UserDefined2, UserDefined3, UserDefined4, UserDefined5, ReplacementValueA, ReplacementValueB, ReplacementValueC, ReplacementValueD, TotalReplacementValue, InceptionDate, and ExpirationDate.

[AIRSpatial].[dbo].[tSpatialDatasetAnalysis]

Added column: SpatialDatasetSID

[AIRSpatial].[dbo].[tSpatialDataset]

Added column: LayerGroup.

[AIRSpatial].[dbo].[xtSpatialDataset{XXX}Index]

Added columns: CellID and IndexedCellID.

Deprecated Tables

AIR has deprecated the following database tables for this release.

Table Details

[AIRGeography].[dbo].[TblAreaCatTranslator]

This table is no longer required to translate the dbo.TblAreaCatmap Table records to dbo.TblAreaExternal Table records.

 

 

 


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.