HCL Commerce Version 9.1.12.0 or later

APPROVAL_STATE_FLOW_STEPS

This table holds the state transition steps carried on for the approval record. This can be used for auditing purpose to view the transitions that have occurred for the approval record before reaching the final state (Approved / Rejected).

Column Descriptions:

Name  Type  Description 
APPROVAL_STATE_FLOW_STEP_ID INT4 NOT NULL The unique identifier for the approval state flow step
APPROVAL_ID INT4 NOT NULL Reference to the approval record for which the state transition is recorded
STATE_FLOW_ID INT4 NOT NULL Reference for the state flow transition
FLOW_TRIGGER_TIME TIMESTAMP Time stamp in ISO format at which the transition happened

Indexes:

Name  Column Names  Type 
APPROVAL_STATE_FLOW_STEPS_PKEY APPROVAL_STATE_FLOW_STEP_ID Primary Key 

Constrained by parent tables:

Constraint Columns Parent Table Parent Columns Type
APPROVAL_STATE_FLOW_STEPS_APPROVAL_ID_FKEY APPROVAL_ID APPROVAL APPROVAL_ID Simple
APPROVAL_STATE_FLOW_STEPS_STATE_FLOW_ID_FKEY STATE_FLOW_ID APPROVAL_STATE_FLOW STATE_FLOW_ID Simple