CT_RECID

VARCHAR2(40)

The Clintrial database identifier of the item associated with a discrepancy.

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 identifier assigned to the subject item.

CTS$REASON

VARCHAR2(2000)

Text indicating why the record was created.

CTV_ERROR_ID

NUMBER

Identifying number for a discrepancy record. ID numbers are unique within a protocol.

CTV_SOURCE

VARCHAR2(20)

Source of a discrepancy. For queries generated by InForm rules, the value is INFORM. For discrepancies generated by Clintrial rules, the standard Clintrial sources apply:

• MANUAL
• RULE
• FLAG
• CLASSIFY

CTV_CONTEXT1

VARCHAR2(240)

Value of the first context item (subject identifier) from the data record that is the source of the discrepancy.

CTV_REMARKS

VARCHAR2(240)

Description of the data error, provided by the creator of the discrepancy record. For discrepancy records created by rules, the description provided within the rule is supplied.

CTV_REPLACE_
REMARKS

VARCHAR2(2000)

Allows a review to replace the description in the CTV_REMARKS column. When this column has a value, it displays on query forms in place of CTV_REMARKS. For discrepancy records created by rules, the description provided within the rule is supplied.

CTV_ADDTL_
REMARKS

VARCHAR2(2000)

Appended to CTV_REMARKS or to CTV_REPLACE_REMARKS on standard data discrepancy forms.

CTV_
COMMENTS_1

VARCHAR2(2000)

Internal comments from the first review (data management). Blank for queries generated by InForm software rules.

CTV_
COMMENTS_2

VARCHAR2(2000)

Additional internal comments

CTV_DSTATUS

VARCHAR2(30)

Discrepancy status of the record. The following values are states of EDC discrepancies in Clintrial software:

• AC—Auto-closed by the Clintrial software; that is, the item passes when a Clintrial rule runs against its value.
• O—Candidate or Open in Clintrial software.

  The following values are states of EDC queries in InForm software:

• 0 (zero)—Candidate.
• 1—Open. For an item validated by a Clintrial rule, this state occurs only when a query is reissued.
• 2—Answered.
• 3—Closed.
• 4—Deleted.
• 5—Sponsor conflict.
• 6—Site conflict.

CTV_STATUS_
CHANGE_DT

DATE

Date and time that the CTV_DSTATUS was last modified.

CTV_PRIORITY

NUMBER

Stores a user-defined priority. For example, a three-point scale can indicate discrepancies of high, medium, or low priority.

• For records created by rules, the priority can be assigned automatically.
• For manually entered records, the person creating the record enters a priority.

CTV_CLOSED_
DATE

DATE

Date and time the record is placed in a terminal discrepancy status (such as Resolution Applied or Linked).

CTV_
CONFIRMATION_FLA

NUMBER

Indicates that a resolution for the discrepancy record has been entered in the database, and only confirmation form the investigator is needed.

CTV_PROPOSAL_TEXT

VARCHAR2(2000)

Description of a proposed resolution. Useful for complex resolutions or if no INF_ERRORITEM records are associated with the discrepancy record.

CTV_
RESOLUTION_
CODE

VARCHAR2(20)

Stores descriptive text or a code from the CTS_REASON_CODES codelist to indicate a resolution reason (for example, original value confirmed or corrected value supplied). Supplied automatically from system parameters as follows:

• From CTV_APPL_RES_CODE during applied proposed value processing.
• From CTV_AUTOCLOSED_RES when validation auto-closes a discrepancy record.
• From CTV_OBSOLETE_RES when a discrepancy record’s status is updated to Obsolete.

CTV_
RESOLUTION_
COMME

VARCHAR2(2000)

Message explaining an unusual resolution or the reason for the change.

CTV_LINKED_
ERROR_ID

NUMBER

CTV_ERROR_ID of another discrepancy record. Used for records in Linked or Reissued discrepancy status to point to the discrepancy record that remains open.

CTV_RULE_
NAME

VARCHAR2(40)

For records created by rules, stores the name of the rule.

CTV_FORM_
BATCH_NUM

NUMBER

Identifier assigned to all records in a batch of data discrepancy forms. All records in a batch have the same batch number. This number can be used to recall the batch for reprinting, or to browse for and display records once the forms are returned.

CTV_FORM_
BATCH_DATE

DATE

Date and time the batch was printed. All records in a batch have the same Form Batch Date.

CTV_BATCH_
ORDER_NUM

NUMBER

A number that sorts discrepancy records in a batch into the order in which they appeared on printed data discrepancy forms.

CTV_PANEL

VARCHAR2(30)

Name of the panel containing the primary clinical data record associated with the discrepancy record.

CTV_DISCR_
RECID

VARCHAR2(40)

CT_RECID of the primary data record associated with the discrepancy record.

CTV_ORCTABLE

VARCHAR2(20)

Oracle table where the primary data record was at the time the discrepancy was detected (that is, update or data).

CTV_DISCREP_
PAGE_ID

VARCHAR2(240)

Value of the page context item of the primary record.

CTV_DISCREP_
BLOCK

VARCHAR2(240)

Value of the block context item of the primary record.

CTV_REC_
MODDATE

DATE

Date of last modification of the primary record at the time the discrepancy was detected.

CTV_ERRDT

DATE

Date and time the record was first inserted into the INF_ERRORSTATUS table.

CTV_ERRTYPE

VARCHAR2(10)

Process that created the discrepancy record:

• VALIDATE—For discrepancies generated by Clintrial rules during CIS auto-validation.
• INFORM—For queries generated by InForm rules.

CTV_ERRACT

VARCHAR2(20)

For records created by rules, error action (Report or Reject) taken by the rule.

QUERYGUID

VARCHAR2(36)

Unique ID assigned to the query returned to the InForm software on synchronization.