LCSTATE is the table that stores a record for every queue configured in Workflow. This is the parent table that cross-references with the ITEMLC table to obtain the name (statename) of the queue in which a document exists. The LCSTATE table is located in DBSpace8.
| Column Name | Data Type | Description |
|---|---|---|
| statenum | bigint | The unique identifier of the queue in OnBase. |
| statename | char(50) | The text representation of the queue name. |
| statedesc | char(80) | |
| statehelp | char(250) | |
| validactionflags | bigint | |
| bitmapnum | bigint | |
| iconnum | bigint | |
| queuetype | bigint | |
| defsystemwork | bigint | |
| defuserwork | bigint | |
| scope | bigint | The unique identifier of the life cycle to which the queue belongs (cross-referenced to lcnum in the LIFECYCLE table). |
| flags | bigint | |
| foldertypenum | bigint | |
| templatenum | bigint | |
| docseltasklistnum | bigint | |
| cqnum | bigint | |
| loadbalancingwork | bigint | |
| obrefresh | bigint | |
| requiredrole | bigint | |
| flags2 | bigint | |
| keynum | bigint | |
| wftimerservername | char(60) |
The index for the LCSTATE table is located in DBSpace8.
| Index Name | Included Columns |
|---|---|
| lcstate1 | statenum |