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