Related Experiment Video
Updated: Nov 28, 2025

TBase - an Integrated Electronic Health Record and Research Database for Kidney Transplant Recipients
Published on: April 13, 2021
A relational database within the Leg Club Network: an audit
Neil McIntyre1, Anna Milena Galazka2,3,4, Ellie Lindsay4,5,6
1Trustee, The Lindsay Leg Club Foundation, Ipswich, UK.
Abstract:
The growing prevalence of venous leg ulcers in an ageing population presents challenges for wound care and management. The Lindsay Leg Club model is an alternative approach to the management of leg health that can improve patient outcomes. This article reports on an audit of a relational database located within the Leg Club Network, containing records of more than 17 000 patients (known as members) who attended a Leg Club in a 5-year period (2014-2019). Overall, over 266 000 member leg assessments and treatments were entered into the database. The average nurse-member attendance time was 28 min, with a skill mix of 23% senior nurses, 70% qualified and associate nurses, and 7% nurses in supervisory roles. Healing rates averaged 62% after 12 weeks. Recurrence rates were 20% after 12 weeks. Annual clinical and volunteer hours averaged 821 and 800 h, respectively. Staffing costs were £28 per wound treatment or leg assessment with a typical duration of 27 min; 71% of members were aged 70 to 94 years old, which indicates the need for a service that caters to the specific requirements of this age group. However, no data on psychosocial and well-being outcomes were recorded. Their inclusion in further developments of this database is recommended.
More Related Videos
07:26Executing Complexity-Increasing Queries in Relational MySQL and NoSQL MongoDB and EXist Size-Growing ISO/EN 13606 Standardized EHR Databases
Published on: March 19, 2018
11:21Methodology for Establishing a Community-Wide Life Laboratory for Capturing Unobtrusive and Continuous Remote Activity and Health Data
Published on: July 27, 2018
Related Concept Videos
Data Reporting and Recording
ER Retrieval Pathway
The ER uses many checkpoints to prevent the entry of incorrectly folded or a resident protein as cargo onto a transport vesicle. These mechanisms...
Types of Records II: Educational and Administrative Records
Differential Relays
Nursing Clinical Information System
A Nursing Clinical Information System (NCIS) is a specialized type of healthcare information system tailored to meet the unique needs of nursing practice. It incorporates the principles of nursing informatics to streamline information management and improve the quality of care delivery.
Critical attributes of NCIS include:
Distribution Reliability and Automation