# Report/Graph page: CRF Status Detail by Site and Subject

Subtotals and totals

- Subtotals—By Subject, Site, and Country.
- Totals—Overall form count totals.

Column descriptions

Column descriptions

Column | Description
--- | ---
Country | Data type: String Description: The country in which a site is located, as entered in the InForm Administration interface. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
Site Mnemonic | Data type: String Description: An abbreviation that identifies a site, as entered in the InForm Administration interface. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
Subject Number | Data type: String Description: The subject number, followed by the subject initials. The subject number identifies the subject. The subject number and subject initials can be changed post enrollment, if this is configured in the study. Note: Subject number might not be unique at your site. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
Visit Mnemonic | Data type: String Description: An abbreviation of the visit title, as specified in the study design. For CRF visits, this title appears at the top of a collection of forms in the visit timeline and may not be a unique identifier. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
DOV | Data type: Date/Time Description: The date that is recorded in a standard Date of Visit control in the InForm application. Data type: Clinical Note: This report element assumes that your study was developed using a specific design for the DOV controls. UUIDs: DateTimeControl—BD991BC0-B0A4-11D2-80E3-00A0C9AF7674 Item—BD991BBF-B0A4-11D2-80E3-00A0C9AF7674 Section—BD991BBE-B0A4-11D2-80E3-00A0C9AF7674
Form Count (% of Expected): Expected | Data type: Numeric Description: The number of expected forms in the study. How calculated: This number reflects the number of expected forms for the site based on the option selected for the Expected forms for filter on the report prompt page. For more information, see Selection criteria: CRF Aging by Site and Form elements and expected forms. Data source: Derived for the report; not stored in the Reporting and Analysis database.
Form Count ( % of Expected): Not Started | Data type: Numeric (Percentage) Description: The number (and percentage) of expected forms that are not started in the InForm application. How calculated: Calculated based on your selection in the Expected forms for filter on the report prompt page. The InForm application calculates the forms that are not started by taking the total number of expected forms, based on the filter you select, and then subtracting from that the number of all forms that have been started. A form is started if any data, queries or comments have been entered. Each instance of a repeating form counts as a separate started form. A deleted repeating form is also counted as a started form. A dynamic form may be Activated but not Started. This value displays as a whole number and as the percentage of expected forms that are not started: [not started, % of expected] = [not started forms count] * 100 / [expected forms count] Data source: Derived for the report; not stored in the Reporting and Analysis database.
Form Count (% of Expected): Incomplete | Data type: Numeric (Percentage) Description: The number of expected forms that are started but incomplete, and the percentage of expected forms that are incomplete. How calculated: For each site, calculates the following: [incomplete forms count] = [started forms count] - [completed forms count] [incomplete, % of expected] = [incomplete forms count] * 100 / [expected forms count] Data source: Derived for the report; not stored in the Reporting and Analysis database.
Form Count (% of Expected): Completed | Data type: Numeric (Percentage) Description: The number of completed forms, and the percentage of expected forms that are complete in the InForm application. How calculated: Counts forms that are expected and meet the following criteria: Are started. Contain data for all required items. For a repeating form, the form is not in a deleted state. For an itemset form, the form is complete even if all the instances are deleted. This value displays as a whole number and as a percentage of the total number of expected forms that are complete: [completed, % of expected] = [completed forms] * 100 / [expected forms] Data source: Replicated from the InForm transactional database to the Reporting and Analysis database. Percentage is derived for display.
Form Count (% of Expected): Frozen | Data type: Numeric (Percentage) Description: The number of frozen forms, and the percentage of expected forms that are currently marked frozen in the InForm application. How calculated: Counts expected forms that have been frozen using any of these InForm features: Freeze CRF Freeze CRB Freeze Visit This value displays as a whole number (number of frozen forms), followed by the percentage of expected forms that are currently marked frozen: [frozen, % of expected] = [frozen forms count] * 100 / [expected forms count] Data source: Replicated from the InForm transactional database to the Reporting and Analysis database. Percentage is derived for display.
Form Count (% of Expected): SV Partial | Data type: Numeric (Percentage) Description: The number of forms marked Not Complete, and the percentage of expected forms where source verification is not complete. How calculated: Counts partially verified forms. A form is considered Not Complete if one of the following is true: The form contains unverified critical items. The form is on the Critical Forms list, and contains unverified items that are marked SV Required. The subject with which the form is associated is in the SV Pool, and the form contains unverified items that are marked SV Required. This value is displayed as a whole number and as a percentage of the total number of expected forms that are marked Not Complete: [Not Complete, % expected] = [Not Complete forms count] * 100 / [expected forms count] Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
Form Count (% of Expected) SV Complete | Data type: Numeric (Percentage) Description: The number of verified forms, and the percentage of expected forms where source verification is complete. How calculated: Counts forms marked Verified. A form is considered Verified if one of the following is true: The form does not contain critical items, and all items on the form that are marked SV Required are verified. The form contains critical items, and all critical items on the form are verified. The form is on the Critical Forms list, and all items on the form that are marked SV Required are verified. The subject with which the form is associated is in the SV Pool, and all items marked SV Required are verified. If none of the items on the form require source verification, the InForm application marks the form Verified. This value displays as a whole number and as a percentage of the total number of expected forms that are marked Verified. [Verified, % of expected] = [Verified forms count] * 100 / [expected forms count] Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
Form Count (% of Expected): Signed | Data type: Numeric (Percentage) Description: The number of signed forms and the percentage of expected forms that have been signed in the InForm application. How calculated: Counts forms that have been signed. This value displays as a whole number and as a percentage of the total number of expected forms that are signed. [signed, % of expected] = [signed forms count] * 100 / [expected forms count] Data source: Replicated from the InForm transactional database to the Reporting and Analysis database. Percentage is derived for display.
Form Count (% of Expected): Locked | Data type: Numeric (Percentage) Description: The number of locked forms, and the percentage of expected forms that are locked. How calculated: Counts forms for which any of the following conditions is true: The form has been locked. The form is contained within a case book that has been locked. The form is contained within a visit that has been locked. This value displays as a whole number and as a percentage: [locked, % of expected] = [locked forms count] * 100 / [expected forms count] Data source: Replicated from the InForm transactional database to the Reporting and Analysis database. Percentage is derived for display.
Form Counts (% of Expected): Forms with Comments | Data type: Numeric (Percentage) Description: The number of expected forms with form-level comments, and the percentage of expected forms that have form-level comments. How calculated: Counts forms that contain form-level comments. Does not count forms with item-level comments only. This value displays as a whole number and a percentage of the total number of expected forms that have comments: [forms with comments, % of expected] = [forms with comments] * 100 / [expected forms count] Data source: Replicated from the InForm transactional database to the Reporting and Analysis database. Percentage is derived for display.
Form Counts (% of Expected): Forms with Queries | Data type: Numeric (Percentage) Description: The number of forms with open queries, and the percentage of expected forms that contain open queries. How calculated: Counts forms that contain an item with an open query. This value displays as a whole number and a percentage of the total number of expected forms that have open queries: [forms with open queries, % of expected] = [forms with open queries] * 100 / [expected forms count] Data source: Replicated from the InForm transactional database to the Reporting and Analysis database. Percentage is derived for display.

Copyright © 2013 Oracle and/or its affiliates. All rights reserved.