Oracle® Healthcare Foundation

New Features Guide

Release 7.0.1

E71002-02

May 2016

Oracle Healthcare Foundation New Features Guide, Release 7.0.1

E71002-02

Copyright © 2016, 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

- Audience

- Documentation Accessibility

- Related Documents

- Conventions

1 New Features and Enhancements

- 1.1 Unified Installer

- 1.2 Data Model Updates

- 1.2.1 Interface Tables

- 1.2.2 Healthcare Data Warehouse

- 1.2.3 Healthcare Common Data Mart

- 1.3 Healthcare Data Warehouse

- 1.4 Warehouse Integration Loaders

- 1.4.1 Warehouse Integration ETLs

- 1.4.2 New Validation Rules of ARC Entity

- 1.4.3 Warehouse Integration Load Plan

- 1.5 Application Toolkit

- 1.6 Application Toolkit Loaders

- 1.6.1 Application Toolkit ETLs

- 1.6.1.1 Configuration Enhancement of ETL Parameters

- 1.6.1.2 Application Toolkit Load Plan

- 1.6.1.3 Mapping Updates

- 1.7 Self-Service Analytics

2 User Documentation

List of Tables

- 1-1 Attributes Added

- 1-2 Active Attributes

- 1-3 Obsolete Attributes

- 1-4 Attributes Added

- 1-5 Reference Table Updates

- 1-6 Obsolete Attributes

- 1-7 Index renamed

- 1-8 New Coded Dimensions

- 1-9 Obsolete Attributes

- 1-10 Attributes Added

- 1-11 Global Parameters

- 1-12 New Parameters added for Encounter Fact Table

- 1-13 New Parameters added for new Fact Tables

- 1-14 New Parameters added for Individual Service Provider Dimension

- 1-15 New Parameters added for Organization Service Provider Dimension

- 1-16 New Parameters added for Patient Dimension

- 1-17 New Parameters added for new Dimension Tables

- 2-1 User Documentation

Preface

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

Audience

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 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

Conventions

The following text conventions are used in this document:

Convention

Meaning

boldface

Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.

italic

Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.

monospace

Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

1 New Features and Enhancements

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

- Section 1.1, "Unified Installer"

- Section 1.2, "Data Model Updates"

- Section 1.3, "Healthcare Data Warehouse"

- Section 1.4, "Warehouse Integration Loaders"

- Section 1.5, "Application Toolkit"

- Section 1.6, "Application Toolkit Loaders"

- Section 1.7, "Self-Service Analytics"

1.1 Unified Installer

Single unified installer supports installation of all data models, data management assembly, and data pipeline services. The installer has separate installations for the following components of Oracle Healthcare Foundation:

- Data Models - Installation for the following data model schemas in Oracle Database 12c:

- Omics Data Bank

- Healthcare Data Warehouse

- Cohort Data Mart

- Healthcare Common Data
Mart

- Data Management Assembly for Oracle Data Integrator 11g - Installation for Oracle Data Integrator (ODI) ETLs and configuration schema or objects for the following loaders:

- Terminology Loaders

- Warehouse Integration Loaders

- Cohort Data Mart Loaders

- Application Toolkit Loaders

The following are the components that are packaged and delivered in this installer:

- Omics Data Bank PLSQL data loaders

- Healthcare Common Data Mart RPD for Oracle Business Intelligence

- Self-Service Analytics Tool

- Data Management Assembly for Informatica - Installation for Informatica ETLs and configuration schemas and objects for the following loaders:

- Terminology Loaders

- Warehouse Integration Loaders

- Cohort Data Mart Loaders

- Application Toolkit Loaders

The following are the components that are packaged and delivered in this installer:

- Omics Data Bank PLSQL data loaders

- Healthcare Common Data Mart RPD for Oracle Business Intelligence

- Self-Service Analytics Tool

- Data Pipeline Services - Installation for the following self-service features for Omics data loading:

- Secure File Upload

- Omics Loader Services

1.2 Data Model Updates

1.2.1 Interface Tables

The following tables are obsolete:

- HDI_CD_INTVER_EQVLNCY

- HDI_CD_SYS_INTVER_EQVLNCY

The following tables are added:

- HDI_APPT_RP

- HDI_INTVN_SPCMN

- HDI_OBSV_CNRN

- HDI_OBSV_SPCMN

- HDI_PATHO_FINDG

- HDI_PT_TMR_REGSTRY

- HDI_SCH_SVCPRV

- HDI_SFPP_METHD

- HDI_SFPS_METHD

- HDI_SFP_ARTFCT

- HDI_SFP_FIXTV

- HDI_SPCMN_FIXTN_PROC

- HDI_SRVY_ENC

- HDI_SRVY_PT

- HDI_SRVY_SVCPRV

- HDI_ORD_CNRN

The following attributes (excluding the previously mentioned tables) are added:

Table 1-1 Attributes Added

TABLE_NAME

COLUMN_NAME

HDI_AA

OCUPATN_CD

HDI_AA

OCUPATN_CDG_SYS

HDI_AA

OCUPATN_CDG_SYS_VER

HDI_AA

PLC_OF_DTH_CD

HDI_AA

PLC_OF_DTH_CDG_SYS

HDI_AA

PLC_OF_DTH_CDG_SYS_VER

HDI_AA

PLC_OF_DTH_CIT

HDI_AA

PLC_OF_DTH_ST_CD

HDI_AA

PLC_OF_DTH_ST_CDG_SYS

HDI_AA

PLC_OF_DTH_ST_CDG_SYS_VER

HDI_BILL_LN_ITM

SVCPRV_DAT_SRC_NUM_ID

HDI_BILL_LN_ITM

SVCPRV_INT_ID

HDI_BILL_LN_ITM

SVCPRV_SRC_CHANGED_ON_DT

HDI_CAREGV

OCUPATN_CD

HDI_CAREGV

OCUPATN_CDG_SYS

HDI_CAREGV

OCUPATN_CDG_SYS_VER

HDI_CAREGV

PLC_OF_DTH_CD

HDI_CAREGV

PLC_OF_DTH_CDG_SYS

HDI_CAREGV

PLC_OF_DTH_CDG_SYS_VER

HDI_CAREGV

PLC_OF_DTH_CIT

HDI_CAREGV

PLC_OF_DTH_ST_CD

HDI_CAREGV

PLC_OF_DTH_ST_CDG_SYS

HDI_CAREGV

PLC_OF_DTH_ST_CDG_SYS_VER

HDI_CHIEF_COMPLAINT

LATRL_CD

HDI_CHIEF_COMPLAINT

LATRL_CDG_SYS

HDI_CHIEF_COMPLAINT

LATRL_CDG_SYS_VER

HDI_CNRN

EXTCAP_EXTN_FLG

HDI_CNRN

GRADNG_SYS_CD

HDI_CNRN

GRADNG_SYS_CDG_SYS

HDI_CNRN

GRADNG_SYS_CDG_SYS_VER

HDI_CNRN

GRD_ATTRIBUTE1

HDI_CNRN

GRD_ATTRIBUTE10

HDI_CNRN

GRD_ATTRIBUTE11

HDI_CNRN

GRD_ATTRIBUTE12

HDI_CNRN

GRD_ATTRIBUTE13

HDI_CNRN

GRD_ATTRIBUTE14

HDI_CNRN

GRD_ATTRIBUTE15

HDI_CNRN

GRD_ATTRIBUTE16

HDI_CNRN

GRD_ATTRIBUTE17

HDI_CNRN

GRD_ATTRIBUTE18

HDI_CNRN

GRD_ATTRIBUTE19

HDI_CNRN

GRD_ATTRIBUTE1_CD

HDI_CNRN

GRD_ATTRIBUTE1_CDG_SYS

HDI_CNRN

GRD_ATTRIBUTE1_CDG_SYS_VER

HDI_CNRN

GRD_ATTRIBUTE2

HDI_CNRN

GRD_ATTRIBUTE20

HDI_CNRN

GRD_ATTRIBUTE2_CD

HDI_CNRN

GRD_ATTRIBUTE2_CDG_SYS

HDI_CNRN

GRD_ATTRIBUTE2_CDG_SYS_VER

HDI_CNRN

GRD_ATTRIBUTE3

HDI_CNRN

GRD_ATTRIBUTE3_CD

HDI_CNRN

GRD_ATTRIBUTE3_CDG_SYS

HDI_CNRN

GRD_ATTRIBUTE3_CDG_SYS_VER

HDI_CNRN

GRD_ATTRIBUTE4

HDI_CNRN

GRD_ATTRIBUTE4_CD

HDI_CNRN

GRD_ATTRIBUTE4_CDG_SYS

HDI_CNRN

GRD_ATTRIBUTE4_CDG_SYS_VER

HDI_CNRN

GRD_ATTRIBUTE5

HDI_CNRN

GRD_ATTRIBUTE5_CD

HDI_CNRN

GRD_ATTRIBUTE5_CDG_SYS

HDI_CNRN

GRD_ATTRIBUTE5_CDG_SYS_VER

HDI_CNRN

GRD_ATTRIBUTE6

HDI_CNRN

GRD_ATTRIBUTE7

HDI_CNRN

GRD_ATTRIBUTE8

HDI_CNRN

GRD_ATTRIBUTE9

HDI_CNRN

GRD_SCR

HDI_CNRN

GRWTH_PTTRN_CD

HDI_CNRN

GRWTH_PTTRN_CDG_SYS

HDI_CNRN

GRWTH_PTTRN_CDG_SYS_VER

HDI_CNRN

HIST_GRD_CD

HDI_CNRN

HIST_GRD_CDG_SYS

HDI_CNRN

HIST_GRD_CDG_SYS_VER

HDI_CNRN

LATRL_CD

HDI_CNRN

LATRL_CDG_SYS

HDI_CNRN

LATRL_CDG_SYS_VER

HDI_CNRN

MET_CD

HDI_CNRN

MET_CDG_SYS

HDI_CNRN

MET_CDG_SYS_VER

HDI_CNRN

NODE_EXTN_CD

HDI_CNRN

NODE_EXTN_CDG_SYS

HDI_CNRN

NODE_EXTN_CDG_SYS_VER

HDI_CNRN

PRMRY_GRD_CD

HDI_CNRN

PRMRY_GRD_CDG_SYS

HDI_CNRN

PRMRY_GRD_CDG_SYS_VER

HDI_CNRN

PRMRY_TMR_CD

HDI_CNRN

PRMRY_TMR_CDG_SYS

HDI_CNRN

PRMRY_TMR_CDG_SYS_VER

HDI_CNRN

SECNDRY_GRD_CD

HDI_CNRN

SECNDRY_GRD_CDG_SYS

HDI_CNRN

SECNDRY_GRD_CDG_SYS_VER

HDI_CNRN

STAG_ATTRIBUTE1

HDI_CNRN

STAG_ATTRIBUTE10

HDI_CNRN

STAG_ATTRIBUTE11

HDI_CNRN

STAG_ATTRIBUTE12

