Query Rules for
Medical Coding &
Data Mining

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

Lolita M. Jones, MSHS, RHIA, CCS, CRC, 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 a Certified Risk Adjustment Coder (CRC) and 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. She also provides the following population health information management services: Hierarchical Condition Categories (HCC)/risk adjustment coding, education, and auditing; and Social Determinants of Health (SDOH) documentation and coding training, internal guidelines development, ad-hoc reports generation, and auditing for data quality/accuracy. Lolita uses her medico-social coding skills to research and write rules for various health information management software programs (e.g., coding validation and medical necessity). 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)


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.


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).


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


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.


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


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.


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


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