4 Oracle Healthcare Data Model Physical Data Model

This chapter provides information about the Oracle Healthcare Data Model physical model.

This chapter includes the following sections:

Introduction to Oracle Healthcare Data Model Physical Data Model
Oracle Healthcare Data Model Tables (HDM)
Reference Tables
Derived Tables
DWX Cross Reference Tables
Compressed Tables
Partition Definitions
Index Definitions
Parallel Definitions
OLAP ETL Views
OLAP SQL Views

Introduction to Oracle Healthcare Data Model Physical Data Model

The Oracle Healthcare Data Model physical model is the physical manifestation of the logical data model into database tables and relationships (or foreign key constraints). Partitions, indexes, parallel definitions, and Cube Views have been added to aid performance.

The Physical data model includes the following:

Oracle Healthcare Data Model Tables (HDM)
Reference Tables
Derived Tables
DWX Cross Reference Tables

Important:

Do not make changes to the schemas as such changes are not supported.

Table 4-1 shows the table name prefix conventions. When you examine the predefined physical model, keep in mind the naming conventions shown in Table 4-1 that use DW (Data Warehouse) and HDM (Healthcare Data Model) prefixes to identify the types of tables and views.

Table 4-1 Table Name Prefix Conventions

Prefix	Description
DWC_	For information on Control tables, see Appendix A, "Oracle Healthcare Data Model Control Tables"
DWD_	Derived table
DWR_	Reference data table
DWX_	Facility-Shift and Code Repository (lookup) Cross Reference Table
HDM_	Oracle Healthcare Data Model Warehouse table

Oracle Healthcare Data Model Tables (HDM)

Table 4-2 shows the Oracle Healthcare Data Model Warehouse (HDM_) tables.

Table 4-2 HDM Tables

