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.
Columns in the IRV_CRF_STATUS_REPORT view
IRV_CRF_STATUS_REPORT |
IRV_CRF_STATUS_REPORT |
---|---|
INFORMPARTIALURL_CRFVIEW |
Partial 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 |
VISITINDEX (PK) |
Instance identifier for the visit in which the form exists: 0 - expected 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 |
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. |