Touchstone 4.0 Database Documentation
tActivity Table
Description
Stores the ActivitySID, the AnalysisSID and the ProjectSID, which you need to find the location of your analysis results.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ActivitySIDUnique system-generated sequential identifier for the activity record.Integer4   
 ParentActivitySIDUnique system-generated sequential identifier of the sub-activity's parent record.Integer4  
 ActivityTypeCode

Codes that represent the activity type.

For a complete list of codes, see tActivityType Table

VarChar10   
 ActivityStageID

Code that identifies the current stage of the activity. 

For a complete list of codes, see tActivityStage Table.

UnsignedTinyInt1   
 ParentActivityStageID

Identifier for the current stage of the parent activity. Used only for sub-activities, such as a Data Quality analysis.

For a complete list of codes, see tActivityStage Table.

UnsignedTinyInt1  
 ActivityNameName of the activity.VarChar255  
 ActivityStatusCode

Code that represents the status of an activity. Note: Use this code, not AnalysisStatusCode, to determine the status of an analysis.

For a complete list of codes, see tActivityStatus Table.

VarChar10   
 ActivityResultStatusCode

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

For a complete list of codes, see tActivityResultStatus Table.

SmallInt2 
((0))
 
 ActivitySeqNumSequence number of the activity.UnsignedTinyInt1  
 AuthorUser that initiated the activity.VarChar255  
 AnalysisSID

Unique system-generated sequential identifier of the analysis instance. Used when the activity is associated with an analysis record.

For a complete list of records, see tAnalysis Table.

Integer4  
 ProjectSID

Unique system-generated sequential identifier for the project record.  

For a complete list of records, see tProject Table.

Integer4  
 BusinessUnitSIDUnique system-generated sequential identifier for the business unit record.Integer4 
((1))
 
 StatusCode

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

For a complete list of codes, see tStatus Table.

VarChar10 
('A')
 
 EnteredDateDate and time when the activity was created.DBTimeStamp4 
(getutcdate())
 
 ExecutedDateDate and time when the activity began execution.DBTimeStamp4  
 CompletedDate

Date-time of when analysis results were generated.

DBTimeStamp4  
 ProgressWeightTotal progress weight of the activity's current stageSmallInt2  
 ProgressPercentPercentage of the activity that has completed.SmallInt2  
 HPCJobIDSystem-assigned identifier for a job submitted to the HPC server.Integer4  
 HPCServerName of the HPC server processing the job.VarChar255  
 MessageAny additional message provided by HPC.VarChar1000  
 DescriptionUser-provided description of the activity.VarChar4000  
 AdvancedJobOptionXML expression for the additional options specified to the HPC server by any activity. Used internally by Touchstone.Xml16  
 IsFinalAggregationPerformed

Indicates whether the log files have been aggregated, or if they still need to be aggregated.

  • 1 = Yes (aggregated)
  • 0 = No (need to be aggregated)
Boolean1 
((0))
 
 ActivityUIDUnique, system-generated identifier for the activity. Used for creating staging tables in the work database.GUID16 
(newid())
 
 ScheduledDateDatabase-stamped date and time when the activity was created.DBTimeStamp4  
 HPCJobPriorityTypeCode

Code that identifies the priority level assigned to the activity.

Jobs with higher priority take precedence over jobs with lower priority as long as the jobs are in queued state in the following order, Top Priority > High Priority > Normal Priority > Low Priority. Jobs that are already running will not be stopped and re-queued to start a higher priority job that is waiting.

For a complete list of codes, see dbo.tHPCJobPriorityType Table.

VarChar25 
('Normal')
 
 ActivityResourceTypeCode

Code that identifies whether the activity was complete on premise or in the cloud.

For a complete list of codes, see dbo.tActivityResourceType Table.

VarChar15 
('OnPremises')
 
 ActivityFailureActionCode

Code that defines whether HPC is to process the parent activity when a child activity fails.

For a complete list of codes, see dbo.tActivityFailureAction Table.

VarChar10  
 ModifiedDateDate and time when the activity was modified.DBTimeStamp4 
(getutcdate())
 
Objects that depend on tActivity
 Database ObjectObject TypeDescriptionDep Level
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
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
tExportActivityFilter tabletExportActivityFilterTableStores information about the filter attribute applied during export.3
tExportActivityOption tabletExportActivityOptionTableStores information regarding the export type.2
tImportActivityOption tabletImportActivityOptionTableStores information about an import activity.2
Objects that tActivity depends on
 Database ObjectObject TypeDescriptionDep Level
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.