The LTC Innovation Blog

Anyone who has worked in a long-term care pharmacy knows that while the general principles of the profession are consistent, specific needs often vary significantly depending on the clients served. Even if you're an independent long-term care (LTC) pharmacy that services a few dozen skilled nursing and assisted living facilities, each one will still have a great number of preferences and unique requirements.

CancelRx messages are a common occurrence in long-term care pharmacy settings. Patient status changes, medication reviews, and facility circumstances often require prescribers to cancel previously prescribed medications.

When data is inserted into, deleted from, or updated in your SQL tables, the indexes update to reflect those changes.

So let’s start basic…”What is a database?” Most simply, it’s just a system to store information. A common real-world example I’m going to use today is a file cabinet. In a file cabinet, you have physical sheets of paper with bits of information written on them. You can think of SQL as the digital equivalent to a file cabinet. SQL stores every piece of data collected on pages that are identical in size. In your file cabinet, the pages are 8x11. In SQL, the pages are 8 KB. Just as those physical sheets of paper end up inside the metal cabinet, SQL stores its pages in its digital cabinet, which are the disk drives.

Pharmacies assisting with the COVID-19 vaccination effort face evolving and complex demands around administration, storage and handling, reporting, and record-keeping. The process has introduced many new requirements for long-term care, such as capturing additional data fields for each patient and new and specific reporting requirements to the state.

Operation Warp Speed (OWS) is the coordinated effort between a number of federal agencies to accelerate the research, discovery, and production of a safe and effective vaccine for COVID-19. Among these are the Centers for Disease Control and Prevention (CDC), the National Institutes of Health (NIH), and the Department of Defense.