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