FORMCOUNT

Always 1; indicates that the row represents one form.

SUBJECTID (PK)

Numeric identifier for the subject with whom the form is associated.

SUBJECTSTATE

Numeric value for state of the subject with whom the form is associated:

1 - Screened
2 - Screening Failure
3 - Enrollment Failure
4 - Enrolled
5 - Randomized
6 - Completed
7 - Dropped Out

SITEID

Numeric identifier for the site with which the form is associated.

STUDYVERSIONID

Numeric identifier for the study version of the study with which the form is associated.

VISITID (PK)

Numeric identifier for the visit with which the form is associated.

VISITREV

Revision number for the visit with which the form is associated.

VISITORDER

Order in the study of the started or activated visit with which the form is associated.

VISITTYPE

Numeric value for the type of started or activated 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 with which the form is associated:

0 - expected visit
1 - started, non-repeating visit
<revisionnumber> - repeating visit

SUBJECTVISITID

Numeric identifier for the subject visit with which the form is associated.

SUBJECTVISITREV

Revision number for the subject visit with which the form is associated.

FORMID (PK)

Numeric identifier for the form.

FORMREV (PK)

Revision number for the form.

FORMINDEX (PK for repeating forms only)

Identifier for the form instance:

0 - unstarted form
1 - non-repeating form
<revisionnumber> - repeating form

INFORMACTIVATIONTIME

Date and time the form was activated.

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.

VISIT_FIRST_ENTRY

Date when data was first entered for the visit with which the form is associated.

VISITDELETED

Visit associated with the form has been deleted:

0 - No

1 - Yes

EXPECTEDSTARTDATE

Expected start date for the visit associated with the form:

(STARTHOURSFROMENROLL + subject enrolled date)

FORMORDER

Order of the form in the visit.

FORMDYNAMIC

Form is a dynamic form:

0 - No

1 - Yes

FORMREPEATING

Form is a repeating form:

0 - No

1 - Yes

FORMCOMMON

Form is a common form:

0 - No

1 - Yes

ALTFORM

Form is an alternate form:

0 - No

1 - Yes

EXPECTINGALTFORM

Form is expected, and has an alternate form:

0 - No

1 - Yes

ALTFORMID

Numeric identifier for the alternate form associated with the form.

ALTFORMREV

Revision number for the alternate form associated with the form.

HASREQUIREDITEMS

Form has one or more required items.

HASSDVREQUIREDITEMS

Form has one or more items marked SV Required.

EXPECTEDFORM

Form is expected:

0 - No

1 - Yes

FHREVS

Count of times the form state has changed.

MINFORMHISTORYID

First form history revision.

MINFORMHISTORYREV

Most recent form history revision.

MAXFORMHISTORYID

Numeric identifier for the first form history revision.

MAXFORMHISTORYREV

Numeric identifier for the most recent form history revision.

FORMHISTORYTIME

Time of the most recent form state change.

HISTORICALORDER

Sequential numeric identifier that corresponds to the current form state revision transaction.

USERID

Numeric identifier of the user who last changed the form state.

TRANSACTIONID

Numeric identifier of the most recent transaction to change the form state.

REASON

Reason for most recent form state change.

STATEHIST

Current form state.

ORIGINALSTATE

Previous form state.

ACTION

Action that may have occurred in conjunction with the last form state change.

STARTEDSTATE

Form is in the Started state:

0 - No

1 - Yes

FMINSTARTEDSTATE

First time the form was placed in the Started state.

FMAXSTARTEDSTATE

Most recent time the form was placed in the Started state.

SDVREADYSTATE

Form is in the SV Ready state:

0 - No

1 - Yes

FMINSDVREADYSTATE

First time the form was placed in the SV Ready state.

FMAXSDVREADYSTATE

Most recent time the form was placed in the SV Ready state.

SDVPARTIALSTATE

Form is in the Not Complete state:

0 - No

1 - Yes

FMINSDVPARTIALSTATE

First time the form was placed in the Not Complete state.

