This table stores state information on the state
| Column Name | Column Datatype | Column Null Option | Column Comment |
| stateobjid | integer | not null | Object ID of state |
| statename | char(128) | not null | Name of state |
| envobjid | integer | not null | Object ID of project |
| stateorder | integer | not null | Order of states in the project |
| viewobjid | integer | not null | Object ID of view |
| snapshot | char(1) | not null | Snapshot view (Y/N) |
| creationtime | date | not null | Time the state was created |
| creatorid | integer | not null | Object ID of user to create |
| modifiedtime | date | not null | Time the state was modified |
| modifierid | integer | not null | Object ID of user to modify |
| note | varchar(2000) | with null | User-defined note |
| locationx | integer | not null | X coordinate of state in lifecycle diagram |
| locationy | integer | not null | Y coordinate of state in lifecycle diagram |
| pmstatusindex | integer | not null | Object ID of project manager status |
Product Name: AllFusion Harvest Change Manager
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| stateobjid | harlinkedprocess | stateobjid |
| stateobjid | harstateprocess | stateobjid |
| stateobjid | harstateaccess | stateobjid |