Customizing States

You can customize these preset process status states:

• Not Started

• First Pass

• Under Review

• Frozen

• Distributed

• Signed Off

• Not Signed Off

• Approved

The process status state information is stored in the HSP_PM_STATES table in the NAME column. You must run statements for your relational database to change the state value.

Example: SQL Relational Database

Run this query to list all available process status states and their current names:

select * from hsp_pm_states

This returns the state_id, the name of the process status state, and the color.

Note the state_id of the process status state you want to change, and then run this query:

UPDATE HSP_PM_STATES SET NAME = 'NewName' WHERE STATE_ID = state_id

Run this SQL statement to change the Approved process status state name to Promoted:

UPDATE HSP_PM_STATES SET NAME='PROMOTED' WHERE STATE_ID=1

Note:

For Oracle relational databases, issue a COMMIT; command to commit the transaction.