 so the first exercise will be to show you how to create the very easy validation rules we are going into here you can see here then you type maintenance after typing maintenance where you are in the maintenance app all of you are seeing this validation button I hope all of you are seeing this validation button then we click on validation and once on the validation here the first button that is where we can click on validation rule so there is you can start scrolling and see what is there or you can go directly and create a new rule in this exercise we have to create a rule we have to create a very simple rule of hiv let's say we take dpt hepatitis those given should be less or equal to dpt those used but I think this will be a little bit complicated it will require some calculation let us take a very simple one which will be please your screen is not showing okay let me let me share my screen so we want to take like the example we used yesterday we're seeing my screen so we are here we want to create hiv we remember the the the exercise we were reviewing now so we want to create the same but for everyone has to do the same then maybe we can move on and try to do more exercise so you hit on the plus button after clicking on the plus button as I said you can go directly where you are here on the validation you can click this plus button it is the same button as if you can click here and you go directly there or you can decide to review what is already there and click on the plus button here so after clicking on the plus button here you go here you put the name of the validation rule you remember yesterday yesterday session was like we have to put a name which is meaningful and because all of us are working in the same instance we are going to use our initial to differentiate the validation rule we create between like me the validation rule I create to be differentiated with the validation rule Bashir created so I have to put my initial like for me like this then I put under scroll and we are going to create a validation rule for hiv I'll type hiv test positive male plus hiv test positive female should be less or equal to hiv test perform male plus hiv test performed female so this it is you remember yesterday we talked about the meaningful of the validation rule I can take the same and put it here on the short name but let me try to reduce it because it is too long then if you have too many role it is also a good a good practice to put a code so that maybe you can document them and you say like in hiv I have this and this but that is not mandatory another one it is the description here in the description you just write what the validation rule will be doing like this validation rule it is about comparing the hiv test positive for male plus the hiv test positive for female you compare them against all the test performed for male and all the test performed for female then here in the instruction you put the instruction so it is like whenever there is an error you call the data manager as we were suggesting data data manager of the facility and ask him or her to correct the data so here again you can put the importance depending of how is the how the program is configured so you can put it there is three type of importance you there is three type of importance you can make it high priority medium priority or low priority you are the one who knows how your program works and how critical this rule can be on your reporting either you can put it high if you find it very critical medium or low let us get remain with the medium the proposed medium and here also you have a reporting type the reporting type it is recommended that it is matching with the reporting period of reporting form so if you are doing this rule against the reporting form which is a monthly reporting form it is better to have this rule run on a monthly basis if it is a quarterly it is better on a quarterly if it is a weekly it is better so it is recommended to keep the same reporting then we have here as you if you remember the three side or the three part of the validation rules we have the left side we have the operator and the right side so we click on the left side once we are on the left side you you have here on the top you have first you can play size if you can skip if any value the data elements you're going to choose here if any of the data elements you are going to choose here any value is missing you can say that you can choose to skip whenever a value is missing or to skip even if all those values are missing or you can be very critical and say never skip if there is a value missing you can have a top up an alert which will pop up and show you that there is a missing value then we are going here on the title there we can have hiv you remember what we put on the left side it is hiv test performed a test positive hiv test positive male plus hiv test positive female this is what will be on the left side then we are going this is the title after putting writing down the title we choose the data element which will be the component of this left side so here we have that element whereby we can choose that element we have programs you remember yesterday we said this validation rule can be run against a data entry form an aggregate data entry form an event capture data entry form and a tracker capture form so if you want to use a program event program or tracker capture you can go to program you can also run them again organize organization units or constant or reporting grades but most of the time people use the validation rules against these two like to check the error on the entered data the two it is this is for aggregate and this is for event and tracker capture program it is also advisable on the data element to choose the disaggregated the disaggregated data element what does that mean that means that here we have hiv test positive which has been disaggregated into male and female so it is advisable when we are picking the data element you pick the disaggregated one the male and the female not the total one because sometimes you may find that the total are not like when doing some calculation you may find some differences so it is advisable to take the disaggregated data element so for here I will write down hiv test I have here hiv test positive male I don't know if all of you are seeing my screen I hope so yes we can see then class hiv test for female and I can see here the description you know here it is kind of code and if you want to see what does this means in our normal language this is here where you can see hiv test positive for male hiv test positive for female and after doing this you save here we are saving the left side now we are going to choose the operator which will be in the middle we have all we have like this one two three four five six seven eight eight like default value whereby you can choose the operator you can have equal to not equal to greater than greater than or equal to less than less than or equal to compulsory pair and exclusive pair so you can choose depending of the condition you want to put there you can choose what condition you take so for us it will be less less less than or equal to we take less than then we go for the right side we can choose right side and we use the same never skip we put the title the description of what will be the data element be down here on this right side we will have hiv test perform male plus hiv test perform performed female the same way we click down here and we go here on that element to choose the data element to put here the same where we choose for the left side we choose disaggregated data element so we will say test performed this will help us to filter because we have a lot of because we have a lot of of data element if you are typing here in this search but search area it will help us to filter the data element instead of searching our data element among a thousand data elements we will filter and search the data element very quickly so we have here the male we double click then plus we choose also hiv test performed for female and we can check if everyone is everything is well and we have hiv test performed male plus hiv test performed female then we go for save we save for this right side then we can go here the other spot is organization unit level we can it is also advisable here also to choose the facility so we run this validation rules against against a facility because you remember this is a validation rules most of the time we are comparing logical rule within a form so the data which has been entered within a reporting form and the reporting form are linked to the facility that's why we are looking we are choosing a facility and send it on there they are from left side to right side then we can we can if you don't skip this from from before you save now sorry before you save this is a participant wants you to start again from the left side from the left side okay so they may maybe delete this and start again this is a quick one so we just go in there a little bit quicker and we start from from scratch so you remember from the analy from the dashboard most of you have reached on the dashboard then you go here on this but this the place where there is all the module or all the apps you choose maintenance app after maintenance app you go directly to the validation button after clicking on the validation button there is this plus button you click on plus button and you have the place where you start creating your validation rules as I explained to you put the validation rule there but before to differentiate in this exercise not in the normal life in the normal life you will put directly the validation rules but in this exercise because we want us to differentiate our validation rules we'll start by putting our initial like for me my initial is r and n a and n then the name of the validation rules the name of what the validation rules for us it is HIV test positive plus for male plus HIV test positive for female which has to be less or equal to less than or equal to HIV test performed for male plus HIV test performed for female this is will be the title of the validation rules remember we said the title have to be meaningful so that people who will see the validation rules maybe notification will understand and they will notice where the problem where the alert is and where they have to go and fix so we put also a short name I said if you have too many validation rules you can make a code and make a list so following them one by one but it is not mandatory we cannot it is also good and advisable to be to put a description of the validation rules what is the purpose of this validation rule what the validation rule will help to do so I just put the title here the name of the validation rule but if you want to put more details you can put more details here also on the instruction you have to put the action if this validation rule is violated what will be the action so we can put an instruction we like call the data manager of the facility and ask him or her to fix data related issue so then we are going here on the importance depending of the critical of your reporting form of your data you may decide if this is very critical and you put it high medium and low so depending of how you are the owner or you are the emini you are the one who knows how this can be critical or how this can be medium so you put the priority for based on the reality in your project or underground there we just keep medium and here we have also the reporting period we have on the reporting period we have monthly we have the same reporting period as the same we are using on the reporting form it is recommended to keep the same reporting period as the reporting form you again you are running this validation rule so if this validation rule is running again within a reporting form of a month you put you choose the report reporting period a monthly if it is a quarterly you put here you choose a quote a quarter or you can choose a weekly depending of the same period your reporting form has then here we are on the place where you have to put the condition or we have to select the variable which will be which will be part of our validation rules so we have the left side we have the operator and we have the right side on the left side when you are clicking on the left side I explained to he here that we can we have these three options where we can skip even if one of the variable is missing we skip we skip it or if all the variable are missing we skip them or here never skips meaning like whenever there is a problem you specify you the validation rule has to tell you and on the description we put the name of what will be the variable on the left side so there be Ibrahim I can can I please suggest something maybe we just put this and we have a question and the answer session maybe that's we can discuss more because if we start interrupting unless if you don't get the voice that's when you can ask if you don't hear the voice or you don't see the the screen but please we will be having a session of question question and answer that will be an open session and will give the flow to everyone so Ibrahim is it something related to the sound or related to if not can you keep it please can you keep it please for a few minutes later on the question and the answer session okay okay thank you thank you too so we'll put here HIV test performed test positive male plus HIV test positive female then I explained that this is the component against which are make which can be part of the left side we have that element we have programs we are all the unit counts we have constant we have reporting rates so the most used component it they are that element and program that element it is where we take the value or the variable we want to to be part of our validation rules and program also is where we choose the program and in the data element it is advisable to use the desecrated data element not use the aggregated one like for here our example it is advisable to keep the male data element and the female data element instead of putting HIV positive test positive so for us I put HIV then this is an area whereby you can filter because we have many data element that's why we are typing the first letters of the data element to filter and the system will display only data element starting whose name that's the name starting only with HIV and it will be easier for us to get the data element so we have we want tests so this is the aggregated one but it is advisable to use the desecrated one if I want to take this male plus this female and I can check if the rule is well written if there is an error most of the time down here you can see an error but for us the rule is well written and we just save then we go to the type of operator which the system have preloaded so you can choose within this eight type of operator the one the one meets your conditions so like we have equal to not equal to greater than greater than or equal to less than less than or equal to compulsory pair and exclusive pair for us the condition is less than or equal to then we go to we go to the right side whereby also we have the same logic we put here the name the name of the variable which will be part of this right side then we go here the same way as we did for the left side we choose the test performed for male double click plus the test performed for female double click we can check if it is well written we can see down here if the name corresponds to what we want and then we save again we are going a little bit down here this validation rule we wanted to be to run against facility it is advisable to put facility because we remember the validation rules they are being run to check the consistency within a reporting form and the reporting form are linked to the facility that's why it is advisable most of the time to choose for facility then here we can put skip validation rules if we don't validation rule to be when we are clicking on complete if you don't want it to be like displayed if it can keep it and allow people to continue the data entry or if you want it to show up when people are doing the other entry so we can it is better also because we did the validation rule to show the person that we need we need this validation rule to show him that there is an error and to correct the error before like the error being saved and maybe compromise the quality of the data we want the person to save it on time then it is not advisable to click here so you just save the validation rules and we can check this validation rules if it is respected yes or not so you remember the method of checking the validation rules we have then after creating the validation rule it is also advisable if you have too many programs you are running so like you have running you are running or you are following data for hiv program for immunization program for maybe tb to create these validation rules and put them into groups so that you can have a group for hiv you can have a group for tb you can have a group for immunization and it will help you to easy search them and reach to them when you want to revise them or when to you want to run the data validation analysis so the validation rule we created I have to go here on the second part and create a group the same way I'll put my initial and put the validation rules I can put a description if I want but it is not mandatory and here I choose the validation rule which will be the member of the group I have just created then I save the group then the the following will be to go to the data entry and to check if the validation rule is running correctly or to check it via the data quality app let me use the data entry for it was the hiv I want to choose a period then when I click on run validations should be showing me the validation rules which are you can see the instruction here down here and the rule which has been the rule which has been violated so I think for this first exercise everyone of you can do it before we go for a second exercise mania if you are back you can take over no I think thank you hamza for that I don't know what happened to my microphone it just stopped working but I'm grateful you've done it very well in a very slow manner that I think everybody is in a position to practice I think now for now is just to allow them to go to the exercises and we they go slowly by slowly exercise by exercise let me hello so we we have now the validation rules in the module so we need to go and we are in day three we are going to use the learner's guide so this is this is what we've been going through all along and actually we've done live demo and now we want us to do the activity so we need to finish this at least I don't know whether they need a small break or they can still manage to at least try to work on before they take a break so so that is that's where we are starting from activity one create a validation rule for HIV it is a the instruction clear we just go one by one you go just the way it's written and then you when you are making the name put the initial to you the first with your initial it is a n or a something and just create it's very straightforward actually and the way hamza has taken it I think he has even given you the free max so I think if there is no any other question from the participants I would like us to go to this and start creating it create the validation rule HIV test positive exactly the way it has been done I think I will leave it at this until we give it a few minutes maybe 15 20 minutes then we will have a small break and then we can continue the exercise this is the main exercise for today it's more mostly on yourself learning how to do it let me see if there are any questions