Oracle® Healthcare Foundation

New Features Guide

Release 7.1.1

E79437-02

March 2017

Oracle Healthcare Foundation New Features Guide, Release 7.1.1

E79437-02

Copyright © 2016, 2017, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Contents

List of Tables

Preface

- Documentation Accessibility

- Related Documents

1 New Features and Enhancements

- 1.1 Application Toolkit

- 1.2 Application Toolkit Loaders

- 1.2.1 Application Toolkit ETLs

- 1.3 Self-Service Analytics

- 1.3.1 Level-based Measures

- 1.3.2 Semi-additive Measures

- 1.3.3 Calculated Columns with all Weight Columns

- 1.3.4 Multiple Annotation File Support

- 1.3.5 Hide Logical Columns Using Naming Conventions

- 1.3.6 Subject Areas Without Folders

- 1.3.7 Use Variables in Calculated Column Definitions

- 1.4 Cohort Data Mart

- 1.5 Administration Console

- 1.6 Omics Loaders

2 User Documentation

List of Tables

- 2-1 User Documentation

Preface

This guide explains new features and enhancements in Oracle Healthcare Foundation.

This guide is for users who want to learn more about new features and enhancements in this release.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Related Documents

For more information, see the following documents:

- Oracle Healthcare Foundation Administration Console Online Help

- Oracle Healthcare Foundation Administrator's Guide

- Oracle Healthcare Foundation Application Programming Interface Guide

- Oracle Healthcare Foundation Application Toolkit Installation Guide

- Oracle Healthcare Foundation Appendix

- Oracle Healthcare Foundation Data Dictionary

- Oracle Healthcare Foundation Electronic Technical Reference Manual

- Oracle Healthcare Foundation Installation Guide

- Oracle Healthcare Foundation Mapping Metadata

- Oracle Healthcare Foundation New Features Guide

- Oracle Healthcare Foundation Programmer's Guide

- Oracle Healthcare Foundation Quick Reference Guide

- Oracle Healthcare Foundation Release Notes

- Oracle Healthcare Foundation Security Guide

- Oracle Healthcare Foundation Third Party Licenses and Notices

1 New Features and Enhancements

This chapter contains descriptions of the new features and enhancements in Oracle Healthcare Foundation.

1.1 Application Toolkit

The following new subject areas are added to Healthcare Common Data mart (HCD):

- Order

- Prescription

- Patient History

There are 6 new fact tables and 16 new dimensions added to HCD.

The following table lists the new fact tables:

Order

Substance Administration Order

Substance Administration Order Line

Prescription

Prescription Line

Patient History

The following table lists the new dimension tables:

Patient History Subtype

Patient History Code

Patient History Value Type

Patient History Value Code

Patient History Status Code

Patient History Reason Code

Order Code

Order Subtype

Order Status Code

Order Schedule Code

Order Priority Code

Order Signing Status Code

Order Reason Code

Prescription Type

Transmission Type

Prescription Status Code

1.2 Application Toolkit Loaders

1.2.1 Application Toolkit ETLs

New application toolkit ETLs are provided for the following tables:

- Order

- Substance Administration Order

- Substance Administration Order Line

- Prescription

- Prescription Line

- Patient History

1.3 Self-Service Analytics

A new Healthcare Common Data Mart RPD compatible with Oracle Business Intelligence 12c is delivered. There are 6 new subject areas added that you can use to create reports and dashboards.

The following are the new subject areas:

- Order

- Substance Administration Order

- Substance Administration Order Line

- Prescription

- Prescription Line

- Patient History

The following sections explain the new features added to the Self-Service Analytics Tool.

1.3.1 Level-based Measures

This feature provides the ability to define level-based measures while defining calculated columns in the OBIEE RPD file. The purpose of level-based measures is to perform calculations at a specific level of aggregation for one or multiple dimensions, which allows data to be returned at different levels of aggregation with a single query.

1.3.2 Semi-additive Measures

This feature allows the creation of semi-additive measures in the OBIEE RPD file to allow specification of alternative aggregation rules for selected dimensions related to either the base or calculated measures.

