# Forms: Form Dates

Forms: Form Dates report elements allow you to report on dates associated with form status.

Forms may be set to some states more than one time. For these states, First and Last date report elements appear in the InForm Ad Hoc Reporting tree. Use these report elements to identify when a form moved from one state to another, as follows:

- Use Last dates to determine the current status for a form, and the date on which the status change occurred.
- Use the First and Last dates together to identify forms that were, but are no longer in a given state. You can also use these dates to identify forms that changed after being assigned a given state. For example, you can compare the Data Last Modified Date to the Last SV Complete date to see whether the form changed after it was marked SV Complete.

If a form has been in a particular state only one time, the First and Last dates for that state display the same date.

If a form has never been assigned a particular status, the First and Last dates for that state return null values. (The resulting columns are empty.)

Forms: Form Dates report elements

Report element | Description
--- | ---
Current Status Date | Data type: Date/Time Description: The date on which the form was assigned its current state. For instance, if the current state of a form is Started, this element would return the date on which the form was started. Date type: System date (GMT).
Data Last Modified Date | Data type: Date/Time Description: The date on which data was last entered or modified on the form. Date type: System date (GMT).
Form's Scheduled Visit Date | Data type: Date Description: The date on which the scheduled visit that contains the form should occur. Date type: System date (GMT).
Form's Visit Data Entry Date | Data type: Date/Time Description: The date on which data was first entered for the visit that contains the form. Date type: System date (GMT).
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 For more information, see DOV controls.
Started Date | Data type: Date/Time Description: The date on which the form was started. Date type: System date (GMT).
Complete Date | Data type: Date/Time Description: The date on which the form was completed. Counts forms that are expected and meet the following criteria: Are started. Contain data for all required items. Date type: System date (GMT).
Deleted Date | Data type: Date/Time Description: The date on which the form was deleted. Date type: System date (GMT).
First Frozen Date | Data type: Date/Time Description: The date on which the status of the form was first set to Frozen. A form is frozen if it has been frozen using any of these InForm features: Freeze CRF Freeze CRB Freeze Visit This report element retrieves only those dates for forms frozen at the form or visit level. It does not retrieve a first frozen date for forms that were frozen at the case book level. Date type: System date (GMT).
Last Frozen Date | Data type: Date/Time Description: The most recent date on which the status of the form was set to Frozen. This report element retrieves only those dates for forms that were frozen at the form or visit level. It does not retrieve a last frozen date for forms that were frozen at the case book level. Date type: System date (GMT).
First SV Ready Date | Data type: Date/Time Description: The date on which the status of the form was first considered SV Ready. A form is considered SV Ready if it has a status of SV Ready, and is selected for source verification. Date type: System date (GMT).
Last SV Ready Date | Data type: Date/Time Description: The most recent date on which the status of the form was set to SV Ready. A form is considered SV Ready if it has a status of SV Ready, and is selected for source verification. Date type: System date (GMT).
First SV Partial Date | Data type: Date/Time Description: The date on which the form status was first set to SV Partial. The InForm application automatically assigns a status of SV partial to any form for which some, but not all, SV required items have been marked SV complete. A form is considered SV Partial if it has a status of SV Partial, and it is selected for source verification. Date type: System date (GMT).
Last SV Partial Date | Data type: Date/Time Description: The date on which the form was last considered SV Partial. A form is considered SV Partial if it has a status of SV Partial, and it is selected for source verification. Date type: System date (GMT).
First SV Complete Date | Data type: Date/Time Description: The date on which the form was first considered SV complete. A form is considered SV Complete when all items on the form marked SV Required are source verified, or if none of the items on the form require source verification. If none of the items require source verification, the InForm application marks the form SV Complete. Date type: System date (GMT).
Last SV Complete Date | Data type: Date/Time Description: The most recent date on which the status of the form was considered SV Complete. A form is considered SV Complete when all items on the form marked SV Required are source verified, or if none of the items on the form require source verification. If none of the items require source verification, the InForm application marks the form SV Complete. Date type: System date (GMT).
First Signed Date | Data type: Date/Time Description: The date on which the form was first signed. Date type: System date (GMT).
Last Signed Date | Data type: Date/Time Description: The date on which the form was last signed. Date type: System date (GMT).
First Locked Date | Data type: Date/Time Description: The date on which the form was first locked. This report element retrieves only those dates for forms that were locked at the form or visit level. It does not retrieve a first locked date for forms that were locked at the case book level. Date type: System date (GMT).
Last Locked Date | Data type: Date/Time Description: The date on which the form was last locked. This report element retrieves only those dates for forms that were locked at the form or visit level. It does not retrieve a last locked date for forms that were locked at the case book level. Date type: System date (GMT).
Review state name Date Changed | Data type: Date/Time Description: The date on which the review state for the form was last updated. Date type: System date (GMT). Notes: You create custom review states and stages for the Data Viewer, using the MedML Installer utility. You can define as many as five custom review states, and each custom review state must include three stages. If you do not define custom review states and stages for your study, the associated report elements do not appear in the InForm Ad Hoc Reporting tree. For more information, see the User Guide. The Review state name Date report element contains study-specific clinical data. It only appears in the Form Dates folder for the Forms report topic if you select the study-specific clinical package on the Select a package page when accessing the InForm Ad Hoc Reporting workspace.

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