Table Name	Associated Logical Data Model Entity and Description
HDM_AA	ADMINISTRATIVE ANALYST
HDM_ACC_ENT	ACCOUNTING ENTRY
HDM_ACRD_ORG	ACCREDITATION ORGANIZATION
HDM_ADT_ORD	ADT ORDER
HDM_ADT_ORD_SPECLARNGMNT	ADT ORDER SPECIAL ARRANGEMENT
HDM_ADT_ORD_SPECL_CRTSY	ADT ORDER SPECIAL COURTESY
HDM_ADVDR	ADVANCE DIRECTIVE
HDM_ADVDR_SVCPRV	ADVANCE DIRECTIVE SERVICE PROVIDER
HDM_ALGY_HX	ALLERGY HISTORY
HDM_ALGY_REACN	ALLERGY REACTION
HDM_ALRT	ALERT
HDM_ALRT_INTMSR	ALERT INTERVENTION MASTER
HDM_ALRT_PRDMSR	ALERT PRODUCT MASTER
HDM_APPL	APPEAL
HDM_APPL_RP	APPEAL RELATED PARTY
HDM_APPL_STUS	APPEAL STATUS
HDM_ASST	ASSET
HDM_ASST_ACCTG_RTRETRN	ASSET ACCOUNTING RATE OF RETURN
HDM_ASST_AMORT	ASSET AMORTIZATION
HDM_ASST_APPR_ADJMT	ASSET APPRAISAL ADJUSTMENT
HDM_ASST_ASSMT	ASSET ASSESSMENT
HDM_ASST_COND	ASSET CONDITION
HDM_ASST_DISCD_PAYBK_PD	ASSET DISCOUNTED PAYBACK PERIOD
HDM_ASST_LOC	ASSET LOCATION
HDM_ASST_LOC_RP	ASSET LOCATION RELATED PARTY
HDM_ASST_LOC_STUS	ASSET LOCATION STATUS
HDM_ASST_NET_PRSNT_VAL	ASSET NET PRESENT VALUE
HDM_ASST_PAYBK_PD	ASSET PAYBACK PERIOD
HDM_ASST_RPLCMT_CST	ASSET REPLACEMENT COST
HDM_ASST_SALV_VAL	ASSET SALVAGE VALUE
HDM_BED	BED
HDM_BENE_PLN	BENEFIT PLAN
HDM_BENE_PROV	BENEFITS PROVIDER
HDM_BILG_ACCT	BILLING ACCOUNT
HDM_BIZ_UNT	BUSINESS UNIT
HDM_CAREGV	CAREGIVER
HDM_CARE_SITE	CARE SITE
HDM_CARE_SITE_BLCK	CARE SITE BLOCK
HDM_CARE_SITE_BLCK_RELSE	CARE SITE BLOCK RELEASE
HDM_CARE_SITE_BLCK_SEGMT	CARE SITE BLOCK SEGMENT
HDM_CARE_SITE_TM_SEGMT	CARE SITE OPEN TIME SEGMENT
HDM_CARE_SITE_TM_UTILZTN	CARE SITE OPEN TIME UTILIZATION
HDM_CARE_SITE_TO	CARE SITE TURNOVER
HDM_CASE	CASE
HDM_CASE_CNRN	CASE CONCERN
HDM_CASE_CNSNT	CASE CONSENT
HDM_CASE_EVNT	CASE EVENT
HDM_CASE_FAC	CASE FACILITY
HDM_CASE_GRP	CASE GROUP
HDM_CASE_GRP_CASE	CASE GROUP CASE
HDM_CASE_OBSV	CASE OBSERVATION
HDM_CASE_PLND_PROC	CASE PLANNED PROCEDURE
HDM_CASE_PST_CARE	CASE POST CARE
HDM_CASE_RP	CASE RELATED PARTY
HDM_CASE_RSN	CASE REASON
HDM_CASE_SUPL	CASE SUPPLY
HDM_CASE_SVCPRV	CASE SERVICE PROVIDER
HDM_CASE_TRANS	CASE TRANSACTION
HDM_CD_REPOSITORY	Code values or concepts from various code systems (concept = a unique medical or clinical idea).
HDM_CD_REPOSITORY_CD_SET	Association of code values to code sets.
HDM_CD_REPOSITORY_CD_TYP	Association of code values to code lookup types.
HDM_CD_SET	A grouping of code values or concepts, outside of a standard classification system or standard medical terminology.
HDM_CD_SYS	Medical terminology or classification system. For example: SNOMED-CT, ICD9.
HDM_CD_TYP	Various lookup types.
HDM_CERTN_ORG	CERTIFICATION ORGANIZATION
HDM_CHRTFLD_COMB	CHARTFIELD COMBINATION
HDM_CHRT_OF_ACCT	CHART OF ACCOUNTS
HDM_CLM	CLAIM
HDM_CLMD_DRUG	CLAIMED DRUG
HDM_CLMD_INTVN	CLAIMED INTERVENTION
HDM_CLMD_SUPL	CLAIMED SUPPLY
HDM_CLMD_SVC	CLAIMED SERVICE
HDM_CLM_ADJMT	CLAIM ADJUSTMENT
HDM_CLM_CHRG	CLAIM CHARGES
HDM_CLM_CHRG_DNYD_RSN	CLAIM CHARGE DENIED REASON
HDM_CLM_CHRG_REDCD_RSN	CLAIM CHARGE REDUCED REASON
HDM_CLM_DLY_RSN	CLAIM DELAY REASON
HDM_CLM_PAYG_PRTY	CLAIM PAYING PARTY
HDM_CLM_PAYMT	CLAIM PAYMENT
HDM_CLM_PAYMT_RP	CLAIM PAYMENT RELATED PARTY
HDM_CLM_PAYPRTY_BAL	CLAIM PAYMENT PARTY BALANCE
HDM_CLM_REJ_RSN	CLAIM REJECTION REASON
HDM_CLM_RELTD_FNDED_PRG	CLAIM RELATED FUNDED PROGRAM
HDM_CLM_RP	CLAIM RELATED PARTY
HDM_CLM_SPECL_PRG_CD	CLAIM SPECIAL PROGRAM CODE
HDM_CLM_STUS	CLAIM STATUS
HDM_CLM_SUBROG_PAYMT	CLAIM SUBROGATION PAYMENT
HDM_CNRN	CONCERN
HDM_CNRN_ANATSITE	CONCERN ANATOMICAL SITE
HDM_CNRN_CSE	CONCERN CAUSE
HDM_CNRN_GRP	CONCERN GROUP
HDM_CNRN_GRP_CNRN	CONCERN GROUP CONCERN
HDM_CNRN_OBSV	CONCERN OBSERVATION
HDM_CNRN_RP	CONCERN RELATED PARTY
HDM_CNRN_SVCPRV	CONCERN SERVICE PROVIDER
HDM_CNRN_TRANS	CONCERN TRANSACTION
HDM_CNSNT	CONSENT
HDM_CNSNT_AUTHZ_INTVN	CONSENT AUTHORIZED INTERVENTION
HDM_CNSNT_GRP	CONSENT GROUP
HDM_CNSNT_GRP_CNSNT	CONSENT GROUP CONSENT
HDM_CNSNT_RP	CONSENT RELATED PARTY
HDM_CNSNT_SVCPRV	CONSENT SERVICE PROVIDER
HDM_CNSNT_TRANS	CONSENT TRANSACTION
HDM_CNSOLD_BAL_SHT	CONSOLIDATED BALANCE SHEET
HDM_CNSOLD_CSH_FLOW_STMT	CONSOLIDATED CASH FLOW STATEMENT
HDM_CNSOLD_STMT_OF_INCM	CONSOLIDATED STATEMENT OF INCOME
HDM_CNSOLD_STMT_OF_NWRTH	CONSOLIDATED STATEMENT OF NET WORTH
HDM_CNTCT	CONTACT
HDM_CNTRCT	CONTRACT
HDM_CNTRCT_GRP_HLTHPLN	CONTRACT GROUP HEALTH PLAN
HDM_CNTRCT_PAYR	CONTRACT PAYER
HDM_CNTRCT_RP	CONTRACT RELATED PARTY
HDM_CNTRCT_SECT	CONTRACT SECTION
HDM_CNTRCT_SECT_CLS	CONTRACT SECTION CLAUSE
HDM_CNTRCT_SLA_PARM	CONTRACT SLA PARAMETER
HDM_CONTN	CONTINUATION
HDM_CRST_BLCK_UTILZTN	CARE SITE BLOCK UTILIZATION
HDM_CRST_OPN_TM_SEGMT	CARE SITE OPEN TIME SEGMENT
HDM_CRST_OPN_TM_UTILZTN	CARE SITE OPEN TIME UTILIZATION
HDM_CST_CNTR	COST CENTER
HDM_CURR_CONV	CURRENCY CONVERSION
HDM_DEP	DEPENDENT
HDM_DEP_WLFR_PLN	DEPENDENT WELFARE PLAN
HDM_DIET_ORD	DIET ORDER
HDM_DIET_ORD_CNSMP_METHD	DIET ORDER CONSUMPTION METHOD
HDM_DLVR_TO_LOC	DELIVER TO LOCATION
HDM_DNB_FIN_RTG	DUN BRADSTREET FINANCIAL RATING
HDM_DNB_PAYMT_INX	DUN BRADSTREET PAYMENT INDEX
HDM_DSCLSR	DISCLOSURE
HDM_EFX_CR_RPT	EQUIFAX CREDIT REPORT
HDM_EMP	EMPLOYEE
HDM_EMPR	EMPLOYER
HDM_EMP_BENE_PLN	EMPLOYEE BENEFIT PLAN
HDM_EMP_BENE_PLN_STMT	EMPLOYEE BENEFIT PLAN STATEMENT
HDM_EMP_CERTN	EMPLOYEE CERTIFICATION
HDM_EMP_CRED	EMPLOYEE CREDENTIAL
HDM_EMP_EMPMT_STUS	EMPLOYEE EMPLOYMENT STATUS
HDM_EMP_HR_EVNT	EMPLOYEE HR EVENT
HDM_EMP_POSTN	EMPLOYEE POSITION
HDM_EMP_PRIV	EMPLOYEE PRIVILEGE
HDM_EMP_RP	EMPLOYEE RELATED PARTY
HDM_EMP_TRN	EMPLOYEE TRAINING
HDM_EMP_WLFR_PLN	EMPLOYEE WELFARE PLAN
HDM_ENC	ENCOUNTER
HDM_ENC_CNRN	ENCOUNTER CONCERN
HDM_ENC_CNSNT	ENCOUNTER CONSENT
HDM_ENC_DRUG_CHRG	ENCOUNTER DRUG CHARGE
HDM_ENC_FAC	ENCOUNTER FACILITY
HDM_ENC_FAC_CHRG	ENCOUNTER FACILITY CHARGE
HDM_ENC_GRP	ENCOUNTER GROUP
HDM_ENC_GRP_ENC	ENCOUNTER GROUP ENCOUNTER
HDM_ENC_HLTHPLN_PLCY	ENCOUNTER HEALTH PLAN POLICY
HDM_ENC_INTVN	ENCOUNTER INTERVENTION
HDM_ENC_INTVN_CHRG	ENCOUNTER INTERVENTION CHARGE
HDM_ENC_OBSV	ENCOUNTER OBSERVATION
HDM_ENC_ORD	ENCOUNTER ORDER
HDM_ENC_RP	ENCOUNTER RELATED PARTY
HDM_ENC_RSN	ENCOUNTER REASON
HDM_ENC_SPECLARNGMNT	ENCOUNTER SPECIAL ARRANGEMENT
HDM_ENC_SPECL_CRTSY	ENCOUNTER SPECIAL COURTESY
HDM_ENC_SUPL_CHRG	ENCOUNTER SUPPLY CHARGE
HDM_ENC_SVC	ENCOUNTER SERVICE
HDM_ENC_SVCPRV	ENCOUNTER SERVICE PROVIDER
HDM_ENC_SVC_CHRG	ENCOUNTER SERVICE CHARGE
HDM_ENC_SVC_RP	ENCOUNTER SERVICE RELATED PARTY
HDM_ENC_SVC_TRANS	ENCOUNTER SERVICE TRANSACTION
HDM_ENC_TRANS	ENCOUNTER TRANSACTION
HDM_ERQST	EARLY REQUEST
HDM_ERQST_AA	EARLY REQUEST ADMINISTRATIVE ANALYST
HDM_ERQST_LN	EARLY REQUEST LINE
HDM_ERQST_TRANS	EARLY REQUEST TRANSACTION
HDM_ERQST_VNDR	EARLY REQUEST VENDOR
HDM_EXPN_CR_RPT	EXPERIAN CREDIT REPORT
HDM_FAC	FACILITY
HDM_FAC_ADDR	FACILITY ADDRESS
HDM_FAC_GRP	FACILITY GROUP
HDM_FAC_GRP_FAC	FACILITY GROUP FACILITY
HDM_FAC_INSP	FACILITY INSPECTION
HDM_FAC_RP	FACILITY RELATED PARTY
HDM_FAC_SPECLTY	FACILITY SPECIALTY
HDM_FAC_STRCTR_RLSHP	FACILITY STRUCTURE RELATIONSHIP
HDM_FAC_SVCPRV	FACILITY SERVICE PROVIDER
HDM_FAM_HX	FAMILY HISTORY
HDM_FIN_STMT	FINANCIAL STATEMENT
HDM_FIXD_ASST_DEPR	FIXED ASSET DEPRECIATION
HDM_FSCL_PD	FISCAL PERIOD
HDM_GRP	GROUP
HDM_GL_ACCT	GL ACCOUNT
HDM_GOV_ORG	GOVERNMENT ORGANIZATION
HDM_GRP_PURCHG_ORG	GROUP PURCHASING ORGANIZATION
HDM_GUARDN	GUARDIAN
HDM_GUARNTR	GUARANTOR
HDM_HAZDOUS_MTRL	HAZARDOUS MATERIAL
HDM_HLTHPLN	HEALTH PLAN
HDM_HLTHPLN_DRUG_CHRG	HEALTH PLAN DRUG CHARGE
HDM_HLTHPLN_DRUG_COVRG	HEALTH PLAN DRUG COVERAGE
HDM_HLTHPLN_DRUG_FRMLRY	HEALTH PLAN DRUG FORMULARY
HDM_HLTHPLN_INTVN_CHRG	HEALTH PLAN INTERVENTION CHARGE
HDM_HLTHPLN_INTVN_COVRG	HEALTH PLAN INTERVENTION COVERAGE
HDM_HLTHPLN_LIMTN	HEALTH PLAN LIMITATION
HDM_HLTHPLN_PLCY	HEALTH PLAN POLICY
HDM_HLTHPLN_PLCY_CPAY	HEALTH PLAN POLICY COPAY
HDM_HLTHPLN_PLCY_DDUC	HEALTH PLAN POLICY DEDUCTIBLE
HDM_HLTHPLN_PLCY_LIMTN	HEALTH PLAN POLICY LIMITATION
HDM_HLTHPLN_PLCY_PREM	HEALTH PLAN POLICY PREMIUM
HDM_HLTHPLN_PLCY_RP	HEALTH PLAN POLICY RELATED PARTY
HDM_HLTHPLN_PROD_CHRG	HEALTH PLAN PRODUCT CHARGE
HDM_HLTHPLN_PROD_COVRG	HEALTH PLAN PRODUCT COVERAGE
HDM_HLTHPLN_SVCPRV_CAPTN	HEALTH PLAN SERVICE PROVIDER CAPITATION
HDM_HLTHPLN_SVC_CHRG	HEALTH PLAN SERVICE CHARGE
HDM_HLTHPLN_SVC_COVRG	HEALTH PLAN SERVICE COVERAGE
HDM_HPLNSPROVF_INTVN	HEALTH PLAN SERVICE PROVIDER FACILITY INTERVENTION
HDM_HPLNSPROVF_INTVNCHRG	HEALTH PLAN SERVICE PROVIDER FACILITY INTERVENTION CHARGE
HDM_HPLNSPROVF_INTVNSTUS	HEALTH PLAN SERVICE PROVIDER FACILITY INTERVENTION STATUS
HDM_HPLNSPROVF_PROD	HEALTH PLAN SERVICE PROVIDER FACILITY PRODUCT
HDM_HPLNSPROVF_PROD_CHRG	HEALTH PLAN SERVICE PROVIDER FACILITY PRODUCT CHARGE
HDM_HPLNSPROVF_PROD_STUS	HEALTH PLAN SERVICE PROVIDER FACILITY PRODUCT STATUS
HDM_HPLNSPROVF_SVC	HEALTH PLAN SERVICE PROVIDER FACILITY SERVICE
HDM_HPLNSPROVF_SVC_AREA	SERVICE PROVIDER HEALTH PLAN FACILITY SERVICE AREA
HDM_HPLNSPROVF_SVC_CHRG	HEALTH PLAN SERVICE PROVIDER FACILITY SERVICE CHARGE
HDM_HPLNSPROVF_SVC_STUS	HEALTH PLAN SERVICE PROVIDER FACILITY SERVICE STATUS
HDM_HPP_BENE_COVRG	HEALTH PLAN POLICY BENEFIT COVERAGE
HDM_HPP_DDUC_BAL	HEALTH PLAN POLICY DEDUCTIBLE
HDM_IMM_HX	IMMUNIZATION HISTORY
HDM_IMM_REACN	IMMUNIZATION REACTION
HDM_IND_PRTY	INDIVIDUAL PARTY
HDM_INSR	INSURER
HDM_INSR_RP	INSURER RELATED PARTY
HDM_INS_CO_RTG	INSURANCE COMPANY RATING
HDM_INTMSR	INTERVENTION MASTER
HDM_INTMSR_AA	INTERVENTION MASTER ADMINISTRATIVE ANALYST
HDM_INTMSR_RP	INTERVENTION MASTER RELATED PARTY
HDM_INTMSR_SVCPRV	INTERVENTION MASTER SERVICE PROVIDER
HDM_INTVN	INTERVENTION
HDM_INTVN_APRO_ANATSITE	INTERVENTION APPROACH ANATOMICAL SITE
HDM_INTVN_CNRN	INTERVENTION CONCERN
HDM_INTVN_CNSNT	INTERVENTION CONSENT
HDM_INTVN_EVNT	INTERVENTION EVENT
HDM_INTVN_GRP	INTERVENTION GROUP
HDM_INTVN_GRP_INTVN	INTERVENTION GROUP INTERVENTION
HDM_INTVN_METHD	INTERVENTION METHOD
HDM_INTVN_OBSV	INTERVENTION OBSERVATION
HDM_INTVN_ORD	INTERVENTION ORDER
HDM_INTVN_OUTCM	INTERVENTION OUTCOME
HDM_INTVN_RP	INTERVENTION RELATED PARTY
HDM_INTVN_RSN	INTERVENTION REASON
HDM_INTVN_SUBST	INTERVENTION SUBSTANCE
HDM_INTVN_SUPL	INTERVENTION SUPPLY
HDM_INTVN_SVCPRV	INTERVENTION SERVICE PROVIDER
HDM_INTVN_TARG_ANATSITE	INTERVENTION TARGET ANATOMICAL SITE
HDM_INTVN_TRANS	INTERVENTION TRANSACTION
HDM_INV	INVOICE
HDM_INV_AA	INVOICE ADMINISTRATIVE ANALYST
HDM_INV_LN	INVOICE LINE
HDM_INV_LN_TAX	INVOICE LINE TAX
HDM_INV_TAX	INVOICE TAX
HDM_INV_TRANS	INVOICE TRANSACTION
HDM_INVPHYCNT	INVENTORY PHYSICAL COUNT
HDM_INVPHYCNT_AA	INVENTORY PHYSICAL COUNT ADMINISTRATIVE ANALYST
HDM_INVPHYCNT_LN	INVENTORY PHYSICAL COUNT LINE
HDM_INVT_ACCTG_LN	INVENTORY ACCOUNTING LINE
HDM_INVT_BAL	INVENTORY BALANCE
HDM_INVT_SHPMNT	INVENTORY SHIPMENT
HDM_INVT_SHPMNT_AA	INVENTORY SHIPMENT ADMINISTRATIVE ANALYST
HDM_INVT_SHPMNT_LN	INVENTORY SHIPMENT LINE
HDM_INVT_SHPMNT_TRANS	INVENTORY SHIPMENT TRANSACTION
HDM_INVT_TRANS	INVENTORY TRANSACTION
HDM_ITM_CTLG	ITEM CATALOG
HDM_ITM_MSTR	ITEM MASTER
HDM_ITM_MSTR_COMOD	ITEM MASTER COMMODITY
HDM_ITM_RECL	ITEM RECALL
HDM_ITM_STORG_COND	ITEM STORAGE CONDITION
HDM_JB	JOB
HDM_JRNL	JOURNAL
HDM_JRNL_ENTRY	JOURNAL ENTRY
HDM_JRNL_LN	JOURNAL LINE
HDM_LAB_ORD	LAB ORDER
HDM_LED	LEDGER
HDM_LED_BAL	LEDGER BALANCE
HDM_LEGL_ENTY	LEGAL ENTITY
HDM_LICNG_ORG	LICENSING ORGANIZATION
HDM_LOC	LOCATION
HDM_MANUFR	MANUFACTURER
HDM_MANUFR_LOT	MANUFACTURER LOT
HDM_MBR	MEMBER
HDM_MBR_HLTHPLN_PLCY	MEMBER HEALTH PLAN POLICY
HDM_MSR_AA	MSR ADMINISTRATIVE ANALYST
HDM_MSR_LN	MSR LINE
HDM_MSR_SCH_LN	MSR SCHEDULE LINE
HDM_MSR_TRANS	MSR TRANSACTION
HDM_MTRL_STCK_RQST	MATERIAL STOCK REQUEST
HDM_NSG_ORD	NURSING ORDER
HDM_NT_TO_FIN_STMT	NOTES TO FINANCIAL STATEMENT
HDM_OBSV	OBSERVATION
HDM_OBSV_ANATSITE	OBSERVATION ANATOMICAL SITE
HDM_OBSV_GRP	OBSERVATION GROUP
HDM_OBSV_GRP_OBSV	OBSERVATION GROUP OBSERVATION
HDM_OBSV_RP	OBSERVATION RELATED PARTY
HDM_OBSV_RSN	OBSERVATION REASON
HDM_OBSV_SGN_SYMP	OBSERVATION SIGN SYMPTOM
HDM_OBSV_SUPL	OBSERVATION SUPPLY
HDM_OBSV_SVCPRV	OBSERVATION SERVICE PROVIDER
HDM_OBSV_TRANS	OBSERVATION TRANSACTION
HDM_OCUPATNL_HX	OCCUPATIONAL HISTORY
HDM_ORD	ORDER
HDM_ORD_CNRN	ORDER CONCERN
HDM_ORD_GRP	ORDER GROUP
HDM_ORD_GRP_OR_DER	ORDER GROUP ORDER
HDM_ORD_OBSV	ORDER OBSERVATION
HDM_ORD_RP	ORDER RELATED PARTY
HDM_ORD_RSN	ORDER REASON
HDM_ORD_SUPL	ORDER SUPPLY
HDM_ORD_SVCPRV	ORDER SERVICE PROVIDER
HDM_ORD_TRANS	ORDER TRANSACTION
HDM_ORG_DIVRS	ORGANIZATION DIVERSITY
HDM_ORG_INDCLSFN	ORGANIZATION INDUSTRY CLASSIFICATION
HDM_ORG_PRTY	ORGANIZATION PARTY
HDM_PAR_LOC	PAR LOCATION
HDM_PAR_RQST	PAR REQUEST
HDM_PAR_RQST_AA	PAR REQUEST ADMINISTRATIVE ANALYST
HDM_PAR_RQST_LN	PAR REQUEST LINE
HDM_PAYEE	PAYEE
HDM_PAYMT	PAYMENT
HDM_PAYMT_TRM	PAYMENT TERM
HDM_PAYR	PAYER
HDM_PAYR_CR_STUS	PAYER CREDIT STATUS
HDM_PAYR_DNB_CR_RSK	PAYER DUN BRADSTREET CREDIT RISK
HDM_PAYR_DNB_PAYMT_INX	PAYER DUN BRADSTREET PAYMENT INDEX
HDM_PAYR_DNB_STBLTY_SCR	PAYER DUN BRADSTREET STABILITY SCORE
HDM_PAYR_TRD_NM	PAYER TRADE NAME
HDM_PERFMD_CASE	PERFORMED CASE
HDM_PHARMCY	PHARMACY
HDM_PO	PURCHASE ORDER
HDM_PO_AA	PURCHASE ORDER ADMINISTRATIVE ANALYST
HDM_PO_DSTRBN_LN	PO DISTRIBUTION LINE
HDM_PO_DSTRBN_LN_TAX	PO DISTRIBUTION LINE TAX
HDM_PO_GRP	PURCHASE ORDER GROUP
HDM_PO_GRP_PURCH_ORD	PURCHASE ORDER GROUP PURCHASE ORDER
HDM_PO_LN	PO LINE
HDM_PO_LN_TAX	PO LINE TAX
HDM_PO_SCH_LN	PO SCHEDULE LINE
HDM_PO_SCH_LN_TAX	PO SCHEDULE LINE TAX
HDM_PO_TAX	PURCHASE ORDER TAX
HDM_PO_TRANS	PURCHASE ORDER TRANSACTION
HDM_POSTN	POSITION
HDM_POSTN_ATTND	POSITION ATTENDANCE
HDM_POSTN_CERTN	POSITION CERTIFICATION
HDM_POSTN_COMP	POSITION COMPENSATION
HDM_POSTN_RP	POSITION RELATED PARTY
HDM_POSTN_RPTG_RLSHP	POSITION REPORTING RELATIONSHIP
HDM_POSTN_TRN	POSITION TRAINING
HDM_PRDMSR	PRODUCT MASTER
HDM_PRDMSR_AA	PRODUCT MASTER ADMINISTRATIVE ANALYST
HDM_PRDMSR_GRP	PRODUCT MASTER GROUP
HDM_PRDMSR_GRP_PROD_MSTR	PRODUCT MASTER GROUP PRODUCT MASTER
HDM_PRDMSR_RP	PRODUCT MASTER RELATED PARTY
HDM_PRDMSR_SVCPRV	PRODUCT MASTER SERVICE PROVIDER
HDM_PROB	PROBLEM
HDM_PROC	PROCEDURE
HDM_PRDCTGVR	PRODUCT CATALOG VENDOR
HDM_PROD_CTLG	PRODUCT CATALOG
HDM_PROD_CTLG_BIZ_UNT	PRODUCT CATALOG BUSINESS UNIT
HDM_PROD_DSPNSING_UNT	PRODUCT DISPENSING UNIT
HDM_PROD_ISSUING_UNT	PRODUCT ISSUING UNIT
HDM_PROD_STCK_UNT	PRODUCT STOCK UNIT
HDM_PRTY	PARTY
HDM_PRTY_ADDR	PARTY ADDRESS
HDM_PRTY_AKA_NM	PARTY AKA NAME
HDM_PRTY_CITZ	PARTY CITIZENSHIP
HDM_PRTY_CNTCT_INFO	PARTY CONTACT INFO
HDM_PRTY_ED	PARTY EDUCATION
HDM_PRTY_EMPMT	PARTY EMPLOYMENT
HDM_PRTY_ETHN	PARTY ETHNICITY
HDM_PRTY_HIER	PARTY HIERARCHY
HDM_PRTY_HIER_VER	PARTY HIERARCHY VERSION
HDM_PRTY_HIER_VER_LVL	PARTY HIERARCHY VERSION LEVEL
HDM_PRTY_HIERVRLVL_AG	PARTY HIERARCHY VERSION LEVEL ASSIGNMENT
HDM_PRTY_HNDICP	PARTY HANDICAP
HDM_PRTY_ID	PARTY IDENTIFICATION
HDM_PRTY_LANG_USE	PARTY LANGUAGE USE
HDM_PRTY_ORGN_DONR	PARTY ORGAN DONOR
HDM_PRTY_PROXY	PARTY PROXY
HDM_PRTY_RC	PARTY RACE
HDM_PT	PATIENT
HDM_PT_CENSUS	PATIENT CENSUS
HDM_PT_ED	PATIENT EDUCATION
HDM_PT_ED_DEL_METHD	PATIENT EDUCATION DELIVERY METHOD
HDM_PT_ED_RECVR	PATIENT EDUCATION RECEIVER
HDM_PT_GRP	PATIENT GROUP
HDM_PT_GRP_PT	PATIENT GROUP PATIENT
HDM_PT_HX	PATIENT HISTORY
HDM_PT_HX_GRP	PATIENT HISTORY GROUP
HDM_PT_HX_GRP_PT_HX	PATIENT HISTORY GROUP PATIENT HISTORY
HDM_PT_HX_RP	PATIENT HISTORY RELATED PARTY
HDM_PT_HX_RSN	PATIENT HISTORY REASON
HDM_PT_HX_SVCPRV	PATIENT HISTORY SERVICE PROVIDER
HDM_PT_ID	PATIENT IDENTIFICATION
HDM_PT_MBR_CRSREF	PATIENT MEMBER CROSSREFERENCE
HDM_PT_PAYR	PATIENT PAYER
HDM_PT_RP	PATIENT RELATED PARTY
HDM_PT_SVCPRV	PATIENT SERVICE PROVIDER
HDM_PURCTRT	PURCHASING CONTRACT
HDM_PURCTRT_AA	PURCHASING CONTRACT ADMINISTRATIVE ANALYST
HDM_PURCTRT_LN	PURCHASING CONTRACT LINE
HDM_PURCTRT_LN_DSCNT	PURCHASING CONTRACT LINE DISCOUNT
HDM_PURCTRT_VNDR_SECT	PURCHASING CONTRACT VENDOR SECTION
HDM_PURSVC_CTLG	PURCHASED SERVICE CATALOG
HDM_PURSVC_MSTR	PURCHASED SERVICE MASTER
HDM_PYD_PD_CMPOS_CR_RTG	PAYER DUN BRADSTREET PERIOD COMPOSITE CREDIT RATING
HDM_PYD_PD_COMRCL_CR_SCR	PAYER DUN BRADSTREET PERIOD COMMERCIAL CREDIT SCORE
HDM_PYD_PD_CR_SCR_CLAS	PAYER DUN BRADSTREET PERIOD CREDIT SCORE CLASS
HDM_PYD_PD_PAYDX_RTG	PAYER DUN BRADSTREET PERIOD PAYDEX RATING
HDM_RCPT	RECEIPT
HDM_RCPT_AA	RECEIPT ADMINISTRATIVE ANALYST
HDM_RCPT_ACCTG_LN	RECEIPT ACCOUNTING LINE
HDM_RCPT_DSTRBN_LN	RECEIPT DISTRIBUTION LINE
HDM_RCPT_DSTRBN_LN_TAX	RECEIPT DISTRIBUTION LINE TAX
HDM_RCPT_SHPMNT_LN	RECEIPT SHIPMENT LINE
HDM_RCPT_SHPMNT_LN_TAX	RECEIPT SHIPMENT LINE TAX
HDM_RCPT_TAX	RECEIPT TAX
HDM_RCPT_TRANS	RECEIPT TRANSACTION
HDM_RECL_AUTHTY	RECALL AUTHORITY
HDM_RELTD_BIZ_UNT	RELATED BUSINESS UNIT
HDM_RELTD_CASE	RELATED CASE
HDM_RELTD_CLM	RELATED CLAIM
HDM_RELTD_CLM_PAYMT	RELATED CLAIM PAYMENT
HDM_RELTD_CNRN	RELATED CONCERN
HDM_RELTD_CNSNT	RELATED CONSENT
HDM_RELTD_ENC	RELATED ENCOUNTER
HDM_RELTD_INTMSR	RELATED INTERVENTION MASTER
HDM_RELTD_INTVN	RELATED INTERVENTION
HDM_RELTD_INVT_TRANS	RELATED INVENTORY TRANSACTION
HDM_RELTD_OBSV	RELATED OBSERVATION
HDM_RELTD_ORD	RELATED ORDER
HDM_RELTD_PRDMSR	RELATED PRODUCT MASTER
HDM_RELTD_PT_HX	RELATED PATIENT HISTORY
HDM_RELTD_SPCMN	RELATED SPECIMEN
HDM_RELTD_SVCPRV	RELATED SERVICE PROVIDER
HDM_RELTD_VNDR	RELATED VENDOR
HDM_REQ	REQUISITION
HDM_REQ_AA	REQUISITION ADMINISTRATIVE ANALYST
HDM_REQ_DSTRBN_LN	REQUISITION DISTRIBUTION LINE
HDM_REQ_DSTRBN_LN_TAX	REQUISITION DISTRIBUTION LINE TAX
HDM_REQ_LN	REQUISITION LINE
HDM_REQ_LN_TAX	REQUISITION LINE TAX
HDM_REQ_SCH_LN	REQUISITION SCHEDULE LINE
HDM_REQ_SCH_LN_TAX	REQUISITION SCHEDULE LINE TAX
HDM_REQ_TAX	REQUISITION TAX
HDM_REQ_TRANS	REQUISITION TRANSACTION
HDM_RFI	RFI
HDM_RFP	RFP
HDM_RFQ	RFQ
HDM_RP	RELATED PARTY
HDM_RTV	RETURN TO VENDOR
HDM_RTV_AA	RETURN TO VENDOR ADMINISTRATIVE ANALYST
HDM_RTV_LN	RTV LINE
HDM_RTV_LN_TAX	RTV LINE TAX
HDM_RTV_TAX	RETURN TO VENDOR TAX
HDM_SCHD_CASE	SCHEDULED CASE
HDM_SHRD_FAC	SHARED FACILITY
HDM_SPCMN	SPECIMEN
HDM_SPCMN_GRP	SPECIMEN GROUP
HDM_SPCMN_GRP_SPCMN	SPECIMEN GROUP SPECIMEN
HDM_SPCMN_RP	SPECIMEN RELATED PARTY
HDM_SPCMN_SVCPRV	SPECIMEN SERVICE PROVIDER
HDM_SPCMN_TRANS	SPECIMEN TRANSACTION
HDM_STORG_LOC	STORAGE LOCATION
HDM_SUBADMN	SUBSTANCE ADMINISTRATION
HDM_SUBADMN_ORD	SUBSTANCE ADMINISTRATION ORDER
HDM_SUBADMN_ORD_ANATSITE	SUBSTANCE ADMINISTRATION ORDER ANATOMICAL SITE
HDM_SUBADMN_ORD_SUBST	SUBSTANCE ADMINISTRATION ORDER SUBSTANCE
HDM_SUBADMN_VERF_FAILR	SUBSTANCE ADMINISTRATION VERIFICATION FAILURE
HDM_SUBST_ADVSRCTN	SUBSTANCE ADVERSE REACTION
HDM_SUBST_ANTID	SUBSTANCE ANTIDOTE
HDM_SUBST_CTLG	SUBSTANCE CATALOG
HDM_SUBST_HX	SUBSTANCE HISTORY
HDM_SUBST_MSTR	SUBSTANCE MASTER
HDM_SUBST_REACN	SUBSTANCE REACTION
HDM_SUM_OF_CLM	SUMMARY OF CLAIMS
HDM_SUM_OF_HR_AND_PAYRL	SUMMARY OF HR AND PAYROLL
HDM_SVC_LVL_PARM	SERVICE LEVEL AGREEMENT PARAMETER TYPE
HDM_SVCMSR	SERVICE MASTER
HDM_SVCMSR_AA	SERVICE MASTER ADMINISTRATIVE ANALYST
HDM_SVCMSR_RP	SERVICE MASTER RELATED PARTY
HDM_SVCMSR_SVCPRV	SERVICE MASTER SERVICE PROVIDER
HDM_SVCPRV	SERVICE PROVIDER
HDM_SVCPRV_ACRD	SERVICE PROVIDER ACCREDITATION
HDM_SVCPRV_GRP	SERVICE PROVIDER GROUP
HDM_SVCPRV_GRP_SVC_PROV	SERVICE PROVIDER GROUP SERVICE PROVIDER
HDM_SVCPRV_INS_PLCY	SERVICE PROVIDER INSURANCE POLICY
HDM_SVCPRV_LIC	SERVICE PROVIDER LICENSE
HDM_SVCPRV_RP	SERVICE PROVIDER RELATED PARTY
HDM_SVCPRV_SPECLTY	SERVICE PROVIDER SPECIALTY
HDM_SVC_PRG	SERVICE PROGRAM
HDM_SVC_PRG_EMP	SERVICE PROGRAM EMPLOYEE
HDM_THERPY_ORD	THERAPY ORDER
HDM_TMZN	TIMEZONE
HDM_TRU_CR_RPT	TRANSUNION CREDIT REPORT
HDM_TST_REF_RNG	TEST REFERENCE RANGE
HDM_VCHR	VOUCHER
HDM_VCHR_AA	VOUCHER ADMINISTRATIVE ANALYST
HDM_VCHR_ACCTG_LN	VOUCHER ACCOUNTING LINE
HDM_VCHR_DSTRBN_LN	VOUCHER DISTRIBUTION LINE
HDM_VCHR_DSTRBN_LN_TAX	VOUCHER DISTRIBUTION LINE TAX
HDM_VCHR_GRP	VOUCHER GROUP
HDM_VCHR_GRP_VCHR	VOUCHER GROUP VOUCHER
HDM_VCHR_LN	VOUCHER LINE
HDM_VCHR_LN_TAX	VOUCHER LINE TAX
HDM_VCHR_PAYMT	VOUCHER PAYMENT
HDM_VCHR_TAX	VOUCHER TAX
HDM_VCHR_TRANS	VOUCHER TRANSACTION
HDM_VNDR	VENDOR
HDM_VNDR_PURCHG_UNT	VENDOR PURCHASING UNIT
HDM_WLFR_PLN	WELFARE PLAN
HDM_WRHS	WAREHOUSE

