Form question output mapping in the Subject Data Extracts

As clinical data is extracted from Oracle Clinical One Platform to display in the Subject Data Extract, form questions get represented in four different columns: Raw, Formatted, Decode and the question itself.

Note:

The Subject Data Extract only contains records of current data.

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

Contains either the formatted or decode value, depending on data type.

Table 3-1 Column output according to data type

Data type	ITEM_R	ITEM_F	ITEM_D	ITEM
Text	Value as entered with no formatting.	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: value as entered, excluding units if present.
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: as entered, in alphanumeric format.
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	Displays the data flag value according to the question's data type:: For text questions: displays the raw value of the data flag. For number questions: displays the formatted value of the data flag. For date questions: displays the raw value of the data flag. For codelist questions: displays the decoded value of the data flag.