PROTOCOL

Study Name

EDC_ENVIRONMENT_ID

Environment ID

EDC_SITE_ID

Internal Site ID

EDC_SUBJECT_ID

Internal Subject 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_ITERATION

Iteration of ObjectID

SITE_LABEL

Site Label

SUBJECT_LABEL

Subject Label

PATH_LABEL

Generic Path to Object ID using labels

EDC_FORM_LABEL

Label of Object ID

FORM_ABSOLUTE_SORT_ORDER

Overall Order of Object ID on Tree

FORM_ENTRY_VERSION

Version of eCRF

FORM_ENTRY_STATUS

Entry Status: Entered; Never Entered; Blank/Deleted

FORM_ENTRY_USER

Last Entry User Name

FORM_ENTRY_USER_SID

Last Entry User Internal ID

FORM_ENTRY_DATE

Last Entry Date (Last time entered)?

FORM_ENTRY_AUDIT_COMMENT

Entry Audit Comment

FORM_FIRST_ENTRY_USER

First Entry User

FORM_FIRST_ENTRY_USER_SID

First Entry User Internal ID

FORM_FIRST_ENTRY_DATE

First Entry Date

FORM_FIRST_ENTRY_AUDIT_COMMENT

First Entry Audit Comment

MUST_VERIFY

Yes = Form or field on form must be verified

MUST_VERIFY_TYPE

Type of Verification required

IS_CURRENTLY_VERIFIED_FLAG

Yes if eCRF is verified or No if eCRF is not verified

CURRENT_VERIFIED_USER

Last User Name to Verify eCRF

CURRENT_VERIFIED_USER_SID

Internal ID of Last User Name to Verify eCRF

CURRENT_VERIFIED_DATE

Verification Date

CURRENT_VERIFIED_AUDIT_COMMENT

Verification Audit Comment

FIRST_VERIFIED_USER

First User Name to Verify eCRF

FIRST_VERIFIED_USER_SID

Internal ID of First User Name to Verify eCRF

FIRST_VERIFIED_DATE

First Verification Date

FIRST_VERIFIED_AUDIT_COMMENT

First Verification Audit Comment

IS_CURRENTLY_SIGNED_FLAG

Yes if eCRF is Signed or No if eCRF is not Signed

CURRENT_SIGNED_USER

Last User Name to Sign eCRF

CURRENT_SIGNED_USER_SID

Internal ID of Last User Name to Sign eCRF

CURRENT_SIGNED_DATE

Signed Date

CURRENT_SIGNED_AUDIT_COMMENT

Signed Audit Comment

FIRST_SIGNED_USER

First User Name to Sign eCRF

FIRST_SIGNED_USER_SID

Internal ID of First User Name to Sign eCRF

FIRST_SIGNED_DATE

First Signed Date

FIRST_SIGNED_AUDIT_COMMENT

First Signed Audit Comment

IS_CURRENTLY_LOCKED_FLAG

Yes if eCRF is Locked or No if eCRF is not Locked

CURRENT_LOCKED_USER

Last User Name to Lock eCRF

CURRENT_LOCKED_USER_SID

Internal ID of Last User Name to Lock eCRF

CURRENT_LOCKED_DATE

Locked Date

CURRENT_LOCKED_AUDIT_COMMENT

Locked Audit Comment

FIRST_LOCKED_USER

First User Name to Lock eCRF

FIRST_LOCKED_USER_SID

Internal ID of First User Name to Lock eCRF

FIRST_LOCKED_DATE

First Locked Date

FIRST_LOCKED_AUDIT_COMMENT

First Locked Audit Comment

CURRENT_MARK_YELLOW

Yes if eCRF is Marked Yellow or No if eCRF is not Marked Yellow

YELLOW_MARK_USER

Last User Name to Mark eCRF Yellow

YELLOW_MARK_USER_SID

Internal ID of Last User Name to Mark eCRF Yellow

YELLOW_MARK_DATE

Marked Yellow Date

YELLOW_AUDIT_COMMENT

Marked Yellow Audit Comment

FIRST_YELLOW_MARK_USER

First User Name to Mark eCRF Yellow

FIRST_YELLOW_MARK_USER_SID

Internal ID of First User Name to Mark eCRF Yellow

FIRST_YELLOW_MARK_DATE

First Marked Yellow Date

FIRST_YELLOW_AUDIT_COMMENT

First Marked Yellow Audit Comment

CURRENT_MARK_RED

Yes if eCRF is Marked Red or No if eCRF is not Marked Red

RED_MARK_USER

Last User Name to Mark eCRF Red

RED_MARK_USER_SID

Internal ID of Last User Name to Mark eCRF Red

RED_MARK_DATE

Marked Red Date

RED_AUDIT_COMMENT

Marked Red Audit Comment

FIRST_RED_MARK_USER

First User Name to Mark eCRF Red

FIRST_RED_MARK_USER_SID

Internal ID of First User Name to Mark eCRF Red

FIRST_RED_MARK_DATE

First Marked Red Date

FIRST_RED_AUDIT_COMMENT

First Marked Red Audit Comment

CURRENT_MARK_GREEN

Yes if eCRF is Marked Green or No if eCRF is not Marked Green

GREEN_MARK_USER

Last User Name to Mark eCRF Green

GREEN_MARK_USER_SID

Internal ID of Last User Name to Mark eCRF Green

GREEN_MARK_DATE

Marked Green Date

GREEN_AUDIT_COMMENT

Marked Green Audit Comment

FIRST_GREEN_MARK_USER

First User Name to Mark eCRF Green

FIRST_GREEN_MARK_USER_SID

Internal ID of First User Name to Mark eCRF Green

FIRST_GREEN_MARK_DATE

First Marked Green Date

FIRST_GREEN_AUDIT_COMMENT

First Marked Green Audit Comment

CURRENT_MARK_BLUE

Yes if eCRF is Marked Blue or No if eCRF is not Marked Blue

BLUE_MARK_USER

Last User Name to Mark eCRF Blue

BLUE_MARK_USER_SID

Internal ID of Last User Name to Mark eCRF Blue

BLUE_MARK_DATE

Marked Blue Date

BLUE_AUDIT_COMMENT

Marked Blue Audit Comment

FIRST_BLUE_MARK_USER

First User Name to Mark eCRF Blue

FIRST_BLUE_MARK_USER_SID

Internal ID of First User Name to Mark eCRF Blue

FIRST_BLUE_MARK_DATE

First Marked Blue Date

FIRST_BLUE_AUDIT_COMMENT

First Marked Blue Audit Comment

OPEN_QUERY_CNT

Number of Open Queries on the eCRF

ANSWERED_QUERY_CNT

Number of Answered Queries on the eCRF

ACCEPTED_QUERY_CNT

Number of Accepted Queries on the eCRF

REQUERIED_QUERY_CNT

Number of Requeried Queries on the eCRF

AUTORESOLVED_QUERY_CNT

Number of Resolved Queries on the eCRF

EDC_FORM_HYPERLINK

URL to eCRF in Express Product.