FMAXSDVPARTIALSTATE

Most recent time the form was placed in the Not Complete state.

SDVCOMPLETESTATE

Form is in the Verified state:

0 - No

1 - Yes

FMINSDVCOMPLETESTATE

First time the form was placed in the Verified state.

FMAXSDVCOMPLETESTATE

Most recent time the form was placed in the Verified state.

SDVSELECTEDSTATE

Form is selected for source verification:

0 - No

1 - Yes

LOCKEDSTATE

Form is in the Locked state:

0 - No

1 - Yes

FMINLOCKEDSTATE

First time the form was placed in the Locked state.

FMAXLOCKEDSTATE

Most recent time the form was placed in the Locked state.

FROZENSTATE

Form is in the Frozen state:

0 - No

1 - Yes

FMINFROZENSTATE

First time the form was placed in the Frozen state.

FMAXFROZENSTATE

Most recent time the form was placed in the Frozen state.

SIGNEDSTATE

Form is in the Signed state:

0 - No

1 - Yes

FMINSIGNEDSTATE

First time the form was placed in the Signed state.

FMAXSIGNEDSTATE

Most recent time the form was placed in the Signed state.

COMPLETESTATE

Form is in the Complete state:

0 - No

1 - Yes

FMINCOMPLETESTATE

First time the form was placed in the Complete state.

FMAXCOMPLETESTATE

Most recent time the form was placed in the Complete state.

HASQUERIESSTATE

Form has associated queries:

0 - No

1 - Yes

FMINHASQUERIESSTATE

First time the form had associated queries.

FMAXHASQUERIESSTATE

Most recent time the form had associated queries.

HASCOMMENTSSTATE

Form has associated comments:

0 - No

1 - Yes

FMINHASCOMMENTSSTATE

First time the form had associated comments.

FMAXHASCOMMENTSSTATE

Most recent time the form had associated comments.

HASDATASTATE

Form has data:

0 - No

1 - Yes

FMINHASDATASTATE

First time the form had data.

FMAXHASDATASTATE

Most recent time the form had data.

MISSINGITEMSSTATE

Form is missing required items:

0 - No

1 - Yes

FMINMISSINGITEMSSTATE

First time the form was considered to have missing items.

FMAXMISSINGITEMSSTATE

Most recent time the form was considered to have missing items.

NOTDONESTATE

Form has been marked Not Done:

0 - No

1 - Yes

FMINNOTDONESTATE

First time the form was marked Not Done.

FMAXNOTDONESTATE

Most recent time the form was marked Not Done.

DELETEDSTATE

Form has been deleted:

0 - No

1 - Yes

FMINDELETEDSTATE

First time the form was deleted.

FMAXDELETEDSTATE

Most recent time the form was deleted.

DELETEDDYNAMICFORMSTATE

Form is a dynamic form that has been deleted:

0 - No

1 - Yes

FMINDELETEDDYNAMICFORMSTATE

First time the dynamic form was deleted.

FMAXDELETEDDYNAMICFORMSTATE

Most recent time the dynamic form was deleted.

BOOKSIGN

Form represents a CRB signature form:

0 - No

1 - Yes

FMINBOOKSIGN

First time the form was a CRB signature form.

FMAXBOOKSIGN

Most recent time the form was a CRB signature form.

INFORMPARTIALURL_CRFVIEW

Partial InForm URL for the form.

FDAYSSINCEDOV

Number of days since DOV for the visit containing this form.

FDAYSSINCESTART

Count of days since the form was started.

FDAYSDOVTOSTART

Count of days from DOV to form started.

FDAYSDOVTOCOMPLETE

Count of days from DOV to form complete.

FDAYSSTARTTOCOMPLETE

Count of days from form started to form complete.

FDAYSCOMPLETETOFROZEN

Count of days from form complete to form frozen.

FDAYSCOMPLETETOSDVREADY

Count of days from form complete to SV Ready.

FDAYSCOMPLETETOSDVCOMPLETE

Count of days from form complete to Verified.

