Columns in RD views
Each RD view contains columns for some or all of the following key variables.
Columns in RD views
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:
|
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. |