Epic Slicer Dicer Cheat Codes - Setup Guide
Create Templates
HB Accounts
Base: All Hospital Accounts (HB & PB)
Population:
Billing System: Hospital Billing
Slices:
Primary Financial Class
Measures
Total Account Balance
Number of Hospital Accounts
Total Active AR Balance
Total Self-Pay Balance
Total Bad-Debt Balance
Total External AR Balance
Total Undistributed Balance
Insurance balance (Total Primary Insurance Balance + Total Non Primary Insurance Balance)
Dates:
M-6
T
Discharge Date
Visual Options
Detail Table and Cross Tab
HB Buckets
Base: All Buckets (HB)
Population:
Bucket Status: Created, Outstanding
Slices:
Bucket Financial Class
Measures
Total Account Balance
Total Expected Reimbursement Amount
Total Bucket Balance
Number of Buckets (HB)
Dates:
Y-1
T
Discharge Date
Visual Options
Detail Table and Cross Tab
HB/PB Transactions
Base: All Transactions (HB&PB)
Population:
Billing System: Hospital Billing/Professional Billing (Depending)
Active Transaction: Yes
Transaction Type: Has Value
AR Classification: Has Value
Service Area: Has Value
Slices:
Primary Financial Class
Measures
Number of Transactions
Total Procedure Quantity
Total Posted Amount
Dates:
M-6
T
Post Date
Visual Options
Detail Table and Cross Tab
Denials
Base: All Denials (PB)
Population:
Slices:
Denial Financial Class
Measures
Number of Denials (PB)
Total Billed Amount
Total Paid Amount
Total Denied Amount
Dates:
Y-1
T
Received Date
Visual Options
Detail Table and Cross Tab