Columns in RD views

Each RD view contains columns for some or all of the following key variables.

Column Name	Column Description
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.