Reference Tables

Table 4-3 describes the Reference tables in Oracle Healthcare Data Model.

Table 4-3 Reference Tables

Table Name	Description
DWR_AGEBND	AGE BAND
DWR_AGEBND_RNG	AGE BAND RANGE
DWR_BASE_DAY	BASE DAY
DWR_CLNDR_HLF_YR	CALENDAR HALF YEAR
DWR_CLNDR_MTH	CALENDAR MONTH
DWR_CLNDR_QTR	CALENDAR QUARTER
DWR_CLNDR_WK	CALENDAR WEEK
DWR_CLNDR_YR	CALENDAR YEAR
DWR_DAY	TIME DAY SNOWFLAKE
DWR_FAC	FACILITY DIMENSION
DWR_KPI	KPI DIMENSION TABLE
DWR_ORG	ORGANIZATION DIMENSION
DWR_PT	PATIENT DIMENSION
DWR_SHFT	SHIFT DIMENSION
DWR_SVCPRVPRCT	SERVICE PROVIDER PRACTICE SNOWFLAKE
DWR_TOD	TIME OF DAY
DWR_WKDAY	WEEKDAY

Derived Tables

Table 4-4 describes the derived tables in Oracle Healthcare Data Model.

Table 4-4 Derived Tables

Table Name	Description
DWD_ENC	ENCOUNTER DIMENSION
DWD_ENC_CASE	ENCOUNTER CASE DERIVED
DWD_ENC_CNRN	ENCOUNTER CONCERN DERIVED
DWD_ENC_INTVN	ENCOUNTER INTERVENTION DERIVED
DWD_ENC_OBSV	ENCOUNTER OBSERVATION DERIVED
DWD_ENC_ORD	ENCOUNTER ORDER DERIVED
DWD_KPI_CASE_FCT	KPI CASE FACT
DWD_KPI_ENC_FCT	KPI ENCOUNTER FACT
DWD_KPI_OBSV_FCT	KPI OBSERVATION FACT

