IRV_SV_SUBJECT_FORMS

This view contains information about forms. It contains all of the forms from IRV_AF_SUBJECT_FORMS and information about expected forms that do not yet exist.

Note:

For rows relating to expected forms that do not yet exist, form state related columns will appear null, to represent their non-started state.
Column Name (Key indicator) Column Description
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.