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, Medico-Social Coding Consultant

Lolita Jones

Lolita holds a Graduate Certificate in Healthcare Data Analytics, and she is the Co-founder of Population Health Analytics Association Incorporated (www.PHAAI.org). Based in New York, she is an AHIMA Approved ICD-10-CM/PCS Trainer with extensive experience in the medical coding field as a: coder, auditor, trainer, educator, and technical editor. Lolita uses her medical coding skills to research and write rules for various health information management software programs (e.g., coding validation and denials management). She also provides population health information management services, specifically: Social Determinants of Health (SDOH) ad-hoc reports generation; identification of SDOH location in the health record; development of SDOH internal coding guidelines; training/education about the importance of documenting and coding SDOH; auditing SDOH documentation quality and coding accuracy; SDOH electronic health record template development; and software rules development for automated capture of SDOH codes. Lolita can be reached via e-mail at LolitaMJ@iQueryData.com or by selecting CONTACT below.

Query Rules Subscription

Get access to our library of coding validation rules – and receive alerts when new rules are added.

What is Medical Coding 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 Query Rules

Lolita Jones is available to write custom coding validation rules 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