1.3.3 Calculated Columns with all Weight Columns

This feature provides the ability to define calculated columns on a fact table having several associated bridge tables, using weight columns from all associated bridge tables.

1.3.4 Multiple Annotation File Support

This feature extends the existing annotation framework to provide the ability to process multiple annotations files.

1.3.5 Hide Logical Columns Using Naming Conventions

This feature is useful for hiding system columns that are not useful in BI reports or to hide by default all user-defined columns. This is achieved by defining a new property bi.hide_columns_regex in the properties file. Some user-defined columns may be re-enabled, as required.

1.3.6 Subject Areas Without Folders

Role-playing dimensions and degenerate dimensions in the OBIEE Presentation Layer are by default placed in separate folders. The new property bi.presentation_folder avoids grouping of presentation tables into folders when its value is set to false. This produces a flat subject area structure that is easier to navigate for the user.

1.3.7 Use Variables in Calculated Column Definitions

This feature supports RPD variable creation and use of these variables in expressions of calculated columns. This improves the expressiveness of the calculated columns and also helps avoid manual modification of calculated columns after the initial RPD generation.

1.4 Cohort Data Mart

The following new subject areas are added to and enhanced in Cohort Data mart (CDM):

- Specimen Alias - Contains information about the alias names for specimens.

- Specimen Metadata - Consists of a predefined set of new attributes in Specimen bridge tables as well as new tables for user definable attributes related to specimens.

- Patient Groups and association of Patients to Patient Groups

- New attributes in Service Provider dimension and Study dimension

- New filter on Patient Observation and Subject Observation bridge tables to segregate observation data from specimen metadata

There are 5 new bridge tables and 6 new dimensions added to CDM. Also, 2 dimensions and 2 bridge tables are enhanced.

The following table lists the new bridge tables:

Patient Specimen Alias

Subject Specimen Metadata

Subject Specimen Alias

Patient Group Patient

Patient Specimen Metadata

-

The following table lists the new dimension tables:

Specimen Subtype

Specimen Metadata

Specimen Status Code

Study Phenotype

Specimen Method Code

Patient Group

The following table lists the enhanced bridge tables:

Patient Specimen

Patient Observation

Subject Specimen

Subject Observation

The following table lists the enhanced dimension tables:

Service Provider

Study

1.5 Administration Console

The following are added in this release:

- Cohort Data Mart (CDM) loader is included as part of ETL Load Summary

- Omics Load Summary

1.6 Omics Loaders

Performance of the gVCF loaders is optimized.

2 User Documentation

This chapter provides a list of Oracle Healthcare Foundation user documentation, description, and the audience.

Table 2-1 User Documentation

Document Name

Description

Audience

Oracle Healthcare Foundation Administration Console Online Help

Provides information about implementation, configuration, and administration of Oracle Healthcare Foundation Administration Console.

Users who are responsible for administration of Oracle Healthcare Foundation. They include Data Warehouse Administrators, ETL Developers and Administrators, System Administrator, and Business Intelligence developers.

Oracle Healthcare Foundation Administrator's Guide

Provides information about implementation, configuration, and administration of Oracle Healthcare Foundation. It also provides details on system monitoring and performance optimization.

Users who are responsible for administration of Oracle Healthcare Foundation. They include Data Warehouse Administrators, ETL Developers and Administrators, System Administrator, and Business Intelligence developers.

Oracle Healthcare Foundation Application Programming Interface Guide

Contains information on Application Programming Interfaces (APIs) that can be used to interface with Oracle Healthcare Foundation.

Users who load Omics data.

Oracle Healthcare Foundation Application Toolkit Installation Guide

Explains the installation of Oracle Healthcare Foundation Application Toolkit.

Users who want to install Oracle Healthcare Foundation Application Toolkit.

Oracle Healthcare Foundation Appendix

Contains default load sequence, sample master data, and unique dependency list for HDM tables.

Data Warehouse Administrators, ETL Developers and Administrators, System Administrator, Business Analysts, Product Managers, Business Intelligence developers, Bioinformaticians, Computational Biologists, Clinicians, Scientists, Developers, and administrators.

