Stores information about each activity, including the unique sequential identifiers for analyses and activities.
You can use the information in the table to find analysis results.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ActivitySID | Unique system-generated sequential identifier for the activity record. | int | 4 | |||
| ParentActivitySID | Unique system-generated sequential identifier of the sub-activity's parent record. | int | 4 |  | |||
| ActivityTypeCode | Codes that represent the activity type. For a complete list of codes, see tActivityType Table. | varchar | 10 | ||||
| ActivityStageID | Code that identifies the current stage of the activity. For a complete list of codes, see tActivityStage Table. | tinyint | 1 | ||||
| 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. | tinyint | 1 | | |||
| ActivityName | Name of the activity. | varchar | 255 | | |||
| 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. | varchar | 10 | ||||
| ActivityResultStatusCode | Code that represents the status of the activity's results. For a complete list of codes, see tActivityResultStatus Table. | smallint | 2 | ((0)) | |||
| ActivitySeqNum | Sequence number of the activity. | tinyint | 1 | | |||
| Author | User that initiated the activity. | varchar | 255 | | |||
| 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. | int | 4 | | |||
| ProjectSID | Unique system-generated sequential identifier for the project record. For a complete list of records, see tProject Table. | int | 4 | | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit record. | int | 4 | ((1)) | |||
| StatusCode | System-provided status code for the record in the table. For a complete list of codes, see tStatus Table. | varchar | 10 | ('A') | |||
| EnteredDate | Date and time when the activity was created. | datetime | 4 | (getutcdate()) | |||
| ExecutedDate | Date and time when the activity began execution. | datetime | 4 | | |||
| CompletedDate | Date-time of when analysis results were generated. | datetime | 4 | | |||
| ProgressWeight | Total progress weight of the activity's current stage | smallint | 2 | | |||
| ProgressPercent | Percentage of the activity that has completed. | smallint | 2 | | |||
| HPCJobID | System-assigned identifier for a job submitted to the HPC server. | int | 4 | | |||
| HPCServer | Name of the HPC server processing the job. | varchar | 255 | | |||
| Message | Any additional message provided by HPC. | varchar | 1000 | | |||
| Description | User-provided description of the activity. | varchar | 16 | | |||
| AdvancedJobOption | XML expression for the additional options specified to the HPC server by any activity. Used internally by Touchstone. | xml | 0 | | |||
| IsFinalAggregationPerformed | Indicates whether the log files have been aggregated, or if they still need to be aggregated.
| bit | 1 | ((0)) | |||
| ActivityUID | Unique, system-generated identifier for the activity. Used for creating staging tables in the work database. | uniqueidentifier | 16 | (newid()) | |||
| ScheduledDate | Database-stamped date and time when the activity was created. | datetime | 4 | | |||
| 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. | varchar | 25 | ('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. | varchar | 15 | ('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. | varchar | 10 | | |||
| ModifiedDate | Date and time when the activity was modified. | datetime | 4 | (getutcdate()) | |||
| ActivityResponse | XML response from the HPC server. Used internally by Touchstone. | xml | 0 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tActivityOutput | Table | Stores the identifier, status, and the file path for the output of each activity. An activity can include one or more tasks. Consequently, an activity output is a logical grouping of one or more task outputs. | 2 |
| tActivityOutputDetail | Table | Stores information about the task outputs of each activity output. The application writes to the table during each task. | 3 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tAnalysis | Table | Stores information about each analysis. | 1 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 3 |