Red Rock Healthcare Solutions:
Achieving Cerner Success with ALTERYX
Cerner Supply Chain
Most Cerner footprints require integration with the organization’s primary materials management system (MM), including item master and inventory management functions. Red Rock Healthcare Solutions (RRHC) supports the creation, integration, maintenance and optimization of the Cerner Item Master.
The Cerner Item Master drives physician preference cards1, equipment conflict checking & tracking, bar coding, clinical documentation, revenue cycle (i.e. Supply Charging), forecasting, and related reporting.
COMMON PROJECT TASK
Item Master Comparison, Validation, and Upload Preparation
Compare item master attributes between MM and Cerner when creating and/or improving integration or system transition
Matching on multiple attributes (ex. Item Number, Manufacturer Data, Packaging)
Key Item Attribute Analysis
Item Classification: Items missing an item class, and count of items per classification, identifying items potentially miscategorized
Manufacturer Data: Items having more than one manufacturer item association
Charging: Items having a certain cost threshold, comparing to supply charge designation, price mark-up calculations and related attributes
Cerner Supply Chain
Most Cerner footprints require integration with the organization’s primary materials management system (MM), including item master and inventory management functions. Red Rock Healthcare Solutions (RRHC) supports the creation, integration, maintenance and optimization of the Cerner Item Master.
The Cerner Item Master drives physician preference cards1, equipment conflict checking & tracking, bar coding, clinical documentation, revenue cycle (i.e. Supply Charging), forecasting, and related reporting.
Any updates performed cause immediate obsolesce of the current model and starting from ‘scratch’
Team lacks understanding of steps performed, difficulty and time consuming iterating
Alteryx Wins
Dynamic Input Tool accepts multiple Cerner standard extract files
Typical item master may be 5-20+ files, ingested with a single tool
Embed our methodology directly into shared Workflows
Fuzzy Matching for Item Description comparison
Attribute aliasing/mapping between data sets (ex. Units of measure, manufacturer and inventory location descriptions)
Alteryx Output immediately ready for Cerner upload (formatted per Cerner specifications)
Forecasting tools optimize staffing and purchasing and expected budget/reimbursement
Repeatability: Workflows used for client monitoring, controlling, and optimization initiatives without any ‘touches’
Repeatability: Existing RRHC Workflows leveraged between clients for technical audits, data file preparation, and reporting with limited changes
1 Provider preference cards are ‘recipes’ for a given surgical procedure, based on a physician’s ‘preference’ for certain instruments, supplies, equipment, as well as instructions for room, staff, and patient preparation and additional needs. We also use Alteryx extensively ensuring continuous improvement of pref cards and comparing outcomes and cost between different providers performing the same procedure, while having different ‘preferences’.
Cerner Revenue Cycle
Patient billing functions may be within Cerner or commonly interfaced to another system. RRHC optimizes the integration from
Supply Chain -> Cerner -> Rev Cycle
Review of historical supply usage, comparing charges with reimbursement
Analysis of client’s internal policies, industry best practices.
- Regulations in comparison with the Charge Master.
‘What-if’ simulations demonstrate the potential charge gain/loss based on a given charging model mark-up schedule, proposed policy changes, and forecasted clinical activity
Repeatability: Workflows used for client monitoring, controlling, and optimization initiatives without any ‘touches’
Repeatability: Existing RRHC Workflows utilized between clients without any needed changes
Red Rock Healthcare has assisted multiple organizations transition from Cerner to the Epic platform. This transition typically occurs due to M&A activity, corporate/leadership strategic and/or technical justification.
Clinical Order Reconciliation: Prevent duplication while remaining comprehensive and/or following new policies/standards for all Orders when converting the Order Catalog.
Provider Preference Cards:
- Item Master review
- Pref Card Pick List Item Analysis
- Reformatting of Cerner Pick Lists to Epic upload formal
Understanding (audit) of the variances between data sources, what was added, removed, and retained
Reproducible Workflows provide a means for us to replace our data sources, while leveraging our earlier work
RRHC Solutions get ‘smarter’ by leveraging previous clients’ data and results
DELIVER QUALITY CARE, CONTAIN COSTS, AND IMPROVE EFFICIENCY
The healthcare industry has been undergoing significant changes for decades. A combination of factors have, however, accelerated the pace of change, including government initiatives to increase access to care, value-based payment models, greater consumer involvement in healthcare purchase decisions and digitization of healthcare information. With change has come a flood of data, and increasing expectations from decision makers for analysis and one single view of the patient, overwhelming the IT organizations of many providers and insurers.
By connecting to, cleansing, and joining all relevant data — clinical, insurance, demographic, and more — regardless of system or format
By analyzing local healthcare service needs and existing infrastructure availability based on location and patient data
By reporting & sharing relevant patient history and care data among all healthcare providers
With on-time reporting by significantly reducing the time required to prep and blend data from all sources
Gain a complete view of your insurance clients by accessing and blending clinical, business and operational data; optimize operations and client services such as call center support based on resource utilization and member preferences; track and monitor client insurance costs across states and programs for future insurance premium adjustments;
assess cost of service and quality by providers for relationship renewals, contract negotiations.
Get a complete view of patient health history by accessing and blending all relevant clinical data, from your internal systems and those of partners; optimize quality and range of healthcare service offerings based on local population needs; forecast future workforce requirements by analyzing utilization patterns by facility & time of the year; evaluate partners (such as pharmacies, physicians, imaging services providers) performance based on quality and cost of service; and assess financial and operational risks of regulation changes, while complying with regulatory requirements.