INFORMPARTIALURL_CRFVIEW

Partial InForm URL for the form.

STUDYVERSIONID

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

SUBJECTID (PK)

Numeric identifier for the subject for whom the form exists.

SITEID

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

VISITID (PK)

Numeric identifier for the visit in which the form exists.

VISITREV

Revision number for the visit in which the form exists.

VISITORDER

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

VISITTYPE

Numeric identifier for the type of 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 in which the form exists:

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

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.

SITENAME

Name of the site with which the form is associated.

SITEMNEMONIC

Mnemonic of the site with which the form is associated.

SITECOUNTRY

Country of the site with which the form is associated.

SUBJECTNUMBERSTR

Subject number for the subject with whom the form is associated.

SUBJECTENROLLED

Subject is currently Enrolled:

0 - No

1 - Yes

SUBJECTEVERENROLLED

Subject has ever been enrolled:

0 - No

1 - Yes

SUBJECTRAMDOMIZED

Subject is currently Randomized:

0 - No

1 - Yes

SUBJECTEVERRAMDOMIZED

Subject has ever been randomized:

0 - No

1 - Yes

SUBJECTCOMPLETED

Subject is currently complete:

0 - No

1 - Yes

SUBJECTEVERCOMPLETED

Subject has ever been complete:

0 - No

1 - Yes

SUBJECTINCOMPLETE

Subject is currently not complete:

0 - No

1 - Yes

SUBJECTEVERINCOMPLETE

Subject has ever been not complete:

0 - No

1 - Yes

SUBJECTSTATE

State of the subject with whom the form is associated.

VISITREFNAME

RefName for the visit in which the form exists.

VISITNAME

Name of the visit in which the form exists.

VISITMNEMONIC

Abbreviated name for the visit in which the form exists.

EXPECTEDSTARTDATE

Expected start date for the visit in which the form exists:

(STARTHOURSFROMENROLL + subject enrolled date)

VISIT_FIRST_ENTRY

Date when data was first entered for the visit in which the form exists.

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.

FORMREFNAME

RefName for the form.

FORMNAME

Form name.

FORMMNEMONIC

Abbreviated name for the form.

FORMORDER

Order of the form in the visit.

EXPECTEDFORM

Form is expected:

0 - No

1 - Yes

HASREQUIREDITEMS

Form has required items:

0 - No

1 - Yes

HASSDVREQUIREDITEMS

Form has items marked SV Required:

0 - No

1 - Yes

STARTEDDATE

Date the form was started:

0 - No

1 - Yes

STARTEDSTATE

Form is in the Started state:

0 - No

1 - Yes

SDVREADYSTATE

Form is in the SV Ready state:

0 - No

1 - Yes

SDVPARTIALSTATE

Form is in the Not Complete state:

0 - No

1 - Yes

SDVCOMPLETESTATE

Form is in the Verified state:

0 - No

1 - Yes

LOCKEDSTATE

Form is in the Locked state:

0 - No

1 - Yes

FROZENSTATE

Form is in the Frozen state:

0 - No

1 - Yes

SIGNEDSTATE

Form is in the Signed state:

0 - No

1 - Yes

COMPLETESTATE

Form is in the Complete state:

0 - No

1 - Yes

HASDATASTATE

Form has data:

0 - No

1 - Yes

MISSINGITEMSSTATE

Form is missing required items:

0 - No

1 - Yes

NOTDONESTATE

Form is marked Not Done:

0 - No

1 - Yes

DELETEDSTATE

Form is deleted:

0 - No

1 - Yes

BOOKSIGN

Form contains a CRB signature:

0 - No

1 - Yes

HASQUERIESSTATE

Form has queries:

0 - No

1 - Yes

HASCOMMENTSSTATE

Form has comments:

0 - No

1 - Yes

QUERYCOUNT

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.

COMMENTCOUNT

Count of comments associated with the form.

CITEMCOMMENT

Count of item comments associated with the form.

CFORMCOMMENT

Count of form comments associated with the form.

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.