DWX Cross Reference Tables

Table 4-5 describes the Cross Reference tables/MVs in Oracle Healthcare Data Model.

Table 4-5 DWX Cross Reference tables

Table Name	Description
DWX_CODE_REP_XREF	CODE REPOSITORY XREF
DWX_FAC_SHFT_XREF	FACILITY SHIFT XREF

Compressed Tables

Table 4-6 shows the compressed DWD , DWR, and DWX tables for the Oracle Healthcare Data Model (tables with the Compress clause).

Table 4-7 lists the Compressed Tables in the HDM Oracle Healthcare Data Model tables (tables with the Compress clause). Oracle Healthcare Data Model uses Database Compression on these tables to save space and load times.

Table 4-6 Compressed DWD, DWR, and DWX Tables

Compressed Table Name
DWD_ENC
DWD_ENC_CASE
DWD_ENC_CNRN
DWD_ENC_INTVN
DWD_ENC_OBSV
DWD_ENC_ORD
DWD_KPI_CASE_FCT
DWD_KPI_ENC_FCT
DWD_KPI_OBSV_FCT
DWX_CODE_REP_XREF
DWR_PT

Table 4-7 Compressed HDM Tables

Compressed Table Name
HDM_ADT_ORD
HDM_ADT_ORD_SPECLARNGMNT
HDM_APPL
HDM_APPL_RP
HDM_APPL_STUS
HDM_CASE
HDM_CASE_CNRN
HDM_CASE_CNSNT
HDM_CASE_EVNT
HDM_CASE_OBSV
HDM_CASE_PST_CARE
HDM_CASE_RP
HDM_CASE_RSN
HDM_CASE_SUPL
HDM_CASE_SVCPRV
HDM_CASE_TRANS
HDM_CLM
HDM_CLM_ADJMT
HDM_CLM_CHRG
HDM_CLM_CHRG_DNYD_RSN
HDM_CLM_CHRG_REDCD_RSN
HDM_CLM_DLY_RSN
HDM_CLM_PAYG_PRTY
HDM_CLM_PAYMT
HDM_CLM_PAYMT_RP
HDM_CLM_PAYPRTY_BAL
HDM_CLM_REJ_RSN
HDM_CLM_RP
HDM_CLM_STUS
HDM_CLM_SUBROG_PAYMT
HDM_CLMD_DRUG
HDM_CLMD_INTVN
HDM_CLMD_SUPL
HDM_CLMD_SVC
HDM_CNRN
HDM_CNRN_CSE
HDM_CNRN_OBSV
HDM_CNRN_RP
HDM_CNRN_SVCPRV
HDM_CNRN_TRANS
HDM_DIET_ORD
HDM_DIET_ORD_CNSMP_METHD
HDM_DSCLSR
HDM_ENC
HDM_ENC_CNRN
HDM_ENC_DRUG_CHRG
HDM_ENC_FAC
HDM_ENC_FAC_CHRG
HDM_ENC_HLTHPLN_PLCY
HDM_ENC_INTVN
HDM_ENC_INTVN_CHRG
HDM_ENC_OBSV
HDM_ENC_ORD
HDM_ENC_RP
HDM_ENC_RSN
HDM_ENC_SPECLARNGMNT
HDM_ENC_SUPL_CHRG
HDM_ENC_SVC
HDM_ENC_SVC_CHRG
HDM_ENC_SVC_TRANS
HDM_ENC_SVCPRV
HDM_ENC_TRANS
HDM_HLTHPLN_PLCY_PREM
HDM_IMM_HX
HDM_IND_PRTY
HDM_INTVN
HDM_INTVN_CNRN
HDM_INTVN_CNSNT
HDM_INTVN_EVNT
HDM_INTVN_METHD
HDM_INTVN_OBSV
HDM_INTVN_OUTCM
HDM_INTVN_RP
HDM_INTVN_RSN
HDM_INTVN_SUBST
HDM_INTVN_SUPL
HDM_INTVN_SVCPRV
HDM_INTVN_TARG_ANATSITE
HDM_INTVN_TRANS
HDM_LAB_ORD
HDM_MBR
HDM_NSG_ORD
HDM_OBSV
HDM_OBSV_ANATSITE
HDM_OBSV_RP
HDM_OBSV_RSN
HDM_OBSV_SGN_SYMP
HDM_OBSV_SUPL
HDM_OBSV_SVCPRV
HDM_OBSV_TRANS
HDM_OCUPATNL_HX
HDM_ORD
HDM_ORD_CNRN
HDM_ORD_DOC
HDM_ORD_OBSV
HDM_ORD_RP
HDM_ORD_RSN
HDM_ORD_SUPL
HDM_ORD_SVCPRV
HDM_ORD_TRANS
HDM_PERFMD_CASE
HDM_PROB
HDM_PROC
HDM_PRTY
HDM_PT
HDM_PT_ED_DEL_METHD
HDM_PT_ED_RECVR
HDM_PT_HX
HDM_PT_MBR_CRSREF
HDM_RELTD_ORD
HDM_SCHD_CASE
HDM_SUBADMN
HDM_SUBADMN_ORD
HDM_SUBADMN_ORD_ANATSITE
HDM_SUBADMN_ORD_SUBST
HDM_SUBADMN_VERF_FAILR
HDM_SUBST_HX
HDM_SUBST_REACN
HDM_THERPY_ORD

