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.

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