Query Rules for
Medical Coding &
Reimbursement
Data Mining

Use data to transform
patient care, clinical research,
data quality, regulatory compliance,
and revenue management.

Lolita M. Jones, MSHS, RHIA, CCS, Healthcare Data Mining Consultant

Lolita Jones

Lolita has extensive experience in the medical coding field as a: coder, auditor, trainer, educator, and technical editor. She’s also an AHIMA Approved ICD-10-CM/PCS Trainer. She currently specializes in researching and writing query rules for medical coding and reimbursement data mining. Lolita also researched and developed a Healthcare Data Mining Clinic educational series, that she currently uses to provide hands-on data analytics & mining query rules training to various healthcare professionals. She is based in New York, and is currently pursuing a SAS Approved Graduate Certificate in Healthcare Data Analytics from a top university. You can contact her via e-mail at LolitaMJ@iQueryData.com or by selecting CONTACT below.

Medical Query Rules Subscription

Get access to our library of query rules for medical coding and reimbursement data mining – and receive alerts when new query rules are added.

What is Healthcare Data Mining?

A Query is a request for data or information from a database(s). Rules define specific constraints associated with the requested data.

Consulting Services for Data Analytics & Mining

Lolita Jones is available for custom query rule development and more.

Free Sample Data Mining Query Rule

Skin Cyst-Soft Tissue Tumor Coding Conflict (FREE)

QUERY RULE:

Search the appropriate database(s) for outpatient surgery accounts in which one of the following ICD-10-CM Diagnosis Codes: L72.0 or L72.11 or L72.3 was reported WITH any soft tissue tumor excision CPT® Code from the range of 21011 – 28047. The sequence of the diagnosis and CPT® codes doesn’t matter, i.e., the ICD-10-CM Diagnosis Codes L72.0, L72.11, L72.3 can be listed in each account as either a Primary Diagnosis Code or as a Secondary Diagnosis Code; and the soft tissue tumor excision CPT® code in the range of 21011 – 28047 can be listed in each account as either a Principal Procedure or as a Secondary Procedure Code.

EXPLANATION:

The excision of epidermal, pilar, or sebaceous cysts is properly coded with the American Medical Association’s (AMA) CPT® codes 11400 – 11446, together with an intermediate or complex wound repair CPT® code when indicated.  Because these cysts are benign tumors that originate from the dermis or adnexal structures, they are not soft tissue tumors, even though they may protrude into the subcutaneous tissue.  It is inappropriate to code the excision of cysts that originate from the dermis or adnexal structures by using the soft tissue tumor excision CPT® codes listed in the 21011 – 28047 code range.

This Query Rule contains the ICD-10-CM diagnosis codes for epidermal, pilar, and sebaceous cysts, and the CPT® code range where the soft tissue tumor excision codes can be found. By searching for outpatient surgery accounts in which a skin cyst ICD-10-CM diagnosis code was reported with a soft tissue tumor excision CPT® code, providers can identify and correct (when applicable) the CPT® codes listed on the account(s).

SOURCE(S):

CPT Assistant newsletters: July 2010, October 2010, and January 2011, American Medical Association, Chicago, IL.

PROVIDER TYPE(S):

Ambulatory Surgery Centers, Hospitals, Physicians, and other providers who report CPT® codes when coding and billing skin cyst excision procedures that were performed on outpatients.

PATIENT TYPE(S):

Outpatients are the population to analyze when applying this Query Rule.

DATES OF SERVICE:

Outpatient surgeries performed any time after July 2010 can be analyzed because that’s the first time that the AMA published this official CPT® coding guideline.

REPORT DATA FIELDS:

At a minimum, the following data elements should be displayed on the report that is generated using the Query Rule:

  • Patient Account Number
  • Patient Medical Record Number
  • Date of Service
  • Query Rule ICD-10-CM Diagnosis Code
  • ICD-10-CM Diagnosis Code Description
  • Query Rule CPT® Code
  • CPT® Code Description

SAMPLE REPORT FORMAT: 

Below is an example of how the data mining results could be displayed in a report:

Questions About Our Premium Healthcare Query Rules Subscription

How do I pay for my subscription?

All payments are currently handled through purchase orders.

Do you offer a monthly plan?

No. We currently only offer a yearly subscription.

How will my subscription renew?

You will be notified via email when your subscription requires renewal.

Access our premium medical and healthcare data mining query rules