This chapter contains descriptions of the new features and enhancements in Oracle Healthcare Foundation.
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 |
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.
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.
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.
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.
This feature extends the existing annotation framework to provide the ability to process multiple annotations files.
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.
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.
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.
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 |