nsw implementation 2008 ppm user conference david perabo, clinical costing manager state based build
TRANSCRIPT
![Page 1: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/1.jpg)
NSW ImplementationNSW Implementation
2008 PPM User Conference2008 PPM User Conference
David Perabo, David Perabo, Clinical Costing ManagerClinical Costing Manager
State Based BuildState Based Build
![Page 2: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/2.jpg)
Slide 2 PowerHealth Solutions 2008 Conference
AgendaAgenda
1.1.History History
2.2.ProcessProcess
3.3.MethodologyMethodology
4.4.StandardisationStandardisation
5.5.QuestionsQuestions
![Page 3: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/3.jpg)
Slide 3 PowerHealth Solutions 2008 Conference
NSW Area Health Services
![Page 4: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/4.jpg)
Slide 4 PowerHealth Solutions 2008 Conference
HistoryHistory
1990’s1990’s TrendstarTrendstar
20002000 Statewide Solution startedStatewide Solution started
20012001 Development of Statewide Development of Statewide Tender (Bearing Point)Tender (Bearing Point)
20022002 Tender Revised (Fujitsu)Tender Revised (Fujitsu)
20032003 3 AHS’s proceed alone3 AHS’s proceed alone
20062006 Tender Revised Tender Revised (Deliottes)(Deliottes)
![Page 5: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/5.jpg)
Slide 5 PowerHealth Solutions 2008 Conference
HistoryHistory
2007 2007
SWAHS release Statewide PCS SWAHS release Statewide PCS RFT RFT
Clinical Costing Standards Clinical Costing Standards DevelopmentDevelopment
State Based Build DevelopmentState Based Build Development
![Page 6: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/6.jpg)
Slide 6 PowerHealth Solutions 2008 Conference
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-upETVLPatient Cost AllocationReport Layer Build
![Page 7: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/7.jpg)
Slide 7 PowerHealth Solutions 2008 Conference
ETVL / Extract MDS
Data Junction mappingsHow to maintain Data Integrity across an AHS
Does the Area use an area-wide MRN?
What Validation Rules to apply
Link and Loading RulesLinking timelines (hours/days)Create NAPOOS for unlinked records
![Page 8: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/8.jpg)
Slide 8 PowerHealth Solutions 2008 Conference
ETVL / Extract MDS
Need to develop SBB extracts to standardise ETVL
Different Source Information Systems
No uniform dataset/extract
Survey of all AHS revealedSurvey of all AHS revealedLack of State-wide Clinical System standards, Lack of State-wide Clinical System standards, with the exception of PAS and Pharmacywith the exception of PAS and Pharmacy
Information management naming conventionsInformation management naming conventions
HIE & Data management standards and business HIE & Data management standards and business practicespractices
Some Areas lack clinical feeder system capability Some Areas lack clinical feeder system capability to support detailed patient level costingto support detailed patient level costing
Confusion about the impacts of eMR on information Confusion about the impacts of eMR on information availability.availability.
![Page 9: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/9.jpg)
Slide 9 PowerHealth Solutions 2008 Conference
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
![Page 10: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/10.jpg)
Slide 10 PowerHealth Solutions 2008 Conference
State Based COA Setup
AccAcc_Code Desc Account Rollup 1
Account Rollup 2 Cost Input Cost Output 1 Cost Output 2
% Fixed
E 15000Payments to VMOs
Payments to VMOs
Payments to VMO's
Payments to VMOs
Payments to VMOs
Payments to VMOs 100
E 15010Payments to VMOs - FFS
Payments to VMOs - FFS
Payments to VMO's
Payments to VMOs - FFS
Payments to VMOs - FFS
Payments to VMOs - FFS 100
E 15020Payments to VMOs - Rural
Payments to VMOs - Rural
Payments to VMO's
Payments to VMOs - Rural
Payments to VMOs - Rural
Payments to VMOs - Rural 100
E 15030Payments to VMOs - Sess
Payments to VMOs - Sess
Payments to VMO's
Payments to VMOs - Sess
Payments to VMOs - Sess
Payments to VMOs - Sess 100
E 21000 Drugs DrugsGoods and Services Drugs Drugs Drugs 100
E 21010Drugs - Medical Gases
Drugs - Medical Gases
Goods and Services
Drugs - Medical Gases
Drugs - Medical Gases
Drugs - Medical Gases 100
E 21020 Drugs DrugsGoods and Services Drugs Drugs Drugs 100
E 22000Med & Surg Supplies
Med & Surg Supplies
Goods and Services
Med & Surg Supplies
Med & Surg Supplies
Med & Surg Supplies 100
E 22010 Imaging ImagingGoods and Services Imaging Imaging Imaging 100
E 22020 Imaging ImagingGoods and Services Imaging Imaging Imaging 100
E 22030 Pathology PathologyGoods and Services Pathology Pathology Pathology 100
E 22040 Prostheses ProsthesesGoods and Services Prostheses Prostheses Prostheses 100
E 22050 Special Services Special ServicesGoods and Services Special Services Special Services Special Services 100
![Page 11: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/11.jpg)
Slide 11 PowerHealth Solutions 2008 Conference
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 softwareSome AHS extract financial data from Oracle into costing softwareSome 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.
![Page 12: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/12.jpg)
Slide 12 PowerHealth Solutions 2008 Conference
General Ledger - Reclass Rules
Program Fractions
Creation NHEC reporting entities
S&W adjustments
Cost Offsets/Exclusions
Source feeder system account
rollups
Teaching & Research
![Page 13: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/13.jpg)
Slide 13 PowerHealth Solutions 2008 Conference
Patient Cost Allocation
Service Code DefinitionDefinition of service codes used for Patient Care Areas
Weight selection for Service CodesArea Mapping – Cost Output weight selection
![Page 14: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/14.jpg)
PPM ImplementationPPM Implementation
David Perabo, David Perabo, Clinical Costing ManagerClinical Costing Manager
Rural Health IssuesRural Health Issues
2008 PPM User Conference2008 PPM User Conference
![Page 15: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/15.jpg)
Slide 15 PowerHealth Solutions 2008 Conference
Greater Western AHS
![Page 16: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/16.jpg)
Slide 16 PowerHealth Solutions 2008 Conference
Additional Complexities
Small Facilities many Multi-Purpose Services
Absence of Source Feeder Systems
Cost Centres providing multi-purpose functions
![Page 17: NSW Implementation 2008 PPM User Conference David Perabo, Clinical Costing Manager State Based Build](https://reader035.vdocuments.us/reader035/viewer/2022062312/551a3ca55503463e778b4d9b/html5/thumbnails/17.jpg)
Slide 17 PowerHealth Solutions 2008 Conference
Questions
David PeraboDavid PeraboClinical Costing ManagerClinical Costing Manager