IRV_CRF_STATUS_REPORT

This view contains information about forms. It contains a subset of the data for all of the forms from the IRV_SV_SUBJECT_FORMS table with labels such as Site Name, and Visit Name joined in to simplify the task of writing reports.

Column Name (Key indicator)	Column Description
INFORMPARTIALURL_CRFVIEW	Partial Oracle InForm URL for the form.
STUDYVERSIONID	Numeric identifier for the study version with which the form is associated.
SUBJECTID (PK)	Numeric identifier for the subject for whom the form exists.
SITEID	Numeric identifier for the site with which the form is associated.
VISITID (PK)	Numeric identifier for the visit in which the form exists.
VISITREV	Revision number for the visit in which the form exists.
VISITORDER	Order in the study of the visit with which the form is associated.
VISITTYPE	Numeric identifier for the type of 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 in which the form exists: 0 - expected visit 1 - started, non-repeating visit <revisionnumber> - repeating visit
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.
SITENAME	Name of the site with which the form is associated.
SITEMNEMONIC	Mnemonic of the site with which the form is associated.
SITECOUNTRY	Country of the site with which the form is associated.
SUBJECTNUMBERSTR	Subject number for the subject with whom the form is associated.
SUBJECTENROLLED	Subject is currently Enrolled: 0 - No 1 - Yes
SUBJECTEVERENROLLED	Subject has ever been enrolled: 0 - No 1 - Yes
SUBJECTRAMDOMIZED	Subject is currently Randomized: 0 - No 1 - Yes
SUBJECTEVERRAMDOMIZED	Subject has ever been randomized: 0 - No 1 - Yes
SUBJECTCOMPLETED	Subject is currently complete: 0 - No 1 - Yes
SUBJECTEVERCOMPLETED	Subject has ever been complete: 0 - No 1 - Yes
SUBJECTINCOMPLETE	Subject is currently not complete: 0 - No 1 - Yes
SUBJECTEVERINCOMPLETE	Subject has ever been not complete: 0 - No 1 - Yes
SUBJECTSTATE	State of the subject with whom the form is associated.
VISITREFNAME	RefName for the visit in which the form exists.
VISITNAME	Name of the visit in which the form exists.
VISITMNEMONIC	Abbreviated name for the visit in which the form exists.
EXPECTEDSTARTDATE	Expected start date for the visit in which the form exists: (STARTHOURSFROMENROLL + subject enrolled date)
VISIT_FIRST_ENTRY	Date when data was first entered for the visit in which the form exists.
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.
FORMREFNAME	RefName for the form.
FORMNAME	Form name.
FORMMNEMONIC	Abbreviated name for the form.
FORMORDER	Order of the form in the visit.
EXPECTEDFORM	Form is expected: 0 - No 1 - Yes
HASREQUIREDITEMS	Form has required items: 0 - No 1 - Yes
HASSDVREQUIREDITEMS	Form has items marked SV Required: 0 - No 1 - Yes
STARTEDDATE	Date the form was started: 0 - No 1 - Yes
STARTEDSTATE	Form is in the Started state: 0 - No 1 - Yes
SDVREADYSTATE	Form is in the SV Ready state: 0 - No 1 - Yes
SDVPARTIALSTATE	Form is in the Not Complete state: 0 - No 1 - Yes
SDVCOMPLETESTATE	Form is in the Verified state: 0 - No 1 - Yes
LOCKEDSTATE	Form is in the Locked state: 0 - No 1 - Yes
FROZENSTATE	Form is in the Frozen state: 0 - No 1 - Yes
SIGNEDSTATE	Form is in the Signed state: 0 - No 1 - Yes
COMPLETESTATE	Form is in the Complete state: 0 - No 1 - Yes
HASDATASTATE	Form has data: 0 - No 1 - Yes
MISSINGITEMSSTATE	Form is missing required items: 0 - No 1 - Yes
NOTDONESTATE	Form is marked Not Done: 0 - No 1 - Yes
DELETEDSTATE	Form is deleted: 0 - No 1 - Yes
BOOKSIGN	Form contains a CRB signature: 0 - No 1 - Yes
HASQUERIESSTATE	Form has queries: 0 - No 1 - Yes
HASCOMMENTSSTATE	Form has comments: 0 - No 1 - Yes
QUERYCOUNT	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.
COMMENTCOUNT	Count of comments associated with the form.
CITEMCOMMENT	Count of item comments associated with the form.
CFORMCOMMENT	Count of form comments associated with the form.
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.