OpenClinica supports a subset of the Item Data Types defined in ODM. The data type mapping is shown below, along with the allowed string pattern used to validate item values for a given data type.  Note that a listing of no definition in the table below means that the data type is not supported in OpenClinica.

Item Data Types

CDISC Item Data Type                        

OpenClinica Data Type

Allowed Values (Data Import)

Representation of Values (Extract)

text

ST

 

 

 

 

Any sequence of characters up to the maximum allowed number of characters (currently 4000). If the value is greater than the width is specified in the items width_decimal property (or 255, whichever is less), a discrepancy note will be created but the data will be allowed.

 

 

partialDate

PDATE

A date represented according to the XML schema date datatype, which is based on the ISO8601 standard (YYYY-MM-DD).

 

A date represented according to the XML schema date datatype, which is based on the ISO8601 standard (YYYY-MM-DD).

Partial Dates can be YYYY-MM or YYYY and will be exported as YYYY-MM or YYYY.

text

FILE

Files cannot be imported into ODM at this time.

A string representing the file name of the stored file, up to the maximum allowed number of characters (currently 4000).

integer

INT

-?digit+

If the value is greater than the width specified in the items width_decimal property (or 255, whichever is less), a discrepancy note will be created but the data will be allowed.

 

float

REAL

-?digit+(.digit+)?

If the value is greater than the width is specified in the items width_decimal property (or 255, whichever is less), a discrepancy note will be created but the data will be allowed.

Float values will only be rounded for calculations, based on the decimal specified in the items width_decimal property if it exists. If no width_decimal is provided it will round to the 4th decimal place.  For example, if someone entered a value like 6.987398 into a field that is not a calculation, the number will not be rounded to the 4th decimal place.

 

date

DATE

A date represented according to the XML schema date datatype, which is based on the ISO8601 standard (YYYY-MM-DD).

 

A date represented according to the XML schema date datatype, which is based on the ISO8601 standard (YYYY-MM-DD).

 

time

No definition

 

 

datetime

No definition

 

 

string

No definition

 

 

boolean

No definition

 

 

double

No definition

 

 

hexBinary

No definition

 

 

base64Binary

No definition

 

 

hexFloat

No definition

 

 

base64Float

No definition

 

 

partialTime

No definition

 

 

partialDatetime

No definition

 

 

durationDatetime

No definition

 

 

intervalDatetime

No definition

 

 

incompleteDatetime

No definition

 

 

URI

No definition