Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

HCCMapping Table

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

7 Posts

5 Users

0 Reactions

68 Views

RSS

bhoover

(@bhoover)

Posts: 360

Honorable Member

Topic starter

Hello All,

I am working on some quality items and noticed a table in the database called 'HCCMapping'. There isn't any documentation on it. Does anyone know the table's purpose?

Thanks,

Brad

Posted : November 23, 2016 2:34 am

evanstaden

(@evanstaden)

Posts: 31

Eminent Member

Hierarchical Condition Category (HCC) is a category of medical conditions that maps to a corresponding group of ICD-9 / ICD-10 diagnosis codes. It is a CMS programs used to assign RAF's (Risk Adjustment Factors) to beneficiaries of health plans and pay accordingly for their care.

All providers need to get on board to avoid reimbursement deductions. The first step is probably to obtain their QRUR's (Quality and Resource Use Reports) from CMS via the EIDM Account on the CMS portal.

https://www.cms.gov/Medicare/Medicare-Fee-for-Service-Payment/PhysicianFeedbackProgram/Obtain-2013-QRUR.html

Posted : November 23, 2016 3:43 am

mond08

(@mond08)

Posts: 74

Estimable Member

I am curious how we utilize this table.

I am familiar with HCC codes but not how to use this table that is in the database.

Dave

Posted : November 23, 2016 3:48 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

Topic starter

I'm in a similar situation Dave. I'm not sure if the table will be helpful since the problem codes it references are in ICD-9 format. But I figured I would ask in case anyone knows...

Posted : November 23, 2016 3:54 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

I am on CEMR 9.8.13 and my HCCMAPPING table is completely empty.

Posted : November 23, 2016 4:36 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

Topic starter

For what its worth we are on CPS 12.0.11 and the table returns the following:

HCCMappingID

ProblemCode

CodeType

RiskAdjstmentFactor

HCCCode

DB_CREATE_DATE

DB_UPDATE_DATE

I get ~3000 rows. The problem codes are ICD-9 codes. All items have a code type of '1'. The HCCCode seems to relate to the HCC Category, for example: HCC2, HCC39, etc.

Posted : November 23, 2016 5:57 am

abulsara

(@abulsara)

Posts: 150

Estimable Member

This table is for future use. GE is working on integrating Payer data, so when that data is received, it will be populated in there. I believe currently, GE only has of the National Payers setup but not 100% sure. Once the table is populated, the information stored within it will be displayed on the Problem List of the Chart Summary. Donna Maddox from GE did a presentation during C-Live either earlier this year or last year.

Posted : November 23, 2016 6:46 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
8 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0