The canonical formats are described below. They are derived from CDISC ODM 1.3 , which itself are derived from XML Schema datatypes. This is the basis for our specification, however only a subset of ODM formats are supported in OpenClinica.

 

OpenClinica Datatype Name

ODM Format Name

Schema Datatype

Canonical Format

(Allowed String Pattern)

Notes

ST

text

xs:string

any sequence of characters

 

INT

integer

xs:integer

-?digit+

 

REAL

float

xs:decimal

-?digit+(.digit+)?

 

DATE

date

xs:date

YYYY-MM-DD

An OpenClinica DATE is a string with year, month, day separated by a -which is the ISO8601 standard date format. [1]

 

The OpenClinica user interface supports localization of dates, with the default date format in the user interface being DD-MMM-YYYY.[2] All dates must be translated by the application to the canonical format specified here prior to insert into the database.

 

It is possible for OpenClinica instances upgraded from 3.0.x and older versions that some items of type DATE may have existing values that do not match the allowed string pattern. See OpenClinica Troika Item Data Specifications.doc and OpenClinica Date Format Change Specifications.doc for reference.

 

PDATE

partialDate

xs:date

YYYY-[[MM-]DD]

An OpenClinica partial date (PDATE) is a string with a year, optional month, and optional day separated by a -. No timezone is specified.

 

The OpenClinica user interface supports localization of partial dates, with the default partial date format in the user interface being DD-MMM-YYYY. All partial dates must be translated by the application to the canonical format specified here prior to insert into the database.

 

It is possible for OpenClinica instances upgraded from 3.0.x and older versions that some items of type PDATE may have existing values that do not match the allowed string pattern. See OpenClinica Troika Item Data Specifications.doc and OpenClinica Date Format Change Specifications.doc for reference.

 

FILE

URI

xs:anyURI

scheme “:” hier-part [ “?” query ] [ “#” fragment ]

See http://www.w3.org/Addressing/URL/uri-spec.txt for URI specification.



[1] http://www.iso.org/iso/date_and_time_format

[2] https://www.openclinica.org/dokuwiki/doku.php?id=developerwiki:i18n