IRV_ACTIVATED_FORMS
This view contains information about forms that are in visits that have been started or activated in InForm. Each row in this view corresponds to one row in the InForm table PF_SUBJECTVECHAPTERPAGE.
Columns in the IRV_ACTIVATED_FORMS table
IRV_ACTIVATED_FORMS |
|
---|---|
Column Name (key indicator) |
Description |
ACTION |
Action related to form state change |
AFSOURCE |
Reserved column |
BOOKSIGN |
If case book is signed. 1 signed 0 not signed. |
COMPLETESTATE |
If the form is completed. 1 complete 0 not complete. |
COUNTANSWEREDQUERIES |
Number of answered queries on this form |
COUNTCANDIDATEQUERIES |
Number of queries in Candidate state on this form |
COUNTCLOSEDQUERIES |
Number of closed queries on this form |
COUNTOPENQUERIES |
Number of open queries on this form |
CREATEDBYUSERID
|
User ID of the user whose action resulted in the given view row being created. |
CREATEDDATETIME
|
Date and time when the view row was created. |
CURFORMHISTORYID |
The latest form history DBUID |
CURFORMHISTORYREV |
The latest form history revision number. |
DATEDATACHANGED |
Last time when form data changed. |
DELETEDDYNAMICFORMSTATE |
if a dynamic form is deleted (un-triggered). 1: deleted. 0: not deleted |
DELETEDSTATE |
If a repeating form instance (page) is deleted. 1: deleted. 0: not deleted. |
DOV |
Date of Visit of the visit this form is in. |
FMAXBOOKSIGN |
The latest date when case book was signed. |
FMAXCOMPLETESTATE |
The latest date when form was completed. |
FMAXDELETEDDYNAMICFORMSTATE |
The latest date when dynamic form was deleted. |
FMAXDELETEDSTATE |
The latest date when repeating page is deleted. |
FMAXFROZENSTATE |
The latest date when form was frozen |
FMAXHASCOMMENTSSTATE |
The latest date when a comment was entered to this form. |
FMAXHASDATASTATE |
The latest date when data was entered. |
FMAXHASQUERIESSTATE |
The latest date when a query was reissued. |
FMAXLOCKEDSTATE |
The latest date when the form was locked. |
FMAXMISSINGITEMSSTATE |
The latest date when the form has missing item state. |
FMAXNOTDONESTATE |
The latest date when the form has Not Done state. |
FMAXSDVCOMPLETESTATE |
The latest date when the form is SDV complete state |
FMAXSDVPARTIALSTATE |
The latest date when the form is SDV partial state |
FMAXSDVREADYSTATE |
The latest date when the form is SDV ready state. |
FMAXSDVSELECTEDSTATE |
The latest date when the form is SDV selected state |
FMAXSIGNEDSTATE |
The latest date when the form was signed. |
FMAXSTARTEDSTATE |
The latest date when the form was stated. |
FMINBOOKSIGN |
The earliest date when case book was signed. |
FMINCOMPLETESTATE |
The earliest date when the form was completed. |
FMINDELETEDDYNAMICFORMSTATE |
The earliest date when the form was dynamic deleted. |
FMINDELETEDSTATE |
The earliest date when the repeating page was deleted. |
FMINFROZENSTATE |
The earliest date when the form was frozen. |
FMINHASCOMMENTSSTATE |
The earliest date when the form was completed. |
FMINHASDATASTATE |
The earliest date when the form has data entered. |
FMINHASQUERIESSTATE |
The earliest date when the form has query reissued. |
FMINLOCKEDSTATE |
The earliest date when the form was locked. |
FMINMISSINGITEMSSTATE |
The earliest date when the form was in missing item state. |
FMINNOTDONESTATE |
The earliest date when the form was in Not Done state. |
FMINSDVCOMPLETESTATE |
The earliest date when the form was SDV complete. |
FMINSDVPARTIALSTATE |
The earliest date when the form was SDV partial state |
FMINSDVREADYSTATE |
The earliest date when the form was SDV ready. |
FMINSDVSELECTEDSTATE |
The earliest date when the form was SDV selected. |
FMINSIGNEDSTATE |
The earliest date when the form was signed. |
FMINSTARTEDSTATE |
The earliest date when the form was started. |
FORMHISTORYID |
Current form history DBUID |
FORMHISTORYREV |
Current form history revision number |
FORMID |
Form DBUID |
FORMINDEX |
Form index for repeating form |
FORMREV |
Form revision number |
FORMTYPE |
Form type. 1: patient CRF, 3: screen/enrollment form |
FROZENSTATE |
Form frozen state. 1 frozen, 0 not |
HASCOMMENTSSTATE |
Form has comment state. 1 has comment, 0 not. |
HASDATASTATE |
Form has data state. 1 has data, 0 not |
HASQUERIESSTATE |
Form has query state. 1 has query, 0 not |
HISTORICALORDER |
Order within an InForm transaction. |
INFORMACTIVATIONTIME |
Date when the form is activated. |
INFORMPARTIALURL_CRFVIEW |
Partial URL to this form |
ITEMSMARKEDINCOMPLETE |
If any item is marked as Not Done. 1 yes. 0 no. |
LOCKEDSTATE |
Form lock state. 1 locked, 0 not |
MISSINGITEMSSTATE |
Form has missing item state. 1 yes, 0 no |
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. |
NOTDONESTATE |
Form Not Done state. 1 marked as not done. 0 not. |
ORIGINALSTATE |
Form’s previous state |
PFTIMESTAMP |
Date when last form transaction happened. |
REASON |
Reason for the last form transaction |
REVIEWSTATE1 |
Review State 1. 1 true, 0 not |
REVIEWSTATE1DATECHANGED |
Date when review state 1 changed. |
REVIEWSTATE2 |
Review State 2. 1 true, 0 not |
REVIEWSTATE2DATECHANGED |
Date when review state 2 changed. |
REVIEWSTATE3 |
Review State 3. 1 true, 0 not |
REVIEWSTATE3DATECHANGED |
Date when review state 3 changed. |
REVIEWSTATE4 |
Review State 4. 1 true, 0 not |
REVIEWSTATE4DATECHANGED |
Date when review state 4 changed. |
REVIEWSTATE5 |
Review State 5. 1 true, 0 not |
REVIEWSTATE5DATECHANGED |
Date when review state 5 changed. |
SDVCOMPLETESTATE |
SDV complete state. 1 complete, 0 not |
SDVPARTIALSTATE |
SDV partial state. 1 partial, 0 not |
SDVREADYSTATE |
SDV ready state. 1 ready, 0 not |
SDVSELECTEDSTATE |
SDV selected state. 1 selected, 0 not |
SIGNEDSTATE |
Signed state. 1 signed, 0 not. |
SITEID |
Site DBUID |
STARTEDSTATE |
Form started state. 1 started, 0 noth |
STATEHIST |
Form state history. |
SUBJECTID |
Subject ID |
SUBJECTVISITID |
Subject visit ID |
TRANSACTIONID |
Last Transaction ID |
USERID |
User ID |
VISITDELETED |
Visit deleted. 1 deleted, 0 not |
VISITID |
Visit DBUID |
VISITINDEX |
Visit index |