IRV_FORM_ITEMS
This view contains information about items on activated forms. This view does not contain information about expected forms.
Columns in the IRV_FORM_ITEMS view
IRV_FORM_ITEMS |
IRV_FORM_ITEMS |
---|---|
ITEMCOUNT |
Always 1; indicates that the row represents one item on a form. |
STUDYVERSIONID |
Numeric identifier for the study version in which the item exists on an activated form. |
CONTEXTID (PK) |
Numeric identifier for the item context. |
SUBJECTID |
Numeric identifier for the subject for which the item exists on an activated form. |
SITEID |
Numeric identifier for the site for which the item exists on an activated form. |
SUBJECTVISITID |
Numeric identifier for the subject visit in which the item exists on an activated form. |
VISITID |
Numeric identifier for the visit in which the item exists on an activated form. |
VISITREV |
Revision number for the visit in which the item exists on an activated form. |
VISITINDEX |
Instance identifier for the visit in which the item exists on an activated form: 0 - expected visit |
FORMID |
Numeric identifier for the activated form on which the item exists. |
FORMREV |
Revision number for the activated form on which the item exists. |
FORMINDEX |
Identifier for the form instance on which the item exists: 0 - unstarted form |
FORMSECTIONORDER |
Order of the section in which the item exists on an activated form. |
SECTIONID |
Numeric identifier for the section in which the item exists on an activated form. |
SECTIONREV |
Revision number for the section in which the item exists on an activated form. |
ITEMSETID |
Numeric identifier for the itemset in which the item exists on an activated form. |
ITEMSETREV |
Revision number for the itemset in which the item exists on an activated form. |
ITEMSETINDEX |
Itemset instance identifier for the itemset in which the item exists on an activated form. |
ITEMSETINDEXORDINAL |
Itemset ordinal (0, 1, 2, 3...n ordered by itemset index). |
SECTIONITEMORDER |
Item/itemset order within the section in which the item exists on an activated form. |
ITEMSETITEMORDER |
Item order within itemset in which the item exists on an activated form. |
ITEMID |
Numeric identifier for the item. |
ITEMREV |
Revision number for the item. |
INFORMPARTIALURL_CRFVIEW |
Partial InForm URL for the activated form on which the item exists. |
SECTIONITEM |
Item is the child of a section: 0 - No 1 - Yes |
ITEMSETITEM |
Item is the child of an itemset: 0 - No 1 - Yes |
IHREVS |
Count of times the item state has changed. |
MINCONTEXTREV |
First item state change revision. |
MAXCONTEXTREV |
Most recent item state change revision. |
STATEUSERID |
Numeric identifier of the user who made the most recent item state change. |
STATETIME |
Time of the most recent item state change. |
STATETRANSACTIONID |
Transaction numeric identifier associated with the most recent item state change. |
STATEREASON |
Reason for the most recent item state change. |
ITEMDELETED |
Item has been deleted: 0 - No 1 - Yes |
ITEMSDVED |
Item has been source verified: 0 - No 1 - Yes |
SDVSELECTEDSTATE |
Form is selected for source verification: 0 - No 1 - Yes |
ITEMFIRSTSDV |
First time the item was source verified. |
SDVTIME |
Most recent time the item was source verified. |
IDREVS |
Count of times the item data has changed. |
MAXAUDITORDER |
Most recent item data change revision. |
DATAUSERID |
Numeric identifier of the user that made the most recent item data change. |
DATATIME |
Time of the most recent item data change. |
DATATRANSACTIONID |
Transaction numeric identifier associated with the most recent item data change. |
DATAREASON |
Reason for the most recent item data change. |
ITEMFIRSTDATA |
First time the item had data. |
ITEMHASQUERIES |
Item has queries: 0 - No 1 - Yes |
QUERIES |
Count of queries against the item. |
QTYPEAUTO |
Count of autoqueries against the item. |
QTYPEMANUAL |
Count of manual queries against the item. |
QTYPECONFLICT |
Count of conflict queries against the item. |
QREISSUED |
Count of reissued queries against the item. |
QCANDIDATE |
Count of candidate queries against the item. |
QOPENED |
Count of open queries against the item. |
QANSWERED |
Count of answered queries against the item. |
QCLOSED |
Count of closed queries against the item. |
QDELETED |
Count of deleted queries against the item. |
ITEMHASCOMMENTS |
Item has comments: 0 - No 1 - Yes |
ITEMCOMMENTS |
Count of comments associated with the item. |
CONTROLS |
Count of controls in the item. |
CONTROLSWITHDATA |
Count of controls in the item that contain data. |
ITEMEMPTY |
Item has no data in any controls: 0 - No 1 - Yes |
NOTDONE |
Item has queries: 0 - No 1 - Yes |
NOTDONEREASON |
Reason entered when item was marked Not Done. |
BLANK |
The item exists in a Repeating Data itemset, and is blank in the itemset. 0 - No 1 - Yes |
ITEMSDVOVERRIDE |
Critical setting for the item is overridden: 0 - No 1 - Yes |
ITEMSDVSELECTED |
Item is selected for source verification: 0 - No 1 - Yes |
CREATEDBYUSERID |
User ID of the user whose action resulted in the given view row being created. |
CREATEDBYDATETIME |
Date and time when the view row was created. |
MODIFIEDBYUSERID |
User ID of the user whose action resulted in the most recent change to data in the given view row. |
MODIFIEDDATETIME |
Date and time when the data in the view row was most recently updated. |