Stay up to date with insights, tips, and education from experts in healthcare IT.
Because SourceID is part of the primary key in virtually all MEDITECH Data Repository tables, it is good practice to include SourceID as the first column all indexes, include it in all joins and to identify SourceID in the WHERE clause of the query. In most cases…
From time to time in your work in SQL from the DR, you’ll wind up CAST-ing or CONVERT-ing a number into a string. If that number starts as a DECIMAL or NUMERIC with a scale (the number of places of accuracy to the right of the decimal…
Ever change the logic in your query, confirm new data in SQL, run the report from SSRS… and get the old data? Ever change the columns in your query, run the report from SSRS… and get a weird error–or just not get any data in the new…
For anyone who has been working in the healthcare IT industry over the past 15-18 years, including yours truly, we can all attest to the fact that interfaces–including the technology that facilitates them–have progressed from being important prerequisites for operational efficiency to mission critical elements for patient…
Recently while working a regulatory report I found myself faced with needing to identify the first (or earliest) of a set of dates. Each date came from a different possible order related to the patient visit, and I needed to chunk through 10 different JOIN-ed tables and…
About Us
Solutions
Learn
Get exclusive offers sent straight to your inbox.
© 1996-2025 Iatric Systems, Inc. All Rights reserved.
