This table contains information about the status of an approval.
Column Description(s):
Column Name | Column 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 |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031157260 |
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 |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_65 |
FLOW_ID |
FLOW |
FLOW_ID |
Cascade |
F_64 |
FLOWTYPE_ID |
FLOWTYPE |
FLOWTYPE_ID |
Cascade |
F_66 |
FLSTATEDCT_ID |
FLSTATEDCT |
FLSTATEDCT_ID |
Cascade |
F_63 |
MBRGRP_ID |
MBRGRP |
MBRGRP_ID |
Cascade |
F_61 |
SUBMITTER_ID |
USERS |
USERS_ID |
Cascade |
F_62 |
APPROVER_ID |
USERS |
USERS_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.