Mastering Slicer Dicer for Enhanced Provider E&M LOS Build Strategies

This is the build for the E&M LOS Slicer Dicer, this was mentioned in both the Epic Grab N' Go Analytics and also the CDI Presentation at the Combined CORE 2025 in New Orleans in October.

Population

Base: All Transactions (PB)

Billing Provider - Has Value

Active Transactions?

Charge Code: (99201, 99202, 99203, 99204, 99205, 99211,99212,99213,99214,99215)

Service Area: Has Value

Transaction Type: Has Value

AR Classification: Has Value

Slices

2 Slices By Charge Code

Both are Grouped - One Group is A group of 99201, 99202, 99203, 99204, 99205 named (New)

The other group is 99211, 99212, 99213, 99214,99215 named (Established)

Having these will group your codes based on new and established, this comes into play when you are benchmarking your statistics

Measures

M6 - Total Procedure Quantity

M1 - Percentage with Charge Code: 99201 or 99211

M2 - Percentage with Charge Code: 99202 or 99212

M3 - Percentage with Charge Code: 99203 or 99213

M4 - Percentage with Charge Code: 99204 or 99214

M5 - Percentage with Charge Code: 99205 or 99215

M7 - Average Provider E&M LOS = (M1 + (M2 x 2) + (M3 x 3) + (M4 x 4) + (M5 x 5))/100

M8 - Benchmark Establish (Hard Coded Value)

M9 - Benchmark New (Hard Coded Value)

M10 - Variance from New (M9-M7)

M11 - Variance from Establish (M8-M7)

Dates

Start Date - Y-1

End Date - T

Based on: Service Date

Slice By: Month

Visual Options

Cross Tab