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.

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). All available elements display, including unknown values. Elements enetered 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.
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.