170 likes | 255 Vues
Learn the history, process, methodology, and standardization of the NSW Area Health Services State-Based Build project. Explore critical issues, challenges, and solutions in clinical costing and general ledger setup.
E N D
State Based Build 2008 PPM User Conference NSW Implementation David Perabo, Clinical Costing Manager
Agenda • History • Process • Methodology • Standardisation • Questions
History 1990’s Trendstar 2000 Statewide Solution started 2001 Development of Statewide Tender (Bearing Point) 2002 Tender Revised (Fujitsu) 2003 3 AHS’s proceed alone 2006 Tender Revised (Deliottes)
History 2007 • SWAHS release Statewide PCS RFT • Clinical Costing Standards Development • State Based Build Development
Critical Issues • Lack of commitment to Clinical Costing • Delays in Hardware Procurement • Development of a State Based Build MDS • Understanding of PPM Modules • General Ledger Set-up • ETVL • Patient Cost Allocation • Report Layer Build
ETVL / Extract MDS • Data Junction mappings • How to maintain Data Integrity across an AHS • Does the Area use an area-wide MRN? • What Validation Rules to apply • Link and Loading Rules • Linking timelines (hours/days) • Create NAPOOS for unlinked records
ETVL / Extract MDS • Need to develop SBB extracts to standardise ETVL • Different Source Information Systems • No uniform dataset/extract • Survey of all AHS revealed • Lack of State-wide Clinical System standards, with the exception of PAS and Pharmacy • Information management naming conventions • HIE & Data management standards and business practices • Some Areas lack clinical feeder system capability to support detailed patient level costing • Confusion about the impacts of eMR on information availability.
General Ledger • Issues less complex due to existing SCOA standards, however: • GL processing required to meet multiple reporting requirements • Cost Centre Definitions • Account Code Definitions • Allocation Statistics • Reclass Rules
General Ledger • There was a lack of consistency in the sourcing of financial data used in costing: • Some AHS extract financial data from the Health Information Exchange (HIE) into costing software • Some AHS extract financial data from Oracle into costing software • Some AHS extract financial data from Oracle into Excel for upload into cost modelling software • The State Based Build project will establish a State-wide standard for the extraction of financial data, from the NSW data warehouse used as the source of financial data.
General Ledger - Reclass Rules • Program Fractions • Creation NHEC reporting entities • S&W adjustments • Cost Offsets/Exclusions • Source feeder system account rollups • Teaching & Research
Patient Cost Allocation • Service Code Definition • Definition of service codes used for Patient Care Areas • Weight selection for Service Codes • Area Mapping – Cost Output weight selection
Rural Health Issues 2008 PPM User Conference PPM Implementation David Perabo, Clinical Costing Manager
Additional Complexities • Small Facilities many Multi-Purpose Services • Absence of Source Feeder Systems • Cost Centres providing multi-purpose functions
Questions David PeraboClinical Costing Manager