FORMCOUNT

Always 1; indicates that the row represents one form.

SUBJECTID (PK)

Numeric identifier for the subject for whom the form exists in a started or activated visit.

SUBJECTSTATE

Numeric value for the state of the subject for whom the form exists in a started or activated visit:

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 in a started visit is associated.

STUDYID

Numeric identifier for the study with which the form in a started visit is associated.

STUDYVERSIONID

Numeric identifier for the current study version.

VISITID (PK)

Numeric identifier for the started or activated visit in which the form exists.

VISITREV

Revision number for the started or activated visit in which the form exists.

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 started or activated visit in which the form exists:

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

SUBJECTVISITID

Numeric identifier for the started or activated subject visit in which the form exists.

SUBJECTVISITREV

Revision number for the started or activated subject visit in which the form exists.

FORMID (PK)

Numeric identifier for the form.

FORMREV (PK)

Revision number for the form.

FORMINDEX (PK)

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 on the form.

VISITDELETED

Started or activated visit in which the form exists has been deleted:

0 - No

1 - Yes

EXPECTEDSTARTDATE

Expected start date for the started or activated visit with which the form is associated:

(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.

FHREVS

Count of times the form state has changed.

MINFORMHISTORYID

Date of the 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.

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.

FORMHISTORYTIME

Time of the most recent form state change.

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.

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 queries:

0 - No

1 - Yes

FMINHASQUERIESSTATE

First time the form had queries.

FMAXHASQUERIESSTATE

Most recent time the form had queries.

HASCOMMENTSSTATE

Form has comments:

0 - No

1 - Yes

FMINHASCOMMENTSSTATE

First time the form had comments.

FMAXHASCOMMENTSSTATE

Most recent time the form had 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 this form was a CRB signature form.

FMAXBOOKSIGN

Most recent time this form was a CRB signature form.

INFORMPARTIALURL_CRFVIEW

Partial InForm URL for the form.

FDAYSSINCEDOV

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

Note: Don't use this column if you load data incrementally from this view through updates to the MODIFIEDDTETIME value. This column updates dynamically every time data is retrieved from this View, changing values for date and time continuously as a result. As such, the MODIFIEDDATETIME column purposely ignores changes in this column.

FDAYSSINCESTART

Count of days since the form was started.

Note: Don't use this column if you load data incrementally from this view through updates to the MODIFIEDDTETIME value. This column updates dynamically every time data is retrieved from this View, changing values for date and time continuously as a result. As such, the MODIFIEDDATETIME column purposely ignores changes in this column.

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 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 item- or itemset-level comments:

0 - No

1 - Yes

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.