rca_participant
Stores information about the participants of a review instance.
Initiator, reviewers, approvers, and moderators are all considered
participants of the review.
|
Field name
|
Field data type
|
Purpose
|
|
id (PRI)
|
varchar(255)
|
The participant identifier.
|
|
participantType
|
varchar(255)
|
The type of participant. The possible values
are INITIATOR, REVIEWER, APPROVER, and MODERATOR.
|
|
processId
|
varchar(255)
|
The process ID of the assign task process.
When an assign task process is started, this value is populated.
-
The value is null for a moderator because no tasks are assigned
to moderators.
-
Initiators are assigned a task for a stage when straight-through
processing is disabled. The field is populated when the stage starts.
-
For reviewers and approvers, the field is populated when
a stage starts.
|
|
umOid
|
varchar(255)
|
The Adobe User Management object identifier
of the user.
|
|
reviewContext(MUL)
|
varchar(255)
|
The foreign key to parent record in Review
Context table. This reference is added here for performance reasons,
so that a direct join to review context table can be made.
|
|
createdAt
|
varchar(255)
|
Stores a value to indicate whether the user
was added during template creation, initiation or during a running
review. The possible values are TEMPLATE_CREATION, INITIATION, UPDATES.
|
|
finalComments
|
text
|
The final comments as recorded by participant,
while completing the review or approval task.
|
|
status
|
varchar(255)
|
The status of participant.
|
|
disposition
|
varchar(255)
|
The custom disposition. The value can be
provided, while completing a review or approval task and indicates
the value selected by the user to complete a task.
|
|
startDate
|
datetime
|
The time the task was assigned.
|
|
endDate
|
datetime
|
Th time the task completed or terminated.
|
|
completedBy
|
varchar(255)
|
The object identifier of the user that completed
the task. Tasks can be forwarded or shared.
|
|
completedFromIP
|
varchar(255)
|
The IP address of the client machine, from
where the task is completed.
|
|
additionalMetadata
|
mediumtext
|
Additional metadata stored for the participant.
Additional metadata can be unstructured information that is provided when
initiating a review.
|
|
reviewStage (MUL)
|
varchar(255)
|
Foreign key to parent record in review stage
table.
|
|
optional
|
bit(1)
|
Whether the reviewer or approver is optional.
This column is used only for approver/reviewer.
|
|
participantNo
|
int(11)
|
The index used to access a list of participants.
The field is used for internal purposes.
|
|
|