HDI_CNRN

STAG_ATTRIBUTE13

HDI_CNRN

STAG_ATTRIBUTE14

HDI_CNRN

STAG_ATTRIBUTE15

HDI_CNRN

STAG_ATTRIBUTE16

HDI_CNRN

STAG_ATTRIBUTE17

HDI_CNRN

STAG_ATTRIBUTE18

HDI_CNRN

STAG_ATTRIBUTE19

HDI_CNRN

STAG_ATTRIBUTE1_CD

HDI_CNRN

STAG_ATTRIBUTE1_CDG_SYS

HDI_CNRN

STAG_ATTRIBUTE1_CDG_SYS_VER

HDI_CNRN

STAG_ATTRIBUTE2

HDI_CNRN

STAG_ATTRIBUTE20

HDI_CNRN

STAG_ATTRIBUTE2_CD

HDI_CNRN

STAG_ATTRIBUTE2_CDG_SYS

HDI_CNRN

STAG_ATTRIBUTE2_CDG_SYS_VER

HDI_CNRN

STAG_ATTRIBUTE3

HDI_CNRN

STAG_ATTRIBUTE3_CD

HDI_CNRN

STAG_ATTRIBUTE3_CDG_SYS

HDI_CNRN

STAG_ATTRIBUTE3_CDG_SYS_VER

HDI_CNRN

STAG_ATTRIBUTE4

HDI_CNRN

STAG_ATTRIBUTE4_CD

HDI_CNRN

STAG_ATTRIBUTE4_CDG_SYS

HDI_CNRN

STAG_ATTRIBUTE4_CDG_SYS_VER

HDI_CNRN

STAG_ATTRIBUTE5

HDI_CNRN

STAG_ATTRIBUTE5_CD

HDI_CNRN

STAG_ATTRIBUTE5_CDG_SYS

HDI_CNRN

STAG_ATTRIBUTE5_CDG_SYS_VER

HDI_CNRN

STAG_ATTRIBUTE6

HDI_CNRN

STAG_ATTRIBUTE7

HDI_CNRN

STAG_ATTRIBUTE8

HDI_CNRN

STAG_ATTRIBUTE9

HDI_CNRN

STAG_CD

HDI_CNRN

STAG_CDG_SYS

HDI_CNRN

STAG_CDG_SYS_VER

HDI_CNRN

STAG_PRGRSS_CD

HDI_CNRN

STAG_PRGRSS_CDG_SYS

HDI_CNRN

STAG_PRGRSS_CDG_SYS_VER

HDI_CNRN

STNG_SYS_VER_CD

HDI_CNRN

STNG_SYS_VER_CDG_SYS

HDI_CNRN

STNG_SYS_VER_CDG_SYS_VER

HDI_CNRN

STNG_TYP_CD

HDI_CNRN

STNG_TYP_CDG_SYS

HDI_CNRN

STNG_TYP_CDG_SYS_VER

HDI_CNRN

TMR_EXTN_PTTRN_CD

HDI_CNRN

TMR_EXTN_PTTRN_CDG_SYS

HDI_CNRN

TMR_EXTN_PTTRN_CDG_SYS_VER

HDI_CNRN

TUBL_FORMTN_RAT

HDI_CNTCT

OCUPATN_CD

HDI_CNTCT

OCUPATN_CDG_SYS

HDI_CNTCT

OCUPATN_CDG_SYS_VER

HDI_CNTCT

PLC_OF_DTH_CD

HDI_CNTCT

PLC_OF_DTH_CDG_SYS

HDI_CNTCT

PLC_OF_DTH_CDG_SYS_VER

HDI_CNTCT

PLC_OF_DTH_CIT

HDI_CNTCT

PLC_OF_DTH_ST_CD

HDI_CNTCT

PLC_OF_DTH_ST_CDG_SYS

HDI_CNTCT

PLC_OF_DTH_ST_CDG_SYS_VER

HDI_COND

LATRL_CD

HDI_COND

LATRL_CDG_SYS

HDI_COND

LATRL_CDG_SYS_VER

HDI_CUST

OCUPATN_CD

HDI_CUST

OCUPATN_CDG_SYS

HDI_CUST

OCUPATN_CDG_SYS_VER

HDI_CUST

PLC_OF_DTH_CD

HDI_CUST

PLC_OF_DTH_CDG_SYS

HDI_CUST

PLC_OF_DTH_CDG_SYS_VER

HDI_CUST

PLC_OF_DTH_CIT

HDI_CUST

PLC_OF_DTH_ST_CD

HDI_CUST

PLC_OF_DTH_ST_CDG_SYS

HDI_CUST

PLC_OF_DTH_ST_CDG_SYS_VER

HDI_DEP

OCUPATN_CD

HDI_DEP

OCUPATN_CDG_SYS

HDI_DEP

OCUPATN_CDG_SYS_VER

HDI_DEP

PLC_OF_DTH_CD

HDI_DEP

PLC_OF_DTH_CDG_SYS

HDI_DEP

PLC_OF_DTH_CDG_SYS_VER

HDI_DEP

PLC_OF_DTH_CIT

HDI_DEP

PLC_OF_DTH_ST_CD

HDI_DEP

PLC_OF_DTH_ST_CDG_SYS

HDI_DEP

PLC_OF_DTH_ST_CDG_SYS_VER

HDI_DX

EXTCAP_EXTN_FLG

HDI_DX

GRADNG_SYS_CD

HDI_DX

GRADNG_SYS_CDG_SYS

HDI_DX

GRADNG_SYS_CDG_SYS_VER

HDI_DX

GRD_ATTRIBUTE1

HDI_DX

GRD_ATTRIBUTE10

HDI_DX

GRD_ATTRIBUTE11

HDI_DX

GRD_ATTRIBUTE12

HDI_DX

GRD_ATTRIBUTE13

HDI_DX

GRD_ATTRIBUTE14

HDI_DX

GRD_ATTRIBUTE15

HDI_DX

GRD_ATTRIBUTE16

HDI_DX

GRD_ATTRIBUTE17

HDI_DX

GRD_ATTRIBUTE18

HDI_DX

GRD_ATTRIBUTE19

HDI_DX

GRD_ATTRIBUTE1_CD

HDI_DX

GRD_ATTRIBUTE1_CDG_SYS

HDI_DX

GRD_ATTRIBUTE1_CDG_SYS_VER

HDI_DX

GRD_ATTRIBUTE2

HDI_DX

GRD_ATTRIBUTE20

HDI_DX

GRD_ATTRIBUTE2_CD

HDI_DX

GRD_ATTRIBUTE2_CDG_SYS

HDI_DX

GRD_ATTRIBUTE2_CDG_SYS_VER

HDI_DX

GRD_ATTRIBUTE3

HDI_DX

GRD_ATTRIBUTE3_CD

HDI_DX

GRD_ATTRIBUTE3_CDG_SYS

HDI_DX

GRD_ATTRIBUTE3_CDG_SYS_VER

HDI_DX

GRD_ATTRIBUTE4

HDI_DX

GRD_ATTRIBUTE4_CD

HDI_DX

GRD_ATTRIBUTE4_CDG_SYS

HDI_DX

GRD_ATTRIBUTE4_CDG_SYS_VER

HDI_DX

GRD_ATTRIBUTE5

HDI_DX

GRD_ATTRIBUTE5_CD

HDI_DX

GRD_ATTRIBUTE5_CDG_SYS

HDI_DX

GRD_ATTRIBUTE5_CDG_SYS_VER

HDI_DX

GRD_ATTRIBUTE6

HDI_DX

GRD_ATTRIBUTE7

HDI_DX

GRD_ATTRIBUTE8

HDI_DX

GRD_ATTRIBUTE9

HDI_DX

GRD_SCR

HDI_DX

GRWTH_PTTRN_CD

HDI_DX

GRWTH_PTTRN_CDG_SYS

HDI_DX

GRWTH_PTTRN_CDG_SYS_VER

HDI_DX

HIST_GRD_CD

HDI_DX

HIST_GRD_CDG_SYS

HDI_DX

HIST_GRD_CDG_SYS_VER

HDI_DX

LATRL_CD

HDI_DX

LATRL_CDG_SYS

HDI_DX

LATRL_CDG_SYS_VER

HDI_DX

MET_CD

HDI_DX

MET_CDG_SYS

HDI_DX

MET_CDG_SYS_VER

HDI_DX

NODE_EXTN_CD

HDI_DX

NODE_EXTN_CDG_SYS

HDI_DX

NODE_EXTN_CDG_SYS_VER

HDI_DX

PRMRY_GRD_CD

HDI_DX

PRMRY_GRD_CDG_SYS

HDI_DX

PRMRY_GRD_CDG_SYS_VER

HDI_DX

PRMRY_TMR_CD

HDI_DX

PRMRY_TMR_CDG_SYS

HDI_DX

PRMRY_TMR_CDG_SYS_VER

HDI_DX

SECNDRY_GRD_CD

HDI_DX

SECNDRY_GRD_CDG_SYS

HDI_DX

SECNDRY_GRD_CDG_SYS_VER

HDI_DX

STAG_ATTRIBUTE1

HDI_DX

STAG_ATTRIBUTE10

HDI_DX

STAG_ATTRIBUTE11

HDI_DX

STAG_ATTRIBUTE12

HDI_DX

STAG_ATTRIBUTE13

HDI_DX

STAG_ATTRIBUTE14

HDI_DX

STAG_ATTRIBUTE15

HDI_DX

STAG_ATTRIBUTE16

HDI_DX

STAG_ATTRIBUTE17

HDI_DX

STAG_ATTRIBUTE18

HDI_DX

STAG_ATTRIBUTE19

HDI_DX

STAG_ATTRIBUTE1_CD

HDI_DX

STAG_ATTRIBUTE1_CDG_SYS

HDI_DX

STAG_ATTRIBUTE1_CDG_SYS_VER

HDI_DX

STAG_ATTRIBUTE2

HDI_DX

STAG_ATTRIBUTE20

HDI_DX

STAG_ATTRIBUTE2_CD

HDI_DX

STAG_ATTRIBUTE2_CDG_SYS

HDI_DX

STAG_ATTRIBUTE2_CDG_SYS_VER

HDI_DX

STAG_ATTRIBUTE3

HDI_DX

STAG_ATTRIBUTE3_CD

HDI_DX

STAG_ATTRIBUTE3_CDG_SYS

HDI_DX

STAG_ATTRIBUTE3_CDG_SYS_VER

HDI_DX

STAG_ATTRIBUTE4

HDI_DX

STAG_ATTRIBUTE4_CD

HDI_DX

STAG_ATTRIBUTE4_CDG_SYS

HDI_DX

STAG_ATTRIBUTE4_CDG_SYS_VER

HDI_DX

STAG_ATTRIBUTE5

HDI_DX

STAG_ATTRIBUTE5_CD

HDI_DX

STAG_ATTRIBUTE5_CDG_SYS

HDI_DX

STAG_ATTRIBUTE5_CDG_SYS_VER

