IRV_AF_SUBJECT_FORMS
This view contains information about forms that are in visits that have been started or activated in the InForm application. Each row in this view corresponds to one row in the Oracle InForm table PF_SUBJECTVECHAPTERPAGE.
| Column Name (Key indicator) | Column Description |
|---|---|
| FORMCOUNT | Always 1; indicates that the row represents one form. |
| SUBJECTID (PK) | Numeric identifier for the subject for whom the form exists in a started or activated visit. |
| SUBJECTSTATE |
Numeric value for the state of the subject for whom the form exists in a started or activated visit: 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 in a started visit is associated. |
| STUDYID | Numeric identifier for the study with which the form in a started visit is associated. |
| STUDYVERSIONID | Numeric identifier for the current study version. |
| VISITID (PK) | Numeric identifier for the started or activated visit in which the form exists. |
| VISITREV | Revision number for the started or activated visit in which the form exists. |
| 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 started or activated visit in which the form exists: 0 - expected visit 1 - started, non-repeating visit <revisionnumber> - repeating visit |
| SUBJECTVISITID | Numeric identifier for the started or activated subject visit in which the form exists. |
| SUBJECTVISITREV | Revision number for the started or activated subject visit in which the form exists. |
| FORMID (PK) | Numeric identifier for the form. |
| FORMREV (PK) | Revision number for the form. |
| FORMINDEX (PK) |
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 on the form. |
| VISITDELETED |
Started or activated visit in which the form exists has been deleted: 0 - No 1 - Yes |
| EXPECTEDSTARTDATE |
Expected start date for the started or activated visit with which the form is associated: (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. |
| FHREVS | Count of times the form state has changed. |
| MINFORMHISTORYID | Date of the 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. |
| 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. |
| FORMHISTORYTIME | Time of the most recent form state change. |
| 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. |
| 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 queries: 0 - No 1 - Yes |
| FMINHASQUERIESSTATE | First time the form had queries. |
| FMAXHASQUERIESSTATE | Most recent time the form had queries. |
| HASCOMMENTSSTATE |
Form has comments: 0 - No 1 - Yes |
| FMINHASCOMMENTSSTATE | First time the form had comments. |
| FMAXHASCOMMENTSSTATE | Most recent time the form had 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 this form was a CRB signature form. |
| FMAXBOOKSIGN | Most recent time this form was a CRB signature form. |
| INFORMPARTIALURL_CRFVIEW | Partial InForm URL for the form. |
| FDAYSSINCEDOV |
Number of days since the date of visit for the visit containing this form. Note: Don't use this column if you load data incrementally from this view through updates to the MODIFIEDDTETIME value. This column updates dynamically every time data is retrieved from this View, changing values for date and time continuously as a result. As such, the MODIFIEDDATETIME column purposely ignores changes in this column. |
| FDAYSSINCESTART |
Count of days since the form was started. Note: Don't use this column if you load data incrementally from this view through updates to the MODIFIEDDTETIME value. This column updates dynamically every time data is retrieved from this View, changing values for date and time continuously as a result. As such, the MODIFIEDDATETIME column purposely ignores changes in this column. |
| 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 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 item- or itemset-level comments: 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. |
Parent topic: Study operational data