A Form item output mapping in data extracts
As clinical data is extracted from Oracle Clinical One Platform to use in Oracle Clinical One Analytics and other downstream applications, form items get represented in four different columns: Raw, Formatted, Decode and the item itself.
Note:
There is a record created for every change applied in Oracle Clinical One Platform. Each record displays the value at the time of the change.- Raw: [ItemReferenceCode]_R
- Alphanumeric value as entered in Oracle Clinical One Platform with no conversions. This includes data entry flags.
- Formatted: [ItemReferenceCode]_F
- Value as entered in Oracle Clinical One Platform converted to the question data type as per form design.
- Decode: [ItemReferenceCode]_D
- Decoded raw value, with additional considerations according to data type. If the question has a code value, it is populated in this field.
- Item: [ItemReferenceCode]
- Conatins either the formatted or decode value, depending on data type.
Table A-1 Column output according to data type
Data type | [ItemReferenceCode]_R | [ItemReferenceCode]_F | [ItemReferenceCode]_D | [ItemReferenceCode] |
---|---|---|---|---|
Text | Value as entered. | Value as entered. | NULL |
Raw value: value as entered. |
Number | Value as entered, excluding units if present. | Value as entered, excluding units if present. | Units if present, otherwise NULL .
|
Formatted value. |
Date | Value as entered in alphanumeric format (no date
format).
|
Complete date or date time using the format from form
design in Oracle Clinical One Platform.
|
ISO 8601 date format, managing partial and full
datetime value: YYYY-MM-DD T HH: MM: SS
|
Raw value: value as entered including unknown elements. |
Codelist | Codelist label.
Note: For multi select questions, includes a pipe "|" separated list. For example "Asian|White". |
Codelist value.
Note: For multi select questions, includes a pipe "|" separated list. For example "A|W". |
Codelist code.
Note: For multi select questions, includes a pipe "|" separated list. For example "1|2". |
Decode value: Codelist code. |
Data Entry flag |
|
NULL |
|
Decode value. |