Partition Definitions

Chapter 6, "Oracle Healthcare Data Model Partitions and Indexes" shows the partition definitions. Table 6-1 and Table 6-2 list the Partition Tables, Partition Column, and Partition Type for Partition definitions in Oracle Healthcare Data Model.

Index Definitions

Chapter 6, "Oracle Healthcare Data Model Partitions and Indexes" shows the indexed DWC, DWD, DWR, and DWX tables. Table 6-3 lists the indexes, including Table Name, Fk Index Name, and Column in Oracle Healthcare Data Model.

Parallel Definitions

Table 4-8 lists the Parallel DWC, DWD , DWR, and DWX tables for the Oracle Healthcare Data Model (tables with the Parallel clause).

Table 4-9 lists the Parallel Tables in the HDM tables in Oracle Healthcare Data Model (tables with the Parallel clause).

Table 4-8 Parallel DWC, DWD, and DWX Tables

Table Name
DWC_ETL_HDM_DMN_CD_SYS
DWD_ENC
DWD_ENC_CASE
DWD_ENC_CNRN
DWD_ENC_INTVN
DWD_ENC_OBSV
DWD_ENC_ORD
DWD_KPI_CASE_FCT
DWD_KPI_ENC_FCT
DWD_KPI_OBSV_FCT
DWR_AGEBND
DWR_AGEBND_RNG
DWR_FAC
DWR_KPI
DWR_ORG
DWR_PT
DWR_SHFT
DWR_SVCPRVPRCT
DWX_CODE_REP_XREF
DWX_FAC_SHFT_XREF

