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 |