Data dictionary question type mapping reference guide

EHR question field mappings and supported question types

This table serves as a guide, listing the categories, values, and types of questions supported by Oracle Clinical One Platform for EHR question mapping.

  • The EHR mapping value column provides a list of EHR elements available for mapping.  The Advanced tab displays these under the EHR Mapping setting.
  • The Recommended question type column lists the ideal Oracle Clinical One Platform question type that you should use when creating each question.
  • Refer to the Supported question types column for a list of alternative question types, that if used, still result in a successful data import.

Table 8-4 EHR question mapping options

Category EHR mapping value Recommended question type Supported question types
Demographics Birth Date Datetime
  • Datetime
  • Age
Demographics Birth Sex RadioButton
  • RadioButton
  • Dropdown
Demographics Ethnicity RadioButton
  • RadioButton
  • Dropdown
  • Checkbox
Demographics Race Checkbox
  • RadioButton
  • Dropdown
  • Checkbox
Labs Lab Test Name Label
  • Label
  • RadioButton
  • Dropdown
  • Checkbox
Labs Lab Result Text Text
Labs Lab Result Units Text Text
Labs Lab Date of Collection Datetime Datetime
Labs Lab Normal Low Range Text Text
Labs Lab Normal High Range Text Text
Labs

Performing Lab

Note: You should not map this option, as it is not active. For more details, review the limitations section under About mapping questions for Electronic Health Record (EHR) data import.

 Text Text
Vitals Body Height Number Number
Vitals Body Height Units RadioButton
  • RadioButton
  • Dropdown
Vitals Body Height Date of Collection Datetime Datetime
Vitals Body Weight Number Number
Vitals Body Weight Units RadioButton
  • RadioButton
  • Dropdown
Vitals Body Weight Date of Collection Datetime Datetime
Vitals Body Mass Index (BMI) Number Number
Vitals Body Mass Index Units RadioButton
  • RadioButton
  • Dropdown
Vitals Body Mass Index Date of Collection Datetime Datetime
Vitals Body Surface Area Number Number
Vitals Body Surface Area Units RadioButton
  • RadioButton
  • DropDown
Vitals Body Surface Area Date of Collection Datetime Datetime
Vitals Body Temperature Noninvasive Number Number
Vitals Body Temperature Noninvasive Units RadioButton
  • RadioButton
  • Dropdown
Vitals Body Temperature Noninvasive Date of Collection Datetime Datetime
Vitals Blood Pressure Diastolic Number Number
Vitals Blood Pressure Diastolic Units This is not an EHR mapping item. This is an attribute of Blood Pressure Diastolic and the unit (mmHg) is added inline automatically when mapped. Not applicable
Vitals Blood Pressure Diastolic Date of Collection Datetime Datetime
Vitals Blood Pressure Systolic Number Number
Vitals Blood Pressure Systolic Units This is not an EHR mapping item. This is an attribute of Blood Pressure Systolic and the unit (mmHg) is added inline automatically when mapped.. Not applicable
Vitals Blood Pressure Systolic Date of Collection Datetime Datetime
Vitals Head Circumference Number Number
Vitals Head Circumference Units RadioButton
  • RadioButton
  • Dropdown
Vitals Head Circumference Date of Collection Datetime Datetime
Vitals

Heart Rate Noninvasive

Note: You should not map this option, as it is not active. For more details, review the limitations section under About mapping questions for Electronic Health Record (EHR) data import.

 Number Number
Vitals Heart Rate Noninvasive Units This is not an EHR mapping item. This is an attribute of Heart Rate Noninvasive and the unit (/min) is added inline automatically when mapped.. Not applicable
Vitals Heart Rate Noninvasive Date of Collection Datetime Datetime
Vitals Oxygen Saturation Number Number
Vitals Oxygen Saturation Units This is not an EHR mapping item. This is an attribute of Oxygen Saturation and the unit (%) is added inline automatically when mapped. Not applicable
Vitals Oxygen Saturation Date of Collection Datetime Datetime
Vitals

Respiratory Rate

Note: You should not map this option, as it is not active. For more details, review the limitations section under About mapping questions for Electronic Health Record (EHR) data import.

 Number Number
Vitals Respiratory Rate Units This is not an EHR mapping item. This is an attribute of Respiratory Rate and the unit (/min) is added inline automatically when mapped. Not applicable
Vitals Respiratory Rate Date of Collection Datetime Datetime
Medications Medication Name Text Text
Medications Medication Dose Text Text
Medications Medication Dose Units Text Text
Medications

Dose Original Form

Note: You should not map this option, as it is not active. For more details, review the limitations section under About mapping questions for Electronic Health Record (EHR) data import.

 Text Text
Medications Medication Frequency Text Text
Medications Medication Route of Administration Text Text
Medications Medication Start Date Datetime Datetime
Medications Medication End Date Datetime Datetime
Medications Medication Status Text Text
Medical History Medical History Diagnosis Text Text
Medical History Medical History Start Date Datetime Datetime
Medical History

Medical History End Date

Note: You should not map this option, as it is not active. For more details, review the limitations section under About mapping questions for Electronic Health Record (EHR) data import.

 Datetime Datetime
Medical History Medical History Status Text Text
Medical History Medical History Confirmation Status Text Text
Procedures Procedure Name Text Text
Procedures Procedure Start Date Datetime Datetime
Procedures

Procedure End Date

Note: You should not map this option, as it is not active. For more details, review the limitations section under About mapping questions for Electronic Health Record (EHR) data import.

 Datetime Datetime
Procedures

Procedure Status

Note: You should not map this option, as it is not active. For more details, review the limitations section under About mapping questions for Electronic Health Record (EHR) data import.

 Text Text

Parent topic: Map form questions for EHR data import