Touchstone 2022 Database Reference
tActivityHpcJob Table
AIRProject Database : tActivityHpcJob Table
Description
Stores information about each activity that is submitted to the HPC server.
Properties
Creation Date4/4/2022 3:02 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 

Unique system-generated sequential identifier for the activity record.

For a complete list of records, see dbo.tActivity Table.

int4   
Primary Key System-assigned identifier for a job submitted to the HPC server.int4   
 Name of the HPC server processing the job.varchar255  
Objects that tActivityHpcJob depends on
 Database ObjectObject TypeDescriptionDep Level
tActivity tabletActivityTable

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.

1
tAnalysis tabletAnalysisTableStores information about each analysis.2
tDataServer tabletDataServerTableStores 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.4
tDataSource tabletDataSourceTable

Stores information about the databases registered with the application, for example, the exposure and results databases.

3
tExposureSet tabletExposureSetTableStores exposure set information from each exposure database on the server.4
tProject tabletProjectTableStores information about each project, for example, the project name and status code.2
See Also

Related Objects

AIRProject Database