Touchstone 4.0 Database Documentation
tDataServer Table
Description
Stores information about each data server used in the project, including its sequential identifier (SID), name, description, connection information, and default MDF and LDF paths.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows1
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key DataServerSID

Unique system-generated sequential identifier of the database server record that stores the Touchstone project data.

Integer4   
 DataServerNameName of the database server that stores the Touchstone project data.VarChar255  
 DescriptionDescription of the database server that stores the Touchstone project data.VarChar4000  
 ConnectionInfoXML expression defining the connection information for any type of data source.Xml16  
 DefaultMDFPathDefault path to the Database Data File (MDF).VarChar1024  
 DefaultLDFPathDefault path to the Transaction Log File (LDF)VarChar1024  
 DefaultInitalSizeDataDefault initial size of a newly created database data file. Used by the AIRExposure Database and AIRResult Database.Integer4  
 DefaultInitalGrowthDataThe initial growth parameter for the data file when a new database is created on the server.Integer4  
 DefaultInitalSizeLogThe initial size of a newly created database log file.Integer4  
 DefaultInitalGrowthLogThe initial growth parameter for the log file when a new database is created on the server.Integer4  
Objects that depend on tDataServer
 Database ObjectObject TypeDescriptionDep Level
tActivity tabletActivityTableStores the ActivitySID, the AnalysisSID and the ProjectSID, which you need to find the location of your analysis results.1
tActivityHpcJob tabletActivityHpcJobTableStores information about each activity that is submitted to the HPC server.2
tActivityOutput tabletActivityOutputTableStores the ID of an activity and its output, status information, and the file path to the output. An activity output is a logical group of one or more activity task outputs.2
tActivityOutputDetail tabletActivityOutputDetailTableStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.3
tActivityParentXref tabletActivityParentXrefTableSystem reference table used to associate an activity to the parent activity.2
tActivityTargetStatus tabletActivityTargetStatusTableStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.2
tAnalysis tabletAnalysisTableStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.1
tAnalysisFilterXRef tabletAnalysisFilterXRefTableSystem reference table used to the identify the analysis IDs, as well as their associated filters.2
tAnalysisTargetXref tabletAnalysisTargetXrefTableSystem reference table used to the identify the target on which the analysis is going to be performed.2
tClashAnalysisOption tabletClashAnalysisOptionTableStores the hold options settings for a clash underwriting analysis.2
tComparativeLossAnalysisOption tabletComparativeLossAnalysisOptionTableStores the values used to generate the results in a Comparative Loss analysis.2
tComparativeLossAnalysisTargetOption tabletComparativeLossAnalysisTargetOptionTableStores information regarding the target analysis in a Comparative Loss analysis.3
tDataQualityAnalysisOption tabletDataQualityAnalysisOptionTableStores information regarding the augmentation of data during a Data Quality analysis.2
tDataQualityAnalysisOutputOption tabletDataQualityAnalysisOutputOptionTableStores the output options for a Data Quality analysis.3
tDataSource tabletDataSourceTableStores information about the data source used for the Touchstone project. A data source is a database that is registered with the Touchstone application.2
tDataSourceActivityOption tabletDataSourceActivityOptionTableStores information about the data source created by a specific activity. A data source is a database that is registered with the Touchstone application.2
tDQAnalysisRuleSet tabletDQAnalysisRuleSetTableStores information regarding the rule sets used during a Data Quality analysis.4
tDQAnalysisSetting tabletDQAnalysisSettingTableStores information regarding the analysis settings used during a Data Quality analysis.4
tDQIndustryFilterLOB tabletDQIndustryFilterLOBTableStores the type of output of the Data Quality analysis and the Line of Business of the insured properties to include in the output results.4
tECAAreaZoneOption tabletECAAreaZoneOptionTableStores the zone set identifiers used during a Geospatial analysis.3
tECACustomSaveOption tabletECACustomSaveOptionTableStores user-defined accumulators that are used in a Geospatial analysis. Reserved for future use.3
tECARingDefinition tabletECARingDefinitionTableStores information regarded the rings used during a Geospatial analysis.4
tECARingGeoMatchLevelOption tabletECARingGeoMatchLevelOptionTableStores information about the geocode match level achieved during the Geospatial \analysis.4
tECARingLandmarkOption tabletECARingLandmarkOptionTableStores information about the landmarks used during a Geospatial analysis.4
tECARingLocationList tabletECARingLocationListTableStores information about the locations included in the Geospatial analysis.4
tECARingOption tabletECARingOptionTableStores information about the ring options selected for the Geospatial analysis.3
tECASpatialDataSetBucketDefinition tabletECASpatialDataSetBucketDefinitionTableStores information that defines the buckets used in a Geospatial analysis. A bucket is a range of attribute values that is analyzed as a single entity with a single damage ratio; For example, a bucket of wind speed could be 60 – 70 miles per hour.4
tECASpatialDataSetOption tabletECASpatialDataSetOptionTableStores information regarding the spatial data set options used during the Geospatial analysis.3
tECASpatialEventOption tabletECASpatialEventOptionTableStores information regarding the events for each model to include during the Geospatial analysis.3
tECASpatialLossOption tabletECASpatialLossOptionTableStores information regarding the loss analysis options used during the Geospatial analysis.3
tExportActivityFilter tabletExportActivityFilterTableStores information about the filter attribute applied during export.3
tExportActivityOption tabletExportActivityOptionTableStores information regarding the export type.2
tExposureConcentrationAnalysisOption tabletExposureConcentrationAnalysisOptionTableStores the options used during a Geospatial analysis.2
tExposureViewDefinition tabletExposureViewDefinitionTableStores information about the exposure sets that are part of the exposure view optionally with a filter.2
tEXPSAnalysisOutputOption tabletEXPSAnalysisOutputOptionTableStores the output options used for the Exposure Summary analysis.2
tHazardAnalysisAttributeOption tabletHazardAnalysisAttributeOptionTableStores information about the attributes applied during a Hazard analysis.3
tHazardAnalysisOption tabletHazardAnalysisOptionTableStores information regarding the options selected for a Hazard analysis.2
tHazardAnalysisOutputOption tabletHazardAnalysisOutputOptionTableStores information regarding the output from a Hazard analysis.2
tImpactAnalysisOption tabletImpactAnalysisOptionTableStores information regarding the analysis options used during a Marginal Impact analysis.2
tImportActivityOption tabletImportActivityOptionTableStores information about an import activity.2
tIntensityAttributeOption tabletIntensityAttributeOptionTableStores information regarding the intensity attribute used during a Hazard analysis.2
tLossAnalysisDemandSurgeOption tabletLossAnalysisDemandSurgeOptionTableStores information regarding the demand surge, by area, used during a Loss analysis.3
tLossAnalysisFloodOption tabletLossAnalysisFloodOptionTableStores information regarding the custom flood zones used during a Loss analysis.3
tLossAnalysisOption tabletLossAnalysisOptionTableStores information regarding the options selected for a Loss analysis.2
tLossAnalysisPerilSetULOBOption tabletLossAnalysisPerilSetULOBOptionTableStores information regarding the perils and Lines of Business analyzed during the Loss analysis. In addition, it also identifies the percentage of the loss from storm surge or precipitation flood, when applicable.3
tLossAnalysisSTStormOption tabletLossAnalysisSTStormOptionTableStores information regarding the severe storm options using during a Loss analysis.3
tLossAnalysisTerrorismOption tabletLossAnalysisTerrorismOptionTableStores information regarding the terrorism options used during a Loss analysis.3
tNonCatAnalysisOption tabletNonCatAnalysisOptionTableStores analysis options used during a non-catastrophe Loss analysis.2
See Also

Related Objects

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