Touchstone 4.0 Database Documentation
tActivityOutput Table
Description
Stores 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.
Properties
Creation Date5/31/2016 9:45 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 ActivitySID

Unique system-generated sequential identifier for the activity record.

For a complete list of records, see tActivity Table.

Integer4   
Primary Key ActivityOutputIDSystem-generated identifier for the activity output  record.Integer4   
 ActivityOutputName of the activity output.VarChar255   
 ActivityOutputStatusCode

Code that represents the status of the activity's output.

For a complete list of codes, see tActivityOutputStatus Table.

VarChar10   
 ActivityOutputAggregationCode

Code that represents the conditions upon which the activity output is accessible by clients.

For a complete list of codes, see tActivityOutputAggregation Table

UnsignedTinyInt1   
 FinalFilePathPath to the output file.  Reserved for future use.VarChar1000  
Objects that depend on tActivityOutput
 Database ObjectObject TypeDescriptionDep Level
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
Objects that tActivityOutput depends on
 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
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
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
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
tProject tabletProjectTableStores information regarding the project, such as project name and status code.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.