Details about each of the patients will need to be stored on a computer system that is safe; these details will be processed so appointments and treatments can be processed. Complex details will be needed for each patient, for example their address, allergies, current prescriptions. These details can then be linked to each appointment made by the particular customer. These details will be taken into consideration when doctors are prescribing medicines and treatments and may be output on screen and in the form of paper printout prescription slips.
Millfield Medical Centre may also want to output reports illustrating different factors, for example they may be reports for appointment details. The company will also need to organise stock levels in the form of medicines, the details will be generated in a computer system and then output in a report. As with most companies the employee records will need to be organised efficiently on a computer system. This will involve their address and personal details so they can be contacted and so that they receive any necessary pay.
Their timetables will be organised and processed so that appointments link in and staff pay can be calculated. ICT system Although the company uses varies systems to efficiently organise information, the main ICT system used within Millfield Medical Centre is a database system. The database enables patient, appointment, prescription and employee records to be stored in a table. A database stores data within tables; these can be linked together in a relational database format. It can be used to create forms, calculations, reports, queries and a menu.
The data can compromise of a variety of numbers and words and this ensures that all the different types of data used in Millfield Medical Centre are stored in one collective place. These records will include details about each individual patient, for example address and telephone number so they can be contacted. These patient details will be linked to details about each prescription that is made, therefore enabling effective, safe care as aimed for in the mission statement. The patient’s medical details will also need to be in depth so they can assist doctors when they are being seen in an appointment.
For each appointment the details such as date and time will need to be linked to the patient information including the prescription records, and also the doctor’s timetables. This meets the data handling needs, as it is essential that appointments can be organised so that the company is providing the service it aims to. As the appointments will need to be linked to employee availability this will also ensure that the hours staff have worked will be recorded. This can be processed within the computer and then be output in the form of payrolls or reports.
This data is all stored within a safe system that enables Millfield Medical Centre to easily search and use data that is relevant to the company. With use of an electronic database it helps staff when ensuring the data handling needs are met, as all of the relevant details are processed in an organised manner. The database helps the company use the data; it can be accessed, managed, used and updated when needed. Data of all aspects of the company can be easily searched for and linked together.
The mission statement for ‘Effective care, well delivered’ is met as the system ensures relevant staff can see patients and that the organisation of their care is well delivered.
(2007) Avaliable at: <http://www. andrewsavory. com/blog/images/sainsburys_checkout. jpg> (Accessed 17 December 2007) – Used to find image of checkout barcode reader within Sainsbury’s supermarket. This illustrated what the tills system is.
How Sainsbury’s is preparing for new Data Protection Act (1999) Available at: <http://www.worldlii. org/int/journals/PLBIN/1999/33. html> (Accessed 13 December 2007) – Used to see size of Sainsbury’s structure (e. g. 178 000 staff). This demonstrated how large the company was and that it was commercial. J Sainsbury plc (2007) Available at: ;http://www. jsainsburys. co. uk; (Accessed 06 December 2007) – Used to find information about history, goals etc. This was helpful for background into the company and learning about their size. I also used this website to copy the Sainsbury’s company logo.
Millfield Medical Centre (2007) Avaliable at: <http://www. millfieldmedicalcentre. nhs. uk/tpct/services/primary_care/gp_portal/millfield/default. asp> (Accessed 10 December 2007) – Used to research history and find information about employees. There was also the NHS logo, which I used to illustrate that the medical centre is a NHS public service. Sainsbury’s Case Study (2007) Available at: ;http://www. bized. co. uk/compfact/sainsbury/sainsindex. htm; (Accessed 06 December 2007) – Used to research history and find out the mission statement.