Meditech DR Core SQL Tables
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 |