Table 4-9 Parallel HDM Tables

Table Name
HDM_AA
HDM_ACC_ENT
HDM_ACRD_ORG
HDM_ADT_ORD
HDM_ADT_ORD_SPECL_CRTSY
HDM_ADT_ORD_SPECLARNGMNT
HDM_ADVDR
HDM_ADVDR_SVCPRV
HDM_ALGY_HX
HDM_ALGY_REACN
HDM_ALRT
HDM_ALRT_DRUG
HDM_ALRT_INTMSR
HDM_ALRT_INTVN
HDM_ALRT_PRDMSR
HDM_ALRT_PROD
HDM_APPL
HDM_APPL_RP
HDM_APPL_STUS
HDM_ASSOC_PROD
HDM_ASST
HDM_ASST_ACCTG_RTRETRN
HDM_ASST_AMORT
HDM_ASST_APPR_ADJMT
HDM_ASST_ASSMT
HDM_ASST_COND
HDM_ASST_DISCD_PAYBK_PD
HDM_ASST_LOC
HDM_ASST_LOC_RP
HDM_ASST_LOC_STUS
HDM_ASST_NET_PRSNT_VAL
HDM_ASST_PAYBK_PD
HDM_ASST_RPLCMT_CST
HDM_ASST_SALV_VAL
HDM_BED
HDM_BENE_PLN
HDM_BENE_PROV
HDM_BILG_ACCT
HDM_BIZ_MTRC
HDM_BIZ_UNT
HDM_CARE_SITE
HDM_CARE_SITE_BLCK
HDM_CARE_SITE_BLCK_RELSE
HDM_CARE_SITE_BLCK_SEGMT
HDM_CARE_SITE_TM_SEGMT
HDM_CARE_SITE_TM_UTILZTN
HDM_CARE_SITE_TO
HDM_CAREGV
HDM_CASE
HDM_CASE_CNRN
HDM_CASE_CNSNT
HDM_CASE_EVNT
HDM_CASE_FAC
HDM_CASE_GRP
HDM_CASE_GRP_CASE
HDM_CASE_OBSV
HDM_CASE_PLND_PROC
HDM_CASE_PST_CARE
HDM_CASE_RP
HDM_CASE_RSN
HDM_CASE_SUPL
HDM_CASE_SVCPRV
HDM_CASE_TRANS
HDM_CD_REPOSITORY
HDM_CD_REPOSITORY_CD_SET
HDM_CD_REPOSITORY_CD_TYP
HDM_CD_SET
HDM_CD_SYS
HDM_CD_TYP
HDM_CERTN_ORG
HDM_CHRT_OF_ACCT
HDM_CHRTFLD_COMB
HDM_CIT
HDM_CLM
HDM_CLM_ADJMT
HDM_CLM_CHRG
HDM_CLM_CHRG_DNYD_RSN
HDM_CLM_CHRG_REDCD_RSN
HDM_CLM_DLY_RSN
HDM_CLM_PAYG_PRTY
HDM_CLM_PAYMT
HDM_CLM_PAYMT_RP
HDM_CLM_PAYPRTY_BAL
HDM_CLM_REJ_RSN
HDM_CLM_RELTD_FNDED_PRG
HDM_CLM_RP
HDM_CLM_SPECL_PRG_CD
HDM_CLM_STUS
HDM_CLM_SUBROG_PAYMT
HDM_CLMD_DRUG
HDM_CLMD_INTVN
HDM_CLMD_SUPL
HDM_CLMD_SVC
HDM_CNIT
HDM_CNIT_RESTRCTN
HDM_CNRN
HDM_CNRN_ANATSITE
HDM_CNRN_CSE
HDM_CNRN_GRP
HDM_CNRN_GRP_CNRN
HDM_CNRN_OBSV
HDM_CNRN_RP
HDM_CNRN_SVCPRV
HDM_CNRN_TRANS
HDM_CNSNT
HDM_CNSNT_AUTHZ_INTVN
HDM_CNSNT_GRP
HDM_CNSNT_GRP_CNSNT
HDM_CNSNT_RP
HDM_CNSNT_SVCPRV
HDM_CNSNT_TRANS
HDM_CNSOLD_BAL_SHT
HDM_CNSOLD_CSH_FLOW_STMT
HDM_CNSOLD_STMT_OF_INCM
HDM_CNSOLD_STMT_OF_NWRTH
HDM_CNTCT
HDM_CNTRCT
HDM_CNTRCT_GRP_HLTHPLN
HDM_CNTRCT_PAYR
HDM_CNTRCT_RP
HDM_CNTRCT_SECT
HDM_CNTRCT_SECT_CLS
HDM_CNTRCT_SLA_PARM
HDM_CONTN
HDM_COUN
HDM_CRST_BLCK_UTILZTN
HDM_CRST_OPN_TM_SEGMT
HDM_CRST_OPN_TM_UTILZTN
HDM_CST_CNTR
HDM_CURR
HDM_CURR_CONV
HDM_DAT_SRC
HDM_DEP
HDM_DEP_WLFR_PLN
HDM_DIET_ORD
HDM_DIET_ORD_CNSMP_METHD
HDM_DLVR_TO_LOC
HDM_DNB_FIN_RTG
HDM_DNB_PAYMT_INX
HDM_DRUG
HDM_DRUG_ADVS_REACN
HDM_DRUG_ANTID
HDM_DRUG_HIER_GRP_DRUG
HDM_DRUG_HIER_RLSHP
HDM_DRUG_INGRD
HDM_DRUG_RESTRCTN
HDM_DSCLSR
HDM_EFX_CR_RPT
HDM_EMP
HDM_EMP_BENE_PLN
HDM_EMP_BENE_PLN_STMT
HDM_EMP_CERTN
HDM_EMP_CRED
HDM_EMP_EMPMT_STUS
HDM_EMP_HR_EVNT
HDM_EMP_POSTN
HDM_EMP_PRIV
HDM_EMP_RP
HDM_EMP_TRN
HDM_EMP_WLFR_PLN
HDM_EMPR
HDM_ENC
HDM_ENC_CNRN
HDM_ENC_CNSNT
HDM_ENC_DRUG_CHRG
HDM_ENC_FAC
HDM_ENC_FAC_CHRG
HDM_ENC_GRP
HDM_ENC_GRP_ENC
HDM_ENC_HLTHPLN_PLCY
HDM_ENC_INTVN
HDM_ENC_INTVN_CHRG
HDM_ENC_OBSV
HDM_ENC_ORD
HDM_ENC_RP
HDM_ENC_RSN
HDM_ENC_SPECL_CRTSY
HDM_ENC_SPECLARNGMNT
HDM_ENC_SUPL_CHRG
HDM_ENC_SVC
HDM_ENC_SVC_CHRG
HDM_ENC_SVC_RP
HDM_ENC_SVC_TRANS
HDM_ENC_SVCPRV
HDM_ENC_TRANS
HDM_ERQST
HDM_ERQST_AA
HDM_ERQST_LN
HDM_ERQST_TRANS
HDM_ERQST_VNDR
HDM_EXPN_CR_RPT
HDM_FAC
HDM_FAC_ADDR
HDM_FAC_GRP
HDM_FAC_GRP_FAC
HDM_FAC_INSP
HDM_FAC_RP
HDM_FAC_SPECLTY
HDM_FAC_STRCTR_RLSHP
HDM_FAC_SVCPRV
HDM_FAM_HX
HDM_FIN_STMT
HDM_FIXD_ASST_DEPR
HDM_FSCL_PD
HDM_GL_ACCT
HDM_GOV_ORG
HDM_GRP
HDM_GRP_PURCHG_ORG
HDM_GUARDN
HDM_GUARNTR
HDM_HAZDOUS_MTRL
HDM_HLTHPLN
HDM_HLTHPLN_DRUG_CHRG
HDM_HLTHPLN_DRUG_COVRG
HDM_HLTHPLN_DRUG_FRMLRY
HDM_HLTHPLN_INTVN_CHRG
HDM_HLTHPLN_INTVN_COVRG
HDM_HLTHPLN_LIMTN
HDM_HLTHPLN_PLCY
HDM_HLTHPLN_PLCY_CPAY
HDM_HLTHPLN_PLCY_DDUC
HDM_HLTHPLN_PLCY_LIMTN
HDM_HLTHPLN_PLCY_PREM
HDM_HLTHPLN_PLCY_RP
HDM_HLTHPLN_PROD_CHRG
HDM_HLTHPLN_PROD_COVRG
HDM_HLTHPLN_SVC_CHRG
HDM_HLTHPLN_SVC_COVRG
HDM_HLTHPLN_SVCPRV_CAPTN
HDM_HPLNSPROVF_DRUG
HDM_HPLNSPROVF_DRUG_CHRG
HDM_HPLNSPROVF_DRUG_STUS
HDM_HPLNSPROVF_INTVN
HDM_HPLNSPROVF_INTVNCHRG
HDM_HPLNSPROVF_INTVNSTUS
HDM_HPLNSPROVF_PROD
HDM_HPLNSPROVF_PROD_CHRG
HDM_HPLNSPROVF_PROD_STUS
HDM_HPLNSPROVF_SVC
HDM_HPLNSPROVF_SVC_AREA
HDM_HPLNSPROVF_SVC_CHRG
HDM_HPLNSPROVF_SVC_STUS
HDM_HPP_BENE_COVRG
HDM_HPP_DDUC_BAL
HDM_IMM_HX
HDM_IMM_REACN
HDM_IND_PRTY
HDM_INGRD
HDM_INS_CO_RTG
HDM_INSR
HDM_INSR_RP
HDM_INTMSR
HDM_INTMSR_AA
HDM_INTMSR_RP
HDM_INTMSR_SVCPRV
HDM_INTVN
HDM_INTVN_APRO_ANATSITE
HDM_INTVN_CATLG
HDM_INTVN_CNRN
HDM_INTVN_CNSNT
HDM_INTVN_EVNT
HDM_INTVN_GRP
HDM_INTVN_GRP_INTVN
HDM_INTVN_METHD
HDM_INTVN_OBSV
HDM_INTVN_ORD
HDM_INTVN_OUTCM
HDM_INTVN_RP
HDM_INTVN_RSN
HDM_INTVN_SUBST
HDM_INTVN_SUPL
HDM_INTVN_SVCPRV
HDM_INTVN_TARG_ANATSITE
HDM_INTVN_TRANS
HDM_INV
HDM_INV_AA
HDM_INV_LN
HDM_INV_LN_TAX
HDM_INV_TAX
HDM_INV_TRANS
HDM_INVPHYCNT
HDM_INVPHYCNT_AA
HDM_INVPHYCNT_LN
HDM_INVT_ACCTG_LN
HDM_INVT_BAL
HDM_INVT_SHPMNT
HDM_INVT_SHPMNT_AA
HDM_INVT_SHPMNT_LN
HDM_INVT_SHPMNT_TRANS
HDM_INVT_TRANS
HDM_ITM
HDM_ITM_CTLG
HDM_ITM_MSTR
HDM_ITM_MSTR_COMOD
HDM_ITM_RECL
HDM_ITM_STORG_COND
HDM_JB
HDM_JRNL
HDM_JRNL_BATC
HDM_JRNL_ENTRY
HDM_JRNL_ENTRY_LN_ITM
HDM_JRNL_LN
HDM_LAB_ORD
HDM_LED
HDM_LED_ACBAL
HDM_LED_ACCT
HDM_LED_BAL
HDM_LEGL_ENTY
HDM_LICNG_ORG
HDM_LOC
HDM_LOC_V1
HDM_MANUFR
HDM_MANUFR_LOT
HDM_MANUFR_LOT_WRHS_ITM
HDM_MBR
HDM_MBR_HLTHPLN_PLCY
HDM_MSR_AA
HDM_MSR_LN
HDM_MSR_SCH_LN
HDM_MSR_TRANS
HDM_MTRL_STCK_RQST
HDM_NETWRK
HDM_NETWRK_SVCPRV
HDM_NETWRK_SVCPRV_FAC
HDM_NSG_ORD
HDM_NT_TO_FIN_STMT
HDM_OBSV
HDM_OBSV_ANATSITE
HDM_OBSV_GRP
HDM_OBSV_GRP_OBSV
HDM_OBSV_RP
HDM_OBSV_RSN
HDM_OBSV_SGN_SYMP
HDM_OBSV_SUPL
HDM_OBSV_SVCPRV
HDM_OBSV_TRANS
HDM_OCUPATNL_HX
HDM_ORD
HDM_ORD_CNRN
HDM_ORD_DOC
HDM_ORD_GRP
HDM_ORD_GRP_OR_DER
HDM_ORD_OBSV
HDM_ORD_RP
HDM_ORD_RSN
HDM_ORD_SUPL
HDM_ORD_SVCPRV
HDM_ORD_TRANS
HDM_ORG
HDM_ORG_DIVRS
HDM_ORG_INDCLSFN
HDM_ORG_PRTY
HDM_ORG_RLSHP
HDM_PAR_LOC
HDM_PAR_RQST
HDM_PAR_RQST_AA
HDM_PAR_RQST_LN
HDM_PAYEE
HDM_PAYMT
HDM_PAYMT_TRM
HDM_PAYR
HDM_PAYR_CR_STUS
HDM_PAYR_DNB_CR_RSK
HDM_PAYR_DNB_PAYMT_INX
HDM_PAYR_DNB_STBLTY_SCR
HDM_PAYR_TRD_NM
HDM_PERFMD_CASE
HDM_PHARMCY
HDM_PO
HDM_PO_AA
HDM_PO_CHNG_ORD
HDM_PO_DSTRBN_LN
HDM_PO_DSTRBN_LN_TAX
HDM_PO_GRP
HDM_PO_GRP_PURCH_ORD
HDM_PO_LN
HDM_PO_LN_TAX
HDM_PO_SCH_LN
HDM_PO_SCH_LN_TAX
HDM_PO_TAX
HDM_PO_TRANS
HDM_POSTN
HDM_POSTN_ATTND
HDM_POSTN_CERTN
HDM_POSTN_COMP
HDM_POSTN_RP
HDM_POSTN_RPTG_RLSHP
HDM_POSTN_TRN
HDM_PRDCTGVR
HDM_PRDMSR
HDM_PRDMSR_AA
HDM_PRDMSR_GRP
HDM_PRDMSR_GRP_PROD_MSTR
HDM_PRDMSR_RP
HDM_PRDMSR_SVCPRV
HDM_PRG_PROD
HDM_PROB
HDM_PROC
HDM_PROD
HDM_PROD_CTLG
HDM_PROD_CTLG_BIZ_UNT
HDM_PROD_DSPNSING_UNT
HDM_PROD_ISSUING_UNT
HDM_PROD_RECL
HDM_PROD_RECL_LOT
HDM_PROD_RESTRCTN
HDM_PROD_STCK_UNT
HDM_PROD_STORG_COND
HDM_PRTY
HDM_PRTY_ADDR
HDM_PRTY_AKA_NM
HDM_PRTY_CITZ
HDM_PRTY_CNTCT_INFO
HDM_PRTY_ED
HDM_PRTY_EMPMT
HDM_PRTY_ETHN
HDM_PRTY_HIER
HDM_PRTY_HIER_VER
HDM_PRTY_HIER_VER_LVL
HDM_PRTY_HIERVRLVL_AG
HDM_PRTY_HNDICP
HDM_PRTY_ID
HDM_PRTY_LANG_USE
HDM_PRTY_ORGN_DONR
HDM_PRTY_PROXY
HDM_PRTY_RC
HDM_PT
HDM_PT_CENSUS
HDM_PT_ED
HDM_PT_ED_DEL_METHD
HDM_PT_ED_RECVR
HDM_PT_GRP
HDM_PT_GRP_PT
HDM_PT_HX
HDM_PT_HX_GRP
HDM_PT_HX_GRP_PT_HX
HDM_PT_HX_RP
HDM_PT_HX_RSN
HDM_PT_HX_SVCPRV
HDM_PT_ID
HDM_PT_MBR_CRSREF
HDM_PT_PAYR
HDM_PT_RP
HDM_PT_SVCPRV
HDM_PURCH_ORD
HDM_PURCHG_DOC
HDM_PURCTRT
HDM_PURCTRT_AA
HDM_PURCTRT_LN
HDM_PURCTRT_LN_DSCNT
HDM_PURCTRT_VNDR_SECT
HDM_PURSVC_CTLG
HDM_PURSVC_MSTR
HDM_PYD_PD_CMPOS_CR_RTG
HDM_PYD_PD_COMRCL_CR_SCR
HDM_PYD_PD_CR_SCR_CLAS
HDM_PYD_PD_PAYDX_RTG
HDM_RCPT
HDM_RCPT_AA
HDM_RCPT_ACCTG_LN
HDM_RCPT_DSTRBN_LN
HDM_RCPT_DSTRBN_LN_TAX
HDM_RCPT_SHPMNT_LN
HDM_RCPT_SHPMNT_LN_TAX
HDM_RCPT_TAX
HDM_RCPT_TRANS
HDM_RECL_AUTHTY
HDM_RELTD_ACBAL
HDM_RELTD_ACCT
HDM_RELTD_BIZ_UNT
HDM_RELTD_CASE
HDM_RELTD_CLM
HDM_RELTD_CLM_PAYMT
HDM_RELTD_CNRN
HDM_RELTD_CNSNT
HDM_RELTD_ENC
HDM_RELTD_INTMSR
HDM_RELTD_INTVN
HDM_RELTD_INVT_TRANS
HDM_RELTD_LED
HDM_RELTD_LEGL_ENTY
HDM_RELTD_OBSV
HDM_RELTD_ORD
HDM_RELTD_PRDMSR
HDM_RELTD_PT_HX
HDM_RELTD_SPCMN
HDM_RELTD_SVCPRV
HDM_RELTD_VNDR
HDM_REQ
HDM_REQ_AA
HDM_REQ_DSTRBN_LN
HDM_REQ_DSTRBN_LN_TAX
HDM_REQ_LN
HDM_REQ_LN_TAX
HDM_REQ_SCH_LN
HDM_REQ_SCH_LN_TAX
HDM_REQ_TAX
HDM_REQ_TRANS
HDM_RESTRCTN
HDM_RFI
HDM_RFP
HDM_RFQ
HDM_RP
HDM_RQST_FOR_INFO
HDM_RQST_FOR_PROPSL
HDM_RQST_FOR_QUOTN
HDM_RTV
HDM_RTV_AA
HDM_RTV_LN
HDM_RTV_LN_TAX
HDM_RTV_TAX
HDM_SCHD_CASE
HDM_SERZD_INV
HDM_SHRD_FAC
HDM_SPCMN
HDM_SPCMN_GRP
HDM_SPCMN_GRP_SPCMN
HDM_SPCMN_RP
HDM_SPCMN_SVCPRV
HDM_SPCMN_TRANS
HDM_ST
HDM_STORG_LOC
HDM_SUBADMN
HDM_SUBADMN_ORD
HDM_SUBADMN_ORD_ANATSITE
HDM_SUBADMN_ORD_SUBST
HDM_SUBADMN_VERF_FAILR
HDM_SUBST_ADVSRCTN
HDM_SUBST_ANTID
HDM_SUBST_CTLG
HDM_SUBST_HX
HDM_SUBST_MSTR
HDM_SUBST_REACN
HDM_SUM_OF_CLM
HDM_SUM_OF_HR_AND_PAYRL
HDM_SVC
HDM_SVC_LVL_PARM
HDM_SVC_PRG
HDM_SVC_PRG_EMP
HDM_SVCMSR
HDM_SVCMSR_AA
HDM_SVCMSR_RP
HDM_SVCMSR_SVCPRV
HDM_SVCPRV
HDM_SVCPRV_ACRD
HDM_SVCPRV_DRUG_RP
HDM_SVCPRV_GRP
HDM_SVCPRV_GRP_SVCPRV
HDM_SVCPRV_INS_PLCY
HDM_SVCPRV_INTVN_CATLG_RP
HDM_SVCPRV_LIC
HDM_SVCPRV_PROD_RP
HDM_SVCPRV_RP
HDM_SVCPRV_SPECLTY
HDM_SVCPRV_SVC_RP
HDM_THERPY_ORD
HDM_TMZN
HDM_TRANS
HDM_TRU_CR_RPT
HDM_TST_PNL_TST_TYP
HDM_TST_REF_RNG
HDM_UNSERZD_INV
HDM_USE_RS
HDM_VCHR
HDM_VCHR_AA
HDM_VCHR_ACCTG_LN
HDM_VCHR_DSTRBN_LN
HDM_VCHR_DSTRBN_LN_TAX
HDM_VCHR_GRP
HDM_VCHR_GRP_VCHR
HDM_VCHR_LN
HDM_VCHR_LN_TAX
HDM_VCHR_PAYMT
HDM_VCHR_TAX
HDM_VCHR_TRANS
HDM_VNDR
HDM_VNDR_PURCHG_UNT
HDM_WLFR_PLN
HDM_WRHS
HDM_WRHS_ACTV_INV
HDM_WRHS_ITM
HDM_WRHS_ITM_AGNG
HDM_WRHS_ITM_ALLOC_STCK
HDM_WRHS_ITM_ANTIC_STCK
HDM_WRHS_ITM_AVAIL_STCK
HDM_WRHS_ITM_AVTPRMIS
HDM_WRHS_ITM_BAL
HDM_WRHS_ITM_ECON_STCK
HDM_WRHS_ITM_EFF_STCK
HDM_WRHS_ITM_INV_LS
HDM_WRHS_ITM_INV_TRNS
HDM_WRHS_ITM_OBSOL_INV
HDM_WRHS_ITM_OBSOL_STCK
HDM_WRHS_ITM_SAFTY_STCK

