STJOB Table

Contains tracked jobs.

Field Data Type Description

LABCODE

Variable string (10)

Laboratory code.

CLI_LABCODE

Variable string (10)

Code of the stored job's laboratory, from the JOB table.

CLI_CODE

Variable string (40)

Code of the stored job's client, from the JOB table.

PROJ_CODE

Variable string (20)

Code of the stored job's project, from the JOB table.

PRO_JOB

Variable string (20)

Code for the job, from the JOB table.

ORDERNO

Variable string (40)
Unicode

Order number, from the JOB table.

CONT_CODE

Variable string (20)

Code of the contact, from the JOB table.

COSTCODE

Variable string (20)

Cost of the cost code, from the JOB table.

LOCATIONCODE

Variable string (20)

Code of the storage location, from the STLOCATION table.

CONTAINERCODE

Variable string (20)

Code of the storage container, from the STCONTAINER table.

STACTIONCODE

Variable string (20)

Code of the storage sample handling action, from the STACTION table.

NOTES

Variable string (60)
Unicode

Notes regarding the storage of the job.

NOUNKS

Integer

Number of unknown samples stored for the job.

NODUPS

Integer

Number of duplicate QC samples stored for the job.

STAFF_CODE

Variable string (20)

Code of the staff member who created or updated the job tracking details, from the STAFF table.

LOCATED

Date-time

Date-time the job tracking details were created or updated.

USERFIELD1..USERFIELD20

Variable string (n)
Unicode

Extra site-specific fields accessed via a customised screen.
Primary key

LABCODE + PRO_JOB

Indices

LABCODE + CLI_CODE

LABCODE + CLI_CODE + PROJ_CODE