HDI_DX

STAG_ATTRIBUTE6

HDI_DX

STAG_ATTRIBUTE7

HDI_DX

STAG_ATTRIBUTE8

HDI_DX

STAG_ATTRIBUTE9

HDI_DX

STAG_CD

HDI_DX

STAG_CDG_SYS

HDI_DX

STAG_CDG_SYS_VER

HDI_DX

STAG_PRGRSS_CD

HDI_DX

STAG_PRGRSS_CDG_SYS

HDI_DX

STAG_PRGRSS_CDG_SYS_VER

HDI_DX

STNG_SYS_VER_CD

HDI_DX

STNG_SYS_VER_CDG_SYS

HDI_DX

STNG_SYS_VER_CDG_SYS_VER

HDI_DX

STNG_TYP_CD

HDI_DX

STNG_TYP_CDG_SYS

HDI_DX

STNG_TYP_CDG_SYS_VER

HDI_DX

TMR_EXTN_PTTRN_CD

HDI_DX

TMR_EXTN_PTTRN_CDG_SYS

HDI_DX

TMR_EXTN_PTTRN_CDG_SYS_VER

HDI_DX

TUBL_FORMTN_RAT

HDI_EMP

OCUPATN_CD

HDI_EMP

OCUPATN_CDG_SYS

HDI_EMP

OCUPATN_CDG_SYS_VER

HDI_EMP

PLC_OF_DTH_CD

HDI_EMP

PLC_OF_DTH_CDG_SYS

HDI_EMP

PLC_OF_DTH_CDG_SYS_VER

HDI_EMP

PLC_OF_DTH_CIT

HDI_EMP

PLC_OF_DTH_ST_CD

HDI_EMP

PLC_OF_DTH_ST_CDG_SYS

HDI_EMP

PLC_OF_DTH_ST_CDG_SYS_VER

HDI_ENC

RSPNSBL_SVCPRV_DAT_SRC_NUM_ID

HDI_ENC

RSPNSBL_SVCPRV_INT_ID

HDI_ENC

RSPNSBL_SVCPRV_SRC_CH_ON_DT

HDI_GUARDN

OCUPATN_CD

HDI_GUARDN

OCUPATN_CDG_SYS

HDI_GUARDN

OCUPATN_CDG_SYS_VER

HDI_GUARDN

PLC_OF_DTH_CD

HDI_GUARDN

PLC_OF_DTH_CDG_SYS

HDI_GUARDN

PLC_OF_DTH_CDG_SYS_VER

HDI_GUARDN

PLC_OF_DTH_CIT

HDI_GUARDN

PLC_OF_DTH_ST_CD

HDI_GUARDN

PLC_OF_DTH_ST_CDG_SYS

HDI_GUARDN

PLC_OF_DTH_ST_CDG_SYS_VER

HDI_GUARNTR

OCUPATN_CD

HDI_GUARNTR

OCUPATN_CDG_SYS

HDI_GUARNTR

OCUPATN_CDG_SYS_VER

HDI_GUARNTR

PLC_OF_DTH_CD

HDI_GUARNTR

PLC_OF_DTH_CDG_SYS

HDI_GUARNTR

PLC_OF_DTH_CDG_SYS_VER

HDI_GUARNTR

PLC_OF_DTH_CIT

HDI_GUARNTR

PLC_OF_DTH_ST_CD

HDI_GUARNTR

PLC_OF_DTH_ST_CDG_SYS

HDI_GUARNTR

PLC_OF_DTH_ST_CDG_SYS_VER

HDI_HMN_SUBJ

OCUPATN_CD

HDI_HMN_SUBJ

OCUPATN_CDG_SYS

HDI_HMN_SUBJ

OCUPATN_CDG_SYS_VER

HDI_HMN_SUBJ

PLC_OF_DTH_CD

HDI_HMN_SUBJ

PLC_OF_DTH_CDG_SYS

HDI_HMN_SUBJ

PLC_OF_DTH_CDG_SYS_VER

HDI_HMN_SUBJ

PLC_OF_DTH_CIT

HDI_HMN_SUBJ

PLC_OF_DTH_ST_CD

HDI_HMN_SUBJ

PLC_OF_DTH_ST_CDG_SYS

HDI_HMN_SUBJ

PLC_OF_DTH_ST_CDG_SYS_VER

HDI_IMG_INSTC

CORDNT_UOM_CD

HDI_IMG_INSTC

CORDNT_UOM_CDG_SYS

HDI_IMG_INSTC

CORDNT_UOM_CDG_SYS_VER

HDI_IMG_INSTC

IMG_INSTC_VAL_DT

HDI_IMG_INSTC

IMG_INSTC_VAL_QLFR_CD

HDI_IMG_INSTC

IMG_INSTC_VAL_QLFR_CDG_SYS

HDI_IMG_INSTC

IMG_INSTC_VAL_QLFR_CDG_SYS_VER

HDI_IMG_INSTC

IMG_X_POSTN

HDI_IMG_INSTC

IMG_Y_POSTN

HDI_IMG_INSTC

IMG_Z_POSTN

HDI_IMG_SRIES

BLCK_VRT_POSTN

HDI_IMG_SRIES

LIGHT_INTNSTY

HDI_IMG_SRIES

MAG

HDI_IMG_SRIES

PICTR_FILE_FMT_CD

HDI_IMG_SRIES

PICTR_FILE_FMT_CDG_SYS

HDI_IMG_SRIES

PICTR_FILE_FMT_CDG_SYS_VER

HDI_IMG_SRIES

PICTR_HGT

HDI_IMG_SRIES

PICTR_WDTH

HDI_IND_PRTY

OCUPATN_CD

HDI_IND_PRTY

OCUPATN_CDG_SYS

HDI_IND_PRTY

OCUPATN_CDG_SYS_VER

HDI_IND_PRTY

PLC_OF_DTH_CD

HDI_IND_PRTY

PLC_OF_DTH_CDG_SYS

HDI_IND_PRTY

PLC_OF_DTH_CDG_SYS_VER

HDI_IND_PRTY

PLC_OF_DTH_CIT

HDI_IND_PRTY

PLC_OF_DTH_ST_CD

HDI_IND_PRTY

PLC_OF_DTH_ST_CDG_SYS

HDI_IND_PRTY

PLC_OF_DTH_ST_CDG_SYS_VER

HDI_INJ

LATRL_CD

HDI_INJ

LATRL_CDG_SYS

HDI_INJ

LATRL_CDG_SYS_VER

HDI_OBSV

OBSV_VAL_DT

HDI_OBSV

OBSV_VAL_QLFR_CD

HDI_OBSV

OBSV_VAL_QLFR_CDG_SYS

HDI_OBSV

OBSV_VAL_QLFR_CDG_SYS_VER

HDI_PAYEE

OCUPATN_CD

HDI_PAYEE

OCUPATN_CDG_SYS

HDI_PAYEE

OCUPATN_CDG_SYS_VER

HDI_PAYEE

PLC_OF_DTH_CD

HDI_PAYEE

PLC_OF_DTH_CDG_SYS

HDI_PAYEE

PLC_OF_DTH_CDG_SYS_VER

HDI_PAYEE

PLC_OF_DTH_CIT

HDI_PAYEE

PLC_OF_DTH_ST_CD

HDI_PAYEE

PLC_OF_DTH_ST_CDG_SYS

HDI_PAYEE

PLC_OF_DTH_ST_CDG_SYS_VER

HDI_PROB

EXTCAP_EXTN_FLG

HDI_PROB

GRADNG_SYS_CD

HDI_PROB

GRADNG_SYS_CDG_SYS

HDI_PROB

GRADNG_SYS_CDG_SYS_VER

HDI_PROB

GRD_ATTRIBUTE1

HDI_PROB

GRD_ATTRIBUTE10

HDI_PROB

GRD_ATTRIBUTE11

HDI_PROB

GRD_ATTRIBUTE12

HDI_PROB

GRD_ATTRIBUTE13

HDI_PROB

GRD_ATTRIBUTE14

HDI_PROB

GRD_ATTRIBUTE15

HDI_PROB

GRD_ATTRIBUTE16

HDI_PROB

GRD_ATTRIBUTE17

HDI_PROB

GRD_ATTRIBUTE18

HDI_PROB

GRD_ATTRIBUTE19

HDI_PROB

GRD_ATTRIBUTE1_CD

HDI_PROB

GRD_ATTRIBUTE1_CDG_SYS

HDI_PROB

GRD_ATTRIBUTE1_CDG_SYS_VER

HDI_PROB

GRD_ATTRIBUTE2

HDI_PROB

GRD_ATTRIBUTE20

HDI_PROB

GRD_ATTRIBUTE2_CD

HDI_PROB

GRD_ATTRIBUTE2_CDG_SYS

HDI_PROB

GRD_ATTRIBUTE2_CDG_SYS_VER

HDI_PROB

GRD_ATTRIBUTE3

HDI_PROB

GRD_ATTRIBUTE3_CD

HDI_PROB

GRD_ATTRIBUTE3_CDG_SYS

HDI_PROB

GRD_ATTRIBUTE3_CDG_SYS_VER

HDI_PROB

GRD_ATTRIBUTE4

HDI_PROB

GRD_ATTRIBUTE4_CD

HDI_PROB

GRD_ATTRIBUTE4_CDG_SYS

HDI_PROB

GRD_ATTRIBUTE4_CDG_SYS_VER

HDI_PROB

GRD_ATTRIBUTE5

HDI_PROB

GRD_ATTRIBUTE5_CD

HDI_PROB

GRD_ATTRIBUTE5_CDG_SYS

HDI_PROB

GRD_ATTRIBUTE5_CDG_SYS_VER

HDI_PROB

GRD_ATTRIBUTE6

HDI_PROB

GRD_ATTRIBUTE7

HDI_PROB

GRD_ATTRIBUTE8

HDI_PROB

GRD_ATTRIBUTE9

HDI_PROB

GRD_SCR

HDI_PROB

GRWTH_PTTRN_CD

HDI_PROB

GRWTH_PTTRN_CDG_SYS

HDI_PROB

GRWTH_PTTRN_CDG_SYS_VER

HDI_PROB

HIST_GRD_CD

HDI_PROB

HIST_GRD_CDG_SYS

HDI_PROB

HIST_GRD_CDG_SYS_VER

HDI_PROB

LATRL_CD

HDI_PROB

LATRL_CDG_SYS

HDI_PROB

LATRL_CDG_SYS_VER

HDI_PROB

MET_CD

HDI_PROB

MET_CDG_SYS

HDI_PROB

MET_CDG_SYS_VER

HDI_PROB

NODE_EXTN_CD

HDI_PROB

NODE_EXTN_CDG_SYS

HDI_PROB

NODE_EXTN_CDG_SYS_VER

HDI_PROB

PRMRY_GRD_CD

HDI_PROB

PRMRY_GRD_CDG_SYS

HDI_PROB

PRMRY_GRD_CDG_SYS_VER

