We have completed the development of a complex data capture system for a collaborative project between a leading UK university and member of the Russell Group and one of the largest NHS Trusts within the UK. The system utilises Microsoft InfoPath, Microsoft SQL Server and Microsoft SharePoint Server 2010 Foundation to provide a simple yet comprehensive data entry system for clinical data and subsequent secondary use by academic researchers.
As part of the development, we have redesigned the customary mannequin model for collecting information on tender and swollen joints, the basis for the targetting of intervention and medication for rheumatological and musculskeletal diseases.
The changes we made allowed the collection of swollen and tender joint information as well as RAI scores. The system is capable of automatically calculating the swollen, tender and RAI totals as well as using information from elsewhere in the data collection form to determine the Disease Activity Scores. This all takes place on the form, allowing the clinician and/or nurse to have immediate access to information upon which to base future care and interventions. This information is also available in an anonymised form for medical researchers and forms part of the patient pathway.
Each joint is assessed by the clinician and the results recorded by selecting pre-determind values within a drop down box. The value of these drop down boxes is linked to a custom list held elsewhere within the same SharePoint site collection which can be updated by non technical members of staff. The form is instructed to download any updates to the list on loading, but also stores a local copy of the data to allow the form to be used away from the network.
Single or multiple user licences for this and other Microsoft InfoPath forms are available via our online shop.
