170 likes | 255 Views
State Based Build. 2008 PPM User Conference. NSW Implementation. David Perabo, Clinical Costing Manager. Agenda. History Process Methodology Standardisation Questions. NSW Area Health Services. History. 1990’s Trendstar 2000 Statewide Solution started
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