The table documentation provides the SQL table structures for the Soarian
Electronic Health Information Single Patient Export and the Database Export.
Although it is included in the Zip file for the Single Patient Export, it can also be accessed from the publicly accessible link in accordance with the ONC's 21st Century Cures Act Final Rule, 170.315(b)(10) EHI Export criterion: https://www.oracle.com/health/regulatory/certified-health-it/
The documentation is located under the Soarian Clinicals Database Schema Documentation section for your software release.
When the Pharmacy and Med Administration Check system (RxMAK) is installed, please note the following:
Single Patient Export
- Patient data from Soarian Clinicals and RxMAK is included in the exported SQL patient database.
- The table documentation contains the table definitions from both Soarian Clinicals and RxMAK.
Database Export
- The Soarian database is exported in a SQL database table format and the
RxMAK database is exported in an XML format.
- Although both Soarian Clinicals and RxMAK tables are listed in this documentation, the SQL table definitions should only be used to understand the data structures from the Soarian Clinicals Database.
- The Soarian Clinicals SQL database table formats and RxMak XML definitions can be found using the public schema documentation location: https://www.oracle.com/health/regulatory/certified-health-it/
For Soarian Clinicals table formats, navigate to your specific release and select your software version.
For RxMak XML Table deifnitions, navigate to your specific release under the 'RxMAK Database Export Documentation' column to download the XML structure of the exported RxMAK Database.
- RxMAK table names that need to be referenced in the XML table definitions can be found in the SQL table definitions, named with all capital letters.
- Use the Soarian Clinicals MRN and Assigning Authority from the HPatientIdentifiers table to query the Pharmacy UDA table, PHCLIN_PERSON_NUMBER_AA, to find a patient's identifiers that are used in the RxMAK XML tables.
Copyright © 2023, Oracle and/or its affiliates |
Release Date: 7/09/2021 |
|
Document ID:
2238395209 |