# Forms: Form Status Counts

Forms: Form Status Counts report elements return totals of forms according to their status.

Forms: Form Status Counts report elements

Report element | Description
--- | ---
Form Count | Data type: Numeric Description: The total number of forms. How calculated: This calculation includes all forms, including expected forms, forms that have not been started, and unscheduled forms. Use this report element in combination with other predefined filters to narrow report results. Data source: Derived and stored in the Reporting and Analysis database.
Expected | Data type: Numeric Description: The number of expected forms in the study. How calculated: Counts forms that meet any of the following criteria: Appear within a scheduled visit (regardless of whether the form is started). Appear within a started unscheduled visit. Are activated dynamic forms. Counts expected forms only for subjects who have been enrolled in the InForm application (includes enrolled, randomized, completed, and dropped subjects). For subjects that have completed or dropped (as indicated by the Study Completion form), only forms in started visits or dynamic started forms are counted. Non-started common forms are not counted as expected.
| Only CRFs are counted. Other special CRFs (such as screening and enrollment) are not included. Alternate forms—One form in each visit is counted. Common forms—A common form is counted only once for the study, regardless of the number of visits in which it occurs. For enrolled or randomized subjects, common forms are considered expected. For complete or dropped-out subjects, only started common forms are considered expected. Common dynamic forms—Each activated or started instance is counted one time. Common dynamic repeating forms—Each activated or started instance is counted one time. Common repeating forms—Each instance is counted one time. Dynamic forms—One activated dynamic form is counted for each visit in which it exists. Deleted (removed) form instances are not counted as expected. Dynamic repeating forms—Each activated or started instance is counted one time. Regular forms—One form is counted for each visit. Repeating forms—For repeating forms that have not been started, one instance of the form is counted as expected. For repeating forms that have been started, each started instance counts as expected. Deleted (removed) form instances are not counted as expected. Data source: Derived and stored in the Reporting and Analysis database.
Started | Data type: Numeric Description: Total count of all forms that are started across all subjects, by visit and by site. How calculated: An expected form is considered started if any type of data entry activity (form data, queries, or comments) has started on the form. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database. Note: To report on forms that are started but incomplete, subtract the complete count (Complete report element) from the started count (Started report element).
Missing Required Items | Data type: Numeric Description: The number of started forms for which at least one required item is empty. How calculated: Counts forms that: Are started. Contain required items. Have at least one required item that does not contain data. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
Complete | Data type: Numeric Description: Total count of all forms that are complete across all subjects, by visit and by site. How calculated: An expected form is considered complete if all of the required items for the form are supplied. For repeating forms, the form cannot be in a deleted state. Data source: Derived and stored in the Reporting and Analysis database.
Frozen | Data type: Numeric Description: The number of expected forms that are currently marked Frozen. How calculated: Counts forms that are expected and have been frozen using any of the following InForm features: Freeze CRF Freeze CRB Freeze Visit Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
SV Ready | Data type: Numeric Description: The number of forms that are currently marked SV Ready. How calculated: Counts forms that are marked SV Ready, and are selected for source verification. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
SV Partial | Data type: Numeric Description: The number of forms for which some SV Required items are not yet source verified. How calculated: Counts forms that are marked SV Partial, and are selected for source verification. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
SV Complete | Data type: Numeric Description: The number of SV Complete forms. How calculated: Counts forms that are marked SV Complete; that is, one of the following is true: All SV required items on the form have been source verified. None of the items on the form require source verification, and the form is automatically marked SV Complete. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
Signed | Data type: Numeric Description: The number of signed forms and the percentage of expected forms that are currently signed in the InForm application. How calculated: Counts forms that have been signed by all groups that are required to sign the form. This value appears as a whole number and as a percentage 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.
Locked | Data type: Numeric Description: The number of locked forms. How calculated: Counts forms that: Have been locked in the InForm application at the form level or visit level. Are contained within a case book that has been locked in the InForm application. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
Marked Incomplete | Data type: Numeric Description: The number of forms that have been marked Incomplete. How calculated: Counts forms that have an existing form comment(s) with an Incomplete Reason of Not Done, Not Applicable, or Unknown. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
Has Data | Data type: Numeric Description: The number of forms on which some data has been entered. How calculated: Counts forms that have entered data in at least one item. The item with data does not need to be a required item. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
Has Open Query | Data type: Numeric Description: The number of forms with open queries. How calculated: Counts forms that contain items with open queries. This count does not include forms that contain items with queries in states other than Open. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
Has Answered Query | Data type: Numeric Description: The number of forms with answered queries. How calculated: Counts forms that contain items with open queries. This count does not include forms that contain items with queries in states other than Answered. Data source: Derived and stored in the Reporting and Analysis database.
Candidate Query | Data type: Numeric Description: The number of candidate queries. Use with the Form Name report element to see the number of candidate queries that are associated with a particular form. How calculated: A query is counted if it is currently a candidate query. Data source: Derived and stored in the Reporting and Analysis database.
Open Query | Data type: Numeric Description: The number of open queries. Use with the Form Name report element to see the number of open queries that are associated with a particular form. How calculated: A query is counted if it is currently open. This count includes reissued queries. Data source: Derived and stored in the Reporting and Analysis database.
Answered Query | Data type: Numeric Description: The number of answered queries. Use with the Form Name report element to see the number of answered queries that are associated with a particular form. How calculated: A query is counted if it is currently answered. Data source: Derived and stored in the Reporting and Analysis database.
Has Form Comment | Data type: Numeric Description: The number of forms that contain form-level comments. How calculated: Counts forms that contain at least one form-level comment. This calculation includes forms that have been marked Incomplete. This count does not include forms with only item-level comments. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.
Has Item Comment | Data type: Numeric Description: The number of forms that contain items with item-level comments. How calculated: Counts forms that contain at least one item-level comment. This calculation includes items that have been marked Incomplete. This calculation does not include forms that include only form-level comments. Data source: Derived and stored in the Reporting and Analysis database.
Deleted Repeating | Data type: Numeric Description: The number of repeating forms that have been deleted. How calculated: Counts forms that are repeating forms that have been deleted. Data source: Replicated from the InForm transactional database to the Reporting and Analysis database.

Copyright © 2009 - 2012 Oracle and/or its affiliates. All rights reserved.