In part 1 of this blog, we covered at a high level the basics of T-SQL user defined functions. In part 2 we’ll explore the advantages of leveraging functions, and when to do so.

I recently had a student from one of our online training sessions email me a few days after class, asking why I recommend always using the SourceID column as part of every TSQL join. They sent two queries to demonstrate why they felt they shouldn’t use SourceID.

CMS recently published the FY 2022 Inpatient Prospective Payment System (IPPS) Proposed Rule which includes several proposed changes to the Hospital Inpatient Quality Reporting (IQR) Program and Medicare Promoting Interoperability Program for eligible hospitals and critical access hospitals (CAHs). For the full text of the rule, see the Federal Register.

So, in plain English, what is a T-SQL user-defined function? A function is a SQL query saved as a database object, which leverages and outputs data to serve a focused purpose. Once a function is created it easily can be utilized at any time by anyone with proper access. Measured creation and execution of functions will greatly streamline data production from your T-SQL environment, allowing technology to do what it’s supposed to - make our lives easier! Let’s start with a simple example to better explain why we should be using functions and illustrate different types.

Background

Anderson Healthcare has served the Illinois communities of Madison and Macoupin counties since 1977 and continues its commitment to providing residents with the highest quality of advanced medical care. A 154-bed inpatient hospital, critical access hospital, rehab institute, surgery center and outpatient acute care facility offer patients cutting-edge medical diagnostics that are not often found in a local community setting using the MEDITECH Expanse electronic health record platform.

We are thrilled with our partnership with Acmeware. Data and analytics are key to our business and our ability to provide top quality healthcare to our communities. So many people rely on timely and accurate data, it is a foundational part of our Information Technology infrastructure.

Background

Novant Health UVA Health System Culpeper Medical Center serves the greater Culpeper, Virginia community and surrounding areas. The campus in is home to a 70-bed, community hospital, Family Birth Center and 24/7 emergency department, and is complemented by additional outpatient services in other northern VA towns, as well as the Novant Health UVA Health System Haymarket Medical Center. Culpeper Medical Center is a longtime MEDITECH MAGIC customer.

CMS recently published the CY 2021 Quality Payment Program (QPP) Final Rule which included numerous updates to the Merit-based Incentive Payment System (MIPS) for 2020 reporting and subsequent reporting years, with a focus on 2021 reporting. For the full text of the rule, see the Federal Register.

MEDITECH's Data Repository best practices recommend a dedicated drive for tempdb data files, that the space allocated to this drive be 25-30% of total data space for the SQL Instance, and that the allocated space be split between eight data files and one log file. Is it possible to modify tempdb to meet these standards? Read on to learn how.

CMS recently published the CY 2021 Quality Payment Program (QPP) Proposed Rule which included numerous updates to the Merit-based Incentive Payment System (MIPS) for 2020 reporting and subsequent reporting years, with a focus on 2021 reporting. For the full text of the rule, see the Federal Register.

CMS recently published the FY 2021 final rule for the Inpatient Prospective Payment Systems (IPPS) and has finalized changes to the Hospital Inpatient Quality Reporting (IQR) program and Medicare & Medicaid Promoting Interoperability (PI) program for eligible hospitals and critical access hospitals. For the full text of the rule, see the Federal Register.

In part 1 of this blog, we discussed how to build a URL that could navigate to various resources on the internet. We learned how to build the URL string based on a combination of the website path and the data within our results. In part 2, we’ll look at a similar example of how to navigate to another SSRS report on our local network that resides in a different project folder. Using the same technique, we can build the navigation link and pass parameters into another report instead of using the default SSRS method which only links to reports in the same folder.