CT_RECID

VARCHAR2(40)

The Clintrial database identifier of the item associated with an error.

MERGE_
DATETIME

DATE

Oracle SYSDATE when the record was created or modified.

STATUS

NUMBER

Numeric code indicating the status of the record:

• 3—Batch-loaded and not yet screened.
• 2—Entered interactively and not yet verified.
• 1—Passed verification or screening.
• 0—Passed validation.
• -1—Failed validation or merge.
• -2—Failed verification.
• -3—Failed screening.

  EDC data has a status of 0 or -1.

ENTRY_ID

VARCHAR2(20)

The InForm user account who entered or last modified InForm data.

To find the name of the user who performed an operation such as validation or coding on data in Clintrial, check the job log.

ENTRY_
DATETIME

DATE

Date and time at which the error record was created.

DB_ID

NUMBER

Unique identifier of the Clintrial database instance. 9999 for EDC data.

SUBJECT_ID

NUMBER

Unique Clintrial identifier assigned to the subject item.

CTS$REASON

VARCHAR2(2000)

Text indicating why the record was created.

CTV_ERROR_ID

NUMBER

Unique identifier of the related INF_ERRORSTATUS record. This column joins INF_ERRORITEM records to a specific INFO_ERRORSTATUS record.

CTV_PANEL

VARCHAR2(30)

Name of the panel containing data associated with this discrepancy record.

CTV_DISCR_
RECID

VARCHAR2(40)

The CT_RECID item of the specific associated data record.

CTV_ITEM_
NAME

VARCHAR2(30)

Name of the specific item that you want to associate with this discrepancy record.

CTV_DISCREP_
PAGE_ID

VARCHAR2(240)

Value of the page context item in the associated data record.

CTV_DISCREP_
BLOCK

VARCHAR2(240)

Value of the block context item in the associated data record.

CTV_ITEM_
VALUE

VARCHAR2(2000)

Value of the specific item at the time the discrepancy was detected.

CTV_NEW_
VALUE

VARCHAR2(2000)

Proposed new value for the specified item (or null).

CTV_NEW_
VALUE_GIVEN

NUMBER

Flag indicating whether or not a new value has been provided.

CTV_REPEAT_ID

VARCHAR2(240)

Optional description to provide contextual information about the item.

CTV_REASON

VARCHAR2(2000)

Descriptive text or a code from the CTS_REASON_CODES codelist to describe the change made from the existing item value to the new value.

CTV_ORDER

NUMBER

Order of error items in the table. When determining the InForm item on which to place a Clintrial discrepancy, CIS processes the error items mapped to the InForm item in CTV_ORDER sequence.