Data



Back to Townhall Home Page

CCSQ D&A Townhall
DateThursday, April 7, 2022 at 1:00pm ET
Agenda
  1. Data & Analytics HCD Research
  2. System Updates
    1. File Lock Issues
    2. Lagging Issues
    3. GitHub Issue
    4. Maintenance Schedule - Updated! 
  3. Data Sources and Usage Updates
    1. Known Issues
    2. Claims Part A Update
    3. BIC Updates
  4. IDR Data Usage Survey
  5. GitHub Overview
    1. GitHub Overview
    2. GitHub Concepts and Workflow
    3. (Live Demo) Using Git in SAS
  6. Q&A
HCD Research

CDR Data Catalog Study (March 2022) 

  • When: March 10th - April 15th; 45 mins (via Zoom)
  • Goal: To understand your current experience consuming and/or contributing to the CDR Data Catalog.
  • Purpose: To inform the evaluation of potential future data catalog tool(s)
System Updates

SAS Viya Issues

File Lock Issues

  • Issue Description: SAS Viya users have reported file lock errors when reading data from their workbenches during SAS job runs
  • What to Expect: The team has found a solution to this, which requires re-mounting storage gateway workbenches. In order to mitigate the impact to production workflows, D&A team is coordinating with each affected organization to re-mount their workbenches at the most convenient time
  • Affected Communities: Select SAS Viya Users with affected workbenches
  • Call to Action: If you are facing this issue, please open a ServiceNow ticket for our team to remount your workbench.

Lagging Issues

  • SAS Viya users have reported intermittent lagging and freezing while utilizing the application.
  • Due to the issue's intermittent nature, some users have reported that their issue has gone away by the time that a help desk ticket has been created.
  • In order to capture the details for the D&A Team to investigate, please follow these instructions found within the Known Issues Log
  • After following these instructions, please provide the information via a helpdesk ticket

Github Issue

  • Issue Description: SAS Viya users have reported issues accessing data within Hive due to issues with two of the environment’s worker nodes.
  • What to Expect: The team continues to work with the SAS Vendor to obtain a patch that will resolve the issue. More updates will be shared once more information about the patch is available.
  • Affected Communities: SAS Viya Users
  • Call to Action: A new workaround has been published on this issue. Please follow these instructions found within the Known Issues Log

Scheduled CAP & CDR Maintenance 

Scheduled CAP & CDR Maintenance Schedule

  • April 8th
  • April 22nd (Added!) 
  • May 6th
  • June 3rd

All events will begin at 8:00 pm ET and end approximately at 11:00pm ET. A communication will be sent out once maintenance is complete. As a reminder, whenever there is maintenance on the environment, you will need to make sure all of your code and table changes are saved.

Data Source & Usage Updates

Known Issues

  • BIC MBI Sequence - 8/25/2021
    • Ongoing – TBD
  • QMARS Longer Text Fields - 1/12/2021
    • Ongoing - TBD
    • Consider using healthcare_service_qmars_ng if your DUA supports it

Claims Part A Updates

  • New fields to be added in mid-April 2022
  • CR20 new fields being added
  • Pricer Version Field (CR12463)
    • added to display the Prospective Payment System (PPS) Pricer Version to Inpatient/SNF, Outpatient, Home Health and Hospice claims at the claim level
  • Medicare-Severity Diagnosis Related Group (MS-DRG) Grouper Version field (CR12463)
    • added to display the MS-DRG Grouper Version to Inpatient/SNF claims at the claim level

BIC Updates

  • New columns added in mid-April 2022:
  • HMO_CONTRACT_NUM field
  • HMO_LKIN_PMT_OPTN_CD field

More information will be provided in the data catalog in the future

GitHub Overview

Agenda:

  • GitHub Oveview

  • GitHub Concepts and Workflow
  • (Live Demo) Using Git in SAS

GitHub Overview

    • GitHub is a web-based, version-control and collaboration tool for developers
    • Founded on Git, an open source code management system
      • Git tracks changes you make to files, so you have a record of what has been done
      • You can revert to specific versions should you ever need to
      • Git also makes collaboration easier, allowing changes by multiple people to all be merged into one source

GitHub Concepts 

    • Repository: contains all of the project files and the entire revision history. Best practice is to always include a README file
    • Branch: contains a unique version of all the project files within your repository.
      • Stable production version is called master branch
    • Commit: a snapshot of the project with newly added changes. Best practice is to include a commit message to describe the changes
      • A branch will contain one or more “commits”
    • Pull/Merge Request: A request to merge a branch into another (e.g. master)
    • Typical Git Workflow (see the graphic within the recording)

(Live Demo) Using Git in SAS

  • Workflow:
    • Create a new repo
    • Generate access token
    • Setup Git Profile in SAS
    • Clone Repo
    • Create a Branch
    • Create a Pull Request
    • Review code
    • Merge Pull Request
    • Update SAS with latest changes from master
Q&A
  1. Could you add both MDC and DRG?
    A - Please submit this to our help desk so that we are able to better understand and answer your question. 
  2. I'm not clear on how we get to the GIT site...is that through IDM? Do we need to create a role in HARP?
    A - As there are only so many licenses available, please open a request via our Request Form. 
  3. I was wondering about beneficiary information in the CDR. I saw a flow chart from April 2020 that said MBSF data would be available in the CDR starting June 2020. Is that data available? Would it be in the beneficiary schema?
    A - Please submit this to our help desk so that we are able to better understand and answer your question. 
  4. Are we able to push from Viya like you did in the demo?
    A - Yes, you should have access to this. If you are experiencing issues, please contact the help desk.