Touchstone 4.0 Database Documentation
tProject Table
Stores information regarding the project, such as project name and status code.
Creation Date5/31/2016 9:45 AM
Text File Group
System Object
Published for Replication
Data Space Used8.00 KB
Index Space Used56.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ProjectSID

Unique system-generated sequential identifier for the project record.

 ProjectNameUser-provided name for the project.VarChar255  
 DescriptionUser-provided description of the project.VarChar4000  

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


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

For a complete list of codes, see tStatus Table.

 EnteredDateDate and time when the project was created.DBTimeStamp4 
 EditedDateDate and time when the project was last modified.DBTimeStamp4 
 AuthorName of the person who created the project.VarChar255  
Objects that depend on tProject
 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
tExposureView tabletExposureViewTableStores information regarding exposures views.1
tExposureViewDefinition tabletExposureViewDefinitionTableStores information about the exposure sets that are part of the exposure view optionally with a filter.2
tExposureViewFilterXRef tabletExposureViewFilterXRefTableSystem reference table used to identify the exposure view filters.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
tProjectExposureViewXref tabletProjectExposureViewXrefTableSystem reference table used to identify the relationship between the project and exposure views.1
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.