5 Oracle Healthcare Data Model Logical to Physical Mapping

This chapter provides a table listing the Oracle Healthcare Data Model entities in the logical data model, and the physical database tables or views to which the logical entities have been implemented into physical tables.

This chapter includes the following section:

• Logical to Physical Mappings for Oracle Healthcare Data Model

Logical to Physical Mappings for Oracle Healthcare Data Model

Table 5-1 lists the Oracle Healthcare Data Model entities in the logical data model, and the physical database tables or views to which the logical entities have been implemented into physical tables.

Table 5-1 Entity Mapping Table: Logical to Physical

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