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 number(5) NULL,
o_queuename varchar2(24) NULL,
o_locker varchar2(24) NULL,
o_username varchar2(49) NULL,
o_startname varchar2(49) NULL,
o_dirname varchar2(12) NOT NULL,
o_dirdesc varchar2(24) NULL,
o_procname varchar2(8) NOT NULL,
o_procdesc varchar2(24) NULL,
o_casedesc varchar2(24) NULL,
o_casenum number(20) NULL,
o_placeno number(5) NULL,
o_dirflags number(5) NULL,
o_procflags number(5) NULL,
o_host
varchar2(24) NOT NULL,
o_pnum number(5) NOT NULL,
o_pnumcount number(5) NOT NULL,
o_caseptr number(15) NULL,
o_reqidhost number(24) NOT NULL,
o_reqid number(20) NOT NULL,
o_deadline date NULL,
o_reqstamp date NULL,
o_qparam1 varchar2(24) NULL,
o_qparam2 varchar2(24) NULL,
o_qparam3 varchar2(12) NULL,
o_qparam4 varchar2(12) NULL,
o_itempriority varchar2(24) NULL,
o_priority_changed date NULL,
o_majorvers number(5) NOT NULL,
o_minorvers number(5) NOT NULL)
The following index is defined for this table.
The staffo table contains one row for every outstanding step on the system.