Culbert Healthcare – CHS Culbert Healthcare – CHS
  • SERVICES
    • CLINICAL OPERATIONS
    • MANAGEMENT CONSULTING
    • HEALTH IT
      • EPIC CONSULTING
      • ATHENAHEALTH & ATHENAIDX
      • ALLSCRIPTS CONSULTING
      • CERNER CONSULTING
  • MEDIA & EVENTS
    • CONFERENCES
    • WEBINARS
    • CASE STUDIES
    • NEWSLETTERS
  • CAREERS
    • AVAILABLE POSITIONS
    • BENEFITS
    • STAFF TESTIMONIALS
  • ABOUT
    • MANAGEMENT TEAM
    • COMPANY MEETING & PRESIDENTS CLUB
  • BLOG
  • CONTACT
Culbert Healthcare – CHS Culbert Healthcare – CHS
  • SERVICES
    • CLINICAL OPERATIONS
    • MANAGEMENT CONSULTING
    • HEALTH IT
      • EPIC CONSULTING
      • ATHENAHEALTH & ATHENAIDX
      • ALLSCRIPTS CONSULTING
      • CERNER CONSULTING
  • MEDIA & EVENTS
    • CONFERENCES
    • WEBINARS
    • CASE STUDIES
    • NEWSLETTERS
  • CAREERS
    • AVAILABLE POSITIONS
    • BENEFITS
    • STAFF TESTIMONIALS
  • ABOUT
    • MANAGEMENT TEAM
    • COMPANY MEETING & PRESIDENTS CLUB
  • BLOG
  • CONTACT
Jun 24

Using Indexes in Epic

  • June 24, 2013
  • Tom D
  • Epic, Tom Dubeck-Stuff You Wish You Had Learned in Epic Certification

Using Indexes

Epic’s databases hold the information that your system lives on.  Being able to query that data quickly and efficiently is a mark of system mastery.  One database tool that I’d like to promote today is the indexes that are created for various items.

Database indexes are lists of record IDs for each known value of the “index item”.  An Example: Patient Encounter Date, item EPT 20, is an index item.  This means that living in the system right now is a self updating list of all patients who had an encounter for each day your system was running.  If necessary, the lists for multiple separate values (the last 3 Mondays) or a range of contiguous values (all of last week) can be generated rapidly.  When trying to query the Patient Database, instead of searching through every record in the system, you can limit your search to patients in the Encounter Date index for a range you deem relevant or an appropriate sample (like the last month’s worth of patients).   This increases the speed of Chronicles or Clarity Searched by orders of magnitude.  The performance gain is even larger if you can find other indexes on items you are searching for.  Encounter Provider, EPT 7040, is another indexed item.  Combining these indexes lets you easily search for “All of Dr X’s patients seen in the last month”

Nearly anywhere you are asked to enter a Record ID in the text side (Chronicles, EAVIEWID, Reflections record editing) typing the command “key ?” without quotes will bring up a list of all the indexed items the master file has.   Likewise if the item is a category list, “key item number=?” will list all categories where at least one record is present and depending on the item, can give you a quick count of how many records are in each index.

I could go on a lot longer, but here are some simple takeaways that help solve problems you might have been stuck on:

  1. How do I find the parent order of this released order?  Search ORD for “key 660=childOrderID”
  2. How do I find out who’s a member of this pool?  Search EMP for key 450=Class ID of Pool.  This also works for User Security Template records instead of pools, with index EMP 198 instead.
  3. How do I find all Order transmittal Destination maps that print to this printer?  Search LOM for “key 110=ID of Printer’s LWS record”
  4. For finding multiple values in the index, you can type commas like “key item number=1,4,8” for multiple values or a colon to make a range, “Key item number=5:25”

You can actually make Indexed items from EPT (like encounter date or Encounter provider/Department) available to end users in Hyperspace as part of the Patient Custom Search Tab.   Take care to only add Indexed items to the tab, attempting patient lookup with non-indexed items will appear very slow in Hyperspace.  Instructions here: https://galaxy.epic.com/?#Browse/page=7900!68!30!443329,443385,34234,34232

 

 

 

 

  • Facebook
  • Twitter
  • Tumblr
  • Pinterest
  • Google+
  • LinkedIn
  • E-Mail

About The Author

Tom Dubeck is a former Epic Technical Services Engineer (TS) with 12+ years of healthcare IT experience. Tom is a proficient programmer and report writer certified in multiple Epic applications and his technical skills include Cache/Mumps, Visual Basic 6, UNIX, Windows OS, Report Writing, SQL Server, .NET, Java, and JavaScript. Throughout his career, he has been responsible for supporting full lifecycle implementations, upgrades, and optimizations of the Epic suite of products including EpicCare Ambulatory, Resolute, Cadence, Prelude, Radiant and Beacon at several large healthcare organizations.

Comments are closed.

Recent Posts

  • 21st Century Cures Act Requirements for Providers – Revised Compliance Dates and Why This Matters
  • Information Blocking Delay-We Can Help you Prepare for April 2021
  • Improve Revenue by Optimizing Coding Performance
  • Work Claim Denials More Efficiently Using Owning Areas: Epic Resolute Hospital Billing
  • Why Now is a Good Time to Shift Your Focus

Recent Comments

    Archives

    • November 2020
    • October 2020
    • September 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • March 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
    • October 2014
    • September 2014
    • August 2014
    • July 2014
    • June 2014
    • May 2014
    • April 2014
    • March 2014
    • February 2014
    • January 2014
    • December 2013
    • November 2013
    • October 2013
    • September 2013
    • July 2013
    • June 2013
    • May 2013
    • April 2013
    • March 2013
    • February 2013
    • January 2013
    • December 2012
    • November 2012
    • October 2012

    Categories

    • 21st Century Cures Act
    • Allscripts
    • athenahealth
    • Clinical Operations
    • CMS Quality Payment Program-MIPS Path
    • Coding
    • Consumerism
    • COVID-19 Resources
    • EHR
    • EHR Integration
    • EHR Optimization
    • Epic
    • Epic Connect
    • Epic Reporting
    • Epic Security
    • GE
    • GE Centricity
    • ICD-10
    • Information Blocking
    • IT
    • MACRA
    • Management Consulting
    • Meaningful Use
    • Patient Access
    • patient experience
    • patient satisfaction
    • process improvement
    • Revenue Cycle
    • Strategy & Executive Leadership
    • Telehealth
    • Tom Dubeck-Stuff You Wish You Had Learned in Epic Certification
    • Training
    • Uncategorized

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org
    Connect with Culbert
    call us at 781.935.1002 info@culberthealth.com
    800 West Cummings Park Suite 6000 Woburn, MA 01801
    2020 Culbert Healthcare Solutions