Test the EHR data import
When OCC is enabled for your study, Oracle provides you with a test connector and subject data that you can import, providing you with the ability to see how the EHR data import feature functions.
Prerequisites
You must complete the following tasks before you can import the test data.
- Confirm the label Oracle Clinical Connector Enabled appears on the General tab under Study Settings. This appears when OCC is enabled for the study. For more information, see Open the study's settings.
- Confirm the required permissions are assigned to connect a site and link the
subject.
Permission Description Link and Unlink Subject with EHR Patient Site permission required to link a subject for EHR data import. Manually Update EHR Imported Data (Optional) Site permission needed to edit EHR data after import. Create and Manage sites Sponsor permission required to enable a site for EHR data import. View EHR Connectors (Optional) Global Role needed to view the EHR Connectors tab under Global Settings to view a list of Oracle Clinical Connectors. - On the Sites & Labs tab, under Study Settings, create a test site and link it to the Test HDI Connector option under the EHR Connection drop-down. For more information, see Enable and manage your EHR site connections.
- Create a test study version that includes questions that match some or all of the EHR data items in the tables below to ensure the data imports successfully.
- Create the test subject (Alex Carter) in the test site and link them to their Medical Record Number (MRN); for Alex use 29560. For more information, see Link subjects for Electronic Health Record (EHR) data import.
- You can now import the test subject data. For more information, see Import Electronic Health Record (EHR) data.
Import and validate the test data
Each section below correlates to a form you designed in your test study. After you link the subject, the Import EHR Data button becomes available on the subjects page. Upon clicking, the system presents the following data for import into Oracle Clinical One Platform.
Table 4-3 Test data—Demographics
| Question | Value |
|---|---|
| First Name | Alex |
| Last Name | Carter |
| Medical Record Number (MRN) to be used for patient linking. | 29560 |
| BIRTH_DATE | Oct-1-1995 |
| BIRTH_SEX | Male |
| ETHNICITY | Hispanic or Latino |
| RACE | Asian |
Table 4-4 Test data—Vitals
| Recorded Date & Time | 1/20/2025 09:05 CST (20-Jan-2025 3:05 PM UTC) | 1/20/2025 09:00 CST (20-Jan-2025 3:00 PM UTC) | 1/6/2025 15:05 CST (06-Jan-2025 9:05 PM UTC) | 1/6/2025 13:00 CST (06-Jan-2025 7:00 PM UTC) | 1/6/2025 11:00 CST (06-Jan-2025 5:00 PM UTC) | 1/6/2025 09:10 CST (06-Jan-2025 3:10 PM UTC) | 1/6/2025 09:00 CST (06-Jan-2025 3:00 PM UTC) | Units |
|---|---|---|---|---|---|---|---|---|
| Body Height | n/a | 164.5 | n/a | n/a | n/a | n/a | 165 | cm |
| Body Weight | n/a | 58 | n/a | n/a | n/a | n/a | 65 | kg |
| BMI | n/a | 21.43 | n/a | n/a | n/a | n/a | 23.88 | kg/m2 |
| Body Surface Area | n/a | 1.63 | n/a | n/a | n/a | n/a | 1.73 | m2 |
| Head Circumference | 54 | n/a | n/a | n/a | n/a | n/a | n/a | cm |
| Body Temperature | n/a | n/a | n/a | 37.1 | 36.7 | 36.9 | 36.6 | C |
| Blood Pressure-Systolic | n/a | n/a | 125 | 118 | n/a | 120 | 140 | mmHg |
| Blood Pressure-Diastolic | n/a | n/a | 82 | 78 | n/a | 80 | 90 | mmHg |
| Oxygen Saturation | n/a | n/a | n/a | n/a | 98 | 95 | n/a | % |
Table 4-5 Test data—Medications
| Collection Date & Time | 9/24/2024 09:28 CDT (24-Sep-2024 2:28 PM UTC) | 9/24/2024 13:27 CDT (24-Sep-2024 6:27 PM UTC) | 1/5/2025 09:31 CST (05-Jan-2025 3:31 PM UTC) | 1/8/2025 09:33 CST (08-Jan-2025 3:33 PM UTC) | 1/6/2025 09:26 CDT (06-Jan-2025 3:26 PM UTC) |
|---|---|---|---|---|---|
| Medication Name | metFORMIN (MetFORMIN (Eqv-Fortamet) 1000mg oral tablet, extended release) | metFORMIN (MetFORMIN (Eqv-Fortamet) 1000mg oral tablet, extended release) | Lisinopril (lisinopril 10mg oral tablet) | Simvastatin (Simvastatin 20mg oral tablet) | amoxicillin (amoxicillin 500mg oral capsule) |
| Dose | 1 | 1 | 1 | 1 | 1 |
| DoseUnits | {tbl} | {tbl} | {tbl} | {tbl} | {capsule} |
| Frequency | BID | BID | once a day (at bedtime) | once a day (at bedtime) | TID |
| RouteOfAdministration | Oral | Oral | Oral | Oral | Oral |
| MedicationStartDate | 24-Sep-24 | 24-Sep-24 | 05-Jan-25 | 08-Jan-25 | 06-Jan-25 |
| MedicationEndDate | n/a | 15-Oct-24 | 12-Jan-25 | 15-Jan-25 | 16-Jan-25 |
| MedicationStatus | Ordered | Ordered | Ordered | Ordered | Completed |
Table 4-6 Test data—Lab Results
| Collected Date & Time | 1/25/2025 12:05 CST (Jan-25-2025 6:05 PM UTC) | 12/12/2024 09:20 CST (12-Dec-2024 3:20 PM UTC) | 11/22/2024 10:10 CST (22-Nov-2024 4:10 PM UTC) | 9/12/2024 20:50 CDT (13-Sep-2024 1:50 AM UTC) | Units | Reference Range |
|---|---|---|---|---|---|---|
|
(Procedures) Glucose Random |
n/a | n/a | n/a | 120 | mg/dL | [80-120] |
| Albumin Lvl | n/a | 4.4 | n/a | n/a | g/dL | [3.5-5.2] |
| HDL | 65 | n/a | n/a | n/a | mg/dL | [27-67] |
| T4 Free | n/a | n/a | 0.9 | n/a | ng/dL | [0.8-1.7] |
| Collected Date & Time | 9/12/2024 12:20 CDT (12-Sep-2024 5:20 PM UTC) | 9/12/2024 07:35 CDT (12-Sep-2024 12:35 PM UTC) | 9/3/2024 09:35 CDT (03-Sep-2024 2:35 PM UTC) | 6/10/2024 10:08 CDT (10-Jun-2024 3:08 PM UTC) | Units | Reference Range |
|
(Procedures) Glucose Random |
135 | 95 | n/a | n/a | mg/dL | [80-120] |
| Albumin Lvl | n/a | n/a | 3.8 | n/a | g/dL | [3.5-5.2] |
| HDL | n/a | n/a | n/a | n/a | mg/dL | [27-67] |
| T4 Free | n/a | n/a | n/a | 1.2 | ng/dL | [0.8-1.7] |
| Collected Date & Time | 6/6/2024 09:10 CDT (06-Jun-2024 2:10 PM UTC) | 3/10/2024 11:05 CDT (10-Mar-2024 4:05 PM UTC) | 1/15/2024 10:13 CST (15-Jan-2024 4:13 PM UTC) | 7/15/2023 10:05 CDT (15-Jul-2023 3:05 PM UTC) | Units | Reference Range |
|
(Procedures) Glucose Random |
n/a | n/a | n/a | n/a | mg/dL | [80-120] |
| Albumin Lvl | 4.0 | n/a | n/a | n/a | g/dL | [3.5-5.2] |
| HDL | n/a | 6.2 | n/a | 58 | mg/dL | [27-67] |
| T4 Free | n/a | n/a | 2.0 | n/a | ng/dL | [0.8-1.7] |
Table 4-7 Test data—Medical History
| Diagnosis, Start Date, Medical History Status, & Confirmation Status | Diagnosis, Start Date, Medical History Status, & Confirmation Status | Diagnosis, Start Date, Medical History Status, & Confirmation Status | Diagnosis, Start Date, Medical History Status, & Confirmation Status | Diagnosis, Start Date, Medical History Status, & Confirmation Status | Diagnosis, Start Date, Medical History Status, & Confirmation Status |
|---|---|---|---|---|---|
| Asthma | Asthma Attack | Hypertension | High Cholesterol | Chronic Pain | Anemia |
| Sep-2010 | Sep-2010 | Feb-2012 | Oct-2017 | Mar-2024 | Aug-2024 |
| Active | Inactive | Active | Active | Active | Active |
| Confirmed | Provisional | Confirmed | Confirmed | Confirmed | Confirmed |
Table 4-8 Test data—Procedures
| Procedure Name & Start Date | Procedure Name & Start Date | Procedure Name & Start Date | Procedure Name & Start Date | Procedure Name & Start Date | Procedure Name & Start Date |
|---|---|---|---|---|---|
| Appendectomy | Dialysis procedure other than hemodialysis (eg, peritoneal dialysis, hemofiltration, or other continuous renal replacement therapies), with single evaluation by a physician or other qualified health care professional | Dialysis procedure other than hemodialysis (eg, peritoneal dialysis, hemofiltration, or other continuous renal replacement therapies), with single evaluation by a physician or other qualified health care professional | Colonoscopy through stoma; with biopsy, single or multiple | Colonoscopy through stoma; with biopsy, single or multiple | Exploration of spinal fusion |
| 15-Mar-20 | 17-Mar-20 | 19-Mar-20 | 10-May-22 | 1-Jun-22 | 12-Oct-24 |