HDI_PROB

PRMRY_TMR_CD

HDI_PROB

PRMRY_TMR_CDG_SYS

HDI_PROB

PRMRY_TMR_CDG_SYS_VER

HDI_PROB

SECNDRY_GRD_CD

HDI_PROB

SECNDRY_GRD_CDG_SYS

HDI_PROB

SECNDRY_GRD_CDG_SYS_VER

HDI_PROB

STAG_ATTRIBUTE1

HDI_PROB

STAG_ATTRIBUTE10

HDI_PROB

STAG_ATTRIBUTE11

HDI_PROB

STAG_ATTRIBUTE12

HDI_PROB

STAG_ATTRIBUTE13

HDI_PROB

STAG_ATTRIBUTE14

HDI_PROB

STAG_ATTRIBUTE15

HDI_PROB

STAG_ATTRIBUTE16

HDI_PROB

STAG_ATTRIBUTE17

HDI_PROB

STAG_ATTRIBUTE18

HDI_PROB

STAG_ATTRIBUTE19

HDI_PROB

STAG_ATTRIBUTE1_CD

HDI_PROB

STAG_ATTRIBUTE1_CDG_SYS

HDI_PROB

STAG_ATTRIBUTE1_CDG_SYS_VER

HDI_PROB

STAG_ATTRIBUTE2

HDI_PROB

STAG_ATTRIBUTE20

HDI_PROB

STAG_ATTRIBUTE2_CD

HDI_PROB

STAG_ATTRIBUTE2_CDG_SYS

HDI_PROB

STAG_ATTRIBUTE2_CDG_SYS_VER

HDI_PROB

STAG_ATTRIBUTE3

HDI_PROB

STAG_ATTRIBUTE3_CD

HDI_PROB

STAG_ATTRIBUTE3_CDG_SYS

HDI_PROB

STAG_ATTRIBUTE3_CDG_SYS_VER

HDI_PROB

STAG_ATTRIBUTE4

HDI_PROB

STAG_ATTRIBUTE4_CD

HDI_PROB

STAG_ATTRIBUTE4_CDG_SYS

HDI_PROB

STAG_ATTRIBUTE4_CDG_SYS_VER

HDI_PROB

STAG_ATTRIBUTE5

HDI_PROB

STAG_ATTRIBUTE5_CD

HDI_PROB

STAG_ATTRIBUTE5_CDG_SYS

HDI_PROB

STAG_ATTRIBUTE5_CDG_SYS_VER

HDI_PROB

STAG_ATTRIBUTE6

HDI_PROB

STAG_ATTRIBUTE7

HDI_PROB

STAG_ATTRIBUTE8

HDI_PROB

STAG_ATTRIBUTE9

HDI_PROB

STAG_CD

HDI_PROB

STAG_CDG_SYS

HDI_PROB

STAG_CDG_SYS_VER

HDI_PROB

STAG_PRGRSS_CD

HDI_PROB

STAG_PRGRSS_CDG_SYS

HDI_PROB

STAG_PRGRSS_CDG_SYS_VER

HDI_PROB

STNG_SYS_VER_CD

HDI_PROB

STNG_SYS_VER_CDG_SYS

HDI_PROB

STNG_SYS_VER_CDG_SYS_VER

HDI_PROB

STNG_TYP_CD

HDI_PROB

STNG_TYP_CDG_SYS

HDI_PROB

STNG_TYP_CDG_SYS_VER

HDI_PROB

TMR_EXTN_PTTRN_CD

HDI_PROB

TMR_EXTN_PTTRN_CDG_SYS

HDI_PROB

TMR_EXTN_PTTRN_CDG_SYS_VER

HDI_PROB

TUBL_FORMTN_RAT

HDI_PT

DECD_INFO_SRC_CD

HDI_PT

DECD_INFO_SRC_CDG_SYS

HDI_PT

DECD_INFO_SRC_CDG_SYS_VER

HDI_PT

OCUPATN_CD

HDI_PT

OCUPATN_CDG_SYS

HDI_PT

OCUPATN_CDG_SYS_VER

HDI_PT

PLC_OF_DTH_CD

HDI_PT

PLC_OF_DTH_CDG_SYS

HDI_PT

PLC_OF_DTH_CDG_SYS_VER

HDI_PT

PLC_OF_DTH_CIT

HDI_PT

PLC_OF_DTH_ST_CD

HDI_PT

PLC_OF_DTH_ST_CDG_SYS

HDI_PT

PLC_OF_DTH_ST_CDG_SYS_VER

HDI_PT

PRMRY_CSE_OF_DTH_CD

HDI_PT

PRMRY_CSE_OF_DTH_CDG_SYS

HDI_PT

PRMRY_CSE_OF_DTH_CDG_SYS_VER

HDI_PT

SECNDRY_CSE_OF_DTH_CD

HDI_PT

SECNDRY_CSE_OF_DTH_CDG_SYS

HDI_PT

SECNDRY_CSE_OF_DTH_CDG_SYS_VER

HDI_PT_ACCT

PT_ABL_TO_PAY_CD

HDI_PT_ACCT

PT_ABL_TO_PAY_CDG_SYS

HDI_PT_ACCT

PT_ABL_TO_PAY_CDG_SYS_VER

HDI_PT_ACCT_HLTHPLN

GRP_ID

HDI_PT_ACCT_HLTHPLN

MBR_ID

HDI_PT_HX

PT_HX_STUS_CD

HDI_PT_HX

PT_HX_STUS_CDG_SYS

HDI_PT_HX

PT_HX_STUS_CDG_SYS_VER

HDI_SBSCRBR

OCUPATN_CD

HDI_SBSCRBR

OCUPATN_CDG_SYS

HDI_SBSCRBR

OCUPATN_CDG_SYS_VER

HDI_SBSCRBR

PLC_OF_DTH_CD

HDI_SBSCRBR

PLC_OF_DTH_CDG_SYS

HDI_SBSCRBR

PLC_OF_DTH_CDG_SYS_VER

HDI_SBSCRBR

PLC_OF_DTH_CIT

HDI_SBSCRBR

PLC_OF_DTH_ST_CD

HDI_SBSCRBR

PLC_OF_DTH_ST_CDG_SYS

HDI_SBSCRBR

PLC_OF_DTH_ST_CDG_SYS_VER

HDI_SCH_BLCK

SCH_BLCK_APPT_TYP_CD

HDI_SCH_BLCK

SCH_BLCK_APPT_TYP_CDG_SYS

HDI_SCH_BLCK

SCH_BLCK_APPT_TYP_CDG_SYS_VER

HDI_SCH_BLCK

SUBTYP_CD

HDI_SCH_BLCK

SUBTYP_CDG_SYS

HDI_SCH_BLCK

SUBTYP_CDG_SYS_VER

HDI_SPCMN

CUT_THKNS_UOM_CD

HDI_SPCMN

CUT_THKNS_UOM_CDG_SYS

HDI_SPCMN

CUT_THKNS_UOM_CDG_SYS_VER

HDI_SPCMN

FINAL_WT

HDI_SPCMN

INITAL_WT

HDI_SPCMN

INTERMDT_WT

HDI_SPCMN

MAX_CUT_THKNS

HDI_SPCMN

MIN_CUT_THKNS

HDI_SPCMN

SPCMN_HGT

HDI_SPCMN

SPCMN_INTG_CD

HDI_SPCMN

SPCMN_INTG_CDG_SYS

HDI_SPCMN

SPCMN_INTG_CDG_SYS_VER

HDI_SPCMN

SPCMN_LATRL_CD

HDI_SPCMN

SPCMN_LATRL_CDG_SYS

HDI_SPCMN

SPCMN_LATRL_CDG_SYS_VER

HDI_SPCMN

SPCMN_LEN

HDI_SPCMN

SPCMN_LEN_UOM_CD

HDI_SPCMN

SPCMN_LEN_UOM_CDG_SYS

HDI_SPCMN

SPCMN_LEN_UOM_CDG_SYS_VER

HDI_SPCMN

SPCMN_WDTH

HDI_SPCMN

SPCMN_WT_UOM_CD

HDI_SPCMN

SPCMN_WT_UOM_CDG_SYS

HDI_SPCMN

SPCMN_WT_UOM_CDG_SYS_VER

HDI_SPCMN_PRN_PROC

SUBTYP_CD

HDI_SPCMN_PRN_PROC

SUBTYP_CDG_SYS

HDI_SPCMN_PRN_PROC

SUBTYP_CDG_SYS_VER

HDI_SRVY_QSTN_RSPNS

SRVY_QSTN_RSPNS_VAL_DT

HDI_SVCPRV

OCUPATN_CD

HDI_SVCPRV

OCUPATN_CDG_SYS

HDI_SVCPRV

OCUPATN_CDG_SYS_VER

HDI_SVCPRV

PLC_OF_DTH_CD

HDI_SVCPRV

PLC_OF_DTH_CDG_SYS

HDI_SVCPRV

PLC_OF_DTH_CDG_SYS_VER

HDI_SVCPRV

PLC_OF_DTH_CIT

HDI_SVCPRV

PLC_OF_DTH_ST_CD

HDI_SVCPRV

PLC_OF_DTH_ST_CDG_SYS

HDI_SVCPRV

PLC_OF_DTH_ST_CDG_SYS_VER

HDI_VNDR

OCUPATN_CD

HDI_VNDR

OCUPATN_CDG_SYS

HDI_VNDR

OCUPATN_CDG_SYS_VER

HDI_VNDR

PLC_OF_DTH_CD

HDI_VNDR

PLC_OF_DTH_CDG_SYS

HDI_VNDR

PLC_OF_DTH_CDG_SYS_VER

HDI_VNDR

PLC_OF_DTH_CIT

HDI_VNDR

PLC_OF_DTH_ST_CD

HDI_VNDR

PLC_OF_DTH_ST_CDG_SYS

HDI_VNDR

PLC_OF_DTH_ST_CDG_SYS_VER

The following attributes which were obsolete are now active:

Table 1-2 Active Attributes

TABLE_NAME

COLUMN_NAME

HDI_ID

ORG_PRTY_INT_ID

HDI_ID

ORG_PRTY_DAT_SRC_NUM_ID

HDI_ID

ORG_PRTY_SRC_CHANGED_ON_DT

The following attributes are obsolete:

Table 1-3 Obsolete Attributes

TABLE_NAME

COLUMN_NAME

HDI_ASSMT

SPCMN_DAT_SRC_NUM_ID

HDI_ASSMT

SPCMN_INT_ID

HDI_ASSMT

SPCMN_SRC_CHANGED_ON_DT

HDI_IMG_INSTC

SPCMN_DAT_SRC_NUM_ID

HDI_IMG_INSTC

SPCMN_INT_ID

HDI_IMG_INSTC

SPCMN_SRC_CHANGED_ON_DT

HDI_OBSV

SPCMN_DAT_SRC_NUM_ID

HDI_OBSV

SPCMN_INT_ID

HDI_OBSV

