rca_review_template
Stores information about review templates. Review Templates
are stored as XML in Review Zone, this table contains partial information
about the review templates, which is used while searching review
templates.
|
Field Name
|
Field data type
|
Purpose
|
|
id (PRI)
|
varchar(255)
|
The review template identifier.
|
|
templateName (UNI)
|
varchar(255)
|
Th template name. The template name must
be unique.
|
|
templateDescription
|
varchar(255)
|
The review template description.
|
|
complianceCode
|
varchar(255)
|
The compliance Code (SOP).
|
|
templateAuthor
|
varchar(255)
|
The author of the template.
|
|
active
|
bit(1)
|
A flag that indicates whether the review
template is active. A value of 1 indicates that the review template
can be used to initiate reviews.
|
