APRVSTATUS

This table contains information about the status of an approval.

Column Descriptions:

NameTypeDescription
APRVSTATUS_IDBIGINT NOT NULLPrimary key.
FLOW_IDBIGINT NOT NULLReference to the flow for the steps in the approval process. Foreign key to FLOW_ID.
SUBMITTER_IDBIGINT NOT NULLID of the user requesting the action which needs approval.
APPROVER_IDBIGINTThe ID of the user eligible to approve or reject the requested action.
FLOWTYPE_IDBIGINT NOT NULLForeign 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_IDBIGINT NOT NULLReference to the business object; that is, which particular business object instance within the business object type specified by FLOWTYPE_ID.
MBRGRP_IDBIGINT NOT NULLThe ID of the member group to which the approver belongs, making the approver an approver for this record.
FLSTATEDCT_IDBIGINT NOT NULLCurrent state of the flow instance.
STATUSINTEGER NOT NULLApproval status of this action. Valid values are as follows:
  • 0=pending
  • 1=approved
  • 2=rejected
SUBMITTIMETIMESTAMPThe time that the action requiring approval was requested.
ACTIONTIMETIMESTAMPThe time when the approval record was acted on; that is, the time it was approved or rejected.
COMMENTSVARCHAR (254)Comments entered by approver during approval or rejection.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>APRVSTATUS_IDPrimary Key
I0000451MBRGRP_IDNon-Unique Index
I922110FLOW_ID+ENTITY_IDNon-Unique Index
I9221180SUBMITTER_ID+APPROVER_ID+FLOWTYPE_ID+STATUSNon-Unique Index
I9221181APPROVER_ID+STATUS+SUBMITTER_ID+FLOWTYPE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_61SUBMITTER_IDUSERSUSERS_IDCascade
F_62APPROVER_IDUSERSUSERS_IDCascade
F_63MBRGRP_IDMBRGRPMBRGRP_IDCascade
F_64FLOWTYPE_IDFLOWTYPEFLOWTYPE_IDCascade
F_65FLOW_IDFLOWFLOW_IDCascade
F_66FLSTATEDCT_IDFLSTATEDCTFLSTATEDCT_IDCascade