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. |