OLAP ETL Views

Table 4-10 shows the OLAP ETL views in ohdm_sys schema. The OLAP ETL Views are source relational views defined in the database and used to load the OLAP Analytic Workspace for Oracle Healthcare Data Model.

Table 4-10 OLAP ETL Views in ohdm_sys Schema

OLAP ETL View Name	Target OLAP Object Name	Target OLAP Object Type	More Information
DWV_AGEBND_DIM	AGEBND	Dimension	Age Band Dimension: AGEBND
DWV_CASE_DIM	CASE	Dimension	Case Dimension: CASE
DWV_FAC_DIM	FAC	Dimension	Facility Dimension: FAC
DWV_KPI_CASE_FCT	CASE_KPI	Cube	Case KPI Cube
DWV_KPI_ENC_FCT	ENC_KPI PT_KPI	Cube	Encounter KPI Cube: ENC_KPI Patient KPI Cube: PT_KPI
DWV_KPI_OBSV_FCT	OBSV_KPI	Cube	Observation KPI Cube: OBSV_KPI
DWV_ORG_DIM	ORG	Dimension	Organization Dimension: ORG
DWV_PT_DIM	PT	Dimension	Patient Dimension: PT
DWV_SHFT_DIM	SHFT	Dimension	Shift Dimension: SHFT
DWV_SPP_DIM	SPP	Dimension	Service Provider Practice Dimension: SPP
DWV_TIME_ENC_DIM	TIME	Dimension	Time Dimension: TIME
DWV_TOD_DIM	TOD	Dimension	Time of Day Dimension: TOD

