Article Text

Download PDFPDF

The Melbourne East Monash General Practice Database: Using data from computerised medical records for research
  1. Danielle Mazza,
  2. Christopher Pearce,
  3. Lyle R. Turner,
  4. Maria de Leon-Santiago,
  5. Adam McLeod,
  6. Jason Ferriggi and
  7. Marianne Shearer
  1. Department of General Practice, School of Primary Health Care, Monash University, Australia
  2. Department of General Practice, School of Primary Health Care, Monash University, Australia, and Melbourne East General Practice Network, Australia
  3. Department of General Practice, School of Primary Health Care, Monash University, Australia
  4. Department of General Practice, School of Primary Health Care, Monash University, Australia
  5. Melbourne East General Practice Network, Australia
  6. Melbourne East General Practice Network, Australia, and Department of Health and Human Services, Victorian Government, Australia
  7. Melbourne East General Practice Network, Australia, and Gippsland Primary Health Network, Australia
  1. Author address for correspondence: Christopher Pearce, Department of General Practice, School of Primary, Health Care, Monash University, Australia, Melbourne East General Practice Network, Nunawading, Victoria, Australia chris.pearce{at}


The Melbourne East Monash General Practice Database (MAGNET) research platform was launched in 2013 to provide a unique data source for primary care and health services research in Australia. MAGNET contains information from the computerised records of 50 participating general practices and includes data from the computerised medical records of more than 1,100,000 patients. Data extracted are patient-level episodic information and includes a variety of fields related to patient demographics and historical clinical information, along with the characteristics of the participating general practices. While there are limitations to the data that are currently available, the MAGNET research platform continues to investigate other avenues for improving the breadth and quality of data, with the aim of providing a more comprehensive picture of primary care in Australia.

  • health services research
  • general practice
  • Melbourne East Monash General Practice Database (MAGNET)
  • primary care data

Commons license

View Full Text

Statistics from


The availability of general practice data for analysis has the potential to benefit both health outcomes and health services research. The large sample sizes, breadth and uniquely longitudinal nature of the information that is available (e.g. medications used) are attributes not commonly found in other health data sets.1 3 The U.K.’s General Practice Research Database (now part of the Clinical Practice Research Datalink)4 is the largest and most comprehensive source of general practice data in the world. This database is considered the ‘gold standard’ for anonymised longitudinal medical records from primary care. Analysis of these data has resulted in the publication of a large number of studies that have contributed significantly to primary care policy and wider health research and practice.5

In contrast, primary health care in Australia has suffered from a particular lack of research capability to inform both policy and practice.6 8 A fundamental barrier to developing this capability has been the limited access to patient and health services data that could underpin this research.9 Approximately 75% of all medical consultations in Australia take place in general practice, with more than 85% of the population accessing a general practitioner (GP) every year.10 For this reason, access to pooled data represents a significant potential resource.

However, access to general practice data in Australia has been limited. The segregated nature of information systems that are currently being used to collect and store patient records has led to incompatibility between software packages, coding regimes, specific fields collected and privacy policies. Also, general practices, by nature, exist as individual small businesses,11 which makes recruiting individual practices for the purpose of data collection arduous and complex.

In Australia, there are currently only two significant sources of general practice data: Medicare Australia and the Bettering the Evaluation and Care of Health (BEACH) program.12 Data held by Medicare Australia (on behalf of the Australian government) are used primarily for financial administration. Apart from some broad descriptors of the types of consultations being billed (e.g. health assessments or mental health plans), Medicare data do not contain any information about the clinical problems being managed. Also, it is structured around individual GPs, but not practices. In contrast, the BEACH program uses a cross-sectional, paper-based survey to collect data on the characteristics of GPs, GP-patient encounters, and the services and treatments provided. However, BEACH only captures information at the GP level (i.e. GPs describe the care that they have provided) and is limited by its paper-based and cross-sectional design. Again, it is not a whole of practice program. Consequently, there is a need to develop other general practice data sources in Australia that are capable of addressing the limitations inherent in the data sources that are currently available.



Inner East Melbourne Medicare Local (IEMML) was one of the 61 Medicare Locals (primary care organisations) in Australia that were responsible for coordinating and delivering health services at a regional level. IEMML served four municipalities in the South East of Melbourne (Figure 1). In July 2015, Medicare Locals were replaced by larger Primary Health Networks. Consequently, the data services are now held within the Melbourne East General Practice Network (MEGPN) and will be offered to all Primary Health Networks, potentially expanding the footprint.

Figure 1 IEMML catchment area – location of general practices that contribute data to MAGNET (© 2011, IEMML)

The data warehouse underpinning Melbourne East Monash General Practice Database (MAGNET) contains information from the computerised medical records of patients attending general practices located within the region served by IEMML (50 practices have contributed data). Currently, the data warehouse contains data from the computerised medical records of more than 1,100,000 registered patients.

