RT_ITEMSTATE
This table contains information about items and itemsets on started forms.
| Column name (Key indicator) | Column description |
|---|---|
| CONTEXTID | Numeric identifier for the item context. |
| ITEM | Always 1; indicates that the row represents one item or itemset. |
| SECTIONITEM |
Item is in a section. 0 - No 1 - Yes |
| ITEMSETITEM |
Item is in an itemset. 0 - No 1 - Yes |
| SITEID | Numeric identifier for the site with which the item is associated. |
| SUBJECTID | Numeric identifier for the subject with which the item is associated. |
| SUBJECTVISITID | Numeric identifier for the subject visit with which the item is associated. |
| VISITID | Numeric identifier for the visit with which the item is associated. |
| VISITINDEX |
Instance identifier for the started or activated visit in which the item exists: 0 - expected visit 1 - started, non-repeating visit <revisionnumber> - repeating visit |
| FORMID | Numeric identifier for the form on which the item exists. |
| FORMINDEX |
Instance identifier for the started or activated form in which the item exists: 0 - expected form 1 - started, non-repeating form <revisionnumber> - repeating form |
| FORMREV | Revision number for the activated form on which the item exists. |
| 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. |
| SECTIONORDER | Order of the section in which the item exists on an activated form. |
| SECTIONITEMORDER | Item order within the section in which the item exists on an activated form. |
| ITEMSETID | Numeric identifier for the itemset in which the item exists. |
| ITEMSETREV | Revision number for the itemset in which the item exists. |
| ITEMSETINDEX | Itemset instance identifier for the itemset 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. |
| MAXAUDITORDER | Most recent item data change revision. |
| ITEMSDVED |
Item has been source verified: 0 - No 1 - Yes |
| ITEMDELETED |
Item has been deleted: 0 - No 1 - Yes |
| MINCONTEXTREV | First item state change revision. |
| MAXCONTEXTREV | Most recent item state change revision. |
| DATATRANSACTIONID | Transaction numeric identifier associated with the most recent item data change. |
| DATAUSERID | Numeric identifier of the user that made the most recent item data change. |
| DATATIME | Time of the most recent item data change. |
| DATAREASON | Reason for the most recent item data change. |
| SDVTIME | Most recent time the item was source verified. If an item is unverified, the value changes to NULL. |
| ITEMHASDATA | Indicates whether the item contains data. |
| CONTROLS | Count of controls in the item. |
| CONTROLSWITHDATA | Count of controls in the item that contain data. |
| STATETRANSACTIONID | Transaction numeric identifier associated with the most recent item state change. |
| STATEUSERID | Numeric identifier of the user who made the most recent item state change. |
| STATETIME | Time of the most recent item state change. |
| STATEREASON | Reason for the most recent item state change. |
| 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. |
| ITEMCOMMENTS | Count of comments associated with the item or itemset. |
| ITEMMARKEDINCOMPLETE |
Item is marked incomplete: 0 - No 1 - Yes |
| BLANK |
The item exists in a Repeating Data itemset, and is blank in the itemset. 0 - No 1 - Yes |
| PREDEFINED |
The item exists in a Repeating Data itemset, and is predefined 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 |
| CREATEDDATETIME | Date and time when the item was started; that is, when a user entered data in the item or triggered a rule that entered data in the item. |
| CREATEDBYUSERID | User ID of the user who started the item by entering data or triggering a rule that entered data in the item. |
| MODIFIEDDATETIME | Date and time when the item was most recently modified; that is, when a user most recently entered data in the item or triggered a rule that entered data in the item. |
| MODIFIEDBYUSERID | User ID of the user who most recently started the item by entering data or triggering a rule that entered data in the item. |
| ITEMFIRSTSDV | First time the item was source verified. |
| ITEMFIRSTDATA | First time the item had data. |
| ITEMEMPTY |
Item has no data in any controls: 0 - No 1 - Yes |