|
id (PRI)
|
varchar(255)
|
The review stage identifier.
|
|
name
|
varchar(255)
|
The stage name.
|
|
stageNo
|
int(11)
|
The index used to access a list of stages.
The field is used for internal purposes.
|
|
status
|
varchar(255)
|
The status of the stage. The Possible values
PENDING, ONGOING, COMPLETED, EXPIRED, REVOKED, REVISED, APPROVED, and
REJECTED.
|
|
disposition
|
varchar(255)
|
The custom disposition for the stage. The
value is a custom-defined status for the stage that can be explicitly
set using Review, Commenting, and Approval APIs.
|
|
type
|
varchar(255)
|
The type of the stage: PARALLEL_REVIEW, SEQUENTIAL_REVIEW,
PARALLEL_APPROVAL, and SEQUENTIAL_APPROVAL.
|
|
taskType
|
varchar(255)
|
The type of the assign task. The possible
values are WORKSPACE, EMAIL_CONNECTED, and CUSTOM.
|
|
preProcessHookName
|
varchar(255)
|
The name of the pre process hook for the
stage.
|
|
postProcessHookName
|
bit(1)
|
The name of the post process hook for the
stage.
|
|
duration
|
int(11)
|
The duration of the stage.
|
|
durationUnit
|
varchar(255)
|
The unit of duration of the stage. The possible
values are DAYS, MINUTES, HOURS, and BUSINESS_DAYS.
|
|
waitForExpiry
|
bit(1)
|
A flag that indicates whether to wait until
the stage duration is reached before determining whether a stage
is complete or expired.
|
|
nonExpiringStage
|
bit(1)
|
A flag that indicates whether the stage
is non-expiring. When a stage is not an expiring stage, then the
stage never expires and duration has no effect on the stage termination.
|
|
startDate
|
dateTime
|
The start date of the stage.
|
|
endDate
|
dateTime
|
the end date of the stage. The value indicates
when the stage is to complete.
|
|
signatureType
|
varchar(255)
|
The type of signature used for approval
stages. The possible values are SERVER_SIDE, CLIENT_SIDE, and NO_SIGNATURE.
|
|
assignTaskToInitiatorProcess
|
varchar(255)
|
The name of the process to use to assign
tasks to review initiators. The value is used when the taskType
field is set to CUSTOM.
|
|
assignTaskToParticipantProcess
|
varchar(255)
|
The name of the process to use to assign
tasks to reviewers or approvers. The value is used when the taskType
field is set to CUSTOM
|
|
additionalMetadata
|
mediumtext
|
Additional metadata as unstructured information.
The information can be provided when initiating a review.
|
|
reviewContext (MUL)
|
varchar(255)
|
The foreign key to the rca_review_context
table.
|
