SUBJECTVISITID

Numeric identifier for the activated subject visit associated with the form.

SUBJECTID (PK)

Numeric identifier for the subject associated with the form.

SITEID

Numeric identifier for the site associated with the form.

VISITID (PK)

Numeric identifier for the visit in which the form exists.

VISITINDEX (PK)

Identifier for the visit instance associated with the form:

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

PAGEREPEATKEY

Repeat identifier that ensures that there are no duplicate repeating pages.

DOV

Date of visit, as entered in the InForm user interface.

VISITDELETED

Visit associated with the form has been deleted:

0 - No

1 - Yes

INFORMACTIVATIONTIME

Date when the visit with which the form is associated was activated.

FORMTYPE

Form type:

1 - CRF

3 - Enrollment

4 - Custom

5 - Custom study

6 - Custom Admin

7 - Custom Rules

8 - Custom Auth

101 - Monitor Regdoc

102 - Monitor Visit Report

AFSOURCE

Reserved for internal Oracle use.

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.

PFTIMESTAMP

Reserved for internal Oracle use.

TRANSACTIONID

Numeric identifier for the transaction in which the form was activated.

REASON

Reason for modifying the form.

ACTION

Action performed on the form.

STATEHIST

States in which the form has existed:

00000001—Started

00000002—Has queries

00000004—Has missing items

00000008—SV Ready

00000010—Frozen

00000020—Locked

00000040—Signed

00000080—Verified

00000100—Not Complete

00000200—Not Done

00000400—Has comments

00000800—Has data

00001000—Deleted dynamic form

00002000—Deleted

00004000—Answered

00008000—Not selected for source verification

ORIGINALSTATE

First state in which the form existed.

FORMHISTORYID

Numeric identifier for the most recent state in which the form exists.

This column is a foreign key for the PF_SVECPSTATEHISTORY table.

FORMHISTORYREV

Revision number for the most recent revision for the form.

This column is a foreign key for the PF_SVECPSTATEHISTORY table.

CURFORMHISTORYID

Numeric identifier for the most recent state in which the form exists.

This column is a foreign key for the PF_SVECPSTATEHISTORY table.

CURFORMHISTORYREV

Revision number for the most recent revision for the form.

This column is a foreign key for the PF_SVECPSTATEHISTORY table.

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 selected for source verification, and 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 selected for source verification, and 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

FMINSDVSELECTEDSTATE

First time the form was selected for source verification.

FMAXSDVSELECTEDSTATE

Most recent time the form was selected for source verification.

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:

0 - No

1 - Yes

FMINBOOKSIGN

First time this form was a CRB signature.

FMAXBOOKSIGN

Most recent time this form was a CRB signature.

COUNTOPENQUERIES

Count of open queries on the form.

COUNTANSWEREDQUERIES

Count of answered queries on the form.

COUNTCANDIDATEQUERIES

Count of candidate queries on the form.

COUNTCLOSEDQUERIES

Count of closed queries on the form.

INFORMPARTIALURL_CRFVIEW

Partial InForm URL for the form.

REVIEWSTATE1

Custom review state and stage in which the form exists, if custom review states are defined for the study.

0 - Custom review stage 1

1 - Custom review stage 2

2 - Custom review stage 3

REVIEWSTATE2

Custom review state and stage in which the form exists, if custom review states are defined for the study.

0 - Custom review stage 1

1 - Custom review stage 2

2 - Custom review stage 3

REVIEWSTATE3

Custom review state and stage in which the form exists, if custom review states are defined for the study.

0 - Custom review stage 1

1 - Custom review stage 2

2 - Custom review stage 3

REVIEWSTATE4

Custom review state and stage in which the form exists, if custom review states are defined for the study.

0 - Custom review stage 1

1 - Custom review stage 2

2 - Custom review stage 3

REVIEWSTATE5

Custom review state and stage in which the form exists, if custom review states are defined for the study.

0 - Custom review stage 1

1 - Custom review stage 2

2 - Custom review stage 3

REVIEWSTATE1DATECHANGED

Date on which the custom review state changed for the form, if custom review states are defined for the study.

REVIEWSTATE2DATECHANGED

Date on which the custom review state changed for the form, if custom review states are defined for the study.

REVIEWSTATE3DATECHANGED

Date on which the custom review state changed for the form, if custom review states are defined for the study.

REVIEWSTATE4DATECHANGED

Date on which the custom review state changed for the form, if custom review states are defined for the study.

REVIEWSTATE5DATECHANGED

Date on which the custom review state changed for the form, if custom review states are defined for the study.

DATEDATACHANGED

The date and time (GMT) when the data on the form was last modified.

ITEMSMARKEDINCOMPLETE

Indicates whether the form contains incomplete items:

0 - No items on the form are marked incomplete.

1 - The form contains items marked incomplete.

CREATEDATETIME

Date and time when the form was started; that is, when a user entered data on the form or triggered a rule that entered data on the form.

CREATEDBYUSERID

User ID of the user who started the form by entering data or triggering a rule that entered data on the form.

MODIFIEDDATETIME

Date and time when the form was most recently started or modified; that is, when a user most recently entered or modified data on the form or triggered a rule that entered or modified data on the form.

MODIFIEDBYUSERID

User ID of the user who started or modified the form by entering or modifying data or triggering a rule that entered or modified data on the form.

NEVERFROZENSTATE

When the value = 1, it indicates the given form has never entered the frozen (or unfrozen) state. When the value = 0, it indicates the listed condition is not met.

UNFROZENSTATE

When the value = 1, it indicates the form was previously frozen, but now is not frozen. When the value = 0, it indicates the listed condition is not met.

NEVERLOCKEDSTATE

When the value = 1, it indicates the form has never entered the locked (or unlocked) state. When the value = 0, it indicates the listed condition is not met.

UNLOCKEDSTATE

When the value = 1, it indicates the form was previously locked, but now is not locked. When the value = 0, it indicates the listed condition is not met.

ORADELPAGEUID_LAST

Internal column used to calculate MODIFIEDBYUSERID.

ORADELPAGEDATE_LAST

Internal column used to calculate MODIFIEDDATETIME.

MODIFIEDDATETIME_D

Reserved for internal Oracle use.