Stores information about the task outputs of each activity output.
The application writes to the table during each task.
Touchstone 2022 Database Reference
tActivityOutputDetail Table
Stores information about the task outputs of each activity output.
The application writes to the table during each task.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| 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. For a complete list of records, see tActivity Table. | int | 4 | |||
| | ActivityOutputID | System-generated identifier for the output of an activity. | int | 4 | |||
| | ActivityOutputDetailID | System-generated identifier for the output detail of an activity. | int | 4 | |||
| FilePath | Path to the output file. | varchar | 1000 | ||||
| HPCTaskID | Identifier of the task running on the HPC server. | int | 4 | ||||
| HPCInstanceID | Identifier of the parametric instance of the task running on the HPC server. | int | 4 | ||||
| HPCJobID | System-assigned identifier for a job submitted to the HPC server. | int | 4 |  |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tActivity | Table | 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. | 2 |
| 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. | 1 |
| tAnalysis | Table | Stores information about each analysis. | 3 |
| tDataServer | Table | Stores information about each data server associated with the project, including the sequential identifier (SID), name, description, connection information, and default MDF and LDF paths for the server. | 5 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 4 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 5 |
| tProject | Table | Stores information about each project, for example, the project name and status code. | 3 |