| Oracle® Healthcare Data Model Reference 11g Release 2 (11.2) Part Number E18026-02 |
|
|
View PDF |
| Oracle® Healthcare Data Model Reference 11g Release 2 (11.2) Part Number E18026-02 |
|
|
View PDF |
This chapter provides the partitioned tables and indexes for the Oracle Healthcare Data Model physical tables.
This chapter includes the following sections:
Table 6-1 shows the partitioned DWD , DWR, and DWX tables for the Oracle Healthcare Data Model with the partitioned table name, partitioned column, and partition Type.
Table 6-2 shows the partitioned HDM tables for the Oracle Healthcare Data Model with the Partitioned table name, partition Type, and partitioned Column.
Table 6-1 Physical Data Model DWD, DWR, and DWX Partitioning
| Physical Table Name | Partition Column | Partition Type |
|---|---|---|
|
DWD_ENC |
ENC_END_DT,ENC_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
DWD_ENC_CASE |
ENC_END_DT,ENC_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
DWD_ENC_CNRN |
ENC_END_DT,ENC_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
DWD_ENC_INTVN |
ENC_END_DT,ENC_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
DWD_ENC_OBSV |
ENC_END_DT,ENC_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
DWD_ENC_ORD |
ENC_END_DT,ENC_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
DWD_KPI_CASE_FCT |
ENC_END_DATE_ID,KPI_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
DWD_KPI_ENC_FCT |
ENC_END_DATE_ID,KPI_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
DWD_KPI_OBSV_FCT |
ENC_END_DATE_ID,KPI_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
DWX_CODE_REP_XREF |
CD_TYP_CD |
HASH |
|
DWR_PT |
PT_ID |
HASH |
Table 6-2 Physical Data Model HDM Partitioning
| Physical Table Name | Partition Column | Partition Type |
|---|---|---|
|
HDM_CASE |
CASE_STRT_DT, CASE_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
HDM_CASE_EVNT |
CASE_EVNT_DT, CASE_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
HDM_CASE_OBSV |
STRT_DT, CASE_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
HDM_CASE_SVCPRV |
STRT_DT, CASE_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
HDM_CNRN |
CNRN_ID |
HASH |
|
HDM_CNRN_OBSV |
STRT_DT, CNRN_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
HDM_CNRN_SVCPRV |
STRT_DT, CNRN_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
HDM_CNSNT |
CNSNT_ID |
HASH |
|
HDM_ENC |
END_DT, ENC_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
HDM_ENC_CNRN |
ENC_ID |
HASH |
|
HDM_ENC_FAC |
ENC_ID |
HASH |
|
HDM_ENC_INTVN |
ENC_ID |
HASH |
|
HDM_ENC_OBSV |
ENC_ID |
HASH |
|
HDM_ENC_ORD |
ENC_ID |
HASH |
|
HDM_ENC_RSN |
ENC_ID |
HASH |
|
HDM_ENC_SVCPRV |
ENC_ID |
HASH |
|
HDM_IND_PRTY |
PRTY_ID |
HASH |
|
HDM_INTVN |
START_DT |
RANGE(DAY) |
|
HDM_INTVN_CNRN |
STRT_DT, INTVN_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
HDM_INTVN_OBSV |
STRT_DT, INTVN_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
HDM_INTVN_RSN |
INTVN_ID |
HASH |
|
HDM_INTVN_SVCPRV |
INTVN_ID |
HASH |
|
HDM_INTVN_SUBST |
INTVN_ID |
HASH |
|
HDM_INVPHYCNT_LN |
STRT_DT |
RANGE(MONTH) |
|
HDM_INVT_BAL |
INVT_BAL_DT |
RANGE(MONTH) |
|
HDM_INVT_SHPMNT |
SHPMNT_SNT_DT |
RANGE(MONTH) |
|
HDM_INVT_TRANS |
INVT_TRANS_DT |
RANGE(MONTH) |
|
HDM_INV_LN |
INV_LN_ID |
HASH |
|
HDM_JRNL_LN |
CRE_DT |
RANGE(MONTH) |
|
HDM_LED_BAL |
PSTNG_DT |
RANGE(MONTH) |
|
HDM_OBSV |
OBSV_DT |
RANGE(DAY) |
|
HDM_OBSV_RSN |
OBSV_ID |
HASH |
|
HDM_OBSV_SVCPRV |
STRT_DT,OBSV_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
HDM_ORD |
ORD_DT |
RANGE(DAY) |
|
HDM_ORD_CNRN |
STRT_DT,ORD_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
HDM_ORD_RSN |
ORD_ID |
HASH |
|
HDM_ORD_SVCPRV |
STRT_DT,ORD_ID |
RANGE(DAY) COMPOSITE BY HASH |
|
HDM_PAYMT |
PAYMT_DT |
RANGE(MONTH) |
|
HDM_PT |
PT_ID |
HASH |
|
HDM_PT_HX |
PT_ID |
HASH |
|
HDM_PO_DSTRBN_LN |
ACCTG_DT |
RANGE(MONTH) |
|
HDM_RCPT_DSTRBN_LN |
ACCTG_DT |
RANGE(MONTH) |
|
HDM_REQ_DSTRBN_LN |
ACCTG_DT |
RANGE(MONTH) |
|
HDM_SUBADMN_ORD |
ORD_ID |
HASH |
|
HDM_VCHR_DSTRBN_LN |
ACCTG_DT |
RANGE(MONTH) |
Table 6-3 shows the indexes for the DWC, DWD , DWR, and DWX tables for the Oracle Healthcare Data Model.
Table 6-3 Physical Data Model Indexes for DWC, DWD, DWR, and DWX Tables
| Table Name | FK Index Name | Columns |
|---|---|---|
|
DWC_ETL_HDM_DMN_CD_SYS |
DWC_ETL_HDM_DMN_CD_SYS_PK |
CD_TYP_ID,CD_SYS_ID |
|
DWC_ETL_PARAM |
DWC_ETL_PARAM_PK |
PRCSS_NM |
|
DWC_INTRA_ETL_ACTVTY |
DWC_INTRA_ETL_ACTVTY_PK |
ACTVTY_KEY |
|
DWC_INTRA_ETL_PROC |
DWC_INTRA_ETL_PROC_PK |
PRCSS_KEY |
|
DWC_MESSAGE |
DWC_MESSAGE_PK |
LANG,MSG_NBR |
|
DWC_OLAP_ETL_PARAM |
DWC_OLAP_ETL_PARAM_PK |
PRCSS_NM |
|
DWD_ENC |
DWD_ENC_PK |
ENC_ID |
|
DWD_KPI_CASE_FCT |
DWD_KPI_CASE_FCT_PK |
KPI_ID,CASE_ID |
|
DWD_KPI_ENC_FCT |
DWD_KPI_ENC_FCT_PK |
KPI_ID,ENC_ID |
|
DWD_KPI_OBSV_FCT |
DWD_KPI_OBSV_FCT_PK |
KPI_ID,OBSV_ID |
|
DWR_AGEBND |
DWR_AGEBND_PK |
AGEBND_ID |
|
DWR_AGEBND_RNG |
DWR_AGEBND_RNG_PK |
AGEBND_RNG_ID |
|
DWR_BASE_DAY |
DWR_BASE_DAY_PK |
CAL_TYP,DY_KEY |
|
DWR_CLNDR_HLF_YR |
DWR_CLNDR_HLF_YR_PK |
CAL_HALF_YR_KEY |
|
DWR_CLNDR_MTH |
DWR_CLNDR_MO_PK |
CAL_MTH_KEY |
|
DWR_CLNDR_QTR |
DWR_CLNDR_QTR_PK |
CAL_QTR_KEY |
|
DWR_CLNDR_WK |
DWR_CLNDR_WK_PK |
CAL_WK_KEY |
|
DWR_CLNDR_YR |
DWR_CLNDR_YR_PK |
CAL_YR_KEY |
|
DWR_DAY |
DWR_DAY_PK |
DATE_ID |
|
DWR_KPI |
DWR_KPI_PK |
KPI_ID |
|
DWR_SHFT |
DWR_SHFT_PK |
SHFT_ID |
|
DWR_SVCPRVPRCT |
DWR_SVCPRVPRCT_PK |
SVCPRVPRCT_ID |
|
DWR_SVCPRVPRCT |
DWR_SVCPRVPRCT_UK |
SVCPRVPRCT_PRCT_ID, SVCPRVPRCT_SVCPRV_ID |
|
DWR_TOD |
DWR_TOD_PK |
TOD_ID |
|
DWR_WKDAY |
DWR_WKDAY_PK |
WKDAY_KEY |
|
DWX_FAC_SHFT_XREF |
DWX_FAC_SHFT_XREF_PK |
FAC_MBR_ID,SHFT_ID |
|
 Copyright © 2010, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
