Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 8 Work Items : staffo

staffo
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).
Structure
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)
Note: This column is not written to or updated unless the WIS_WRITELOCKS parameter in the SWDIR\etc\staffcfg file is set.
Nodename of the node where the o_reqid is generated, as defined in the nodes table.
base:increment:number:period:type
base is the base priority value for this work item.
increment is the amount that will be added to the item’s priority value whenever the period expires.
number is the number of increments that will be added to the item’s priority value.
period is the time period, in the units specified in type, which must expire before the item’s priority value is incremented.
type is the unit of measure of the period, either “M” or “m” for minutes, “H” or “h” for hours or “D” or “d” for days.
Primary Key
The following primary key is defined for this table.
Triggers
None.
Indexes
The following index is defined for this table.

1
UNIQUE index

Table Activity
The staffo table contains one row for every outstanding step on the system.
Rows are added, updated and deleted in the following situations.
a work item is opened and the WIS_WRITELOCKS parameter in the SWDIR\etc\staffcfg file is set.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved