Database Table: APRVSTATUS

This table stores approval requests and their status and contains multiple rows for each action awaiting approval, with one row for every potential approver. Each entry is unique per approver, entity tuplet. The FlowTypeId indicates which type of entityId is pending approval.

Column Name Column Type Column Description
ACTIONTIME TIMESTAMP
NULL
The time when the approval record was acted on; that is, the time it was approved or rejected.
APPROVER_ID BIGINT
NULL
The ID of the user eligible to approve or reject the requested action.
APRVSTATUS_ID BIGINT
NOT NULL
Primary key.
COMMENTS VARCHAR (254)
NULL
Comments entered by approver during approval or rejection.
ENTITY_ID BIGINT
NOT NULL
Reference to the business object; that is, which particular business object instance within the business object type specified by FLOWTYPE_ID.
FLOWTYPE_ID BIGINT
NOT NULL
Foreign key reference to the type of flow that determines the type of business object included in the approval. There are different IDs for each type of approval, including RFQ, order, user registration, contract, organization registration approvals and so on. Foreign key to FLOWTYPE_ID.
FLOW_ID BIGINT
NOT NULL
Reference to the flow for the steps in the approval process. Foreign key to FLOW_ID.
FLSTATEDCT_ID BIGINT
NOT NULL
Current state of the flow instance.
MBRGRP_ID BIGINT
NOT NULL
The ID of the member group to which the approver belongs, making the approver an approver for this record.
STATUS INTEGER
NOT NULL
Approval status of this action:
0 = pending
1 = approved
2 = rejected
SUBMITTER_ID BIGINT
NOT NULL
ID of the user requesting the action which needs approval.
SUBMITTIME TIMESTAMP
NULL
The time that the action requiring approval was requested.
Indexes:
Index Name Indexed Column Names Index Type
I922110 FLOW_ID, ENTITY_ID Non-Unique Index
I9221180 SUBMITTER_ID, APPROVER_ID, FLOWTYPE_ID, STATUS Non-Unique Index
I9221181 APPROVER_ID, STATUS, SUBMITTER_ID, FLOWTYPE_ID Non-Unique Index
SQL030416034836860 APRVSTATUS_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_61 SUBMITTER_ID USERS USERS_ID Cascade
F_62 APPROVER_ID USERS USERS_ID Cascade
F_63 MBRGRP_ID MBRGRP MBRGRP_ID Cascade
F_64 FLOWTYPE_ID FLOWTYPE FLOWTYPE_ID Cascade
F_65 FLOW_ID FLOW FLOW_ID Cascade
F_66 FLSTATEDCT_ID FLSTATEDCT FLSTATEDCT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable