Subject Forms dataset

You can use the Subject Forms dataset in Oracle Clinical One Analytics to analyze and visualize data about forms associated to each subject.

Modes

Available in all 3 modes: Testing, Training, and Production

What type of data can I include in a custom report or visualization on subject forms?

With this dataset you can get valuable information, such as:

• How many incomplete forms are there for a specific site, visit, and subject
• What forms are available for source data verification (SDV) at a particular site (CRA)
• When you should schedule a site visit based on the amount of completed forms there are at a site (CRA)
• The percentage of forms with a status of Incomplete, Completed, Frozen, Source Data Verification Complete, Signed by country, site, subject, and visit

For information about permissions required to access this dataset, see About your access to Oracle Clinical One Analytics.

Browse descriptions of data elements included in this dataset:

• Study folder
  
• Site folder
  
• Country folder
  
• Subject folder
  
• Event folder
  
• Form (Required) folder
  
• Form Association folder
  
• Audit folder
  
• Aggregation folder
  
• Reference folder
  

Study folder

This table describes the data elements included in the Study folder

Table 2-59 Data elements in the Study folder

Data element	Description
STUDY_MODE	Indicates the study mode used in the referencing data in a custom report, such as Testing, Training, or Active.
STUDY_ID_NAME	A study ID as specified by the study manager when they created the study, such as a protocol acronym and protocol number.
STUDY_TITLE	A protocol's title as specified by the study manager.
STUDY_REFNAME	The STUDY_ID_NAME data element that is converted to uppercase and spaces are removed. This value never changes after created even if STUDY_ID_NAME changes.
STUDY_PHASE	A study's phase as indicated by the study manager when they created the study.
THERAPEUTIC_AREA	Indicates the therapeutic area as specified by the study manager when they created the study.
BLINDING_TYPE	Indicates whether the study is an open-label type of study or a blinded study, as specified by the study manager when they created the study.
STUDY_VERSION	Indicates the study version number of the referencing data in a custom report.

Site folder

This table describes the data elements included in the Site folder.

Table 2-60 Data elements in the site folder

Data element	Description
ADD_SUBJECTS	Flag that enables or prevents site users from adding subjects at one or multiple sites.
ADDRESS_CITY	A site's city as entered by the site manager when they created or last modified the site.
ADDRESS_COUNTRY	A site's country as entered by the site manager when they created or last modified the site. The field display the country ISO code.
ADDRESS_POSTALCODE	The Zip Postal Code associated with a site's address.
ADDRESS_STATE_OR_PROV_OR_CNTY	A site's state, province, or county as entered by the site manager when they created or last modified the site.
ADDRESS_STREET_1	A site's first address as entered by the site manager when they created or last modified the site.
ADDRESS_STREET_2	A site's second address as entered by the site manager when they created or last modified the site.
DEA_NUMBER	The DEA registration number.
DISPENSE_TO_SUBJECTS	Flag that enables or prevents site users from dispensing kits, devices or performing dose changes for subjects at one or multiple sites.
DRUG_DESTRUCTION_CAPABLE	Flag that defines if the kit type is destructible at the site or not.
EMAIL	Email address of the site as entered by the site administrator when they created or last modified the site.
EXPIRATION	Indicates the expiration date of the DEA Registration Number as defined by a site manager.
FAX	The contact fax number as entered by the site administrator when they created or last modified the site.
INITIAL_SUBJECTS_COUNT	Number of initial subjects included in the SDV strategy.
INITIAL_SUBJECTS_SDV_TYPE	Type of Source Data Verification: All Questions or Critical Questions.
PHONE	The contact phone number as entered by the site manager when they created or last modified the site.
PI_PREFIX	The principal investigator's prefix at the site.
RANDOMIZE_SUBJECTS	Flag that enables or prevents site users from randomizing subjects at one or multiple sites.
REMAINING_SUBJECTS_PERCENTAGE	Number of remaining subjects included in the SDV strategy.
REMAINING_SUBJECTS_SDV_TYPE	Type of Source Data Verification: All Questions or Critical Questions.
SCREEN_SUBJECTS	Flag that enables or prevents site users from screening subjects at one or multiple sites.
SDV_GROUP_NAME	Name of the SDV Strategy, as entered by the study manager.
SHIPPING_ADDRESS_1	A site's first shipping address as entered by the site manager when they created or last modified the site.
SHIPPING_ADDRESS_2	A site's second shipping address as entered by the site manager when they created or last modified the site.
SHIPPING_ATTENTION	Indicates the name of the person who will receive shipments at the site, as specified by a site manager.
SHIPPING_CITY	City associated with the shipping address, as entered by the site manager when they created or last modified the site.
SHIPPING_COUNTRY	Country associated with the shipping address, as entered by the site manager when they created or last modified the site.
SHIPPING_EMAIL	Email address associated with the shipping address.
SHIPPING_FAX	Fax number associated with the shipping address.
SHIPPING_PHONE	Phone number associated with the shipping address.
SHIPPING_STATE_OR_PROV_OR_CNTY	State, province, or county associated with the shipping address, as entered by the site manager when they created or last modified the site.
SHIPPING_ZIP	Zip Postal Code associated with the shipping address.
SITE_ID_NAME	Indicates the site ID as entered by a site manager when they created or last modified a site.
SITE_STATUS	Indicates the status of a site whether it is New, Active, or Retired.
SITE_STUDY_VERSION	The study version assigned to the site, as configured by a site manager.
TIMEZONE	Indicates the time zone the site is currently placed on as specified by a site manager.
INVESTIGATOR	A Principal Investigator's Full Name as listed when the site manager created the site.
SITE_NAME	Indicates the site's name as entered by a site manager when they created or last modified a site.
SITE_TYPE	Indicates the type of organization.

Country folder

This table describes the data elements included in the Country folder.

Table 2-61 Data elements in the Country folder

Data element	Description
COUNTRY_NAME	Indicates a country's two-digit ISO code.

Subject folder

This table describes the data elements included in the Subject folder.

Table 2-62 Data elements in the Subject folder

Data element	Description
SUBJECT_NUMBER	The number currently assigned to the subject in the system as identifier.
SUBJECT_STATE	A subject's state.
PREVIOUS_SUBJECT_NUMBER	When a subject number change is applied, this field holds the number that was assigned to the subject before the change.

Event folder

This table describes the data elements included in the event folder.

Table 2-63 Data elements in the event folder

Data element	Description
EVENT_TITLE	The event's title, defined by the user when an event is created.
EVENT_REFNAME	The event's reference name. Displays a capitalized version of the (user entered) EVENT_TITLE with blank spaces removed. Oracle Clinical One Analytics generates this value, which is not displayed in the Oracle Clinical One Platform user interface. Note: This value does not change if the associated EVENT_TITLE is updated in a subsequent Study Version.
EVENT_ID_NAME	The event's id as in Oracle Clinical One Platform.
VISIT_IS_REQUIRED	Indicates whether or not a visit is required.
IS_SCHEDULED_VISIT	Indicates whether the visit is scheduled or not.
SCHEDULED_FROM_EVENT_NAME	Displays the EVENT_TITLE (visit title) of the Scheduled From visit as defined in the Visit Schedule. Note: If a visit is not scheduled or it is the first visit in the schedule, then this element is populated with the visit’s own title. For example, Screening Visit is displayed for the Screening Visit, as it is the first visit in the schedule.
VISIT_STATUS	Indicates a visit's status in the system. Future visits are included with the status of 'SCHEDULED'. Dynamic and cycle visits will not be included until an event happens that causes their creation on the subject's schedule.
VISIT_START_DATE	Date stamp of a visit's start date.
VISIT_TYPE	Displays the type of visit: Screening, Randomization, Dispensation, Non-Dispensation, Optional, Withdrawal or Study Completion.
EVENT_TYPE	Displays the type of event: Visit_Complete Visit_Started Visit_Date_Changed Visit_Inserted New visits added to the schedule and applied to a study using Advanced Study Versioning (ASV).
PROJECTED_VISIT_START_DATE	Date when the next scheduled dispensation should start in the study.
PROJECTED_VISIT_END_DATE	Date when the next scheduled dispensation should end in the study.
PROJECTED_VISIT_DATE	Date when the next scheduled dispensation should take place in the study.
DELAY_DAYS	The number of days between the prior scheduled visit.
DELAY_HOURS	The number of hours between the prior scheduled visit (in addition to the DELAY_DAYS field).
VISIT_WINDOW_BEFORE_DAYS	Indicates how many days before the scheduled date and time the visit can occur, as entered by a study designer.
VISIT_WINDOW_BEFORE_HOURS	Indicates how many hours before the scheduled date and time the visit can occur, as entered by a study designer.
VISIT_WINDOW_AFTER_DAYS	Indicates how many days after the scheduled date and time the visit can occur.
VISIT_WINDOW_AFTER_HOURS	Indicates how many hours after the scheduled date and time the visit can occur.
EVENT_INSTANCE_NUM	Indicates the unscheduled visit instance number as designed by the study designer.
VISIT_ORDER	The order in which subject visits occur, as configured in the study design.
SCHEDULED_FROM_EVENT_REFNAME	Displays the EVENT_REFNAME of the Scheduled From Visit as defined in the Visit Schedule. Note: If a visit is not scheduled or it is the first visit in the schedule, then this element is populated with the visit’s own refname. For example, SCREENINGVISIT is displayed for the Screening Visit, as it is the first visit in the schedule.

Form (Required) folder

This table describes the data elements included in the Form (Required) folder.

Table 2-64 Data elements in the Form folder

