Categorize Observations, Medications, Supplies, and Control Acts (Optional)

HDR 8.1 supports grouping data in certain general classes into subtypes, or categories. These categories follow the HL7 FHIR standard described here: https://www.hl7.org/fhir/codesystem-observation-category.html. You may need all, some, or none of these categories.

HDR 8.1 has a separate table to store data for each category. For more information about the tables, see the HDR Technical Reference Manual (eTRM) on the Oracle Help Center at https://docs.oracle.com/health-sciences/health-hdr-81/hdr-docs.htm.

To use categories, it must be possible to identify them in your HDR data. For example, to identify lab observations you may use ETS classifications or an attribute on the observation itself, like title.

You must edit the hdr8_acts_migration.sql migration script with appropriate filter conditions to separate the data into category tables.

1. In the tables below, find the table name that stores data for a category you want to use. See Observation categories, Medication (Substance Administration) categories, Supply categories, or Control Act categories.
2. Open hdr8_acts_migration.sql in a text editor.
3. Search for: AND 1 = 0 --modify the logic.
4. Replace 1 = 0 --modify the logic with the filter condition and logic to write data to the appropriate table.

   For example, for extracting only laboratory observations into OHF_HDR_LAB_OBSEVN_RES table, customers who currently use ETS Classifications to main laboratory terminology codes can replace the condition 1=0 with the below condition with appropriate changes.

   AND ACT_CODE_ETS_ID IN (
           SELECT CONCEPT_ID FROM HCT_ET_CLSSFCTN_DCLRNS
           WHERE CLASSIFICATION_ID = (
                   SELECT CONCEPT_ID FROM HCT_ET_CONCEPTS_V
                   WHERE CODINGSCHEME_NAME = 'ETSClassifications'
                       AND CONCEPT_CODE = 'LAB_RESULT'
               )
       );
   

Any data that is not categorized will be classified under the general category. Once the data is migrated to the category-specific tables, the RIM APIs support retrieval and persistence of data into the same tables using a special category attribute.

Observation categories

There are Observation categories for mood codes EVN, RQO, and DEF.

Table 7-1 Categories for mood code EVN

Category (Subtype)	Table name
General Observation Event	OHF_HDR_OBS_EVN_RES
Social History	OHF_HDR_SOCHIST_OBSEVN_RES
Vital Sign	OHF_HDR_VITAL_OBSEVN_RES
Laboratory	OHF_HDR_LAB_OBSEVN_RES
Procedure	OHF_HDR_PROC_OBSEVN_RES
Survey	OHF_HDR_SURVEY_OBSEVN_RES
Exam	OHF_HDR_EXAM_OBSEVN_RES
Therapy	OHF_HDR_THERAPY_OBSEVN_RES
Allergy	OHF_HDR_ALRGY_OBSEVN_RES
Diagnostic Report	OHF_HDR_DIAGRPT_OBSEVN_RES
Risk Assessment	OHF_HDR_RISK_OBSEVN_RES

Table 7-2 Categories for mood code RQO

Category (Subtype)	Table name
General Observation RQO	OHF_HDR_OBS_RQO_RES
Diagnostic Order	OHF_HDR_DIAGORD_OBSRQO_RES

Table 7-3 Categories for mood code DEF

Category (Subtype)	Table name
General Observation Def	OHF_HDR_OBS_DEF_RES
Data Element	OHF_HDR_DATELE_OBSDEF_RES

Medication (Substance Administration) categories

Table 7-4 Categories for mood code EVN

Category (Subtype)	Table name
General Medication Event	OHF_HDR_SBADM_EVN_RES
Medication Statement	OHF_HDR_MEDSTMNT_SBAEVN_RES
Immunization Recommendation	OHF_HDR_IMUNIZTN_SBAEVN_RES

Table 7-5 Categories for mood code RMD

Category (Subtype)	Table name
General Medication RMD	OHF_HDR_SBADM_RMD_RES
Immunization	OHF_HDR_IMUNRCMD_SBARMD_RES

Supply categories

Table 7-6 Categories for mood code EVN

Category (Subtype)	Table name
General Supply Event	OHF_HDR_SPLY_EVN_RES
Medication Dispense	OHF_HDR_MEDDISP_SPLYEVN_RES

Table 7-7 Categories for mood code RQO

Category (Subtype)	Table name
General Supply RQO	OHF_HDR_SPLY_RQO_RES
Nutrition Order	OHF_HDR_NUTRORD_SPLYRQO_RES

Control Act categories

Table 7-8 Categories for mood code EVN

Category (Subtype)	Table name
General Control Act	OHF_HDR_CACT_EVN_RES
Audit	OHF_HDR_AUDIT_CACTEVN_RES
Provenance	OHF_HDR_PROVENC_CACTEVN_RES