Developing the ISPRM registry of rehabilitation disaster relief experts Jan D. Reinhardt, PhD; James E. Gosney, MD; Andrew J. Haig, MD; & Jian’an Li, MD Background • Natural disasters => new disabilities and existing disabilities • Physical Rehabilitation required • However, rehabilitation perspective often underdeveloped in disaster settings • Scarcity of existing rehab resources and professionals make external/international assistance necessary Background (continued) • However: • How identify deployable experts – with expertise in disaster rehabilitation – best suited to the setting in question? • => Database of rehabilitation professionals with expertise in disaster relief including Physical and Rehabilitation Medicine (PRM) • WHO DAR-ISPRM collaboration plan 20112013 Background (continued) • “ISPRM will, moreover, compile a database of international experts for PRM in disaster relief, which may provide a PRM professional volunteer team when it is needed in any region of the world. • In that ISPRM will closely collaborate with relevant NGOs, other academic organizations and WHO offices”. (WHO-DAR/ISPRM 2011) Objective • Establish a database of PRM/rehabilitation experts in natural disaster that can be used to identify deployable individuals/teams in the case of international disaster International Disaster UN/WHO Deployment of rehab experts/teams Agency/NGO responsible for disability & rehab ISPRM disaster rehab experts’ database What is a database? • More than a survey … • “A database is an organized collection of data. The data is typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies).” See: http://en.wikipedia.org/wiki/Database What is a database? - continued Functions: • Input (forms like surveys etc.) • Storing (protected server, backups, etc.) • Retrieving (search masks, structured requests) • Managing information (update, modify, aggregate, etc.) What is a database? - continued Database Management System (DBMS), e.g. SQL: • • • • Data definition Update Retrieval Administration ISPRM – Rehab Disaster Experts DB Data definition: • Variables – Needs of end-user … – Relevant info for monitoring ISPRM – Rehab Disaster Experts DB • Variables – Demographics • • • • • • • • • • Name (surname, first) Gender Date of birth Country(ies) of citizenship Country of residence Religion Contact information (phone, e-mail, address) Hospital and/or university affiliation(s) Current position(s) Professional rehabilitation organization affiliation ISPRM – Rehab Disaster Experts DB • Variables – Professional qualifications • Emergency training qualification • Disaster training qualifications • Medical/specialty qualifications – – – – MD (If yes, years of experience) PRM residency qualification (if yes, years of experience) Registration Licensing • Upload CVs, diploma etc. «FMTs will adhere to professional guidelines: all their staff must be registered to practice in home country and have licence for the work they are assigned to by the agency» (WHO-FMT Working Group 2013) ISPRM – Rehab Disaster Experts DB • Variables – Disaster relief qualifications • Disaster experience (up to 10 disasters) • Disaster 1-10 (multiple entries possible) – – – – – – Name of country Type of disaster Date Sponsoring organization Medical role Traumatic disabling conditions treated: » fracture » spinal cord injury (SCI) » amputation, etc. ISPRM – Rehab Disaster Experts DB • Variables – Deployability • • • • • • • • • Clearance by employer Length of time willing to serve Native language(s) English-skills Other language(s) Health restrictions Dietary restrictions (describe) Other deployment considerations (describe) Motivation (Describe reason(s) for registering including your feelings about working with people from different backgrounds) ISPRM – Rehab Disaster Experts DB Data definition: • Relations ISPRM – Rehab Disaster Experts DB Update: • Inserting data: Initial survey of ISPRM membership • Modifying and deleting data: Repeated Surveys, online selfentry of users … • Challenges: Reaching the expert population, correctness/accuracy of information (verification through institutions?) ISPRM – Rehab Disaster Experts DB Retrieval of info: • • • • Search mask Suited to the needs of the end-user Easy to use Practical usefulness of eventual output, i.e. list of deployable experts ISPRM – Rehab Disaster Experts DB Administration: • Registering and monitoring users, enforcing data security, monitoring performance, maintaining data integrity, dealing with concurrency control, and recovering information if the system fails. • Needs ongoing professional programming and monitoring • Needs secure server (https) involving firewalls etc. • Needs ethical statement on data protection • Needs mechanisms for backup Database & Network Disaster Relief Experts Internet FirewallProtected php End-user Web-Server Database Administrator SwiSCIDatabase MySQL ISPRM – Rehab Disaster Experts DB Administration: • Potential links to other existing databases, e.g. CRED natural disaster database, FMT database, ISPRM membership database … Related Projects DART certification UN disab experts, etc.: ISCoS, Other rehab NGOs ISPRM – Rehab Disaster Experts DB Budget: - Infrastructure: - Webserver - Database-server - Firewall, backup system etc. - Database administrator/manager - Programming (sql, html, php), definition of database (2 months) - Development of forms for entry and retrieval (2 months) - Monitoring (1 day per months) - Update (1 day per week) ISPRM – Rehab Disaster Experts DB Outlook/next steps: • Think big, start with small steps • Obtain feedback from responder organizations on variables • Initial ISPRM member survey • Identify institution to host database • Write up grant proposal Thank You!