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 |