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