Touchstone 4.0 Database Documentation
tDataSource Table
Description
Stores information about the data source used for the Touchstone project. A data source is a database that is registered with the Touchstone application.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows12
Data Space Used8.00 KB
Index Space Used88.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key DataSourceSIDUnique system-generated sequential identifier for the data source  record that stores the project data.Integer4   
 DataSourceTypeCode

Code that represents the type of data source used in the project.

For a complete list of codes, see tDataSourceType Table.

VarChar10   
 DataServerSID

Unique system-generated sequential identifier for the data server record on which the project data is stored.

For a complete list of records, see tDataServer Table.

Integer4   
 DataSourceNameUser-provided name of the data source that stores the exposure and result data used in the project.VarChar255   
 IsRegistered

Indicates whether a database is registered with the Touchstone application.

  • 1 = Yes (registered)
  • 0 = No (not registered)
Boolean1  
 BusinessUnitSID

Unique system-generated sequential identifier for the business unit record.

Integer4 
((1))
 
 DescriptionUser-provided description of the data source.VarChar4000  
 StatusCode

System-provided status code for the record in the table.

For a complete list of codes, see tStatus Table.

VarChar10 
('A')
 
 DBUIDGlobally unique  identifier for the database.GUID16  
 RowVersionUsed for version stamping.Binary8   
Objects that depend on tDataSource
 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
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
tDQAnalysisRule tabletDQAnalysisRuleTableStores data relating to the rules used in a Data Quality analysis.5
tDQAnalysisRuleSet tabletDQAnalysisRuleSetTableStores information regarding the rule sets used during a Data Quality analysis.4
tDQAnalysisRuleSetRuleSubTypeSelected tabletDQAnalysisRuleSetRuleSubTypeSelectedTableStores information regarding the rule sub type used during the Data Quality analysis.5
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
tECASpatialDataSetBucketDetail tabletECASpatialDataSetBucketDetailTableStores information regarding the data set bucket used during the Geospatial analysis. A bucket is a range 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.5
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
Objects that tDataSource depends on
 Database ObjectObject TypeDescriptionDep Level
tDataServer tabletDataServerTableStores information about each data server used in the project, including its sequential identifier (SID), name, description, connection information, and default MDF and LDF paths.3
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.