WebSphere Commerce database table: APRVSTATUS

This table contains information about the status of an approval.

Column Descriptions
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235124430 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

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names 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