RT_ACTIVATED_FORMS
This table contains information about forms that are in visits that have been started or activated in the InForm application. Each row in this view corresponds to one row in the InForm table PF_SUBJECTVECHAPTERPAGE.
| Column name (Key indicator) | Column description |
|---|---|
| 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 Oracle 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. |