Database User Manual
Contents
1. 17 USERS MENU 18 OVEIVIOW 033 sre Gaia UE m a ee ERE Feb ee Nene 18 Loue vcl ted de Aste e ds dbi Apu etos 18 CHANGE PASSWORD MENU 20 m d Se E fas 20 SIBBS c A A M M MC Mu AL 20 INTRODUCTION Using this database The following manual is designed to familiarize new users with the Human African Trypanasomiasis Database interface This manual will focus on the tasks involved with putting together and maintaining the database To move from one menu to another use the list on the left side of your screen Click on a menu to reveal interface associated with that menu To search for a specific topic that you would like information about Use Search at the top of your list view Human African Trypanasomiasis Database Overview The Human African Trypanasomiasis Database is a fully featured web application system that can be used to store and process data entered with the click of a button If you have any questions about using the database refer to the administrator through the contacts provided at the end of every interface Steps 1 To access the database Setup Enter the url i e www artsvisual net pattec 2 Enter the username of the user e g Admin 3 Enter the administrator s password in t2. Flies Trapped Day Horne gt Flies Trapped per Flies Trapped per Day Add New Previous Next 1 4074 Date of Survey Flies Trapped per Day illage P d X 2009 03 10 5 kinishi X 2009 03 09 60 villagei L X 2009 02 14 20 village2 2 X 2009 01 06 1 Webuye Print above Print all Export above Export all lll High Risk 5 Moderate Risk Low Risk Copyright 2009 Email administrator pattec org Phone 254 20 443445 Done To log out click on the logout menu 12 VILLAGE MENU Overview The page provides you with a list of registered villages and their coordinates Steps 1 How to add new village survey data e Click on the add new link This leads you to another page for data entry e Choose or add a country then district after which you write the name of the village e Enter the longitude and latitude e Click the submit button to update the database 2 How to search for a village e Choose the country then district by clicking on them e Click on the search button for display 3 How to print a list of the village data Click on your preference of the two provisions as indicated below e Print above Click on this link to print just the list viewed on that particular page e Print all Click on this link to print a list of all cattle data in all the pages displayed 4 How to export a list of village data Click on your prefer
3. 254 20 443445 Done z To log out click on the logout menu HAT SURVEY MENU Overview This gives you a view of HAT survey data the survey type whether passive hospital or active village the number of infected people the total population and the ensuing probability Steps 1 How to add a new HAT Survey data e Click the add new link which links you to a data entry page e Click on pick date and choose date by clicking on the month and date Click on active or passive Enter infected and the total screened figure Click on the submit button to update the data in the database Click on the reset button to correct a mistake in the data during entry and re enter the data correctly e Click on go back to move to the previous page 2 How to edit or add patient details for a given village or hospital e Click on the number of infected for the village or hospital it leads you to a data entry page e Enter the patients names age gender village HAT type disease status other diseases namely malaria or typhoid which have similar symptoms amp remarks about the patient e Click on the submit button to update the data in the database 3 How to predict risk levels e The probability menu gives the indication of the level of risk of HAT Once the data has been entered the inbuilt model calculates the risk level When the probability column is green low risk yellow medium risk red high risk 4 How to enter a vill
4. AFRICAN TRYPANOSOMIASIS AT DATABASE USER MANUAL Table of Contents INTRODUCTION PEE 3 Using this 3 Human African Trypanasomiasis 3 le ce 3 SLPS EP 3 torem Ee EE 4 OVOrVIOW oT 4 BASELINE DATA 5 OVeEIVIBW ni 5 a 5 SURVEY MENU noob eme tnb tb toner 7 VET VIOW enero po vadit d vtta pad vod pd vo ad 7 MEN 7 CATTLE MENU dh coated itte aste oad aol 9 o crecen bud iM ERE MM i e 9 bad o eR ee arr nae dde thua ud eee are Pere one ded 9 FLIES TRAPPED PER DAY 11 eae oe eee a S m RUM Ae 11 Steps aae e EDI LL M Vereen Det toh T 11 VILEAGE MENU con e GS 13 OQVerVIOW oso vetet o Pu liu be tots d 13 ee Madden um LIO cus nid ee LED ce 13 HEALTH FACILITY MENU eeee 15 L g sh Sen A P E e A E e ud 15 Itl TL m 15 PROBABILITY 17 OVerVIOW 17 P
5. HAT Survey HAT survey sHow 120 All Surveys Search Add New Previous Next 1 70f7 LE of survey Survey Type Hospital 9 4 2009 05 03 Passive hospital 1 67 4588 2009 04 06 Active village1 333 665555 P 2009 04 02 0 gt 2009 03 06 Active village2 30 444 2 X 2009 03 04 Active village 444 6666 P d 2009 03 03 Passive hospital 2 56 789 2 2009 02 04 hospital 1 182 4566 Print Above Print All Export Above Export All 18 High Risk Moderate Risk lil Low Risk Copyright 2009 Email administrator pattec org Phone 254 20 443445 http www artsvisual net pattec modules pattec CATTLE MENU Overview This page presents data collecting from cattle screening surveys It gives an overview of the dates of survey the infected and total screened the village and the ensuing probability Steps 1 How to add new cattle survey data e Click on the add new link This leads you to another page for data entry e Enter the data and submit for database update 2 How to search for any given cattle survey e Enter the village or the date of survey and click the search button for display 3 How to print a list of the cattle data Click on your preference of the two provisions as indicated below e Print above Click on this link to print just the list viewed on that particular page e Print all Click on this link to print a list of all cattl
6. administrator pattec org Phone 254 20 443445 http www artsvisual net pattec modules pattec action change_password fi Pictures Change Password M untitled Paint To log out click the logout menu 20
7. age e Click on pick a village e Click on the respective village from the village list e To search for a village click on the drop down list and pick country which lists all the villages in the country To add a country refer to the village menu Click on country to add new Click on district and then add village Enter the latitude and longitude Click the submit button to update the database 5 How to print a list of the baseline data Click on your preference of the two provisions as indicated below e Print above Click this link to print just the list viewed on that particular page e Print all Click on this link to print a list of all baseline data in all the pages displayed 6 How to export a list of baseline data Click on your preference of the two provisions indicated below upon which a csv file is generated Browse to open with Ms Excel etc e Export above Click on this link to export just the list viewed on that particular page e Export all Click on this link to export a list of all HAT survey data in all the pages displayed J HAT Survey Mozilla Firefox File Edit History Bookmarks Tools Help c Bj Most Visited fj Getting Started A Latest Headlines Cancel Account Survey A http www artsvisual net pattec logout out eB soogle ific North Korea 7 Lucy Wambui Kingangi confirmed you a _ 3 HAT Survey PATTEC HAT Survey Home gt
8. e data in all the pages displayed 4 How to export a list of cattle data Click on your preference of the two provisions indicated below upon which a csv file is generated Browse to open with Ms Excel etc e Export above Click on this link to export just the list viewed on that particular page e Export all To export click on the provided link browse to open with Ms Excel 5 To view many pages scroll the given pages by clicking on either the previous or next links provided ttle Mozilla Firefox Edit View History Bookmarks Tools Help m X e http www artsvisual net pattec logout out Most Visited ff Getting Started Latest Headlines Cancel Account Survey PATTEC Cattle Home gt Cattle Cattle sow 20 search Add Mew Previous Next 1 3of3 n of Survey Infected Total Probability 566 2009 03 11 4444 kinishi 9 4 2009 03 08 56 1000 village2 L 2009 03 04 6677 7567 village1 Print Above Print All Export Above Export all Bl High Risk Moderate Risk lll Low Risk Copyright 2009 PATTEC Email administrator pattec org Phone 254 20 443445 http www artsvisual net pattec modules pattec action cattle lla Firefo untitled Paint 2 07 c To log out click the logout menu 10 FLIES TRAPPED PER DAY Overview This page provides information on fly trappings It provides dates o
9. ect a mistake in the data during entry Click on the reset button and re enter the data correctly 3 How to search for a village e Enter either the year of survey or the village name at the provided text box then click the search button 4 How to print a list of the baseline data Click on your preference of the two provisions as indicated below Print above Click on this link to print just the list viewed on that particular page e Print all Click on this link to print a list of all baseline data in all the pages displayed 5 How to export a list of baseline data Click on your preference of the two provisions indicated below upon which a csv file is generated browse to open with Ms Excel etc e Export above Click on this link to export just the list viewed on that particular page e Export all Click on this link to export a list of all baseline data in all the pages displayed File Edit History Bookmarks Tools Help e x e a http www artsvisual net pattec logout out Y Most Visited fifi Getting Started 8 Latest Headlines Cancel Account Survey Google Home gt Baseline Baseline sHow 20 Add New Previous Next 1 4of4 60 P X 2009 village1 JS X 2009 20 village2 4 X 2009 5 kinishi P X 2009 1 Webuye Print Above Print All Export Above Export All Copyright 2009 PATTEC Email administrator pattec org Phone
10. ence of the two provisions indicated below upon which a csv file is generated Browse to open with Ms Excel etc e Export above Click on this link to export just the list viewed on that particular page e Export all To export click on the provided link browse to open with Ms Excel 5 How to scroll the given pages e Click on the previous or the next links provided 13 File Edit History Bookmarks Tools Help Xx a http www artsvisual net pattec logout out B Most Visited Getting Started Ww Latest Headlines T Cancel Account Survey PATTEC villages Home gt Villages Manage Villages show 20 All Countries s id New Previous Next 1 4074 District Country 5 Webuye Bungoma Kenya J X village2 district 2 Chad P X villagei district 1 Chad JP X kinishi bujumbura Burundi Print above Print all Export above Export all Copyright amp 2009 PATTEC Email administrator pattec org Phone 254 20 443445 Done start My Flies Trapped per Da untitled Paint To log out click on the logout menu 14 HEALTH FACILITY MENU Overview The page provides you with a menu to input names of health facilities and their coordinates Steps 1 How to add new health facility data e Click on the add new link This leads you to another page for data entry e Choose or add a country then district afte
11. f the survey the flies trapped daily FTD the village where the survey was done and the probability Steps 1 How to add new survey data e Click on the add new link This leads you to another page for data entry e Enter the data and submit for database update e Click on the reset button to correct an error and then enter the data correctly 2 How to search for any given FTD survey e Enter the date of survey and click the search button for display 3 How to print a list of the FTD data Click on your preference of the two provisions as indicated below e Print above Click on this link to print just the list viewed on that particular page e Print all Click on this link to print a list of all cattle data in all the pages displayed 4 How to search for existing data on Flies Trapped Per Day e Enter the village name or the date of survey and click on the search button for display 5 How to scroll the given pages e Click on either the previous or next links provided 11 Flies Trapped per Day Mozilla Firefox File Edit History Bookmarks Tools Help O e x e http www artsvisual net pattec logout out G Most Visited fie Getting Started Al Latest Headlines Cancel Account Survey HH BEC NEWS Asia Pacific Rare Koreas yp Lucy Wambui Kingangi confirmed you a J on BBC NEWS Asia Pacific Tensions hig B
12. he blank field next e g Password 4 Click on submit to set up the database Overview The map provides an overview of distribution of the Human African Trypanosomiasis disease in Africa PATTEC Home Mozilla Firefox File Edit View History Bookmarks Tools Help e x e http www artsvisual net pattec Most Visited gt Getting Started Latest Headlines Cancel Account Survey Ci Ci ry mi ry E Countries reporting cases E Countries reporting under 100 cases Countries reporting between 100 8 1000 cases 18 Countries reporting more than 1000 cases E d Copyright 2009 Email webadmin pattec org lt h gt Waiting For www google com To log out click on the logout menu BASELINE DATA MENU Overview This menu provides baseline information on HAT from the different countries The information in this menu include a list of the affected villages the number of people infected and the year the survey was done Steps 1 How to enter data e Click on the add new link e Click on the dropdown list and click on the respective year of the baseline data e Enter the number of the infected people e Click on the village link e Click on the village respective to the baseline data To add a new village refer to the village menu Click on the submit button to update the data in the database 2 How to corr
13. in pattec ort Flies Trapped per Day Graph 2 17 USERS MENU Overview This provides the administrator with a list where they can see the users already created Steps 1 How to create new users e Click on the add new link Upon clicking e Fill in the required entries and e Click the submit button for the system to update the new user 2 How to search for a user e Enter the name and click the search button for display 3 How to print the list of the users Click on your preference of the two provisions as indicated below e Print above Click on this link to print just the list viewed on that particular page e Print all Click on this link to print a list of all cattle data in all the pages displayed 4 Howto export Click on your preference of the two provisions indicated below upon which a csv file is generated Browse to open with Ms Excel etc e Export above Click on this link to export just the list viewed on that particular page e Export all Click on the provided link browse to open with Ms Excel 5 How to scroll the given pages e Click on the previous or the next links provided 18 File Edit History Bookmarks Tools Help x a http www artsvisual net pattec logout out z Google A Most Visited Getting Started 5 Latest Headlines Cancel Account Survey PATTEC Users Home gt Users Users sow Z0 Add New P
14. r which you write the name of the health facility e Enter the longitude and latitude e Click the submit button to update the database 2 How to search for a health facility e Choose the country then district by clicking on them e Click on the search button for display 3 How to search for a health facility e Choose the country then district by clicking on them e Click on the search button for display 4 How to print a list of the health facility data Click on your preference of the two provisions as indicated below e Print above Click on this link to print just the list viewed on that particular page e Print all Click on this link to print a list of all cattle data in all the pages displayed 5 How to export a list of health facility data Click on your preference of the two provisions indicated below upon which a csv file is generated Browse to open with Ms Excel etc e Export above Click on this link to export just the list viewed on that particular page e Export all Click on the provided link browse to open with Ms Excel 6 How to scroll the given pages e Click on the previous or the next links provided 15 x x ty http www artsvisual net pattec Google Most Visited fij Getting Started D Latest Headlines Cancel Survey Ki Facebook 1 Health va Foo Home gt Health Facilty Manage Health Facilty SHOW 20 All Countrie
15. revious Next 1 30f3 J X usernamet Calcol Sewe country admin administrator Administrator Administrator2 admin 4 admin admin Print above Print all Export above Export Copyright 2009 PATTEC Email administrator pattecorg Phone 254 20 443445 http jfwww artsvisual net pattec modules pattec action users To log out click on the logout menu 19 CHANGE PASSWORD MENU Overview This interface provides the administrator the ability to change user passwords Steps 1 How to change the password e Enter the old password e Enter the new password e Verify the new password by entering it again e Submit for database update Change Password Mozilla Firefox File Edit View History Bookmarks Tools Help a d http Jwwiw artsvisual net pattec logout out _ _ x eME ogle B Most Visited 4 Getting Started Al Latest Headlines Cancel Account Survey GGG BBC NEWS Asia Pacific North Korea wy Lucy Wambui Kingangi confirmed you a __ a Change Password B Um NEWS UK Magazine My night PATTEC Change Password Home gt Change Password Change Password Enter your old and new password in the form below to change your password Indicates Compulsary Field Old Password New Password Should be 6 20 characters long and should not contain spaces Verify New Password Copyright 2009 PATTEC Email
16. s All Districte Add New Previous Next 1 Zofz 2 X hospital 2 district 2 Chad J X hospital 1 district 1 Chad Print Above Print all Export above Export All Copyright 2009 PATTEC Email webadmin pattec org Je To log out click on the logout menu 16 PROBABILITY MENU Overview This menu gives an overview of the trend of the situation of HAT in a graph form in a given country over time Steps 1 How to select the surveillance graph Click on a drop down list and click your choice of surveillance i e Active surveillance Human graph Passive surveillance Human graph Cattle prevalence graph Flies Trapped per Day graph 2 How to view a graph e Select the time i e month year country then the district village or hospital and then click GO graph of the general trend for that area is given by a graph spanning a period of 6 months 3 To print the graphs generated click on the print link Probability Mozilla Firefox SQ _ _ 2 Google v G search gt e GP M 7 Bookmarksy 39 P9 Vo E autoril Sendtor Settings PATTEC Probability Home gt Probability Probability Select the surveillance graph you would like to view Graph Passive Surveillance Human Graph Prevalance in Cattle Grapl
Download Pdf Manuals
Related Search