VALIDATION
SEQUENCE

NUMBER

Sequence in which the record is validated.

PANELNAME

VARCHAR2(36)

Name of the panel requiring validation.

CTRECID

VARCHAR2(40)

Clintrial ID of the record requiring validation.

VALIDATION
EXECUTED

NUMBER

Boolean indicating whether validation has been run:

• 0 (default)—Validation has not been run.
• 1—Validation has been run.

VALIDATIONDATE

DATE

Oracle SYSDATE (localized date and time from the Oracle server) at which validation was run.

VALIDATIONERROR

NUMBER

Flag indicating the validation error status:

• 0—No error or the error was recorded in CTS.JOB_LOG.
• 1—An error occurred that was too serious to be recorded in CTS.JOB_LOG.