Open topic with navigation

TIBCO iProcess® Engine 11.9.1

# 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(
    ROWID		NUMERIC(15)	NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 50),
    	o_flags			INTEGER,
    	o_queuename		VARCHAR(24),
    	o_locker		VARCHAR(24),
    	o_username		VARCHAR(49),
    	o_startname		VARCHAR(49),
    	o_dirname		VARCHAR(12)	NOT NULL,
    	o_dirdesc		VARCHAR(24),
    	o_procname		VARCHAR(8)	NOT NULL,
    	o_procdesc		VARCHAR(24),
    	o_casedesc		VARCHAR(24),
    	o_casenum		NUMERIC(20),
    	o_placeno		INTEGER,
    	o_dirflags		INTEGER,
    	o_procflags		INTEGER,
    	o_host			VARCHAR(24)	NOT NULL,
    	o_pnum			INTEGER		NOT NULL,
    	o_pnumcount		INTEGER		NOT NULL,
    	o_caseptr		NUMERIC(20),
    	o_reqidhost		VARCHAR(24)	NOT NULL,
    	o_reqid			NUMERIC(20)	NOT NULL,
    	o_deadline		TIMESTAMP,
    	o_reqstamp		TIMESTAMP,
    	o_qparam1		VARCHAR(24),
    	o_qparam2		VARCHAR(24),
    	o_qparam3		VARCHAR(12),
    	o_qparam4		VARCHAR(12),
    	o_itempriority		VARCHAR(24),
    	o_priority_changed	TIMESTAMP,
    	o_majorvers		INTEGER		NOT NULL,
    	o_minorvers		INTEGER		NOT NULL)

Column | Description
`o_flags` | Flags associated with this work item. For internal use only.
`o_queuename` | Queue name of the user or group queue that contains this work item, as defined in the user_names table.
`o_locker` | Name of the user who has locked the queue (if it is locked), as defined in the user_names table. Note: This column is not written to or updated unless the `WIS_WRITELOCKS` parameter in the `SWDIR``\etc\staffcfg` file is set.
`o_username` | Queue name of the user or group queue that contains this work item, as defined in the user_names table.
`o_startname` | Username of the user who started the case that this work item belongs to, as defined in the user_names table.
`o_dirname` | Step name of the step that generated this work item.
`o_dirdesc` | Step description of the step that generated this work item.
`o_procname` | Procedure name of the procedure that generated this work item, as defined in the proc_index table.
`o_procdesc` | Procedure description of the procedure that generated this work item, as defined in the proc_index table.
`o_casedesc` | Case description of the case that this work item belongs to, as defined in the case_information table.
`o_casenum` | Case number of the case that this work item belongs to, as defined in the case_information table.
`o_placeno` | Step mark number. For internal use only.
`o_dirflags` | Step flags. For internal use only.
`o_procflags` | Procedure flags. For internal use only.
`o_host` | ID of the node that this work item is associated with, as defined in the nodes table.
`o_pnum` | Procedure number of the procedure that generated this work item, as defined in the proc_index table.
`o_pnumcount` | Version count of procedure. For internal use only.
`o_caseptr` | Case control record number. For internal use only.
`o_-reqidhost` | Nodename of the node where the `o_reqid` is generated, as defined in the nodes table.
`o_reqid` | Unique ID for this work item, generated from the sequences table.
`o_deadline` | Date and time that the deadline (if defined) expires on this work item. If no deadline is set this value appears as `12/31/3000 11:15:00 PM`.
`o_reqstamp` | Timestamp when this work item was delivered to the queue.
`o_qparam1` | Value of work queue parameter 1 for this work item.
`o_qparam2` | Value of work queue parameter 2 for this work item.
`o_qparam3` | Value of work queue parameter 3 for this work item.
`o_qparam4` | Value of work queue parameter 4 for this work item.
`o_itempriority` | Priority definition for this work item, in the format: `base`:`increment`:`number`:`period`:`type` where:
| • | `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.
`o_priority_changed` | Timestamp when the priority value for this work item was last changed.
`o_majorvers` | Major version number of the procedure that generated this work item, as defined in the proc_version table.
`o_minorvers` | Minor version number of the procedure that generated this work item, as defined in the proc_version table.

## Primary Key

The following primary key is defined for this table.

Key Name | Column(s)
`pk_staffo` | `o_reqid o_reqidhost`

## Indexes

The following indexes are defined for this table.

Index Name | Column(s) Indexed
`idx_staffo` | `o_queuename`
`idx_staffo_rowid` 1 UNIQUE index | `rowid`

## 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 row is... | When...
added | a work item is sent out to a queue.
updated | any of the following occur:
| • | a work item is kept and any changes have been made.
| • | a work item’s priority value changes.
| • | a work item is opened and the `WIS_WRITELOCKS` parameter in the `SWDIR``\etc\staffcfg` file is set.
deleted | either:
| • | a work item is released or withdrawn.
| • | a case is closed or purged.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO iProcess® Engine