To provide an alternative source of primary health care data in Australia, IEMML collaborated with Monash University to create the MAGNET research platform. It was designed to replace (and improve on) pre-existing systems that provided audit loops for practices, but not a research program. Data were initially collected from the computerised medical records of each practice using one of the commercially available clinical audit tools.13 These were designed for population health reporting focusing on chronic disease. The development of the database was informed by a theoretical framework on data governance at an organisational level.14

Data source and extraction

The extraction of data from general practices involves a number of steps (Figure 2). Initially, participating general practices are asked to sign a consent agreement informing them of the data extraction process and the use of deidentified data in the data warehouse for research purposes. As part of national practice accreditation requirements, practices are also required to inform patients that data collected by the practice may be utilised for quality improvement and research. Individual patients are able to opt out of data collection. Once a practice agrees to participate in the data extraction program, a practice liaison officer visits the practice to install the extraction tool. The extraction process produces an initial encrypted data file, which is sent by secure data transfer from the general practice to MEGPN. Subsequent incremental data extractions are then set to run at defined intervals from the practice.

Figure 2 Procedure for MAGNET data collection

Extraction is facilitated through the use of the GeneRic Health Network Information Technology for the Enterprise (GRHANITE) extraction technology.15 This tool is designed to extract patient-level episodic information across the various medical software programs used by GPs in Australia. GRHANITE™ is an important component of the POpulation Level Analysis and Reporting (POLAR) tool, which primary health networks utilise to provide comprehensive feedback to general practices. This feedback, provided as a report to the practices, combines practice data with local emergency data and local government-level data. The web-based tool and feedback reports developed by MEGPN are offered free of charge to member practices as a quality improvement initiative to assist in monitoring and improving their own clinical governance and population health activities.16 The data available for research are, therefore, a by-product of clinical governance processes within the practice, which is supported and encouraged by MEGPN. Consequently, data quality improvement is a practice-level activity rather than a research project-led activity. The useful feedback of practicerelevant information has been a critical component of uptake of the extraction program.

Creation of MAGNET data warehouse

The MAGNET data warehouse consists of multiple datasets that are aggregated and connected by common data elements. The connection of datasets is performed at a geographic level using postcodes, statistical local areas (SLAs) or local government areas. The data warehouse is gradually moving towards the Australian Bureau of Statistics (ABS) geo-mapping standards17 as more datasets have the capability to map to SLA levels.

The data warehouse has a ‘star structure’ construction, with the ‘fact’ or ‘raw data’ being central to the structure. Dimensions of interest and metrics are then added to the fact tables to incorporate additional information or analysis potential. Data extracts that have been collected from the general practices are then uploaded and processed onto a staging database. Validation and data cleansing are performed during this staging process and only clean, validated data are transferred to the data warehouse. Validation rules are constantly being reviewed to ensure that the data are relevant, and any datum that fails the validation process is quarantined for further analysis.

Data types and limitations

The data extracted from computerised medical records are related to patients and their episodes of care (e.g. patient demographics and historical clinical information). The characteristics of the participating general practices are also collected.

Patient demographics

Patient demographics that have been extracted include date of birth, gender, pension and Department of Veterans Affairs status and location of residence (Table 1). Identifying information related to both patients and the general practices has been excluded to meet privacy concerns.

Table 1 Patient- and practice-level variables that are included in the MAGNET dataset

Clinical information

GRAHNITE™ extracts all data related to the patient’s episodes of care within the practice (Table 1). Specific information about each consultation is also collected (e.g. time and duration of the consultation). For most of these variables, the information is coded using the computerised medical record’s internal coding system, which relies on the GP to select an appropriate option from a predefined list. Other data include diagnoses, reason for encounter, prescribed medications, structured observations, investigations ordered and received, immunisations and many other fields. Understanding the workflow, cognitive load and financial incentives is crucial to understanding the data.

A unique function of GRAHNITE™ is the ability of the software to build a comprehensive set of statistical linkage keys. These linkage keys enable the identification of the same patients at different practices (thus removing patient duplication), which makes the final dataset more representative of the catchment’s population. The linkage keys can also be used to link MAGNET with other datasets when the appropriate ethical considerations have been met. Linking patient records creates a ‘richer’ dataset consisting of a timeline or sequence of health events for a particular cohort of patients. Such information is useful not only for research purposes but also for improving health services and measuring the outcomes of health care programs.

Privacy issues

Privacy of health data is considered paramount, and privacy is built into the data governance protocols. Australian general practices are required as part of their accreditation to give all patients information about their use of health data, including in practice use for quality purposes and potential use for research. MEGPN then enters into an agreement with the practice regarding the use of data. Crucially, data are not used outside the practice without the practice’s consent, and only deidentified data are used outside the practice. Ethics approval has been granted by Monash University for the use of the data.


Principal findings

Data within MAGNET acknowledges a data hierarchy,14 where the data are primarily used to assess quality improvement at both the practice level and the population level and to monitor the activities of primary care services within the region.16 , 18 These data can also be used to support targeted and prioritydriven strategic research in primary care.19 For example, data within MAGNET can be used for research that focuses on improving the quality of care in general practice and optimising primary care practice organisation and health care systems.