Oracle Healthcare Foundation Configuration Guide

Contains configuration details of Oracle Healthcare Foundation.

Data Warehouse Administrators, ETL Developers and Administrators, System Administrator, and Business Intelligence developers.

Oracle Healthcare Foundation Data Dictionary

Provides information about the attributes of each Entity and the relationship between these Entities.

Business Analysts, Clinical Analysts, Implementation Analysts, Developers, or anyone that wants a basic understanding about the Healthcare Data Warehouse model.

Oracle Healthcare Foundation Electronic Technical Reference Manual

Contains data models technical references.

Data Warehouse Administrators, ETL Developers and Administrators, System Administrator, Business Analysts, Product Managers, Business Intelligence developers, Bioinformaticians, Computational Biologists, Clinicians, Scientists, Developers, and administrators.

Oracle Healthcare Foundation Installation Guide

Explains the installation and initial setup of Oracle Healthcare Foundation.

Users who want to install Oracle Healthcare Foundation.

Oracle Healthcare Foundation Mapping Metadata

Contains end-to-end mappings.

Users of Oracle Healthcare Foundation who are responsible for loading data from source systems to Oracle Healthcare Foundation and developing self-service business intelligence applications. They include Data Warehouse Administrators, ETL Developers and Administrators, System Administrator, Business Analysts, Product Managers, Business Intelligence developers, Bioinformaticians, Computational Biologists, Clinicians, Scientists, Developers, and administrators.

Oracle Healthcare Foundation New Features Guide

Explains new features and enhancements in Oracle Healthcare Foundation.

Users who want to learn more about new features and enhancements in this release.

Oracle Healthcare Foundation Programmer's Guide

Describes architecture, features, and components of Oracle Healthcare Foundation.

Users of Oracle Healthcare Foundation who are responsible for loading data from source systems to Oracle Healthcare Foundation and developing self-service business intelligence applications. They include Data Warehouse Administrators, ETL Developers and Administrators, System Administrator, Business Analysts, Product Managers, Business Intelligence developers, Bioinformaticians, Computational Biologists, Clinicians, Scientists, Developers, and administrators.

Oracle Healthcare Foundation Quick Reference Guide

Provides the configuration details and the process for data loading.

Users who are responsible for administration of Oracle Healthcare Foundation. They include Data Warehouse Administrators, ETL Developers and Administrators, System Administrator, and Business Intelligence developers.

Oracle Healthcare Foundation Release Notes

Provides a complete, up-to-date description of Oracle Healthcare Foundation.

Users who want to learn more about new features and enhancements in this release.

Oracle Healthcare Foundation Security Guide

Describes various security guidelines for the Oracle Healthcare Foundation installation.

They include Data Warehouse Administrators, ETL Developers and Administrators, System Administrator, and Business Intelligence developers.

Oracle Healthcare Foundation Third Party Licenses and Notices

Contains third party licenses information distributed with Oracle Healthcare Foundation.

Users who want to install Oracle Healthcare Foundation.

Oracle Legal Notices

Copyright Notice

Copyright © 1994-2017, Oracle and/or its affiliates. All rights reserved.

License Restrictions Warranty/Consequential Damages Disclaimer

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

Warranty Disclaimer

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

Restricted Rights Notice

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

Hazardous Applications Notice

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

Third-Party Content, Products, and Services Disclaimer

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Pre-General Availability Draft Documentation Notice

If this document is in public or private pre-General Availability status:

This documentation is in pre-General Availability status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.

Private Pre-General Availability Draft Documentation Notice

If this document is in private pre-General Availability status:

The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your pre-General Availability trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.

This document in any form, software or printed matter, contains proprietary information that is the exclusive property of Oracle. Your access to and use of this confidential material is subject to the terms and conditions of your Oracle Master Agreement, Oracle License and Services Agreement, Oracle PartnerNetwork Agreement, Oracle distribution agreement, or other license agreement which has been executed by you and Oracle and with which you agree to comply. This document and information contained herein may not be disclosed, copied, reproduced, or distributed to anyone outside Oracle without prior written consent of Oracle. This document is not part of your license agreement nor can it be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.