FDAYSCOMPLETETOSIGNED

Count of days from form complete to signed.

FDAYSSIGNTOSDVCOMPLETE

Count of days from form signed to Verified.

FDAYSSDVREADYTOSDVCOMPLETE

Count of days from form SV Ready to Verified.

FDAYSFROZENTOSDVCOMPLETE

Count of days from form frozen to Verified.

FDAYSSDVCOMPLETETOSIGN

Count of days from form frozen to Verified.

FDAYSSIGNTOLOCK

Count of days from form signed to locked.

FDAYSCOMPLETETOLOCK

Count of days from form complete to locked.

LASTDATATIME

Most recent date and time when any of the following occurred:

• Data was entered or changed on the form.
• An add entry itemset row was deleted or undeleted on the form.
• The form instance was deleted or undeleted.

QUERIES

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.

HASANSWEREDQUERY

Form has one or more associated answered queries:

0 - No

1 - Yes

ITEMCOMMENTS

Count of item- or itemset-level comments associated with the form.

FORMCOMMENTS

Count of form-level comments associated with the form.

HASITEMCOMMENT

Form has one or more associated item- or itemset-level comments:

0 - No

1 - Yes

REVIEWSTATE1STAGE1

Form is in the first stage of the first custom review state in the study:

0 - No

1 - Yes

REVIEWSTATE1STAGE2

Form is in the second stage of the first custom review state in the study:

0 - No

1 - Yes

REVIEWSTATE1STAGE3

Form is in the third stage of the first custom review state in the study:

0 - No

1 - Yes

REVIEWSTATE2STAGE1

Form is in the first stage of the second custom review state in the study:

0 - No

1 - Yes

REVIEWSTATE2STAGE2

Form is in the second stage of the second custom review state in the study:

0 - No

1 - Yes

REVIEWSTATE2STAGE3

Form is in the third stage of the second custom review state in the study:

0 - No

1 - Yes

REVIEWSTATE3STAGE1

Form is in the first stage of the third custom review state in the study:

0 - No

1 - Yes

REVIEWSTATE3STAGE2

Form is in the second stage of the third custom review state in the study:

0 - No

1 - Yes

REVIEWSTATE3STAGE3

Form is in the third stage of the third custom review state in the study:

0 - No

1 - Yes

REVIEWSTATE4STAGE1

Form is in the first stage of the fourth custom review state in the study:

0 - No

1 - Yes

REVIEWSTATE4STAGE2

Form is in the second stage of the fourth custom review state in the study:

0 - No

1 - Yes

REVIEWSTATE4STAGE3

Form is in the third stage of the fourth custom review state in the study:

0 - No

1 - Yes

REVIEWSTATE5STAGE1

Form is in the first stage of the fifth custom review state in the study:

0 - No

1 - Yes

REVIEWSTATE5STAGE2

Form is in the second stage of the fifth custom review state in the study:

0 - No

1 - Yes

REVIEWSTATE5STAGE3

Form is in the third stage of the fifth custom review state in the study:

0 - No

1 - Yes

REVIEWSTATE1

Form is in the first custom review state.

0 - No

1 - Yes

REVIEWSTATE2

Form is in the second custom review state.

0 - No

1 - Yes

REVIEWSTATE3

Form is in the third custom review state.

0 - No

1 - Yes

REVIEWSTATE4

Form is in the fourth custom review state.

0 - No

1 - Yes

REVIEWSTATE5

Form is in the fifth custom review state.

0 - No

1 - Yes

REVIEWSTATE1DATECHANGED

Date and time when the form was assigned the first custom review state.

REVIEWSTATE2DATECHANGED

Date and time when the form was assigned the second custom review state.

REVIEWSTATE3DATECHANGED

Date and time when the form was assigned the third custom review state.

REVIEWSTATE4DATECHANGED

Date and time when the form was assigned the fourth custom review state.

REVIEWSTATE5DATECHANGED

Date and time when the form was assigned the fifth custom review state.

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.