The runScripts table of the rd_workflow database provides the LSF output of the runs of the various programs/scripts as well as the jobId of the run that links the run to the data in the rd_lsf database. The columns of this table are:
- runId - The ID of the run from the run table of the rd_workflow database. This value is used as the workflowId in the build table of the rd_releasemgr database to link the two databases.
- scriptId - The ID of the program/script (from the workflowScripts table) that was run. This value plus the value from the runId column, uniquely identify every entry in the table
- jobId - the job ID from the job table of the rd_lsf database. This value provides the linkage between the rd_workflow and rd_lsf databases
- rank - Unused. No idea what this one is. It always seems to be zero. It is probably supposed to be a mirror of the rank value from the job table in the rd_lsf database
- output - The output for the job from the LSF batch queuing system.
- submitTime - The time the run was submitted to the LSF system
- startTime - The time the run actually started
- stopTime - The time the run completed execution