Quantcast
Data Repository Training - Class Details

Syllabus – DR Conversion to Expanse

Day 1

  • A discussion of the new Expanse data architecture, or “split” into NPR and M-AT, including a review of all key applications that have been upgraded to the latest platform.
  • We review the database normalization conventions within Expanse, including table and column naming conventions, more consistent primary keys within tables and more.
  • A walk-through review of DR application functions within MEDITECH (system monitoring, error checking, data mapping, etc.).  *This section is optional.
  • Application review for Admissions: what’s new in DR for REG and HIM, with commonly used tables and conventions for patient demographic data.
  • Application review for Abstracting: what’s new in DR for ABS with commonly used tables and conventions for diagnosis-related data.

Day 2 (1/2 day)

  • Application review for Patient Accounts: what’s new in DR for BAR with commonly used tables and conventions for patient account financial data.
  • Advanced T-SQL: table and scalar-valued functions
  • Advanced T-SQL: PIVOT function with practical examples

 

Copyright © 1998-2018 Acmeware, Inc.
333 Elm St Suite 225
Dedham, MA 02026