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:

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 question column (QUESTIONLABEL_R, QUESTIONLABEL_F, QUESTIONLABEL_D, and QUESTIONLABEL) 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 QUESTIONLABEL 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: QUESTIONLABEL_R

Alphanumeric value as entered in Oracle Clinical One Platform with no conversions. This includes data entry flags.

Formatted: QUESTIONLABEL_F

Value as entered in Oracle Clinical One Platform converted to the question data type as per form design.

Decode: QUESTIONLABEL_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: QUESTIONLABEL

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

Table 3-1 Column output according to data type

Data type	QUESTIONLABEL_R	QUESTIONLABEL_F	QUESTIONLABEL_D	QUESTIONLABEL
Text	Value as entered with no conversions.	Value as entered.	NULL	Formatted 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: 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 formatted 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.