SUBJECTID

Subject numeric identifier.

SITEID

Site numeric identifier.

SUBJECTVISITID

Subject visit numeric identifier.

VISITID

Visit numeric identifier.

Note: For common forms, the VISITID is the numeric identifier for the common visit.

VISITINDEX

Visit instance identifier.

0 - Expected visit.

1 - Started, non-repeating visit.

<revision number> - Repeating visit

FORMID

Form numeric identifier.

FORMREV

Revision number for the form.

FORMINDEX

Form instance identifier.

0 - Unstarted form.

1 - Non-repeating form.

<revision number> - Repeating form.

SUBJECTINITIALS

Subject initials.

SUBJECTNUMBERSTR

Subject number.

FIRSTDATATIME

Date and time when data was first entered for an item on the form.

LASTDATATIME

Most recent date and time when any of the following occurred:

• Data was entered or changed on the form.
• An add entry itemset row was deleted or undeleted on the form.
• The form instance was deleted or undeleted.

SITEMNEMONIC

Site mnemonic.

VISITMNEMONIC

Visit mnemonic.

FORMMNEMONIC

Form mnemonic.

VISITORDER

Order of the visit in the study.

SITENAME

Site name.

SITECOUNTRY

Country in which the site exists.

FORMCOMMENTTEXT

Comment text for a form- or item-level comment on the form.

FORMIDX

Ordinal number for the form sequence in the visit.

Note: Contains data for repeating forms only.

DELETEDFORM

Indicates whether the form instance is deleted.

Y - The form is deleted.

N - The form is not deleted.

Note: Contains data for repeating forms only.

ITEMSETID

Numeric identifier for the itemset.

Note: Contains data only for forms that contain itemsets.

ITEMSETINDEX

Numeric identifier for the itemset instance.

Note: Contains data only for forms that contain itemsets.

ITEMSETIDX

Ordinal number for the itemset row sequence in the itemset.

Note: Contains data only for forms that contain itemsets.

DELETEDITEM

Indicates whether the itemset row is deleted.

Y - The itemset row is deleted.

N - The itemset row is not deleted.

Note: Contains data only for forms that contain itemsets.

VISITIDX

Ordinal number for the visit sequence in the study.

Note: Contains data only for forms that exist in a repeating visit.

CD_COUNT

Count of data items processed for the form instance.

CREATEDBYUSERID

User ID of the user who started the study object by entering data for the study object in the RD view or triggering a rule that entered data for the study object.

CREATEDDATETIME

Date and time when the study object in the RD view was started; that is, when a user entered data on the study object or triggered a rule that entered data for the study object.

MODIFIEDBYUSERID

User ID of the user who most recently modified the study object by entering data for the study object in the RD view or triggering a rule that entered data for the study object.

Note: When a new study version is applied, the MODIFIEDBYUSERID value will be updated to "1" for all rows in all RD_ views to reflect that the new study version was deployed by the system user.

MODIFIEDDATETIME

Date and time when the study object in the RD view was most recently modified; that is, when a user most recently entered data on the study object or triggered a rule that entered data for the study object.

Note: When a new study version is applied, the MODIFIEDDATETIME value for all rows in all RD_ views will be updated to reflect the date/time the new study version is deployed.

DOV

Date of visit. If the form on which the RD view is based is not the DOV form, a column for the date of the visit is created.