SPCMN_SRC_CHANGED_ON_DT

HDI_SCH

SVCPRV_DAT_SRC_NUM_ID

HDI_SCH

SVCPRV_INT_ID

HDI_SCH

SVCPRV_SRC_CHANGED_ON_DT

HDI_SPCMN

INTVN_DAT_SRC_NUM_ID

HDI_SPCMN

INTVN_INT_ID

HDI_SPCMN

INTVN_SRC_CHANGED_ON_DT

1.2.2 Healthcare Data Warehouse

The following tables are obsolete:

- HDM_CD_INTVER_EQVLNCY

- HDM_CD_SYS_INTVER_EQVLNCY

The following tables are added:

- HDM_APPT_RP

- HDM_GRD

- HDM_INTVN_SPCMN

- HDM_OBSV_CNRN

- HDM_OBSV_SPCMN

- HDM_PATHO_FINDG

- HDM_PT_TMR_REGSTRY

- HDM_SCH_SVCPRV

- HDM_SFPP_METHD

- HDM_SFPS_METHD

- HDM_SFP_ARTFCT

- HDM_SFP_FIXTV

- HDM_SPCMN_FIXTN_PROC

- HDM_SRVY_ENC

- HDM_SRVY_PT

- HDM_SRVY_SVCPRV

- HDM_STAG

- HDM_ORD_CNRN

The following attributes (excluding the tables previously mentioned) are added:

Table 1-4 Attributes Added

TABLE_NAME

COLUMN_NAME

HDM_BILL_LN_ITM

SVCPRV_ID

HDM_BILL_LN_ITM

SVCPRV_VN

HDM_CNRN

LATRL_CD_ID

HDM_CNRN

LATRL_CD_VN

HDM_CNRN

ORIG_LATRL_CD_ID

HDM_CNRN

ORIG_LATRL_CD_VN

HDM_ENC

RSPNSBL_SVCPRV_ID

HDM_ENC

RSPNSBL_SVCPRV_VN

HDM_IMG_INSTC

CORDNT_UOMCD_ID

HDM_IMG_INSTC

CORDNT_UOMCD_VN

HDM_IMG_INSTC

IMG_X_POSTN

HDM_IMG_INSTC

IMG_Y_POSTN

HDM_IMG_INSTC

IMG_Z_POSTN

HDM_IMG_INSTC

ORIG_CORDNT_UOMCD_ID

HDM_IMG_INSTC

ORIG_CORDNT_UOMCD_VN

HDM_IMG_SRIES

BLCK_VRT_POSTN

HDM_IMG_SRIES

LIGHT_INTNSTY

HDM_IMG_SRIES

MAG

HDM_IMG_SRIES

ORIG_PICTR_FILE_FMT_CD_ID

HDM_IMG_SRIES

ORIG_PICTR_FILE_FMT_CD_VN

HDM_IMG_SRIES

PICTR_FILE_FMT_CD_ID

HDM_IMG_SRIES

PICTR_FILE_FMT_CD_VN

HDM_IMG_SRIES

PICTR_HGT

HDM_IMG_SRIES

PICTR_WDTH

HDM_IND_PRTY

OCUPATN_CD_ID

HDM_IND_PRTY

OCUPATN_CD_VN

HDM_IND_PRTY

ORIG_OCUPATN_CD_ID

HDM_IND_PRTY

ORIG_OCUPATN_CD_VN

HDM_IND_PRTY

ORIG_PLC_OF_DTH_CD_ID

HDM_IND_PRTY

ORIG_PLC_OF_DTH_CD_VN

HDM_IND_PRTY

ORIG_PLC_OF_DTH_ST_CD_ID

HDM_IND_PRTY

ORIG_PLC_OF_DTH_ST_CD_VN

HDM_IND_PRTY

PLC_OF_DTH_CD_ID

HDM_IND_PRTY

PLC_OF_DTH_CD_VN

HDM_IND_PRTY

PLC_OF_DTH_CIT

HDM_IND_PRTY

PLC_OF_DTH_ST_CD_ID

HDM_IND_PRTY

PLC_OF_DTH_ST_CD_VN

HDM_OBSV

OBSV_VAL_DT

HDM_OBSV

OBSV_VAL_QLFR_CD_ID

HDM_OBSV

OBSV_VAL_QLFR_CD_VN

HDM_OBSV

ORIG_OBSV_VAL_QLFR_CD_ID

HDM_OBSV

ORIG_OBSV_VAL_QLFR_CD_VN

HDM_PT

DECD_INFO_SRC_CD_ID

HDM_PT

DECD_INFO_SRC_CD_VN

HDM_PT

ORIG_DECD_INFO_SRC_CD_ID

HDM_PT

ORIG_DECD_INFO_SRC_CD_VN

HDM_PT

ORIG_PRMRY_CSE_OF_DTH_CD_ID

HDM_PT

ORIG_PRMRY_CSE_OF_DTH_CD_VN

HDM_PT

ORIG_SECNDRY_CSE_OF_DTH_CD_ID

HDM_PT

ORIG_SECNDRY_CSE_OF_DTH_CD_VN

HDM_PT

PRMRY_CSE_OF_DTH_CD_ID

HDM_PT

PRMRY_CSE_OF_DTH_CD_VN

HDM_PT

SECNDRY_CSE_OF_DTH_CD_ID

HDM_PT

SECNDRY_CSE_OF_DTH_CD_VN

HDM_PT_ACCT

ORIG_PT_ABL_TO_PAY_CD_ID

HDM_PT_ACCT

ORIG_PT_ABL_TO_PAY_CD_VN

HDM_PT_ACCT

PT_ABL_TO_PAY_CD_ID

HDM_PT_ACCT

PT_ABL_TO_PAY_CD_VN

HDM_PT_ACCT_HLTHPLN

GRP_ID

HDM_PT_ACCT_HLTHPLN

MBR_ID

HDM_PT_HX

ORIG_PT_HX_STCD_ID

HDM_PT_HX

ORIG_PT_HX_STCD_VN

HDM_PT_HX

PT_HX_STCD_ID

HDM_PT_HX

PT_HX_STCD_VN

HDM_SCH_BLCK

ORIG_SCH_BLCK_APPT_TYP_ID

HDM_SCH_BLCK

ORIG_SCH_BLCK_APPT_TYP_VN

HDM_SCH_BLCK

ORIG_SCH_BLCK_SUBTYP_ID

HDM_SCH_BLCK

ORIG_SCH_BLCK_SUBTYP_VN

HDM_SCH_BLCK

SCH_BLCK_APPT_TYP_ID

HDM_SCH_BLCK

SCH_BLCK_APPT_TYP_VN

HDM_SCH_BLCK

SCH_BLCK_SUBTYP_ID

HDM_SCH_BLCK

SCH_BLCK_SUBTYP_VN

HDM_SPCMN

CUT_THKNS_UOMCD_ID

HDM_SPCMN

CUT_THKNS_UOMCD_VN

HDM_SPCMN

FINAL_WT

HDM_SPCMN

INITAL_WT

HDM_SPCMN

INTERMDT_WT

HDM_SPCMN

MAX_CUT_THKNS

HDM_SPCMN

MIN_CUT_THKNS

HDM_SPCMN

ORIG_CUT_THKNS_UOMCD_ID

HDM_SPCMN

ORIG_CUT_THKNS_UOMCD_VN

HDM_SPCMN

ORIG_SPCMN_INTG_CD_ID

HDM_SPCMN

ORIG_SPCMN_INTG_CD_VN

HDM_SPCMN

ORIG_SPCMN_LATRL_CD_ID

HDM_SPCMN

ORIG_SPCMN_LATRL_CD_VN

HDM_SPCMN

ORIG_SPCMN_LEN_UOMCD_ID

HDM_SPCMN

ORIG_SPCMN_LEN_UOMCD_VN

HDM_SPCMN

ORIG_SPCMN_WT_UOMCD_ID

HDM_SPCMN

ORIG_SPCMN_WT_UOMCD_VN

HDM_SPCMN

SPCMN_HGT

HDM_SPCMN

SPCMN_INTG_CD_ID

HDM_SPCMN

SPCMN_INTG_CD_VN

HDM_SPCMN

SPCMN_LATRL_CD_ID

HDM_SPCMN

SPCMN_LATRL_CD_VN

HDM_SPCMN

SPCMN_LEN

HDM_SPCMN

SPCMN_LEN_UOMCD_ID

HDM_SPCMN

SPCMN_LEN_UOMCD_VN

HDM_SPCMN

SPCMN_WDTH

HDM_SPCMN

SPCMN_WT_UOMCD_ID

HDM_SPCMN

SPCMN_WT_UOMCD_VN

HDM_SPCMN_PRN_PROC

ORIG_SPCMN_PRN_PROC_SUBTYP_ID

HDM_SPCMN_PRN_PROC

ORIG_SPCMN_PRN_PROC_SUBTYP_VN

HDM_SPCMN_PRN_PROC

SPCMN_PRN_PROC_SUBTYP_ID

HDM_SPCMN_PRN_PROC

SPCMN_PRN_PROC_SUBTYP_VN

HDM_SRVY_QSTN_RSPNS

SRVY_QSTN_RSPNS_VAL_DT

The following Reference tables are updated:

Table 1-5 Reference Table Updates

TABLE_NAME

COLUMN_NAME

REFERENCE_TABLE_NAME

HDM_PRTY_ID

PRTY_ID

HDM_PRTY

HDM_PRTY_ID

PRTY_VN

HDM_PRTY

The following attributes are obsolete:

Table 1-6 Obsolete Attributes

TABLE_NAME

COLUMN_NAME

HDM_OBSV

SPCMN_ID

HDM_OBSV

SPCMN_VN

HDM_SCH

SVCPRV_ID

HDM_SCH

SVCPRV_VN

HDM_SPCMN

INTVN_ID

HDM_SPCMN

INTVN_VN

The following index is renamed:

Table 1-7 Index renamed

Current Index Name

Old Index Name

HDM_CROSS_MAP_ATRB_CD_TYP_S_N1

HDM_CROSS_MAP_ATRB_CD_TYP_S_UK

1.2.3 Healthcare Common Data Mart

The following are the new Fact Tables:

- W_HCD_BILL_F

- W_HCD_CLAIM_F

- W_HCD_CLAIM_PAYMT_F

- W_HCD_ENC_CHARGE_F

- W_HCD_OBSERVATION_F

- W_HCD_PATIENT_ACCOUNT_F

- W_HCD_PATIENT_F

The following is the new Fact Bridge Table:

- W_HCD_PT_ACNT_HLTH_PLN_FB

The following are the new Fact Child Tables:

- W_HCD_BILL_LINE_FC

- W_HCD_CLAIM_LINE_FC

- W_HCD_CLAIM_PAYMT_LINE_FC

The following are the new Dimension Views for Fact Tables:

- W_HCD_BILL_DV

- W_HCD_CLAIM_DV

- W_HCD_CLAIM_PAYMT_DV

- W_HCD_ENCOUNTER_DV

