Programmer/developer/for A Mental Health Information System (Mhis) Module - Section 2

Programmer/Developer For a Mental Health Information System (MHIS) Module - Section 2   Background: The mental health team is currently working on the integration of mental health into the PHCCs with the provision of support and supervision. The current health information system hence need to be adapted to allow for prescription and control of prescription of the psychotropic and neurological medication lists for humanitarian setting . In addition, the quality of the provided services need to be monitored.    Objectives The objectives of the MHIS is to: Provide guidance on dispensing psychotropic medications Monitor mental health indicators Maintain a list of stakeholders Facilitate mental health team data mining   Duties and Responsibilities: The programmer/developer is expected to conclude the following tasks: Work closely with the IT and the mental health team; Liaise with the IT and mental health team to determine requirements and develop detailed specifications using the general Mental health information system (MHIS) specifications (see appendix 1); Ensure the Integration of the MHIS to the current health information system which is in Arabic, with concurrent use of English on specific interfaces; Design, test and install the different sections of the MHIS; Train end-users on using the new platform    Skills/Qualifications: Knowledgeable and competent in information systems; previous experience on health information system is an added value; Has experience in web applications development; Knowledgeable in the following technologies: C# Java script Backbone.js JQuery Html5 Reporting Excellent verbal and written communication and interpersonal skills; High attention to details; Ensure accuracy of information; Training skills and ability to communicate technical information to non-IT persons; Ensure availability of computer equipment; Use a logical approach to problem solving/analytical skills; Is Flexible and adaptive; Manage time effectively; Experience required: 3 to 5 years Education degree: Bachelor Degree (Master degree is preferable) Field of education: Computer Science, Software Engineering, Computer Engineering, Web Development, or a related field. Languages: Fluent in English and Arabic; French is a plus.    Appendix 1 - General MHIS specifications   A/ MHIS components: 1-Psychotropic Medication management: -          Psychotropic medication management (promotion of the humanitarian list based on doctor specialty, with prescription pattern and medical tests to be monitored, and integration of the drug substitution list) (annex 1)   -          Roster of staff trained on mental health interventions (annex 2)   2-MH quality indicators (annex 3)   3- Special Interface -          For specialized MH NGOs working outside PHCC network: to access MH quality indicators and 4Ws -          List for stakeholders (annex 4) -          Organized Virtual Space to share and back-up files   B/ Main requirements: B/ Main requirements: B1-User management/operational access: The platform should provide different levels of access to functionality and features of the database including but not limited to the following profiles: nurse trained on mhGAP, social worker trained on mhGAP; doctor trained on mhGAP; case manager, psychologist, psychiatrist, community mental health team leader, pharmacist, mhGAP PHCC supervisors, other administrative mental health team members and IT. The access to mental file is restricted to facility level for identified users to ensure confidentiality of sensitive information. Each profile has specific access to edit, modify, validate or read the data. B2-Maintenance access: Log files are needed. Each access is documented in log file. Reading the log files is only accessible for the IT. Management of users and profiles is ensured by the IT. Lists of values used in various variables are updated by IT. All tables should be fully audited for changes and deletions of records and/or values.   B3-Specification development The design must be modular and include scalability of the platform to support the programme’s potential growth in number of beneficiaries and number of locations, as well as flexibility to support new functional requirements. Some changes may occur to the below annexes. Hence a detailed specification document will be developed by the consultant and will be cleared with the mental health team  at the start of the development process.   B4-Training Central training will be provided to around 75 PHCC trained on mhGAP and mental health team. User and technical guides will be produced.   Annex 1: Psychotropic medication management This section is meant to reinforce the control on psychotropic and neurologic medications supported by MOPH (but not on other psychotropic and neurologic medications); there is no check on patient eligibility for medications This section can be entered either from the patient medical file filled by the GP trained on mhGAP or psychiatrist file if the doctor is practicing in the PHCC or as a stand-alone if the doctor is not practicing in the PHCC and the patient is coming with a medical report. 1-Main indicators All patients need to have an ID in the center to be able to take the psychotropic medication from the center. It the doctor is practicing (or not) in the center: enter/retrieve for the patient the date of prescription, diagnosis, doctor LOP registration number, medication name, first time prescription (patient just started on medication for his MH condition), the date and results of blood tests for specific medications, type of center and the pregnancy/breastfeeding status if the patient is a woman If the doctor is not practicing in the center: add also the availability of a medical report Medication name*: the medication name can be selected from a drop list (see appendix 5 – to be provided at a later stage) as a brand name or molecular name (search by part of the name), with its strength, form, daily dosage as per prescription, and duration of treatment Date of prescription*: as per the prescription (dd/mm/yyyy) Diagnosis*: ICD10; it can be searched by part of the name or ICD10 code (appendix 6 – to be provided at a later stage) Doctor LOP registration number*: as per LOP list; in case the LOP registration number is not found, there should be a possibility to add the LOP registration number, the name of doctor, the specialty of doctor and mobile number as per the format of LOP list and to send it to mental health team for validation LOP list (appendix1- to be provided later): it is the list of doctor from the Lebanese Order of Doctors (LOP) of Beirut and of the North; it contains LOP registration number (3 numerical digits followed by “/” followed by a letter in Arabic), name of doctor (last name, first name, father name), specialty of doctor (drop list) and mobile number (8 numerical digest) Doctor practicing in the center*: yes   no First time prescription (mandatory field if the doctor is not practicing in the center)*: Is the patient taking the medication for the first time?  yes   no Availability of a medical report (if the doctor is not practicing in the center) :  yes   no The results of blood tests: specific tests require blood test results to be within specific limits (see appendix 4 - to be provided at a later stage) The date of blood tests:: as per blood test result document (dd/mm/yyyy) Type of center:  outside MOPH/YMCA network,  within MOPH/YMCA network   a referral center (see appendix 6 – to be provided later) Pregnant:  yes   no Breastfeeding:  yes   no   2-Analysis The analysis is based is reinforcing the control on psychotropic medications supported by MOPH (but not on other psychotropic medications) using the following inicators: 1-Doctor -          LOP registration number -          Specialty as per LOP -          Additional training as per MOPH: to be added: mhGAP training -          Practicing in the center 2-Medical report -          For doctor not practicing in the center 3-Medication as per MOPH lists and classifications (could be extended later to ATC classification N03-N07) -          prescription date -          Medication per doctor specialty and ICD10 essential list for chronic medications List for humanitarian list (added to the essential list) Other list -          Mandatory lab test/results -          Type of center -          Generic 5-Patient name -          Not on quarantine list for Lebanese patients 6-Patient age 7-Patient gender -          Female and pregnant or breastfeeding       Annex 2: Roster of staff trained on mental health interventions The roster aims to keep track on the mental health training provided, with a reminder for needed refresher training and possibility to send Monkey surveys Main indicators include: Staff: first name, middle name and last name, Gender, Area of residence, Profession, current position, Email, Phone, training received, readiness for deployment/training Training schedule: dates, training type and description, CME, Reminder date for refresher training Employer: Organization: name, location, phone, email Director: name, phone, email Comments Updated: date, name of staff     Annex 3: Mental health quality indicators There are specific mental health quality indicators (to be provided later) Common Mental health quality indicators for all MHPSS actors include: For persons with mental health (MH) disorders -          # of new consultation -          # of follow-up (FU) consultation -          Number (#) of persons on FU -          # of defaulters with suicide risk or self-harm (person with suicide risk or self-harm not interacting with the service for > 1week) -          # of defaulters with psychosis (person with psychosis not interacting with the service for > 3 months) -          # of persons referred for psychiatric admission -          # of persons referred back from psychiatric hospital For general population (PSS interventions) For NGOs with child protection activities and not reporting using child protection working group indicators -          # of girls and boys benefitting from structured community-based child protection, PSS and life skills programmes For NGOs with protection activities and not reporting using protection working group indicators -          # of individuals enrolled for the first time in life skills activities in community centers -          # of displaced persons and vulnerable individuals engaged in community based activities -          # of individuals in need who benefitted from individualized assistance and services For staff -          # of staff trained on specific MH interventions -          # of staff benefiting from staff care activities       Annex 4: List of stakeholders The list of stakeholders aims at keeping track of stakeholders and activities to which they participated. Main indicators include: -          Stakeholder: Name, type, phone, location -          Focal person: First name, last name, position, phone, email -          Type of involvement with mental health team -          Comments -          Last updated on (date) -          Updated by (name of staff)