OLAP SQL Views

The OLAP SQL Views are target relational views defined in the database, these are based on the OLAP Analytic Workspace objects Dimensions/Cubes and are used by the reports. Each dimension, for example KPI, has a dimension hierarchy specific view (KPI_HKPI_VIEW) in addition to a generic dimension view (KPI_VIEW).

Each cube (PT_KPI) has a cube view (PT_KPI_VIEW). Cube ENC_KPI has the regular Cube View (ENC_KPI_VIEW). In addition, another database view (ENC_KPI_VIEW_MERGED) is defined based on the ENC_KPI Cube for additional reporting functionality.

Table 4-11 shows the OLAP SQL views present in ohdm_sys schema.

Table 4-11 OLAP SQL Views in ohdm_sys Schema

Cube View Name	OLAP Object Nam	OLAP Object Type	More Information
AGEBND_HAGEBND_VIEW	AGEBND_HAGEBND	Hierarchy	Age Band Dimension: AGEBND
AGEBND_VIEW	AGEBND	Dimension	Age Band Dimension: AGEBND
CASE_HCASE_VIEW	CASE_HCASE	Hierarchy	Case Dimension: CASE
CASE_KPI_VIEW	CASE_KPI	Cube	KPI Dimension: KPI
CASE_VIEW	CASE	Dimension	Case Dimension: CASE
ENC_KPI_VIEW	ENC_KPI	Cube	Encounter KPI Cube: ENC_KPI
ENC_KPI_VIEW_MERGED	ENC_KPI	Cube	Encounter KPI Cube: ENC_KPI
FAC_HFAC_VIEW	FAC_HFAC	Hierarchy	Facility Dimension: FAC
FAC_VIEW	FAC	Dimension	Facility Dimension: FAC
KPI_HKPI_VIEW	KPI_HKPI	Hierarchy	KPI Dimension: KPI
KPI_VIEW	KPI	Dimension	KPI Dimension: KPI
OBSV_HOBSV_VIEW	OBSV_HOBSV	Hierarchy	Observation Dimension: OBSV
OBSV_KPI_VIEW	OBSV_KPI	Cube	Observation KPI Cube: OBSV_KPI
OBSV_VIEW	OBSV	Dimension	Observation Dimension: OBSV
ORG_HORG_VIEW	ORG_HORG	Hierarchy	Organization Dimension: ORG
ORG_VIEW	ORG	Dimension	Organization Dimension: ORG
PT_HPT_VIEW	PT_HPT	Hierarchy	Patient Dimension: PT
PT_KPI_VIEW	PT_KPI	Cube	Patient KPI Cube: PT_KPI
PT_VIEW	PT	Dimension	Patient Dimension: PT
SHFT_HSHFT_VIEW	SHFT_HSHFT	Hierarchy	Shift Dimension: SHFT
SHFT_VIEW	SHFT	Dimension	Shift Dimension: SHFT
SPP_HSPP_VIEW	SPP_HSPP	Hierarchy	Service Provider Practice Dimension: SPP
SPP_VIEW	SPP	Dimension	Service Provider Practice Dimension: SPP
TIME_HTCLNDR_VIEW	TIME_HTCLNDR	Hierarchy	Time Dimension: TIME
TIEM_VIEW	TIME	Dimension	Time Dimension: TIME
TOD_HTOD_VIEW	TOD_HTOD	Hierarchy	Time of Day Dimension: TOD
TOD_VIEW	TOD	Dimension	Time of Day Dimension: TOD