ChildHood Headache

1. ChildHood Headache Database User Guide September 2010

2. Welcome to www.childhoodheadache.org

3. While this web site gives medical information about childhood headache,it can also record patient medical information in database. Click Database Icon

4. For security an authentication window is used. Type your UserName Type your PassWord

5. Welcome to childhood headache database form

6. There are four different type of panels in this form Functional Panel Plain Panel Detail Panels Chart Panel

7. Functional Panel Functional Panel consists function icons in order to do database actions New icon Save icon Search icon Report icon Export icon New empty form for a patient who never came before to your medical center Shows current patient’s data in a PDF file format that can be print out Opens a window to find patients whose data is recorded before Opens a window in order to export patients’ data to SPSS Saves patient data in database

8. Plain Panel Plain Panel consists three different type of boxes Combo boxes Edit boxes Check boxes By clicking combo box list of items are opened in which patient’s data can be typed by keyboard By clicking check boxes items can be selected

9. Detailed and Chart Panel Detail Panels are used for patient’s tabular data. Not Filled Filled Chart Panel consists data of Detail Panel

10. Explanation of some edit boxes fields Edit boxes • Edit Boxes are fields in which two types of data can be typed. • Text : Any text can be typed in a field because texts do not affect statistics. • Number : Just one number can be typed in a field because a number affects statistics.* If a number value may not represent a field because it has minimum and maximum values, mean of the value should be type in the field. Typing numbers like “1-4” or “1,2,4” or “1.2.4” are incorrect.* Different countries use different decimal number separators. One of the decimal number separators - comma “,” or dot “.” - should be used.

11. Personal Identification Number: A unique number assigned for one patient. This number may include letters as well.

12. What is Personel ID In statistical software there is no need to record Personal ID, name and last name of a patient. But in database software it is compulsory to record these three fields. While database software records patients data, it is also used for tracking (querying) patients data. In order to query recorded patients data, name and last name may not help to find correct patient. As an example:Name      Last Name--------   ------------------John       BrownHans       WhiteJohn       BrownCarol       GreenJohn       BrownMike        NavyJohn       BrownAs you see there are four "John Brown" in this database. There is no way to distinguish any of them from others.  In this kind of case it is better to use a Personel ID. Personel ID can be used in three different way:(A) Personal ID may be produced by database.(B) Personal ID may be produced by your clinic. (Some clinics still use paper based files. There may be numbers on them.)In items (A) and (B) patients can be informed about their Personel ID. When the patient comes to clinic next time, clinic may ask the Personel ID. So none of "John Brown" confused since Personel ID is used. But in reality most of patients forget to bring their Personel ID or cannot remember their Personel ID. And the confusion goes on.(C) In Turkey, people have Personel ID which is given by government. This ID is used in anywhere like bank, government, large amount of shopping, health, vs. So most of Turkish people memorized their Personal ID or carry their Personel ID in their pocket. This prevents confusing "John Brown".Although it is suggested you to use item (C) which is your country's Personel ID to distinguish "John Brown"  and prevent confusing, it may not be lawful in some country for national security and your old paper based files may not hold these Personel ID. In this situation it is better to use item (B).

14. Smoking: Smoking habituation of subject should be given as packed per year Alcohol: Habituation of drunk should be given as year Hypertension: Duration of diagnosis as year Diabetes Mellitus: Duration of diagnosis as year Cardiac Disorder: Duration of diagnosis as year

15. Severity: Mean severity of headache attacks according to visual analog scale Duration: Mean duration of attacks as hour Frequency: Mean frequency of attacks per month Date: Date of every examination Department: The department where the patient will be consulted

16. How to Record a New Patient

17. How to Record a New Patient A New Patient is a patient who is never recorded in your database Let’s enlarge Functional Panel

18. 2) Fill “Per.ID”, “Name” and “Surname”fields. These fields are compulsory. 1) Click New icon Compulsory Fields

19. How to Record a New Patient A New Patient is a patient who is never recorded in your database 3) Fill other necessary fields; except Detail Panels 4) Click Save icon Let’s enlarge one of the Detail Panel

20. Filling one of the Detail Panel After clicking the Save icon on the form, a plus icon becomes visible in the Detail Panel. This means that Detailed Panel is ready to be filled. 5) Fill necessary fields 6) Click green plus icon Data is appended below

21. How to Search a Record A Patient who is recorded in your database can be searched 1) Click Search icon

22. How to Search a Record A Patient who is recorded in your database can be searched 2) A new window is be opened 3) Type either “Per. ID” or “Name” and “Surname” of the patient 4) Click icon 5) Matching patients are listed in this grid 6) Click the proper patient 7) Click icon to return main page 8) The patient’s data will be seen in the form

23. Advanced Search • There are two kinds of Jokers to do advanced search. • _ (underscore) joker is used for only one character • % (percentage) joker is used for at least one character • Example 1) • Suppose a patient’s Name and Sirname is as follows • Name : Adian • Sirname : Brown • But by mistake sometimes names can be written wrong like Adien. • If Adian is written like Adien, and if it is searched as Adian, • this patient can’t be found. • For this kind of confusion only one character joker can be used like this : Type Adi_n in name and Brown in surname field. • Example 2) • Suppose a patient’s Name and Sirname is as follows • Name : Annelise • Sirname : Brown • But by mistake sometimes names can be written wrong like Anneliese. • If Annelise is written like Anneliese, and if it is searched as Annelise, • this patient can’t be found. • For this kind of confusion at least one character joker can be used like this: Type Annel%sein name and Brown in surname field. • Example 3) • Suppose a patient’s Name and Sirname is as follows • Name : Andrew • Sirname : Brown • For some reason patients whose sirname is Brown are required. Type % in name and Brown in surname field. • Example 4) • To see all patients type % in name and % in surname field.

24. Thank You