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. |
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 |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|