PROTOCOL

Study Name

EDC_ENVIRONMENT_ID

Environment ID

EDC_TREE_NODE_ID

Internal TreeNode ID

EDC_PATH

Internal detailed Path to Object ID

EDC_LOCATION

Generic Path to ObjectID using Object IDs

EDC_OBJECT_ID

Internal Name of eCRF

EDC_SITE_ID

Internal Site ID

SITE_NAME

Site Label

EDC_SUBJECT_ID

Internal Subject ID

SUBJECT_LABEL

Subject Label

FORM_PATH_LABEL

Generic Path to Object ID using labels

FORM_LABEL

Label of Object ID

FORM_ABSOLUTE_SORT_ORDER

Order of Object ID on Tree

EDC_ITERATION

Iteration of ObjectID

EDC_QUID

Internal ID of query

QUERY_CODE

The query code number.

QUERY_DESCRIPTION

The description of the query.

QUERY_SPECIFIC_ERROR

The error associated with this query.

QUERY_RELATED_CONTROL

Field ID is applicable

QUERY_RELATED_COTROL_DATASET_FIELD_NAME

The Column Name associated with this query in Standard dataset.

QUERY_RELATED_CONTROL_DATASET_NORMALIZED_FIELD_NAME

The Column Name associated with this query in Normalized dataset.

QUERY_TYPE

Query type: Reviewer Initiated, Data Manager Initiated, or Auto.

QUERY_ORIGINATION_DATE

First Entry User Name

QUERY_ORIGINATION_ENTRY_USER

First Entry User Name internal ID

QUERY_ENTRY_VERSION

Entry Version of the Query

QUERY_STATUS

Status: Open; Answered; Accepted; Required; Data-Resolved

QUERY_ANSWER

Answer to the query

QUERY_ANSWER_DATE

Answer Date

QUERY_ANSWER_ENTRY_USER

User Name who answered

QUERY_REVIEW_DATE

Review Date

QUERY_REVIEW_ENTRY_USER

User Name of Reviewer

EDC_QUERY_HYPERLINK

URL in Express Product to eCRF/Folder with query.