Data Element	Description
FREEZE	Indicates whether a form is frozen or not by a data manager or CRA.
VERIFIED	Indicates whether a form is verified or not by a CRA. Data element can be populated with the following values: VERIFIED: A question, form, or visit is verified. UNVERIFIED: A question, form, or visit is not verified. VERIFY_REQUIRED: A question, form, or visit requires verification and is not yet verified. NOT_APPLICABLE
SIGNED	Indicates whether a form is signed by a PI or not.
FORM_NAME	The name of the form, as specified by the study designer.
FORM_REFNAME	A form's reference name.
REPEAT_SEQUENCE_NUMBER	Refers to the row instance number of all applicable form types with repeating data: Two section forms: unique numeric identifier of the row in the repeating section. Lab forms: unique numeric identifier of the row in the repeating section that captures lab tests and results. Repeating forms: indicates the repeating form number.
FORM_STATUS	Can be valid or invalid. Invalid form status indicates there are items within the form with a validation failure.
IS_REPEATING	Indicates whether or not it is a repeating form.
IS_ROLLOVER	Indicates whether the form contains a rollover type of question.
REPEAT_FORM_NUMBER	Refers to the form instance number of all applicable form types with repeating data: Two section forms: indicates the form instance number. Lab forms: defaulted to a value of 1. Repeating forms: this value will be null.
INNER_REPEAT	Refers to the Section Repeat values of all applicable form types with repeating data: Two section forms: unique numeric identifier of the row in the repeating section. Lab forms: unique numeric identifier of the row in the repeating section that captures lab tests and results. Repeating forms: this value will be null.
OUTER_REPEAT	Refers to the Form Repeat values of all applicable form types with repeating data: Two section forms: unique identifier of the non-repeating section of the form, the form instance number. Lab forms: defaulted to a value of 1. Repeating forms: unique numeric identifier of the repeating form.
IS_MISSING_FORM	N (No) indicates that a form has been started. Y (Yes) indicates that a form has not been started or all questions on that form were cleared/deleted. Dynamic and unscheduled forms only appear when the form has been started, and data entry has occurred.

Form Association folder

This table describes the data elements included in the Form Association folder.

Data element	Description
ASSOCIATED_EVENT_INSTANCE_NUM	The unique identifier for an associated event. Note: If the visit is not UnScheduleAbleVisit, this field will not be populated with any value.
ASSOCIATED_EVENT_NAME	The name of the associated event.
ASSOCIATED_FORM_NAME	The name of the associated form.
ASSOCIATED_FORM_REFNAME	Indicates the reference code of the associated form.
ASSOCIATED_FORM_TYPE	Indicates the form type of the associated form.
ASSOCIATED_REPEAT_SEQUENCE_NUM	When association is with a repeating form, indicates the associated sequence number.
ASSOCIATED_STUDY_VERSION	Indicates the study version of the associated form.
ASSOCIATED_REPEAT_FORM_NUM	When association is with a repeating form, indicates the associated repeating form number.

Audit folder

This table describes the data elements included in the Audit folder.

Table 2-65 Datat elements in the audit folder

Data element	Description
IS_CURRENT	Audit trail field to display either current status or full audit trail of the data.
VERSION_START	Indicates the date and time of when the data was changed.
VERSION_END	Indicates the date and time of when data was changed, if the data is not current.
OPERATION_TYPE	Audit trail field that represents the type of operation performed (i.e. create, modify).
USER_NAME	Audit trail field that represents the user who performed the action. The value for this column may represent a user's actual username or a user's email address, depending on how the user login was defined in Oracle Life Sciences IAMS.
CURRENT_STUDY_ROLE_NAME	Specifies of the role of the user who updated the given record. If the user's study role changes, this field will show the current study role of the given user.

Aggregation folder

This table describes the data elements included in the Aggregation folder.

Table 2-66 Data elements in the Aggregation folder

Data Element	Description
TOTAL_ITEMS	Number of total questions in a form
ENTERED_ITEMS	Number of questions answered in a form

Reference folder

This table describes the data elements included in the Reference folder.

Data Element	Description
SCHEDULED_FROM_EVENT_WID	A number that represents the unique identifier of the previously scheduled event.
STUDY_WID	A number that represents the unique identifier of the study.
SITE_WID	A number that represents the unique identifier of a site.
SUBJECT_WID	Indicates a subject's numeric identifier.
EVENT_WID	A number that represents the unique identifier of an event.
SUBJECT_EVENTINST_FORM_WID	A number that represents the unique identifier of a subject form associated with a specific visit instance.
FORM_WID	A number that represents the unique identifier of a form.
USER_WID	Indicates a user's numeric identifier.
DH_TIMESTAMP	A timestamp that indicates when the data became available in the dataset.
SUBJECT_EVENT_INST_WID	A number that represents the unique identifier of a subject event's instance.
COUNT	Represents the count of forms.
ASSOCIATED_EVENT_WID	A number that represents the unique identifier of the event to which the form is assigned when a form association is present.
ASSOCIATED_FORM_WID	A number that represents the unique identifier of the associated form, if present.
CURRENT_STUDY_ROLE_WID	Numeric identifier of the role of the user who updated the given record. If the user study role changes, this field will show the current study role of the given user.