IRV_SV_SUBJECT_FORMS
This view contains information about forms. It contains all of the forms from IRV_AF_SUBJECT_FORMS and information about expected forms that do not yet exist.
Note:
For rows relating to expected forms that do not yet exist, form state related columns will appear null, to represent their non-started state.Column Name (Key indicator) | Column Description |
---|---|
FORMCOUNT | Always 1; indicates that the row represents one form. |
SUBJECTID (PK) | Numeric identifier for the subject with whom the form is associated. |
SUBJECTSTATE |
Numeric value for state of the subject with whom the form is associated: 1 - Screened 2 - Screening Failure 3 - Enrollment Failure 4 - Enrolled 5 - Randomized 6 - Completed 7 - Dropped Out |
SITEID | Numeric identifier for the site with which the form is associated. |
STUDYVERSIONID | Numeric identifier for the study version of the study with which the form is associated. |
VISITID (PK) | Numeric identifier for the visit with which the form is associated. |
VISITREV | Revision number for the visit with which the form is associated. |
VISITORDER | Order in the study of the started or activated visit with which the form is associated. |
VISITTYPE |
Numeric value for the type of started or activated visit in which the form exists: 1 - Visit 2 - Enrollment 3 - Screening 4 - Monitor 5 - Status 6 - Common CRF 7 - Regdocs 8 - Visitreports 9 - Conflict 16 - Relation |
VISITINDEX (PK) |
Instance identifier for the visit with which the form is associated: 0 - expected visit 1 - started, non-repeating visit <revisionnumber> - repeating visit |
SUBJECTVISITID | Numeric identifier for the subject visit with which the form is associated. |
SUBJECTVISITREV | Revision number for the subject visit with which the form is associated. |
FORMID (PK) | Numeric identifier for the form. |
FORMREV (PK) | Revision number for the form. |
FORMINDEX (PK for repeating forms only) |
Identifier for the form instance: 0 - unstarted form 1 - non-repeating form <revisionnumber> - repeating form |
INFORMACTIVATIONTIME | Date and time the form was activated. |
DOV | Date of visit, as entered in the InForm user interface. |
DOVDTMASK | Indicates valid date components that comprise the DOV. Sum of the following values for each valid date part: Year (0x01) 1, Month (0x02) 2, Day (0x04) 4, Hour (0x08) 8, Minute (0x10) 16, Second (0x20) 32. |
VISIT_FIRST_ENTRY | Date when data was first entered for the visit with which the form is associated. |
VISITDELETED |
Visit associated with the form has been deleted: 0 - No 1 - Yes |
EXPECTEDSTARTDATE |
Expected start date for the visit associated with the form: (STARTHOURSFROMENROLL + subject enrolled date) |
FORMORDER | Order of the form in the visit. |
FORMDYNAMIC |
Form is a dynamic form: 0 - No 1 - Yes |
FORMREPEATING |
Form is a repeating form: 0 - No 1 - Yes |
FORMCOMMON |
Form is a common form: 0 - No 1 - Yes |
ALTFORM |
Form is an alternate form: 0 - No 1 - Yes |
EXPECTINGALTFORM |
Form is expected, and has an alternate form: 0 - No 1 - Yes |
ALTFORMID | Numeric identifier for the alternate form associated with the form. |
ALTFORMREV | Revision number for the alternate form associated with the form. |
HASREQUIREDITEMS | Form has one or more required items. |
HASSDVREQUIREDITEMS | Form has one or more items marked SV Required. |
EXPECTEDFORM |
Form is expected: 0 - No 1 - Yes |
FHREVS | Count of times the form state has changed. |
MINFORMHISTORYID | First form history revision. |
MINFORMHISTORYREV | Most recent form history revision. |
MAXFORMHISTORYID | Numeric identifier for the first form history revision. |
MAXFORMHISTORYREV | Numeric identifier for the most recent form history revision. |
FORMHISTORYTIME | Time of the most recent form state change. |
HISTORICALORDER | Sequential numeric identifier that corresponds to the current form state revision transaction. |
USERID | Numeric identifier of the user who last changed the form state. |
TRANSACTIONID | Numeric identifier of the most recent transaction to change the form state. |
REASON | Reason for most recent form state change. |
STATEHIST | Current form state. |
ORIGINALSTATE | Previous form state. |
ACTION | Action that may have occurred in conjunction with the last form state change. |
STARTEDSTATE |
Form is in the Started state: 0 - No 1 - Yes |
FMINSTARTEDSTATE | First time the form was placed in the Started state. |
FMAXSTARTEDSTATE | Most recent time the form was placed in the Started state. |
SDVREADYSTATE |
Form is in the SV Ready state: 0 - No 1 - Yes |
FMINSDVREADYSTATE | First time the form was placed in the SV Ready state. |
FMAXSDVREADYSTATE | Most recent time the form was placed in the SV Ready state. |
SDVPARTIALSTATE |
Form is in the Not Complete state: 0 - No 1 - Yes |
FMINSDVPARTIALSTATE | First time the form was placed in the Not Complete state. |
FMAXSDVPARTIALSTATE | Most recent time the form was placed in the Not Complete state. |
SDVCOMPLETESTATE |
Form is in the Verified state: 0 - No 1 - Yes |
FMINSDVCOMPLETESTATE | First time the form was placed in the Verified state. |
FMAXSDVCOMPLETESTATE | Most recent time the form was placed in the Verified state. |
SDVSELECTEDSTATE |
Form is selected for source verification: 0 - No 1 - Yes |
LOCKEDSTATE |
Form is in the Locked state: 0 - No 1 - Yes |
FMINLOCKEDSTATE | First time the form was placed in the Locked state. |
FMAXLOCKEDSTATE | Most recent time the form was placed in the Locked state. |
FROZENSTATE |
Form is in the Frozen state: 0 - No 1 - Yes |
FMINFROZENSTATE | First time the form was placed in the Frozen state. |
FMAXFROZENSTATE | Most recent time the form was placed in the Frozen state. |
SIGNEDSTATE |
Form is in the Signed state: 0 - No 1 - Yes |
FMINSIGNEDSTATE | First time the form was placed in the Signed state. |
FMAXSIGNEDSTATE | Most recent time the form was placed in the Signed state. |
COMPLETESTATE |
Form is in the Complete state: 0 - No 1 - Yes |
FMINCOMPLETESTATE | First time the form was placed in the Complete state. |
FMAXCOMPLETESTATE | Most recent time the form was placed in the Complete state. |
HASQUERIESSTATE |
Form has associated queries: 0 - No 1 - Yes |
FMINHASQUERIESSTATE | First time the form had associated queries. |
FMAXHASQUERIESSTATE | Most recent time the form had associated queries. |
HASCOMMENTSSTATE |
Form has associated comments: 0 - No 1 - Yes |
FMINHASCOMMENTSSTATE | First time the form had associated comments. |
FMAXHASCOMMENTSSTATE | Most recent time the form had associated comments. |
HASDATASTATE |
Form has data: 0 - No 1 - Yes |
FMINHASDATASTATE | First time the form had data. |
FMAXHASDATASTATE | Most recent time the form had data. |
MISSINGITEMSSTATE |
Form is missing required items: 0 - No 1 - Yes |
FMINMISSINGITEMSSTATE | First time the form was considered to have missing items. |
FMAXMISSINGITEMSSTATE | Most recent time the form was considered to have missing items. |
NOTDONESTATE |
Form has been marked Not Done: 0 - No 1 - Yes |
FMINNOTDONESTATE | First time the form was marked Not Done. |
FMAXNOTDONESTATE | Most recent time the form was marked Not Done. |
DELETEDSTATE |
Form has been deleted: 0 - No 1 - Yes |
FMINDELETEDSTATE | First time the form was deleted. |
FMAXDELETEDSTATE | Most recent time the form was deleted. |
DELETEDDYNAMICFORMSTATE |
Form is a dynamic form that has been deleted: 0 - No 1 - Yes |
FMINDELETEDDYNAMICFORMSTATE | First time the dynamic form was deleted. |
FMAXDELETEDDYNAMICFORMSTATE | Most recent time the dynamic form was deleted. |
BOOKSIGN |
Form represents a CRB signature form: 0 - No 1 - Yes |
FMINBOOKSIGN | First time the form was a CRB signature form. |
FMAXBOOKSIGN | Most recent time the form was a CRB signature form. |
INFORMPARTIALURL_CRFVIEW | Partial InForm URL for the form. |
FDAYSSINCEDOV | Number of days since DOV for the visit containing this form. |
FDAYSSINCESTART | Count of days since the form was started. |
FDAYSDOVTOSTART | Count of days from DOV to form started. |
FDAYSDOVTOCOMPLETE | Count of days from DOV to form complete. |
FDAYSSTARTTOCOMPLETE | Count of days from form started to form complete. |
FDAYSCOMPLETETOFROZEN | Count of days from form complete to form frozen. |
FDAYSCOMPLETETOSDVREADY | Count of days from form complete to SV Ready. |
FDAYSCOMPLETETOSDVCOMPLETE | Count of days from form complete to Verified. |
FDAYSCOMPLETETOSIGNED | Count of days from form complete to signed. |
FDAYSSIGNTOSDVCOMPLETE | Count of days from form signed to Verified. |
FDAYSSDVREADYTOSDVCOMPLETE | Count of days from form SV Ready to Verified. |
FDAYSFROZENTOSDVCOMPLETE | Count of days from form frozen to Verified. |
FDAYSSDVCOMPLETETOSIGN | Count of days from form frozen to Verified. |
FDAYSSIGNTOLOCK | Count of days from form signed to locked. |
FDAYSCOMPLETETOLOCK | Count of days from form complete to locked. |
LASTDATATIME |
Most recent date and time when any of the following occurred:
|
QUERIES | Count of queries against the form. |
QTYPEAUTO | Count of autoqueries against the form. |
QTYPEMANUAL | Count of manual queries against the form. |
QTYPECONFLICT | Count of conflict queries against the form. |
QREISSUED | Count of reissued queries against the form. |
QCANDIDATE | Count of candidate queries against the form. |
QOPENED | Count of opened queries against the form. |
QANSWERED | Count of answered queries against the form. |
QCLOSED | Count of closed queries against the form. |
QDELETED | Count of deleted queries against the form. |
HASANSWEREDQUERY |
Form has one or more associated answered queries: 0 - No 1 - Yes |
ITEMCOMMENTS | Count of item- or itemset-level comments associated with the form. |
FORMCOMMENTS | Count of form-level comments associated with the form. |
HASITEMCOMMENT |
Form has one or more associated item- or itemset-level comments: 0 - No 1 - Yes |
REVIEWSTATE1STAGE1 |
Form is in the first stage of the first custom review state in the study: 0 - No 1 - Yes |
REVIEWSTATE1STAGE2 |
Form is in the second stage of the first custom review state in the study: 0 - No 1 - Yes |
REVIEWSTATE1STAGE3 |
Form is in the third stage of the first custom review state in the study: 0 - No 1 - Yes |
REVIEWSTATE2STAGE1 |
Form is in the first stage of the second custom review state in the study: 0 - No 1 - Yes |
REVIEWSTATE2STAGE2 |
Form is in the second stage of the second custom review state in the study: 0 - No 1 - Yes |
REVIEWSTATE2STAGE3 |
Form is in the third stage of the second custom review state in the study: 0 - No 1 - Yes |
REVIEWSTATE3STAGE1 |
Form is in the first stage of the third custom review state in the study: 0 - No 1 - Yes |
REVIEWSTATE3STAGE2 |
Form is in the second stage of the third custom review state in the study: 0 - No 1 - Yes |
REVIEWSTATE3STAGE3 |
Form is in the third stage of the third custom review state in the study: 0 - No 1 - Yes |
REVIEWSTATE4STAGE1 |
Form is in the first stage of the fourth custom review state in the study: 0 - No 1 - Yes |
REVIEWSTATE4STAGE2 |
Form is in the second stage of the fourth custom review state in the study: 0 - No 1 - Yes |
REVIEWSTATE4STAGE3 |
Form is in the third stage of the fourth custom review state in the study: 0 - No 1 - Yes |
REVIEWSTATE5STAGE1 |
Form is in the first stage of the fifth custom review state in the study: 0 - No 1 - Yes |
REVIEWSTATE5STAGE2 |
Form is in the second stage of the fifth custom review state in the study: 0 - No 1 - Yes |
REVIEWSTATE5STAGE3 |
Form is in the third stage of the fifth custom review state in the study: 0 - No 1 - Yes |
REVIEWSTATE1 |
Form is in the first custom review state. 0 - No 1 - Yes |
REVIEWSTATE2 |
Form is in the second custom review state. 0 - No 1 - Yes |
REVIEWSTATE3 |
Form is in the third custom review state. 0 - No 1 - Yes |
REVIEWSTATE4 |
Form is in the fourth custom review state. 0 - No 1 - Yes |
REVIEWSTATE5 |
Form is in the fifth custom review state. 0 - No 1 - Yes |
REVIEWSTATE1DATECHANGED | Date and time when the form was assigned the first custom review state. |
REVIEWSTATE2DATECHANGED | Date and time when the form was assigned the second custom review state. |
REVIEWSTATE3DATECHANGED | Date and time when the form was assigned the third custom review state. |
REVIEWSTATE4DATECHANGED | Date and time when the form was assigned the fourth custom review state. |
REVIEWSTATE5DATECHANGED | Date and time when the form was assigned the fifth custom review state. |
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. |
Parent topic: Study operational data