- W_HCD_PATIENT_ACCOUNT_DV

- W_HCD_PT_ACNT_HLTH_PLN_DV

The following are the new Fact Views:

- W_HCD_BILL_LINE_FV

- W_HCD_CLAIM_LINE_FV

- W_HCD_CLAIM_PAYMT_LINE_FV

- W_HCD_PT_ACNT_HLTH_PLN_FV

The following is the new Bridge Views:

- W_HCD_PT_ACNT_HLTH_PLN_BV

The following are the new Dimension Tables:

- W_HCD_CHARGE_MASTER_D

- W_HCD_COST_CENTER_D

- W_HCD_DRG_D

- W_HCD_GUARANTOR_D

- W_HCD_HEALTH_PLAN_D

- W_HCD_HOUR_OF_DAY_D

- W_HCD_INSURER_D

- W_HCD_OBSERVATION_D

- W_HCD_OBSERVATION_VALUE_D

The following are the new Shrunken Dimension Tables:

- W_HCD_TIME_OF_DAY_D

- W_HCD_YEAR_D

- W_HCD_QTR_D

- W_HCD_MONTH_D

- W_HCD_WEEK_D

The following are the new Coded Dimensions:

Table 1-8 New Coded Dimensions

New Coded Dimension

Code Type Code

Code Type Name

Referencing Fact

W_HCD_PT_ACNT_TYP_DV

PT_ACCT_TYP

Payment Account Type

W_HCD_PATIENT_ACCOUNT_F

W_HCD_PREADMIT_CERT_CD_DV

PREADMT_CERTN_CD

Preadmission Certification Code

W_HCD_PATIENT_ACCOUNT_F

W_HCD_PT_ABLTY_TO_PAY_CD_DV

PT_ABL_TO_PAY_CD

Patient Ability To Pay Code

W_HCD_PATIENT_ACCOUNT_F

W_HCD_PA_HLTH_PLN_RLSHPTYP_DV

PT_ACCT_HPLN_RLSHPTYP

Patient Account Health Plan Relationship Type

W_HCD_PT_ACNT_HLTH_PLN_FB

W_HCD_BILL_TYP_DV

BILL_TYP

Bill Type

W_HCD_BILL_F

W_HCD_BILL_STCD_DV

BILL_STCD

Bill Status Code

W_HCD_BILL_F

W_HCD_ESTD_PAYMT_TYP_DV

ESTD_PAYMT_TYP

Estimated Payment Type

W_HCD_BILL_F

W_HCD_TAX_TYP_DV

TAX_TYP

Tax Type Code

W_HCD_BILL_F

W_HCD_BILL_REASON_CD_DV

BILL_RSN_CD

Bill Reason Code

W_HCD_BILL_F

W_HCD_BILL_MDFR_CD_DV

BILL_LN_ITM_MDFR_CD

Bill Modifier Code

W_HCD_BILL_LINE_FC

W_HCD_CURR_CD_DV

CURR_CD

Currency Code

Not Applicable

W_HCD_CLAIM_TYP_DV

CLM_TYP

Claim Type

W_HCD_CLAIM_F

W_HCD_CLAIM_STCD_DV

CLM_STCD

Claim Status Code

W_HCD_CLAIM_F

W_HCD_CLAIM_HOLD_CD_DV

CLM_HLD_CD

Claim Hold Code

W_HCD_CLAIM_F

W_HCD_CLAIM_COND_CD_DV

CLM_COND_CD

Claim Condition Code

W_HCD_CLAIM_F

W_HCD_CLAIM_OCCUR_CD_DV

CLM_OCCR_CD

Claim Occurrence Code

W_HCD_CLAIM_F

W_HCD_CLAIM_VALUE_CD_DV

CLM_VAL_CD

Claim Value Code

W_HCD_CLAIM_F

W_HCD_STATE_CD_DV

USPS_ST_CD

State Code

W_HCD_CLAIM_F

W_HCD_COUNTRY_CD_DV

ISO_CNTRY_CD

Country Code

Not Applicable

W_HCD_CLAIM_LINE_TYP_DV

CLM_LN_ITM_TYP

Claim Line Type

W_HCD_CLAIM_LINE_FC

W_HCD_TYP_OF_SVC_CD_DV

TYP_OF_SVC_CD

Type of Service Code

W_HCD_CLAIM_LINE_FC

W_HCD_PLC_OF_SVC_CD_DV

PLC_OF_SVC_CD

Place of Service Code

W_HCD_CLAIM_LINE_FC

W_HCD_CLAIM_MDFR_CD_DV

CLM_LN_ITM_MDFR_CD

Claim Modifier Code

W_HCD_CLAIM_LINE_FC

W_HCD_SVC_OR_SUPL_UOMCD_DV

UCUM_UOMCD

Service or Supply UoM Code

Not Applicable

W_HCD_CLAIM_PAYMT_STCD_DV

CLM_PAYMT_STCD

Claim Payment Status Code

W_HCD_CLAIM_PAYMT_F

W_HCD_PAYMT_METHD_TYP_DV

PAYMT_METHD_TYP

Payment Method Type

W_HCD_CLAIM_PAYMT_F

W_HCD_PAYMT_TYP_DV

PAYMT_TYP

Payment Type

W_HCD_CLAIM_PAYMT_F

W_HCD_OUTLIER_TYP_DV

OTLR_TYP

Outlier Type

W_HCD_CLAIM_PAYMT_F

W_HCD_CLAIM_PAYMT_LINE_STCD_DV

CLM_PAYMT_LN_ITM_STCD

Claim Payment Line Status Code

W_HCD_CLAIM_PAYMT_LINE_FC

W_HCD_PATIENT_STCD_DV

PT_STCD

Patient Status Code

W_HCD_PATIENT_F

W_HCD_GENDER_CD_DV

HL7_GNDR_CD

Gender Code

W_HCD_PATIENT_F

W_HCD_LIVING_DEPENDENCY_CD_DV

LIVG_DEPC_CD

Living Dependency Code

W_HCD_PATIENT_F

W_HCD_OBSV_SUBTYP_DV

OBSV_SUBTYP

Observation Subtype

W_HCD_ENC_OBSERVATION_F

W_HCD_OBSV_STCD_DV

OBSV_STCD

Observation Status Code

W_HCD_ENC_OBSERVATION_F

W_HCD_OBSV_METHD_CD_DV

OBSV_METHD_CD

Observation Method Code

W_HCD_ENC_OBSERVATION_F

W_HCD_OBSV_VALUE_TYP_DV

VAL_TYP

Observation Value Type

W_HCD_ENC_OBSERVATION_F

W_HCD_OBSV_VALUE_QUAL_CD_DV

OBSV_VAL_QLFR_CD

Observation Value Qualifier Code

W_HCD_ENC_OBSERVATION_F

W_HCD_OBSV_INTERP_CD_DV

INTERP_CD

Observation Interpretation Code

W_HCD_ENC_OBSERVATION_F

W_HCD_OBSV_PT_REASON_CD_DV

OBSV_RSN_CD

Observation Patient Reason Code

W_HCD_ENC_OBSERVATION_F

W_HCD_INFORMANT_CD_DV

INFRMNT_TYP

Informant Code

W_HCD_ENC_OBSERVATION_F

W_HCD_SPECIMEN_TYP_DV

HL7_SPCMN_TYP

Specimen Type

W_HCD_ENC_OBSERVATION_F

W_HCD_OBSV_VALUE_UOMCD_DV

UCUM_UOMCD

Observation Value UoM Code

Not Applicable

The following attributes are obsolete:

Table 1-9 Obsolete Attributes

TABLE_NAME

COLUMN_NAME

W_HCD_ENCOUNTER_F

DRG_CD_WID

The following attributes are added:

Table 1-10 Attributes Added

TABLE_NAME

COLUMN_NAME

W_HCD_ENCOUNTER_F

APR_DRG_WID

W_HCD_ENCOUNTER_F

AP_DRG_WID

W_HCD_ENCOUNTER_F

MS_DRG_WID

W_HCD_ENCOUNTER_F

ENC_ARRIVAL_TOD_WID

W_HCD_ENCOUNTER_F

ENC_CANCELLED_TOD_WID

W_HCD_ENCOUNTER_F

ENC_END_TOD_WID

W_HCD_ENCOUNTER_F

ENC_OCCURRED_TOD_WID

W_HCD_ENCOUNTER_F

ENC_RESCHED_TOD_WID

W_HCD_ENCOUNTER_F

ENC_SCHED_TOD_WID

W_HCD_ENCOUNTER_F

ENC_START_TOD_WID

W_HCD_ENCOUNTER_F

PLANNED_DISCH_TOD_WID

W_HCD_ENCOUNTER_F

PATIENT_ACCOUNT_WID

W_HCD_ENC_DIAG_FB

LAST_EXPERIENCED_TOD_WID

W_HCD_ENC_DIAG_FB

ONSET_TOD_WID

W_HCD_ENC_DIAG_FB

RECORDED_TOD_WID

W_HCD_ENC_DIAG_FB

RESOLUTION_TOD_WID

W_HCD_ENC_PROC_FB

PROC_END_TOD_WID

W_HCD_ENC_PROC_FB

PROC_START_TOD_WID

W_HCD_ENC_IND_SVC_PROV_FB

IND_SVC_PROV_END_TOD_WID

W_HCD_ENC_IND_SVC_PROV_FB

IND_SVC_PROV_START_TOD_WID

W_HCD_SUBST_ADMIN_FB

SUBST_ADMIN_END_TOD_WID

W_HCD_SUBST_ADMIN_FB

SUBST_ADMIN_START_TOD_WID

W_HCD_EMPLOYEE_D

INT_ORG_WID

W_HCD_IND_SVC_PROV_D

HOME_ADDR_LINE_1

W_HCD_IND_SVC_PROV_D

HOME_ADDR_LINE_2

W_HCD_IND_SVC_PROV_D

HOME_ADDR_LINE_3

W_HCD_IND_SVC_PROV_D

HOME_ADDR_EFF_DT

W_HCD_IND_SVC_PROV_D

HOME_PHONE_NUM

W_HCD_IND_SVC_PROV_D

MOBILE_NUM

W_HCD_IND_SVC_PROV_D

WORK_PHONE_NUM

W_HCD_IND_SVC_PROV_D

PRIMARY_EMAIL_ADDR

W_HCD_IND_SVC_PROV_D

ALTERNATE_EMAIL_ADDR

W_HCD_INT_ORG_D

CREDIT_STATUS_CODE

W_HCD_INT_ORG_D

CREDIT_STATUS_DESC

W_HCD_INT_ORG_D

CREDIT_STATUS_NAME

W_HCD_INT_ORG_D

CREDIT_STATUS_CDSYSCD

W_HCD_INT_ORG_D

CREDIT_STATUS_CDSYSNM

W_HCD_INT_ORG_D

CREDIT_STATUS_CDSYSVR

W_HCD_INT_ORG_D

IND_CLSFN_CODE

