Warehousing In Healthcare
Healthcare Industry
Background
Comparing the evolution of changes of data warehousing in healthcare industry in the early 90’s where patient’s records were written down in hardcopies and were filed accordingly to alphabetical orders in their registry, in the result when retrieving of data could wait up to as long as 30 days and lots of space had been taken out for storing these papers.
In the 20’s they came out individual system such as EMR, e-CRM, e-pharmacy, etc to keep track of various data in their system although retrieving of data had greatly improved but still not effective due to records that had been found are required to print out and delivery by hands to the respective health professional. (Cited http://www.himssanalytics.org/docs/wp_emr_ehr.pdf, 20 June 2011)
Solution …show more content…
To further enhancement the healthcare data warehouse, by using the SAP Netweaver 2004s they implemented the Collaborative Health Network (CHN) also known as the eHealth which currently used in USA, Canada, South America, Europe and Asia. Depending on the network setup; public health agencies, pharmacies, private & government clinic or even global hospital could link up to through this system (Fig 2.1).
Fig 2.1
Fig 2.1
How it works
The primary function of this system is patients information are instantaneously updated and shared amongst all participating facilities to through Master Patient Index (MPI), Electronic Health Record (EHR) and it’s security is secured by Health Professional Index (HPI) (Fig 2.2).
1) The Master Patient Index (MPI) contains demographic data about a patient: name, aliases, age, affiliation, addresses, known IDs, and insurance data. Anything that can assist in identification is in the MPI. The MPI consolidates all your information across the network, to ensure no duplication and one unique clinical history that will be saved in EHR.
2) The Electronic Health Record (EHR) is where CHN stores summarized data about the clinical encounter history of the patients, irrespective of the type of encounter (ambulatory, inpatient stay, GP visit, phone consultation, and so on).
3) The Health Professional Index (HPI) is the location for all data on doctors, nurses, admissions clerks, and so on. This is where security levels are set, to define which health professional could access the level of data. For instance, an admissions clerk can only access the MPI data, not the clinical information that is stored in the EHR. HPI could also use as directory, by gathering a list of doctors and facilities in a particular location, to provide a better direction for the patient.
Fig 2.2
Fig 2.2
Benefits
The idea of CHN allows all various healthcare systems around the facilities to communicate together and share patient’s information as a data warehouse. It also provides a system link to various networks of its organizations in any part of the country to share the information, so that in any point of time CHN will provide all patient’s data immediately even when you lost conscious. With this system, healthcare professionals could have better treatment while the cost is being controlled.
Fig 2.3
Fig 2.3
References
Anon, SAP Community Network Wiki - Enterprise Services WIKI - Foundation for Collaborative Health Networks. Available at: http://wiki.sdn.sap.com/wiki/display/ESpackages/Foundation+for+Collaborative+Health+Networks [Accessed June 19, 2011].
Anon, 1997.
Data warehousing in healthcare: what is it and why do it? Available at: http://findarticles.com/p/articles/mi_m0DUD/is_n2_v18/ai_19197105/?tag=mantle_skin;content [Accessed June 19, 2011].
Anon, Electronic health record - Wikipedia, the free encyclopedia. Available at: http://en.wikipedia.org/wiki/Electronic_health_record [Accessed June 28, 2011].
Anon, SAP - Accenture and SAP to Team on New Collaborative Health Network Solution. Available at: http://www.sap.com/press.epx?pressID=6750 [Accessed June 28, 2011].
Andy David_Towards Sustainable Healthcare System.pdf. Available at: http://www.sap.com/singapore/about/events/bestOfSummit08/Final%20Presentation%20-%20Breakout/Room%20202/Best%20Practices/Andy%20David_%20Towards%20Sustainable%20Healthcare%20System.pdf [Accessed June 20, 2011].
Dave Garets and Mike Davis, 2006 – Electronic Medical Records vs. Electronic Health Records. Available at: http://www.himssanalytics.org/docs/wp_emr_ehr.pdf [Accessed June 20, 2011].
Anon, EMR vs EHR – What is the Difference? | Health IT Buzz. Available at: http://www.healthit.gov/buzz-blog/electronic-health-and-medical-records/emr-vs-ehr-difference/ [Accessed July 2,
2011].
Background
Comparing the evolution of changes of data warehousing in healthcare industry in the early 90’s where patient’s records were written down in hardcopies and were filed accordingly to alphabetical orders in their registry, in the result when retrieving of data could wait up to as long as 30 days and lots of space had been taken out for storing these papers.
In the 20’s they came out individual system such as EMR, e-CRM, e-pharmacy, etc to keep track of various data in their system although retrieving of data had greatly improved but still not effective due to records that had been found are required to print out and delivery by hands to the respective health professional. (Cited http://www.himssanalytics.org/docs/wp_emr_ehr.pdf, 20 June 2011)
Solution …show more content…
To further enhancement the healthcare data warehouse, by using the SAP Netweaver 2004s they implemented the Collaborative Health Network (CHN) also known as the eHealth which currently used in USA, Canada, South America, Europe and Asia. Depending on the network setup; public health agencies, pharmacies, private & government clinic or even global hospital could link up to through this system (Fig 2.1).
Fig 2.1
Fig 2.1
How it works
The primary function of this system is patients information are instantaneously updated and shared amongst all participating facilities to through Master Patient Index (MPI), Electronic Health Record (EHR) and it’s security is secured by Health Professional Index (HPI) (Fig 2.2).
1) The Master Patient Index (MPI) contains demographic data about a patient: name, aliases, age, affiliation, addresses, known IDs, and insurance data. Anything that can assist in identification is in the MPI. The MPI consolidates all your information across the network, to ensure no duplication and one unique clinical history that will be saved in EHR.
2) The Electronic Health Record (EHR) is where CHN stores summarized data about the clinical encounter history of the patients, irrespective of the type of encounter (ambulatory, inpatient stay, GP visit, phone consultation, and so on).
3) The Health Professional Index (HPI) is the location for all data on doctors, nurses, admissions clerks, and so on. This is where security levels are set, to define which health professional could access the level of data. For instance, an admissions clerk can only access the MPI data, not the clinical information that is stored in the EHR. HPI could also use as directory, by gathering a list of doctors and facilities in a particular location, to provide a better direction for the patient.
Fig 2.2
Fig 2.2
Benefits
The idea of CHN allows all various healthcare systems around the facilities to communicate together and share patient’s information as a data warehouse. It also provides a system link to various networks of its organizations in any part of the country to share the information, so that in any point of time CHN will provide all patient’s data immediately even when you lost conscious. With this system, healthcare professionals could have better treatment while the cost is being controlled.
Fig 2.3
Fig 2.3
References
Anon, SAP Community Network Wiki - Enterprise Services WIKI - Foundation for Collaborative Health Networks. Available at: http://wiki.sdn.sap.com/wiki/display/ESpackages/Foundation+for+Collaborative+Health+Networks [Accessed June 19, 2011].
Anon, 1997.
Data warehousing in healthcare: what is it and why do it? Available at: http://findarticles.com/p/articles/mi_m0DUD/is_n2_v18/ai_19197105/?tag=mantle_skin;content [Accessed June 19, 2011].
Anon, Electronic health record - Wikipedia, the free encyclopedia. Available at: http://en.wikipedia.org/wiki/Electronic_health_record [Accessed June 28, 2011].
Anon, SAP - Accenture and SAP to Team on New Collaborative Health Network Solution. Available at: http://www.sap.com/press.epx?pressID=6750 [Accessed June 28, 2011].
Andy David_Towards Sustainable Healthcare System.pdf. Available at: http://www.sap.com/singapore/about/events/bestOfSummit08/Final%20Presentation%20-%20Breakout/Room%20202/Best%20Practices/Andy%20David_%20Towards%20Sustainable%20Healthcare%20System.pdf [Accessed June 20, 2011].
Dave Garets and Mike Davis, 2006 – Electronic Medical Records vs. Electronic Health Records. Available at: http://www.himssanalytics.org/docs/wp_emr_ehr.pdf [Accessed June 20, 2011].
Anon, EMR vs EHR – What is the Difference? | Health IT Buzz. Available at: http://www.healthit.gov/buzz-blog/electronic-health-and-medical-records/emr-vs-ehr-difference/ [Accessed July 2,
2011].