|
id (PRI)
|
varchar(255)
|
The review context identifier.
|
|
templateName
|
varchar(255)
|
The name of the template for the review
instance. No reference is provided back to review template table.
It is stored here for review tracking purposes, has no runtime significance,
and is kept for backward compatibility.
|
|
templateDescription
|
text
|
The description of the template for the
review instance. This value has no runtime significance and is available
for backwards compatibility.
|
|
complianceCode
|
varchar(255)
|
The compliance code of the template for
the review instance. This value has no runtime significance and
is available for backwards compatibility.
|
|
reviewType
|
varchar(255)
|
The type of the review. The possible values
are REGULATED_REVIEW or AD_HOC_REVIEW.
This value has no
runtime significance and is available for backward compatibility.
|
|
templateAuthor
|
varchar(255)
|
The name of the author. This value has no
runtime significance and is available for backwards compatibility.
|
|
reviewId (MUL)
|
varchar(255)
|
The identifier for the review instance.
|
|
revision
|
int(11)
|
The revision number for the review instance.
Revision number starts from 1.
|
|
currentRevision
|
bit(1)
|
A flag that indicates to store whether the
review is the current revision. There is only one current revision
of a review at any time.
|
|
changeDescription
|
text
|
The description for a change. The change
description is provided at the time of review revision.
|
|
title
|
varchar(255)
|
The title of the review.
|
|
purpose
|
text
|
The description or purpose of the review.
|
|
status
|
varchar(255)
|
The current Status of the review. The possible
values are ONGOING, COMPLETED, EXPIRED, REVOKED, and REVISED.
|
|
stp
|
bit(1)
|
A flag that specifies whether straight-through
processing is used for the review instance.
|
|
currentStage
|
int(11)
|
The current stage number. The first stage
in a review starts with the number 0.
|
|
commentServerPath
|
varchar(255)
|
The Web-based Distributed Authoring and
Versioning (WebDAV) or file share location of review zone.
|
|
auditLevel
|
varchar(255)
|
The selected audit level for the review
instance.
|
|
arsProcessName
|
varchar(255)
|
The ARS creation process name.
|
|
rtsProcessName
|
varchar(255)
|
The RTS creation process name.
|
|
initiator (UNI)
|
varchar(255)
|
The foreign key to initiator of the review
instance.
|
|
commentVisibility
|
varchar(255)
|
A value that specifies commenting visibility.
The possible values are INTER_STAGE (Comments are shared across
multiple stages) and ONLY_INTRA_STAGE (Comments for the current stage
are available. Comments from other stages are not available).
|
|
additionalMetadata
|
mediumtext
|
Additional metadata is extra unstructured
information that can be provided while initiating a review.
|
|
invocationId
|
varchar(255)
|
The invocation ID of the review initiation
request. The field is used for internal purposes.
|