W_HCD_INT_ORG_D

IND_CLSFN_DESC

W_HCD_INT_ORG_D

IND_CLSFN_NAME

W_HCD_INT_ORG_D

IND_CLSFN_CDSYSCD

W_HCD_INT_ORG_D

IND_CLSFN_CDSYSNM

W_HCD_INT_ORG_D

IND_CLSFN_CDSYSVR

W_HCD_INT_ORG_D

IND_CLSFN_SUBTYPE_CODE

W_HCD_INT_ORG_D

IND_CLSFN_SUBTYPE_DESC

W_HCD_INT_ORG_D

IND_CLSFN_SUBTYPE_NAME

W_HCD_INT_ORG_D

IND_CLSFN_SUBTYPE_CDSYSCD

W_HCD_INT_ORG_D

IND_CLSFN_SUBTYPE_CDSYSNM

W_HCD_INT_ORG_D

IND_CLSFN_SUBTYPE_CDSYSVR

W_HCD_INT_ORG_D

ADDR_EFF_DT

W_HCD_ORG_SVC_PROV_D

ADDR_LINE_1

W_HCD_ORG_SVC_PROV_D

ADDR_LINE_2

W_HCD_ORG_SVC_PROV_D

ADDR_LINE_3

W_HCD_ORG_SVC_PROV_D

EMAIL_ADDR

W_HCD_ORG_SVC_PROV_D

WEB_PAGE_ADDR

W_HCD_PATIENT_D

HOME_ADDR_LINE_1

W_HCD_PATIENT_D

HOME_ADDR_LINE_2

W_HCD_PATIENT_D

HOME_ADDR_LINE_3

W_HCD_PATIENT_D

HOME_ADDR_EFF_DT

W_HCD_PATIENT_D

HOME_PHONE_NUM

W_HCD_PATIENT_D

MOBILE_NUM

W_HCD_PATIENT_D

WORK_PHONE_NUM

W_HCD_PATIENT_D

PRIMARY_EMAIL_ADDR

W_HCD_PATIENT_D

ALTERNATE_EMAIL_ADDR

W_HCD_PATIENT_D

DECEASED_INFO_SRC_CODE

W_HCD_PATIENT_D

DECEASED_INFO_SRC_DESC

W_HCD_PATIENT_D

DECEASED_INFO_SRC_NAME

W_HCD_PATIENT_D

DECEASED_INFO_SRC_CDSYSCD

W_HCD_PATIENT_D

DECEASED_INFO_SRC_CDSYSNM

W_HCD_PATIENT_D

DECEASED_INFO_SRC_CDSYSVR

W_HCD_PATIENT_D

PRI_CAUSE_OF_DEATH_CODE

W_HCD_PATIENT_D

PRI_CAUSE_OF_DEATH_DESC

W_HCD_PATIENT_D

PRI_CAUSE_OF_DEATH_NAME

W_HCD_PATIENT_D

PRI_CAUSE_OF_DEATH_CDSYSCD

W_HCD_PATIENT_D

PRI_CAUSE_OF_DEATH_CDSYSNM

W_HCD_PATIENT_D

PRI_CAUSE_OF_DEATH_CDSYSVR

W_HCD_PATIENT_D

SEC_CAUSE_OF_DEATH_CODE

W_HCD_PATIENT_D

SEC_CAUSE_OF_DEATH_DESC

W_HCD_PATIENT_D

SEC_CAUSE_OF_DEATH_NAME

W_HCD_PATIENT_D

SEC_CAUSE_OF_DEATH_CDSYSCD

W_HCD_PATIENT_D

SEC_CAUSE_OF_DEATH_CDSYSNM

W_HCD_PATIENT_D

SEC_CAUSE_OF_DEATH_CDSYSVR

W_HCD_PATIENT_D

PLACE_OF_DEATH_CODE

W_HCD_PATIENT_D

PLACE_OF_DEATH_DESC

W_HCD_PATIENT_D

PLACE_OF_DEATH_NAME

W_HCD_PATIENT_D

PLACE_OF_DEATH_CDSYSCD

W_HCD_PATIENT_D

PLACE_OF_DEATH_CDSYSNM

W_HCD_PATIENT_D

PLACE_OF_DEATH_CDSYSVR

W_HCD_PATIENT_D

PLACE_OF_DEATH_STATE_CODE

W_HCD_PATIENT_D

PLACE_OF_DEATH_STATE_DESC

W_HCD_PATIENT_D

PLACE_OF_DEATH_STATE_NAME

W_HCD_PATIENT_D

PLACE_OF_DEATH_STATE_CDSYSCD

W_HCD_PATIENT_D

PLACE_OF_DEATH_STATE_CDSYSNM

W_HCD_PATIENT_D

PLACE_OF_DEATH_STATE_CDSYSVR

W_HCD_PATIENT_D

PLACE_OF_DEATH_CITY

W_HCD_PATIENT_D

OCCUPATION_CODE

W_HCD_PATIENT_D

OCCUPATION_DESC

W_HCD_PATIENT_D

OCCUPATION_NAME

W_HCD_PATIENT_D

OCCUPATION_CDSYSCD

W_HCD_PATIENT_D

OCCUPATION_CDSYSNM

W_HCD_PATIENT_D

OCCUPATION_CDSYSVR

1.3 Healthcare Data Warehouse

The following are the enhancements:

- There are 17 new tables added and new attributes added to 15 existing entities.

- Specimen, Observation, and Intervention subject areas support histopathology data.

- New intersection entities added in Survey subject.

- New entities added in Scheduling subject to support related party pattern and new intersection entity added to capture the relationship between a Schedule and a Service Provider.

1.4 Warehouse Integration Loaders

1.4.1 Warehouse Integration ETLs

New warehouse integration ETLs are provided for all new Interface Tables. For more information on Interface Tables, see Section 1.2.1.

HDI_ETL_GLBL_PARAM_G Updates

Parameter name updated for the following global parameters:

Table 1-11 Global Parameters

New Parameter Name (New Default Value)

Old Parameter Name (Old Default Value)

VERSIONING (YES)

IGNORE_VERSIONING (NO)

ALLOW_INVALID_CODE (NO)

IGNORE_INVALID_CODE (NO)

ALLOW_INVALID_REFERENCES (NO)

IGNORE_INVALID_RFRNCD_COL (NO)

The following parameter is obsolete:

- MAP_TYPE_USED_FOR_STANDARDIZATION

The following new parameters are added:

- RULE_ID_RFRNCED_COL_NULL

- SMTP_MAIL_FROM (Applicable only for WIL ODI loaders)

1.4.2 New Validation Rules of ARC Entity

New foundation rule is implemented in HDI_ARC ETL to validate source node and target node are not same (except for root node).

This rule applies for records having Root Node Flag value N or NULL to ensure value of source node and target node are not same.

This rule applies to the following combination of attributes in ARC entity:

Source Individual Party      Target Individual Party
Source Organization Party          Target Organization Party
Source Role     Target           Role
Source Code     Target           Code

Exception Message Code: RULE_ID_NODES_INVALID

Exception Message Description: Exception occurred because Source Node and Target Node must not be same except for Root Node | attributes causing error appended at the end of exception message.

1.4.3 Warehouse Integration Load Plan

ODI load plan is provided to load HDM tables used by Application Toolkit.

1.5 Application Toolkit

There are 11 new fact tables and 51 new dimensions added to Healthcare Common Data Mart to support measures related to Charges, Billing, Claims, Payment, Patient, and Observation.

The following are the new fact and dimension tables:

New Fact Tables

- Patient

- Observation

- Patient Account

- Patient Account Health Plan

- Encounter Charge

- Bill

- Bill Line

- Claim

- Clam Line

- Claim Payment

- Claim Payment Line

New Dimension Tables

- DRG

- Encounter

- Observation Codes

- Observation Value

- Charge Master

- Cost Center

- Insurer

- Health Plan

- Guarantor

- Patient Account

- Patient Account Health Plan

- Bill

- Claim

- Claim Payment

- Year

- Quarter

- Month

- Week

- Hour of Day

- Observation Status

- Observation Method

- Observation Interpretation

- Observation Patient Reason

- Observation Subtype

- Observation Value Qualifier Code

- Observation Value Type

- Bill Status

- Bill Type

- Bill Modifier

- Bill Reason

- Claim Status

- Claim Condition

- Claim Holding

- Claim Type

- Claim Line Type

- Claim Modifier

- Claim Occurrence

- Claim Payment Status

- Claim Payment Line Status

- Claim Payment Method Type

- Claim Payment Type

- Estimated Payment Type

- Patient Account Health Plan Relationship Type

- Patient Ability To Pay

- Patient Account Type

- Place of Service Code

- Preadmit Certification

- Tax Type

- Type of Service

1.6 Application Toolkit Loaders

1.6.1 Application Toolkit ETLs

New application toolkit ETLs are provided for new fact tables, fact bridge tables, fact child tables, and dimension tables. For more details, see Section 1.2.3.

New Parameters added in HCD_ETL_ENTY_SELCTN_PARAM_G

Table 1-12 New Parameters added for Encounter Fact Table

Entity Name (MSTR_ENTY_NM)

Parameter Name (ATTRIB_NM)

Default Parameter Value (ATTRIB_VAL)

W_HCD_ENCOUNTER_F

ENC_MSDRG_CDTYP

MS_DRG_CD

W_HCD_ENCOUNTER_F

ENC_APDRG_CDTYP

AP_DRG_CD

W_HCD_ENCOUNTER_F

ENC_APRDRG_CDTYP

APR_DRG_CD

Table 1-13 New Parameters added for new Fact Tables

Entity Name (MSTR_ENTY_NM)

Parameter Name (ATTRIB_NM)

Default Parameter Value (ATTRIB_VAL)

W_HCD_BILL_F

ENC_RSPNSBL_ORG_SVCPRV_RLSHPTYP_CD

ENC_SVCPRV_RLSHPTYP_RSPNSBL_SVCPRV

W_HCD_CLAIM_F

ENC_RSPNSBL_ORG_SVCPRV_RLSHPTYP_CD

ENC_SVCPRV_RLSHPTYP_RSPNSBL_SVCPRV

W_HCD_CLAIM_F

ENC_SVCPRV_RLSHPTYP_PRMRY_ATTNDG_SVCPRV_CD

ENC_SVCPRV_RLSHPTYP_ATTNDG_SVCPRV

W_HCD_CLAIM_F

CLM_DX_PRIMARY_ADMTNG_DX_RLSHPTYP_CD

-

W_HCD_CLAIM_F

CLM_DX_PRNCPL_DX_RLSHPTYP_CD

-

W_HCD_CLAIM_F

CLM_INTVN_PRNCPL_PROC_RLSHPTYP_CD

-

W_HCD_CLAIM_PAYMT_F

ENC_RSPNSBL_ORG_SVCPRV_RLSHPTYP_CD

ENC_SVCPRV_RLSHPTYP_RSPNSBL_SVCPRV

