Once data has been entered into the eCRFs, OpenClinica offers a variety of different extract types from Excel and HTML to CDISC ODM XML. In these extracts, OpenClinica uses the ISO 8601 standard date format to represent dates and partial dates. The ISO 8601 standard date format is a string with the year, month, and day, separated with a – (i.e. 2015-08-15).

One particular extract type, Data Mart, is available with an OpenClinica Enterprise subscription (or Community Data Mart, which is available here thanks to community user Lindsay Stevens!).

If you are new to Data Mart, there may be a few things that are unfamiliar to you. In particular, PDates extract in a different format in Data Mart than they do in other OpenClinica extract formats.

PDates in Data Mart extract as a range of dates. This range of dates is specified using a minimum and a maximum value. Therefore, for one PDate data field in Data Mart, two columns are generated:

{PDate Item Name}_min
{PDate Item Name}_max

Minimum and maximum columns in Data Mart

 

 

For example, lets say you have a PDate item in your CRF with an Item_Name of STARTDATE. When you run a Data Mart extract, the following columns will be generated in Data Mart to account for this item:

startdate_min
startdate _max

As mentioned above, if an item is defined as a PDate, the following would be accepted by the system during data entry:

 – A Full Date (example: 12-Jan-2015)
 – Month and Year Only (example: Jan-2015)
 – Year Only (example: 2015)

Each of the above options would extract in Data Mart as follows:

1. If a full date, such as 12-Jan-2015, is entered during data entry, then the following would be extracted in Data Mart:

 – in the {PDate Item Name}_min column the value would be the full date: “2015-01-12”
 – in the {PDate Item Name}_max column the value would be the full date: “2015-01-12”

In this case, the {PDate Item Name}_min and {PDate Item Name}_max values are the same because the full date was provided.

Full Date in Data Mart

 

2) If only the month and year, such as Jan-2015, is entered during data entry, then the following would be extracted in Data Mart:

 – in the {PDate Item Name}_min column the value would be the first day of the month: “2015-01-01”
 – in the {PDate Item Name}_max column the value would be the last day of the month: “2015-01-31”

The event could have occurred on any date within the provided month. This means that the date could fall between the first day of the month, 01-Jan-2015, and the last day of the month, 31-Jan-2015.

 Data Mart Month and Year Only

3) Lastly, if only the year, such as 2015, was provided during data entry, then the event could have occurred on any day in any month of the provided year. The values would therefore extract as follows:

 – in the {PDate Item Name}_min column the value would be the first day of the year: “2015-01-01”
 – in the {PDate Item Name}_max column the value would be the last day of the year: “2015-12-31”

The date could have occurred at any point between the first day of the year, 01-Jan-2015, and the last day of the year, 31-Dec-2015.

Data Mart Year Only

 

To learn more about PDates and/or Data Mart, please visit the following resources: 

OpenClinica Enterprise Data Mart Guide

Community Data Mart

Date Formats in OpenClinica