Recruitment Tool Manual []
Contents
1. Date 17 03 2003 15 03 History EuroPa Forms Logout Welcome Make search Younger than 50 years F Use criteria for search A Personal Data 1 Date of Birth J Data pool Survey period Form status Period start at Period ends at Center Multiple selection with CTRL He ED y EI A Done Al visits gt don t care gt hz fb f2oo2 fie fB 2003 Search M Store result Defining the search criteria and the data basis for the database query Page 8 of 10 V 1 2 05 2003 05 02 The time period has to be specified by a start and an end date The date the patient s medical data was saved in the registry is taken as a reference The pre selected time period is one year back in the past When you have supplied all the necessary constraints you can start the query in the medical database by clicking on the SEARCH button If the Store results checkbox is ticked then the results of the query are saved permanently so us to be easily retrieved and repeated via the History 4 3 Query Results A list of pseudonyms which associated medical data match the search criteria is given as a result of the database query The associated search criteria and data basis are shown below the result table The result table contains pseudonyms status e g active deceased the center the patient is assigned to the assigned EuroPa participant and the date of the visit This list can be filtered by patien2. Page 7 of 10 V 1 2 05 2003 05 02 13 kt 33 ll For numerical data text and date fields you can specify greater equal less or different than value For numerical values the following can be used to define a range gt greater than lt less than lt less than or equal to gt greater than or equal to lt gt not equal to equal For text fields you can specify the following equal lt gt not equal to contains contains Clicking the AND button generates an additional field for the same question in order to specify the search criteria still further It can be deleted by pressing the REMOVE button All search criteria within a question group have a logical AND link By contrast different question groups are related with a logical OR Data Basis Pool To restrict the search area you can specify the data basis Time period recorded e g last visit first visit all Form status Time period you want to search in Centers that the user is entitled to run queries in Recruitment Tool EuroPa ersion 1 0 0 Mozilla File Edit View Go Bookmarks Tools Window Help 3 f Back Forward Reload Stop 4 Home W Bookmarks amp https fias9 brainmedia de cgi bin WebObjects QueryTool woa 1 wo 6hzZ7HfsxamHyv6 ovDnuCyw 6 3 3 9 3 15 Y Investigator Dr Tamara Appelt Younger than 50 years Help 4 en AT euroPa Project
3. Created at Created by Name of the query Clicking on any column header sorts the table by the respective column The numbering at the beginning of the rows is intended for orientation only and is not an identification criterion To create a new query form go to the Create new search form page by clicking on the New button or by using an existing form as a template and copying it To do this select it using the radio button in front of the row and click on the Copy button The original form remains unchanged Finally it is also possible to open a particular form without search criteria by clicking on the form name which links to the respective form Page 3 of 10 V 1 2 05 2003 05 02 Recruitment Tool EuroPa ersion 1 0 0 Mozilla f i loj x File Edit View Go Bookmarks Tools Window Help Y z a a EA https ias9 brainmedia defcgi bin WebObjects QueryTool woallfwolyl Y a Search z Investigator Dr Tamara Appelt Help OT x _ 1 euroPa Project Date 14 03 2003 14 20 History WWelcome Hr Created at Created by Hame C 14 03 2003 1418 Dr Tamara Appelt Interest in participating in clinical trials C 2 14 03 2003 13 42 Dr Tamara Appelt Younger than 50 years EuroPa Logout Copy New D Fage 1 of 1 Table view of existing query forms The navigation buttons at the top right of the window enable you to open the help text exit the Recruitment Tool or go back to
4. amp EuroPa Recruitment Tool User Manual gt CD european network for parkinson s disease Content Wg HOS CN Oi ape eset wets date ve EE E E ss CSS cities Sette sch he tele ainsi agent E tegatana ae dag tia ainda ETE E E E TE E W COME F AGS srnec e E E EE A EE EE E E A EE 4 Perlonmng QUOTA CS eein EA E BoM Tr OWNS AET E E E E E A E EA N N E E EN E EEA E A E E 4 1 1 Creating a New Query FOr cccccccsssececceeseeecseeeeceeuseecceuseeecsaeeecsauseesssuseeessageeessuseeetsseaesssageees 4 1 2 Saved Query FOrmS asidedsapudusetditodnascenctiniawhsciontnbntedientaineatidqbaienesbasdnutaisntapietina iain nduonsenadiehuddmbudnmsmeodentenmnteuas KEPO SLY a E E E E E E E E E E E E 4 3 Query Results ce aa ceie sts ce eerste tess use case Semele aie ean ices caeta sc een dd at enn odie Geena deta onsale naeenp Eaeieates sane tenia 4 4 List of Saved Queries and Results History cc cceecccccseeeeeeeeeeeeeeeeeeeeeaeeeeeseeeeeeseeeeeesseeeessageeessaeeeeneas Page 1 of 10 V 1 2 05 2003 05 02 Recruitment Tool EuroPa ersion 1 0 0 Mozilla i Ioj x File Edit View Go Bookmarks Tools Window Help od z a a nA https ias9 brainmedia defcgi bin WebObjects Query Tool 2 Search ad aanp TH european network for parkinson s disease Recruitment Tool EuroPa Lser lD Password Login Change Password 1 Description The Recruitment Tool runs separately as a stand alone application alongside the Eur
5. new checkbox which is added This checkbox specifies whether you want to include a specific criterion into your search or not These checkboxes are marked by a pink coloured background cf fig Hence if you want to include a question or answer option into the search you first have to make sure that the checkbox in the corresponding field use criteria for search pink coloured is checked In a second step the answer option yellow region you are looking for has to be provided as well Marking only the checkbox in the pink region of a question and not the one in the corresponding yellow region would mean that your are only searching for patients who do not fulfil this question Example You want to search the registry for all male patients who were ever exposed to L Dopa Standard but did not discontinue because of side effects and did not receive L Dopa Standard as first drug treatment Compare with the figure below section A Personal Data gt Question 2 Gender 4 Mark the checkbox pink region of this question to mark it as a search criterion 2 Select the Radiobutton male in the yellow region Search Result now would be gt all male patients Section C Drug History gt Question 1 L Dopa Standard 3 Mark the checkbox pink region of this question corresponding to ever exposed to mark it as a search criterion 4 Mark the checkbox Yellow region of this que
6. you want to perform a query in By now the only project in EuroPa is the patient registry Below the project the centre is listed for which the user has recruitment rights H Recruitment Tool EuroPa ersion 1 0 0 Mozilla Eo Ioj x File Edit wiew Go Bookmarks Tools Window Help KA 7 o a a a https fias9 brainmedia de cgi bin WebObjects QueryTool woallfwolcd 2 Search 4 Investigator Dr Tamara Appelt iS euroPa Date 14 03 2003 13 35 Choose a project On the lef side are the center listed where you could search for patients Please choose the project for recruitment Ifyou dont see all of your centers than you do not have the rights to make recruitments in EuroPa the missing centers Marburg Contact the administration if you wantto gain admission there too Welcome page selecting a project in this case there is only one 4 Performing Queries In the Recruitment Tool the user can select whether to create a new query or to run a previous query again with new or the same search criteria To create a new query use the forms area in the Recruitment Tool Forms Previous queries and their search criteria are stored in the History 4 1 Forms The Search Forms page see fig below provides the possibility to create new query forms as well as the access to previously saved queries The forms overview lists all saved queries The table shows the following information
7. AVE button The BACk button takes you back to the previous page without saving changes 4 1 2 Saved Query Forms Saved query forms can be used As a starting point for creating a new query form e g to expand it with additional questions To search in the medical database using modified search criteria Page 5 of 10 V 1 2 05 2003 05 02 To use an existing query form as the basis for a new query form you can select it in the overview table using the radio button next to it Then click on the Copy button to create a new version of this form to which you have to assign a new name You can now add or remove questions This does not change the original form lf you want to use a saved form for carrying out a query you can click on the name of the form which is linked to the respective query page Make search XY Here you can set the search criteria you are interested in see below 4 2 Perform a Query The following information has to be entered in the query form to be able to carry out a query of the registry Define the search criteria Define the data basis Select whether you want to save the result Start the query pe INE Search Criteria In order to define the search criteria the original registry questions and their possible answers are so us displayed to enter the desired value of the field cf fig The search form slightly differs from the original registry data entry form with respect to a
8. ars E E E E E D Current Drugs C 1 L Dopa Standard amph yes no 0 amp LDopa Slow Release emphy yes no 0 3 L Dopa Soluble empy yes no 4 L Dopa Etiylester empty yes no C amp L Dopa Dual Release emph yes no C amp L Dopa Others emphy yes na if OTHERS specify rea Gisconinued hecause of Pecehed as frst drug T O E E E E generic Eee Ad peed ma mm ra Tae ae SSE ANTE aooe OOE Re SIL aes Ee be eee PEE Oam m me a ee Meee l ae bu n aa men mbe E ie nena lt ec ee aed ee ee lea aes Me eel I ee rir z Ree Sere Yo Tye rs aint JUUSEPRERrsseeys Sresgesd seta thesuseagey ds i ai ie Example of a search form Questions from three registry forms have been selected in the step before For the subsequent query of the registry criteria have now to be defined by marking the respective checkboxes For each question there are pink and yellow regions Checkboxes in pink regions define answers you want to include into the query the corresponding yellow regions represent the answer option of the original data entry form Search criteria Drug History L Dopa Standard discontinued because of side effects no Drug History L Dopa Standard ever exposed yes Drug History L Dopa Standard received as first drug treatment no Patient Data Gender male Summarized search criteria as shown below the results of the search
9. d first treatment Dr Regina Wick 17 04 2003 10 32 10 11 b Suche nach Spass Markus Stoll 15 04 2003 08 40 JE 12 b L Dopa Standard Dr Regina Wick 09 04 2003 13 48 2 13 b Birth Gender or Birth Exarm Dr Friederike Herz 08 04 2003 21 09 7 14 b Suche nach Spass Dr Friederike Herz 08 04 2003 21 08 0 15 b Suche nach Spass Dr Friederike Herz 08 04 2003 21 07 0 db View of the query history V 1 2 05 2003 05 02
10. oPa application It provides the possibility to query the medical data stored in the EuroPa database A query takes two steps First a general query form is created It contains the questions you want to include into the search After saving the values that you want to use as search criteria are entered into the form Running the query yields a list of pseudonyms that match all search criteria Functions 1 Create and save new database queries 2 Reopen previous queries 3 Generate a list of patient pseudonyms matching the search criteria 2 Access In the AdminTool participants are assigned access rights and it is made explicit which participants have the right to perform queries with the Recruitment Tool and which do not The individual center based participants who have a right to use the Recruitment Tool e g centre managers are able to search in their own center and produce simple statistical reports Participants using the Recruitment Tool can only see their own queries and those of colleagues in their own center However results are only shown for the participants own queries Only original data is included into the search Any changed or modified data logged in the Audit Trail are not considered A search based on defined criteria so us to retrieve a list of matching medical data associated PIDs from the database Page 2 of 10 V 1 2 05 2003 05 02 3 Welcome Page On the welcome page you can select the project that
11. osis Time of symptom onset Clinical Data Previous Drug Exposure Current Drug Treatment Clinical Trial History Sa aaa Back Save se 2 S Es G4 Done n Creating a new query form selecting the questions In the example shown the search is containing the question Gender from the form Personal Data You can not yet select whether you want to search for female or male patients Questions within a question group have a logical AND relationship i e the results will contain those pseudonyms matching all the search criteria If you want to include alternative criteria in the search you need to create a second question group This group applies in addition to the first group logical OR The OR link adds an additional form set which can be removed by clicking on the REMOVE button Within this group as well all questions are linked with AND Example You want to search the database for male or female patients with the Diagnosis initial PD iPD Therefore you have to create a first question group containing the criteria Gender and Diagnosis and a second one by clicking on OR containing the same criteria After saving you can enter the respective values which is then resulting in the search instruction select all PIDS where Gender male AND Diagnosis iPD OR Gender female AND Diagnosis iPD You can save the newly created query form by clicking on the S
12. ry allows you to view the associated search criteria The query name and the number of patients found by your own searches are both hyperlinks Listed searches created by other working group members are not fully accessible you can only display the query form but not the resulted patient list Clicking on the query name enables repetition of the query The query form opens and the associated search criteria are already entered You can repeat the search and save the actual results The link for the number of patients only for your own searches provides access to the full result list of the associated saved database query Page 9 of 10 V 1 2 05 2003 05 02 RecruitmentTool training mode EuroPa ersion 1 6 12 Netscape Investigator EE lg D JF euroPa Date Markus Stoll 01 05 2003 16 47 Project EuroPa Welcome Help Logout Forms Page 10 of 10 No Search Done by Done at patients found 1 b L Dopa Standard 2 Markus Stoll 01 05 2003 15 57 0 2 b update test Markus Stoll 29 04 2003 08 51 0 3 b update test Markus Stoll 29 04 2003 08 49 0 4 b update test Markus Stoll 29 04 2003 08 47 0 5 b L Dopa Standard 2 Dr Friederike Herz 17 04 2003 15 54 0 6 b markus Markus Stoll 17 04 2003 13 27 5 T b L Dopa Standard 2 Dr Friederike Herz 17 04 2003 10 35 11 8 b iPD Dr Regina Wick 17 04 2003 10 34 8 9 b L Dopa Standard firsttreatment Dr Regina Wick 17 04 2003 10 33 0 10 b L Dopa Standar
13. stion corresponding to ever exposed Search Result now would be gt all male patients who were ever exposed to L Dopa Standard 5th Mark the checkbox pink region of this question corresponding to discontinued 6 Do NOT mark the checkbox Yellow region of this question corresponding to discontinued because of side effects Search Result now would be gt all male patients who were ever exposed to L Dopa Standard but did not discontinue it because of side effects 7 Mark the checkbox pink region of this question corresponding to first drug treatment 8 Do NOT mark the checkbox Yellow region of this question corresponding to received as first drug treatment Search Result now will be gt all male patients who were ever exposed to L Dopa Standard but did not discontinue it because of side effects and did not receive it as first drug treatment Page 6 of 10 V 1 2 05 2003 05 02 fa te jae HA TARTA RE a Se Tt ee he E Investigator Dr Friederike Project EuroPa Poren Help Pa 75Pa Herz _ Date 17 04 2003 Form L Dopa Fors History 1509 Slandand_ s Make search L Dopa Standard 2 i le Criteria ior Search Personal Data 2 Gender female male g Co Drug History dee gree side affects treatment 1 L Dopa Standard a z E 3 L D pa Slow Release E E C E E 3 L Dopa Soluble E E E 0 E 4 L Dopa Ethylester E E E E E 5 L Dopa Dual Release E E E E E 5 Olh
14. t status center and EuroPa participant In order to include pseudonym in the result list all search criteria must be fulfilled in at least one saved data set Only original data is considered All changed or modified entries logged in the Audit Trail are not considered 3 13 Search Criteria Data Basis and Display Selection are shown below the result table Those list can be expanded or closed using the triangles cf fig page 10 The checkboxes below the Display Selection point allow you to define which columns have to be displayed in the result table The results of the database query can be printed out via the browser s print function The result can downloaded as an Excell worksheet for further statistical analysis by clicking on the EXCEL button The BACk button makes you return to the query form without losing the entries you made before search criteria and data basis however the results it contains will not be saved in the History The NEW QUERY button allows you to run a new query using the same query form 4 4 List of Saved Queries and Results History The History gives you a list of the created and saved queries of all members in your working group cf fig The table contains the following information Search Name of the query Done at Number of Patients found You can click on any column heading to sort the table by that column The triangle in front of a que
15. the welcome page HELP LOGOUT WELCOME The History button takes you to the History page 4 1 1 Creating a New Query Form The following steps are involved in creating a query form Specify a name for the query Select the form group from which you want to use forms drop down list Select the form family Select the forms Select the questions oo YS In the EuroPa Patient Registry you can select the Visit or Patient Exit form group Depending on the selection the associated form families are listed The forms they contain and their questions can each be listed by selecting the triangle by their name Questions but not yet the answers are added to the query form by setting the corresponding checkbox cf fig Page 4 of 10 V 1 2 05 2003 05 02 Recruitment Tool EuroPa ersion 1 0 0 Mozilla File Edit View Go Bookmarks Tools Window Help a Y A 3 amp https lias9 brainmedia de cqgi bin WebObjects QueryTool woal 1 wo kESSKyqum8bFUPIdhkmtsg 30 3 Back Fo r W a rd Reload Stop Investigator Dr Tamara Appelt Help E a AI euroPa Project Date 14 03 2003 14 42 Welcome Name Demo Search Gender Search through Visit xl EuroPa Logout Select the question you wantto search With OR you can create another form group You must supply a name to identify the seach form Personal Data v Personal Data Use criteria for search Date of Birth lv Gender Date of examination l Diagn
Download Pdf Manuals
Related Search