W_HCD_ENC_CHARGE_F

ENC_CHRG_RSPNSBL_ORG_SVCPRV_RLSHPTYP_CD

ENC_SVCPRV_RLSHPTYP_RSPNSBL_SVCPRV

W_HCD_OBSERVATION_F

OBSV_SVCPRV_RLSHPTYP_RSPNSBL_IND_SVCPRV_CD

OBSV_SVCPRV_RLSHPTYP_RSPNSBL_SVCPRV

W_HCD_OBSERVATION_F

OBSV_SVCPRV_RLSHPTYP_RSPNSBL_ORG_SVCPRV_CD

OBSV_SVCPRV_RLSHPTYP_RSPNSBL_SVCPRV

W_HCD_OBSERVATION_F

OBSV_SVCPRV_RLSHPTYP_PERFMR_CD

OBSV_SVCPRV_RLSHPTYP_PERFMR

W_HCD_OBSERVATION_F

OBSV_SVCPRV_RLSHPTYP_VRFR_CD

OBSV_SVCPRV_RLSHPTYP_VRFR

W_HCD_OBSERVATION_F

OBSV_SVCPRV_RLSHPTYP_RCRDR_CD

OBSV_SVCPRV_RLSHPTYP_RCRDR

W_HCD_OBSERVATION_F

OBSV_RSN_SUBTYP_OBS_PT_RSN_CD

OBSV_RSN_SUBTYP_OBS_PT_RSN

W_HCD_OBSERVATION_F

OBSV_SUBTYP_CD

OBSV_SUBTYP_ACTY_ST

OBSV_SUBTYP_ADL

OBSV_SUBTYP_ADVS_EVNT

OBSV_SUBTYP_ASSMT

OBSV_SUBTYP_PATHO_FINDG

OBSV_SUBTYP_CMPLCTN

OBSV_SUBTYP_CNTRAINDCTN

OBSV_SUBTYP_DC_NT

OBSV_SUBTYP_EVLTN

OBSV_SUBTYP_IMG_INSTNCE

OBSV_SUBTYP_INTLRNCE

OBSV_SUBTYP_RPT

OBSV_SUBTYP_RSLT

W_HCD_PATIENT_ACCOUNT_F

ENC_RSPNSBL_ORG_SVCPRV_RLSHPTYP_CD

ENC_SVCPRV_RLSHPTYP_RSPNSBL_SVCPRV

W_HCD_PATIENT_F

PT_SVCPRV_RLSHPTYP_PRMRY_CARE_SVCPRV_CD

PT_SVCPRV_RLSHPTYP_PRMRY_CARE_PHYS

W_HCD_PATIENT_F

PT_SVCPRV_RLSHPTYP_RSPNSBL_SVCPRV_CD

PT_SVCPRV_RLSHPTYP_RSPNSBL_SVCPRV

Table 1-14 New Parameters added for Individual Service Provider Dimension

Entity Name (MSTR_ENTY_NM)

Parameter Name (ATTRIB_NM)

Default Parameter Value (ATTRIB_VAL)

W_HCD_IND_SVC_PROV_D

PRTY_ALT_ID_TYP_3_CD

PRTY_ID_TYP_PPT_NBR

W_HCD_IND_SVC_PROV_D

CNTCT_INFO_SUBTYP_EML_CD

CNTCT_INFO_SUBTYP_EML

W_HCD_IND_SVC_PROV_D

CNTCT_INFO_SUBTYP_TELE_CD

CNTCT_INFO_SUBTYP_TELE

W_HCD_IND_SVC_PROV_D

CNTCT_INFO_SUBTYP_MOB_CD

CNTCT_INFO_SUBTYP_MOB

W_HCD_IND_SVC_PROV_D

CNTCT_INFO_TYP_HME_TELE_CD

H

W_HCD_IND_SVC_PROV_D

CNTCT_INFO_TYP_WRK_TELE_CD

WP

W_HCD_IND_SVC_PROV_D

PRTY_RLSHPTYP_SPV_CD

PRTY_RLSHPTYP_MGR

Table 1-15 New Parameters added for Organization Service Provider Dimension

Entity Name (MSTR_ENTY_NM)

Parameter Name (ATTRIB_NM)

Default Parameter Value (ATTRIB_VAL)

W_HCD_ORG_SVC_PROV_D

CNTCT_INFO_SUBTYP_URL_CD

CNTCT_INFO_SUBTYP_URL

W_HCD_ORG_SVC_PROV_D

CNTCT_INFO_SUBTYP_EML_CD

CNTCT_INFO_SUBTYP_EML

W_HCD_ORG_SVC_PROV_D

SVCPRV_PRTY_RLSHPTYP_CD

SVCPRV_PRTY_RLSHPTYP_MBR_BIZ_UNT

Table 1-16 New Parameters added for Patient Dimension

Entity Name (MSTR_ENTY_NM)

Parameter Name (ATTRIB_NM)

Default Parameter Value (ATTRIB_VAL)

W_HCD_PATIENT_D

CNTCT_INFO_SUBTYP_EML_CD

CNTCT_INFO_SUBTYP_EML

W_HCD_PATIENT_D

CNTCT_INFO_SUBTYP_TELE_CD

CNTCT_INFO_SUBTYP_TELE

W_HCD_PATIENT_D

CNTCT_INFO_SUBTYP_MOB_CD

CNTCT_INFO_SUBTYP_MOB

W_HCD_PATIENT_D

CNTCT_INFO_TYP_WRK_TELE_CD

WP

W_HCD_PATIENT_D

CNTCT_INFO_TYP_HME_TELE_CD

H

Table 1-17 New Parameters added for new Dimension Tables

Entity Name (MSTR_ENTY_NM)

Parameter Name (ATTRIB_NM)

Default Parameter Value (ATTRIB_VAL)

W_HCD_CHARGE_MASTER_D

CHRG_MSTR_STCD

-

W_HCD_CHARGE_MASTER_D

CHRG_MSTR_RLSHPTYP_CD

CHRG_MSTR_RLSHPTYP_PARENT

W_HCD_COST_CENTER_D

CNTCT_INFO_SUBTYP_EML_CD

CNTCT_INFO_SUBTYP_EML

W_HCD_COST_CENTER_D

CNTCT_INFO_SUBTYP_TELE_CD

CNTCT_INFO_SUBTYP_TELE

W_HCD_COST_CENTER_D

CNTCT_INFO_SUBTYP_URL_CD

CNTCT_INFO_SUBTYP_URL

W_HCD_COST_CENTER_D

PRTY_ADDR_TYP_BUS_CD

PRTY_ADDR_TYP_BUS

W_HCD_COST_CENTER_D

PRTY_RLSHPTYP_MGR_CD

PRTY_RLSHPTYP_MGR

W_HCD_COST_CENTER_D

CNTCT_INFO_SUBTYP_FAX_CD

CNTCT_INFO_SUBTYP_FAX

W_HCD_DRG_D

TYPE_CD

APR_DRG_TYP,APS_DRG_TYP,AP_DRG_TYP,IR_DRG_TYP,MS_DRG_TYP,R_DRG_TYP,S_DRG_TYP

W_HCD_GUARANTOR_D

PRTY_ID_TYP_CD

PRTY_ID_TYP_SSN

W_HCD_GUARANTOR_D

CNTCT_INFO_SUBTYP_TELE_CD

CNTCT_INFO_SUBTYP_TELE

W_HCD_GUARANTOR_D

CNTCT_INFO_SUBTYP_MOB_CD

CNTCT_INFO_SUBTYP_MOB

W_HCD_GUARANTOR_D

CNTCT_INFO_TYP_HME_TELE_CD

H

W_HCD_GUARANTOR_D

CNTCT_INFO_SUBTYP_URL_CD

CNTCT_INFO_SUBTYP_URL

W_HCD_GUARANTOR_D

CNTCT_INFO_TYP_WRK_TELE_CD

WP

W_HCD_GUARANTOR_D

CNTCT_INFO_SUBTYP_EML_CD

CNTCT_INFO_SUBTYP_EML

W_HCD_GUARANTOR_D

PRTY_ADDR_TYP_HME_CD

PRTY_ADDR_TYP_HME

W_HCD_INSURER_D

CNTCT_INFO_SUBTYP_EML_CD

CNTCT_INFO_SUBTYP_EML

W_HCD_INSURER_D

CNTCT_INFO_SUBTYP_FAX_CD

CNTCT_INFO_SUBTYP_FAX

W_HCD_INSURER_D

CNTCT_INFO_SUBTYP_TELE_CD

CNTCT_INFO_SUBTYP_TELE

W_HCD_INSURER_D

CNTCT_INFO_SUBTYP_URL_CD

CNTCT_INFO_SUBTYP_URL

W_HCD_INSURER_D

PRTY_ADDR_TYP_BUS_CD

PRTY_ADDR_TYP_BUS

W_HCD_OBSERVATION_D

TYPE_CD

OBSV_CD

W_HCD_OBSERVATION_VALUE_D

TYPE_CD

OBSV_VAL_CD

1.6.1.1 Configuration Enhancement of ETL Parameters

ETL selection parameter configuration enhanced to configure only code value (code system and code system version are not required). Application Toolkit ETLs enhanced to consider only code value from configuration table (HCD_ETL_ENTY_SELCTN_PARAM_G).

1.6.1.2 Application Toolkit Load Plan

ODI load plan is provided to execute Application Toolkit ETLs as per recommended load sequence.

1.6.1.3 Mapping Updates

Internal Organization Dimension ETL

ETL for W_HCD_INT_ORG_D is updated to change driving entity to HDM_BIZ_UNT instead of HDM_ORG_PRTY.

Patient, Employee and Individual Service Provider Dimension ETLs

Mapping enhanced for Full Name attribute of W_HCD_PATIENT_D, W_HCD_EMPLOYEE_D, and W_HCD_IND_SVC_PROV_D based on conditional mapping, as follows:

If HDM_PRTY.PRTY_NM is NOT NULL, then populate Party Name attribute value of HDMParty entity to Full Name attribute.

Else

Populate Full Name attribute by concatenating First Name & ' ' & Middle Name & ' ' & Last Name & ' ' & Name Suffix attributes from Individual Party.

Hierarchy Table ETLs

Hierarchy tables ETLs are enhanced to change data loading strategy from bottom-up to top-down approach.

1.7 Self-Service Analytics

A new Healthcare Common Data Mart RPD is delivered for Oracle Business Intelligence. There are 11 new subject areas added that can be used to create reports and dashboards.

The following are the new subject areas:

Clinical

- Patient

- Observation

Finance

- Patient Account

- Patient Account Health Plan

- Encounter Charge

- Bill

- Bill Line

- Claim

- Claim Line

- Claim Payment

- Claim Payment Line

2 User Documentation

The 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 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-2016, 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.

Alpha and Beta Draft Documentation Notice

If this document is in preproduction status:

This documentation is in preproduction 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 Alpha and Beta Draft Documentation Notice

If this document is in private preproduction 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 beta 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.