Data within MAGNET are currently being analysed for a number of studies. One example is the REDIRECT project, which involves the analysis of general practice data to examine the ‘primary care patient journey’ of older patients who present unnecessarily to hospital emergency departments. Another example is a study examining the utilisation of guidelines for managing overweight and obese patients in general practice.20 Measurable components of the guidelines that are included in the MAGNET dataset (e.g. weight, height and waist circumference) have been analysed to determine the extent to which GPs are currently implementing guideline recommendations. The linkage capability within MAGNET is also currently being used to link local emergency data with patient-level data in general practice, allowing the mapping of the general practice journeys of all patients admitted to the regional emergency departments.

Limitations of MAGNET data

General practice software in Australia is only in its infancy in truly using contained data to inform clinical decisions.21 Decision support in clinical systems not only requires quality data to inform the computational issues but also drives data quality. Decision support is either rudimentary or absent, and therefore remains dormant for both uses. Consequently, there are some limitations to the data within MAGNET. Firstly, the ‘completeness’ of certain variables (e.g. pregnancy information and aboriginality) is an issue. Because the primary use of the data is to inform the clinical care of a patient, only data that serve a clinical purpose have a high degree of validity and reliability. Therefore, items such as aboriginality are not necessarily well recorded.

Aboriginality is a good example of how data quality could drive better outcomes using computerised processes. The Aboriginal population has poorer health outcomes compared to the populace and there are different financial incentives to promote care. Thus, there is a different immunisation schedule for aboriginal children, for instance. If aboriginality is recorded in the system, the Electronic Medical Record can promote correct care and encourage use of financial incentives. As an example, the activities of MEGPN (and IEMML) during 10 years of practice improvement with the clinical governance program (prior to the formation of MAGNET) have increased the reliability around examples such as diabetes.

Secondly, data quality may be reduced because computerised medical records are often stored in many different computer systems, some of which use different coding terminologies and structures including non-standards-based terminologies. Each clinical information system has its own database structure and can record the same category of information in different parts of the software (e.g. diagnoses can be in a summary section, part of the consultation notes, or entered as a ‘reason for encounter’). This structure and appearance can influence data collection.22 , 23 Additionally, the encounter or consultation details that have been extracted are limited because of the interaction between different clinical and billing systems in some practices. Even the data extraction process itself may be fallible.24


Kaiser Permanente, a U.S.-based healthcare provider, is widely regarded to have one of the best clinical governance programs,25 but it is based on using a single clinical system and a fee structure reliant on clinical coding. This is not replicable at any significant level in Australia. Other programs rely on extractions without necessarily providing the data quality program. The closest parallel to MAGNET is probably the UK’s PRIMIS project,26 which is a data quality program with similar foundations. However, none necessarily combines the data quality program with a comprehensive research outlook.


The development of the MAGNET research platform contains many lessons for others considering similar programs. In developing expertise in combining disparate clinical systems while sitting at the juncture of clinical governance and clinical research, MAGNET bridges many of the issues experienced in other platforms. Its increased use of data linkage across primary care and secondary care will continue to breakdown the silo problems that bedevil other similar platforms.

Similarly, research involving data requires extensive work within a project to ensure data consistency and quality; otherwise, it is difficult to ensure that the results are both reliable and valid.27 A key point of difference with the MAGNET research platform is in combining all the above issues.

The POLAR program allows flexible, tailored clinical governance programs to be delivered with the ‘unintended’ consequence of improving data quality across a range of systems and with due understanding of both the social and structural sources of data. By targeting practices within the area of a general practice support organisation, the program can be effectively replicated across the country, maintaining the population concentration whilst widening the geographical spread. This then represents a practical opportunity to unlock the potential of routine data for quality research.


The MAGNET research platform is the only source of routinely collected GP data in Australia with a regionally representative focus. Its availability for use in research is unique, which in conjunction with a program of tailored clinical governance programs, contributes to improving data quality across a range of systems. The nature of the practice recruitment, based around a central general practice support organisation, implies that MAGNET can be effectively expanded across the country. This represents a practical opportunity to unlock the potential of routine data for quality research.


The MAGNET research platform is supported by funding from the Faculty of Medicine, Nursing and Health Sciences at Monash University and MEGPN.


  1. 1.
  2. 2.
  3. 3.
  4. 4.
  5. 5.
  6. 6.
  7. 7.
  8. 8.
  9. 9.
  10. 10.
  11. 11.
  12. 12.
  13. 13.
  14. 14.
  15. 15.
  16. 16.
  17. 17.
  18. 18.
  19. 19.
  20. 20.
  21. 21.
  22. 22.
  23. 23.
  24. 24.
  25. 25.
  26. 26.
  27. 27.
View Abstract


  • Declaration of conflicting interests The authors declare that they have no conflicts of interest.

Request Permissions

If you wish to reuse any or all of this article please use the link below which will take you to the Copyright Clearance Center’s RightsLink service. You will be able to get a quick price and instant permission to reuse the content in many different ways.