| Oracle® Healthcare Foundation New Features Guide Release 7.0.1 E71002-02 |
|
|
PDF · Mobi · ePub |
| Oracle® Healthcare Foundation New Features Guide Release 7.0.1 E71002-02 |
|
|
PDF · Mobi · ePub |
This chapter contains descriptions of the new features and enhancements in Oracle Healthcare Foundation. This chapter contains the following sections:
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
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_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_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_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 |
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_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_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:
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:
The following attributes are 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 |
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.
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:
| 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)
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.
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
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 |
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).
ODI load plan is provided to execute Application Toolkit ETLs as per recommended load sequence.
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.
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
|
 Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
