This table contains information about the status of
an approval.
Column Descriptions:
Name | Type | Description |
APRVSTATUS_ID | BIGINT NOT NULL | Primary key. |
FLOW_ID | BIGINT NOT NULL | Reference to the flow for the steps in the
approval process. Foreign key to FLOW_ID. |
SUBMITTER_ID | BIGINT NOT NULL | ID of the user requesting the action which needs
approval. |
APPROVER_ID | BIGINT | The ID of the user eligible to approve or reject
the requested action. |
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. |
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. |
MBRGRP_ID | BIGINT NOT NULL | The ID of the member group to which the approver
belongs, making the approver an approver for this record. |
FLSTATEDCT_ID | BIGINT NOT NULL | Current state of the flow instance. |
STATUS | INTEGER NOT NULL | Approval status of this action. Valid values are
as follows:
- 0=pending
- 1=approved
- 2=rejected
|
SUBMITTIME | TIMESTAMP | The time that the action requiring approval was
requested. |
ACTIONTIME | TIMESTAMP | The time when the approval record was acted on;
that is, the time it was approved or rejected. |
COMMENTS | VARCHAR (254) | Comments entered by approver during approval or
rejection. |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | APRVSTATUS_ID | Primary Key |
I0000451 | MBRGRP_ID | Non-Unique Index |
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 |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | 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 |