Meditech DR Core SQL Tables

  • Published by steve on 5 January 2012.

Core Tables for Meditech Data Repository SQL database.

Module TableName
ABS AbsAnesthesiaPhysicians
ABS AbsApcCpts
ABS AbsCanadianData
ABS AbsCharges
ABS AbsCmgData
ABS AbsConsultations
ABS AbsCptCodes
ABS AbsDrgCptModifiers
ABS AbsDrgData
ABS AbsDrgData2
ABS AbsDrgDiagnoses
ABS AbsDrgProcedures
ABS AbsInsurances
ABS AbsMaternityVisits
ABS AbsNewbornData
ABS AbsOperationProcedures
ABS AbsOperations
ABS AbsOperationSurgeonAssistants
ABS AbsOperationSurgeons
ABS AbsOtherPhysicians
ABS AbsOvOperativeEpisodes
ABS AbsPatientTransactions
ABS AbsProjectsQueriesCs
ABS AbsQueries
ABS AbsReimbursements
ABS AbsServices
ABS AbsSpecialCareUnits
ABS AbsStdCosts
ABS AbstractData
ABS AbstractData2
ABS AbstractProviders
ADM AdmDischarge
ADM AdmEmployers
ADM AdmGuarantors
ADM AdmInsuranceOrder
ADM AdmInsuranceOtherType
ADM AdmInsuredData
ADM AdmittingData
ADM AdmNursingCensus
ADM AdmStatsAccommodation
ADM AdmStatsAccommodationOut
ADM AdmStatsAdmitProvider
ADM AdmStatsAttendProvider
ADM AdmStatsFinancialClass
ADM AdmStatsHospital
ADM AdmStatsLocation
ADM AdmStatsLocationOut
ADM AdmStatsObservationPatient
ADM AdmStatsOutLocation
ADM AdmStatsOutRegistrations
ADM AdmStatsPatientOrigin
ADM AdmStatsPrimaryCareProvider
ADM AdmStatsRoomRateAccommodation
ADM AdmStatsRoomRateAccomOut
ADM AdmStatsService
ADM AdmStatsServiceOut
ADM AdmVisitAuthorizations
ADM AdmVisitClinicalQueries
ADM AdmVisitEvents
ADM AdmVisitInsuranceAuthMan
ADM AdmVisitInsuranceAuthManCpts
ADM AdmVisitProviders
ADM AdmVisitQueries
ADM AdmVisits
ADM AdmVitalSigns
AP ApChecks
AP ApInvoices
BAR BarBchs
BAR BarBchTxnItems
BAR BarBchTxns
BAR BarBills
BAR BarBillsProration
BAR BarChargeTransactions
BAR BarClientChargeTransactions
BAR BarClientCollectionTransaction
BAR BarClients
BAR BarCollectionTransactions
BAR BarEmployers
BAR BarGuarantors
BAR BarInsuranceBillLedger
BAR BarInsuranceLedger
BAR BarInsuranceOrder
BAR BarInsurances
BAR BarInsuredData
BAR BarOtherTransactions
BAR BarPeInsuranceLedgers
BAR BarPeStatusVectors
BAR BarVisitFinancialData
BAR BarVisitFinancialData2
BAR BarVisitFinancialData3
BAR BarVisitFinancialData4
BAR BarVisitGuarantors
BAR BarVisitProviders
BAR BarVisitQueries
BAR BarVisits
LAB BbkDonors
LAB BbkHistory
LAB BbkHistoryAntibodies
LAB BbkHistoryAntigens
LAB BbkHistoryAudits
LAB BbkHistoryBloodTypes
LAB BbkHistoryMarkers
LAB BbkHistoryTransfusions
LAB BbkHistoryTransReactions
LAB BbkSpecimenCrossmatches
LAB BbkSpecimenCrossmatchResults
LAB BbkSpecimenDeletedOrds
LAB BbkSpecimenIssuedProducts
LAB BbkSpecimenIssuedUnits
LAB BbkSpecimenOrders
LAB BbkSpecimenOrdProds
LAB BbkSpecimenOrdTests
LAB BbkSpecimens
LAB BbkSpecimenTests
LAB BbkUnitFinalDispositions
LAB BbkUnitFinalDispositionStats
LAB BbkUnits
LAB BbkUnitStatusActivity
ABS DAbsChgCat
ABS DAbsCpts
ABS DAbsDiagnoses
ABS DAbsDrgs
ABS DAbsMdcMccs
ABS DAbsPatientClass
ABS DAbsProcedures
BAR DBarChargeCategories
BAR DBarProcAltCodeEffectDates
BAR DBarProcedures
BAR DBarProcFeeSchedEffectDates
BAR DBarProcRevenueSites
BAR DBarProcStandardEffectDates
LAB DBbkAnalyzers
RAD DItsProcedures
RAD DItsReport
LAB DLabAnalyzers
LAB DMicAnalyzers
MIS DMisAbsService
MIS DMisAbsServiceFacility
MIS DMisAdmitPatientStatus
MIS DMisAdmitPriority
MIS DMisAdmitSource
MIS DMisArrivalMode
MIS DMisDirection
MIS DMisDischargeDisposition
MIS DMisEmployer
MIS DMisFacilities
MIS DMisFinancialClass
MIS DMisGlAccount
MIS DMisGlAccountComponents
MIS DMisGlClass
MIS DMisGlComponent
MIS DMisGlComponentValue
MIS DMisGlComponentValueSummary
MIS DMisGlPeriod
MIS DMisGroupResponseElements
MIS DMisInsurance
MIS DMisInsuranceGroup
MIS DMisLocation
MIS DMisLocationFacility
MIS DMisMaritalStatus
MIS DMisNewbornAdmitSource
MIS DMisPostalCode
MIS DMisProvider
MIS DMisProviderFacility
MIS DMisProviderGroup
MIS DMisProviderType
MIS DMisRace
MIS DMisRelationship
MIS DMisRoom
MIS DMisRoomBed
MIS DMisService
MIS DMisServiceFacility
MIS DMisUserFinancialAccessComps
MIS DMisUserFinancialDbAccess
MIS DMisUserRestrictedFinAccess
MIS DMisUsers
MIS DMisUserStatistics
MIS DMisUserStatisticsDetail
MIS DMisVendorFacInfo
MIS DMisVendors
MM DMmStock
NUR DNurAccessUsers
NUR DNurIntervention
NUR DNurInterventionOrderEntry
NUR DNurNurDiagnosis
NUR DNurStdCarePlan
PHA DPhaDrugData
DR DrSources
EDM EdmPatientDeparts
EDM EdmPatientDocumentSigs
EDM EdmPatients
EDM EdmPatientStatusEventHistory
EDM EdmPatientStatusEvents
FA FaAssetAmountsByPeriod
FA FaAssetAmountsByYear
FA FaAssetAmountsInitial
FA FaAssetDistributions
FA FaAssets
GL GlAccountAmounts
GL GlAccountBatch
GL GlBatchCredits
GL GlBatchDebits
GL GlBatchTransaction
GL GlBudgetsByPeriod
GL GlStatisticsAmounts
GL GlStatisticsBatch
GL GlStatisticsBatchTransaction
GL GlStatisticsBatchTxnAmount
HR HrEmployeePayrolls
HR HrEmployeePersonelPositions
HR HrEmployees
RAD ItsOrder
RAD ItsResult
RAD ItsResultOrders
RAD ItsResultTranscription
LAB LabInfectionControlData
LAB LabInfectionControlQueries
LAB LabInfectionControlQueryMult
LAB LabReqOrderedBbkProds
LAB LabReqOrderedBbkTests
LAB LabReqOrderedLabTests
LAB LabReqOrderedMicProcs
LAB LabReqOrderedPthProcs
LAB LabReqPthSpecimens
LAB LabReqQueries
LAB LabReqQueryMult
LAB LabReqSpecimens
LAB LabRequisitionDetails
LAB LabRequisitions
LAB LabSpecimenOrders
LAB LabSpecimens
LAB LabSpecimenTests
LAB MicSpecimenCultures
LAB MicSpecimenOrders
LAB MicSpecimenOrdProcs
LAB MicSpecimenOrganisms
LAB MicSpecimenOrgSensAntibiotics
LAB MicSpecimenOrgSensitivities
LAB MicSpecimenProcedures
LAB MicSpecimenProcResults
LAB MicSpecimenResultPrompts
LAB MicSpecimenResultTests
LAB MicSpecimens
MIS MisGlBatchCreditsCs
MIS MisGlBatchCs
MIS MisGlBatchDebitsCs
MM MmInvoices
MM MmPurchaseOrderLines
MM MmPurchaseOrders
MM MmPurchaseOrderTransactions
MM MmStock
Mri MriDrcPatients
Mri MriPatientCanadianData
Mri MriPatients
Mri MriPatientUnitNumbers
Mri MriPatientVisitEvents
Mri MriPatientVisits
NUR NurInterventionOccurrences
NUR NurPatientPoc
NUR NurPatientPocDiagnoses
NUR NurPatientPocGoals
NUR NurPatientPocInterventions
NUR NurPatientPocMiscInterventions
NUR NurPocWorkActivity
NUR NurPocWorkIntOccDirections
NUR NurPocWorkLocationChanges
NUR NurPocWorkTdRepeatResultMult
NUR NurPocWorkTdRepeatResults
NUR NurQueryResults
NUR NurQueryResultsMultiple
NUR NurRaiMdsData
NUR NurRaiMdsQueries
NUR NurRaiMdsQueryMultiples
NUR NurRaiMdsSectionInfo
NUR NurRaiMdsSectionRmore
NUR NurRaiMdsSectionUMeds
NUR NurRaiMdsSectionUserData
NUR NurStatisticsDocedCpts
NUR NurStatisticsDocedDept
NUR NurStatisticsDocedLocs
NUR NurStatisticsIntervens
NUR NurStatisticsPeriodIntervens
NUR NurStatisticsPeriodProviders
NUR NurStatisticsRequiredCpts
OE OeOrderQueries
OE OeOrders
OE OeStatDailyProcedures
OE OeVisitData
PHA PhaRx
PHA PhaRxAdministrations
PHA PhaRxAdminLog
PHA PhaRxAdminLogNewQueriesCs
PHA PhaRxAdminLogOldQueriesCs
PHA PhaRxInteractions
PHA PhaRxMedications
PHA PhaRxTransactions
PP PpEmployeePayroll
PP PpEmployees
PP PpEmployeeSkills
PP PpPayrollPosition
PP PpPayrolls
PP PpTimeCardBenefits
PP PpTimeCardComputedWithholdings
PP PpTimeCardEarnings
PP PpTimeCardMultiPayCheck
PP PpTimeCardMultiPayDirectDep
PP PpTimeCardMultiPaySource
PP PpTimeCards
LAB PthSpecimenFindings
LAB PthSpecimenHistologies
LAB PthSpecimenProcedures
LAB PthSpecimens
SCH SchAppointmentResources
SCH SchAppointments
SCH SchCalendar
SCH SchCalendarDetail