Analytics and Reporting

Common Codes for COVID-19 Analyses

April 22, 2020

Below you will find a list of codes commonly used to support analyses related to COVID-19. Codes in bold type were recently developed specifically for this purpose. *The CDC recommends using U07.1 and using the additional B97.29 code only for confirmed cases of COVID-19. Suspected, possible or probable cases of COVID-19 are to be...Read more

CPT Codes Released to Track COVID-19 Antibody Testing

Mary Jo Condon, MPPA

April 17, 2020

Analytics and Reporting

Update: As of June 26, 2020 the AMA Current Procedural Terminology (CPT®) Editorial Panel has adopted a new CPT code to report antigen testing of patients suspected of SARS-CoV-2 infection. The new CPT code for infectious agent antigen detection by immunoassay technique is 87426. Current Procedural Terminology (CPT) codes are now available to report when patients receive...Read more

Can prescription claims foretell the impact of COVID-19 on depression and anxiety?

Mary Jo Condon, MPPA

April 9, 2020

Analytics and Reporting

As our nation prepares for weeks of continued increases in confirmed COVID-19 cases and deaths, many are thinking about the implications on psychological and emotional health. Beyond the uncertainty and worry of the virus itself, social distancing measures bring separation from family and friends, disruption in daily routine and concerns about financial well being. Pharmacy...Read more

How to Track Coronavirus in Your APCD

Mary Jo Condon, MPPA

March 17, 2020

Analytics and Reporting, Leading an APCD

States will be looking to their all-payer claims databases (APCDs) to gain a better understanding of the impact of the coronavirus pandemic. This blog post will offer suggestions on how to tap into APCDs to see trends in related healthcare utilization and cost. What’s the difference between SARS-CoV-2 and COVID-19? SARS-CoV-2 (short for Severe Acute...Read more

Inconsistent Data Sets: A Summary of the ETL Normalization of CMS Quality Data

Freedman HealthCare Staff

January 14, 2020

Analytics and Reporting, Data Quality, Technology

This series has explored Freedman Analytical Engine (FAE)’s purpose and process. More specifically, we have looked at the problems that FAE solves, the need for standardized data in order to complete analysis, and the involvement of programmers and analysts in completing this ETL process. We have described ways in which file structures are identified and...Read more

Inconsistent Data Sets: Normalizing CMS Quality Data Files for Analysis

Freedman HealthCare Staff

November 1, 2019

Analytics and Reporting, Data Quality, Technology

In the last post, we discussed the five file formats encountered by Freedman Analytical Engine (FAE) as it processes Centers for Medicare and Medicaid Services (CMS) quality data. They require FAE to standardize these files to create one merged CSV. This merged file will most closely resemble a Vertical ID file. This post will focus...Read more

Inconsistent Data Sets: The Five CMS Quality Data File Structures

Freedman HealthCare Staff

October 17, 2019

Analytics and Reporting, Data Quality, Technology

In the last blog post we discussed augmenting the ETL process for CMS quality data. Freedman Analytical Engine (FAE) starts with this quality data, which does not have a consistent structure, and normalizes the column headers and measure identifiers, merging it into one CSV for analysis. To normalize these varying formats, the different file structures...Read more

Next 1 … 5 6 7 … 10 Previous

Common Codes for COVID-19 Analyses

CPT Codes Released to Track COVID-19 Antibody Testing

Can prescription claims foretell the impact of COVID-19 on depression and anxiety?

How to Track Coronavirus in Your APCD

Inconsistent Data Sets: A Summary of the ETL Normalization of CMS Quality Data

Inconsistent Data Sets: Normalizing CMS Quality Data Files for Analysis

Inconsistent Data Sets: The Five CMS Quality Data File Structures

About the APCD Journal

Follow the APCD Journal

Categories