Form item output mapping in data extracts

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.

Each item column (ITEM_R, ITEM_F, ITEM_D, and ITEM) displays in the extract using the question's reference code. The reference code is specified in form design. For example, if the reference code of a question is AGE, the ITEM columns will output in the extract as AGE_R, AGE_F, AGE_D and AGE, respectively.

Following are the general descriptions of each column and a table with special considerations according to data type:

Raw: ITEM_R: Alphanumeric value as entered in Oracle Clinical One Platform with no conversions. This includes data entry flags.
Formatted: ITEM_F: Value as entered in Oracle Clinical One Platform converted to the question data type as per form design. Values from text questions are formatted to remove all non-printable characters (such as tabs, carriage returns, newline characters, and leading or trailing white spaces).
Decode: ITEM_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: ITEM or VALUE: Contains either the formatted or decode value, depending on data type.

Table A-1 Column output according to data type

Data type	ITEM_R	ITEM_F	ITEM_D	ITEM or VALUE
Text	Value as entered.	Value as entered formatted to remove all non-printable characters. This includes tabs, carriage returns, newline characters, and leading or trailing white spaces. Note: If the formatted value after removing non-printable characters is empty, this field stores a `NULL` value.	`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). All available elements display, including unknown values. Elements entered as unknown display as `UNK`.	Complete date or date time using the format from form design in Oracle Clinical One Platform. Only available elements display. `UNK` time elements are omitted. `NULL` for partial dates and time only items.	ISO 8601 date format, managing partial and full datetime value: YYYY-MM-DD T HH: MM: SS Only available elements display. `UNK` date and time elements are omitted.	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.
File upload	Displays the name of the uploaded file.	Displays the name of the uploaded file.	Displays the name of the uploaded file.	Displays the name of the uploaded file.
Data Entry flag	NA for Not Applicable ND for Not Done UNK for Unknown Not Answered for when the question is not answered	`NULL`	C48660 for Not Applicable C49484 for Not Done C17998 for Unknown -99999 for when the question is not answered	Decode value.