The staffo table holds information about
outstanding steps, that is, steps that have been delivered to work queues but not yet released (or otherwise removed).
The staffo table is structured as follows:
TABLE staffo(
o_flags INTEGER NULL,
o_queuename VARCHAR(24) NULL,
o_locker VARCHAR(24) NULL,
o_username VARCHAR(49) NULL,
o_startname VARCHAR(49) NULL,
o_dirname VARCHAR(12) NOT NULL,
o_dirdesc VARCHAR(24) NULL,
o_procname VARCHAR(8) NOT NULL,
o_procdesc VARCHAR(24) NULL,
o_casedesc VARCHAR(24) NULL,
o_casenum NUMERIC(20) NULL,
o_placeno INTEGER NULL,
o_dirflags INTEGER NULL,
o_procflags INTEGER NULL,
o_host
VARCHAR(24) NOT NULL,
o_pnum INTEGER NOT NULL,
o_pnumcount INTEGER NOT NULL,
o_caseptr NUMERIC(20) NULL,
o_reqidhost VARCHAR(24) NOT NULL,
o_reqid NUMERIC(20) NOT NULL,
o_deadline DATETIME NULL,
o_reqstamp DATETIME NULL,
o_qparam1 VARCHAR(24) NULL,
o_qparam2 VARCHAR(24) NULL,
o_qparam3 VARCHAR(12) NULL,
o_qparam4 VARCHAR(12) NULL,
o_itempriority VARCHAR(24) NULL,
o_priority_changed DATETIME NULL,
o_majorvers INTEGER NOT NULL,
o_minorvers INTEGER NOT NULL)
The following index is defined for this table.
The staffo table contains one row for every outstanding step on the system.