 And then we'll have a look at some custom applications which were developed during the pandemic for specific use cases. So we'll have a session on that. And then to close the session today we'll have a presentation on the next upcoming Academy and how you can make best use of the Academy calendar and the community of practice. So we have a slight adjustment in the agenda so we'll start with the session on Custom apps first and then we'll proceed towards the the program indicators and the Academy and the next steps presentation. Okay, I'll proceed with sharing my screen and starting with the presentation. So the learning objectives of the session on custom apps is to understand how custom apps can support a tracker implementation. We'll have a look at the relationship tracing up which was developed in collaboration between his Sri Lanka and the University of Australia team for mapping relationships between the contacts and the index cases for COVID-19. And then many his groups worked on developing applications for COVID-19 certificates and COVID-19 health passes, we'll see one such example on how you can plug external apps to your existing tracker implementations can generate the required outputs from these custom applications. So, up till now we've discussed the various outputs that can be made when working with tracker data so we have seen how you can generate your event reports how you can do the charting of the data and event visualizer especially when you have your data elements with different option sets. And then we've also seen how you can plot the tracker data maps using track identity layer and the events here. Today we'll also see the program indicator function how that can be used in data visualizer and maps to complete the set of outputs that you can produce using the default apps available in DHS too. But there are many instances and use cases where these tools might not meet our requirements. In these cases we develop custom applications to meet the specific needs of implementation. So why these custom apps are kind of the cons they offer is that they allow you to use all the data stored within DHS to and you can create custom outputs or interfaces based on your own requirements. There is a kind of an advancement that you can carry out using external web apps which can be plugged on your databases and whatever outputs the system cannot produce by default those can be produced through the use of custom applications. Many his groups work with different countries where they were using DHS to for their COVID-19 surveillance and COVID-19 vaccine registration registrations as well. So there they produce these COVID-19 certificates so one of the examples was in one where they wanted to generate a COVID certificate directly from the tracker capture application so this was something which is not available by default. But custom changes were made to the tracker capture application to generate the vaccination certificate right at the point of data entry. Similarly, in Western Central Africa, a specific application was developed to get the outputs from the vaccination system to generate these travel passes or vaccination cards, giving the details of the person and the vaccinations he or she has taken till date. So these are some examples on how custom apps were developed to produce these outputs for COVID-19 certificates. Then relationship analysis were very important to understand the dynamics of how COVID-19 was spreading from one single index case to its potential contacts. So then there were few apps developed using the tracker APIs or external statistical tools such as R were also used to develop these applications. And then you could carry out a customized analysis based on the requirements through these external web app. So we'll be talking about the COVID-19 relationships app today, which was developed by the Sri Lanka team where they were able to create a diagram where they were able to see the put in the index cases which had registered as positive COVID-19 cases and then all the contacts which are established with that perspective and discuss they were shown in this HubExpoke model. So there you see these blue dots are basically the index case and the purple dots in extension show the relationship with the contacts. So the largest number of contacts was seen for individuals that greater the radius of the circle was. So, this way, this app was developed and we'll see a couple of examples and then you can also try on during the exercise using the learner's guide. Then in different countries with different requirements from the epidemiological team in terms of getting more information on the COVID-19 relationship model. So similar app was developed in now where they were using the kind of same mechanism, but the interface was different and customized as per the country requirements. So the local his group responsible and working with that country did develop another app where you could do contact tracing you could link the index case with different contacts and then see which contacts are linked to the index case and how many contacts are linked. So these are all examples where you could use the tracker data in different interfaces which may which may not be available as part of DHS to default feature set but they can be developed on top of your implementation and can help you in doing more advanced analysis. This is another example of a dashboard where the default dashboard was not fulfilling all the requirements. So, dashboard apps were also developed by different his groups where they pulled all the tracker data through the API, and then were able to plot that data using their own customizations as they wanted to do it. And these dashboard apps are also developed where custom dashboards were designed to meet the requirements of the analysis which the Ministry of Health had. So this is one other example of a customized dashboard where you could see the data in a different format as compared to a default DHS dashboard so these dashboard apps were also developed. Okay, so now we've gone through the presentation so we'll have a look at one of the examples of the COVID-19 application, the custom applications which were developed. So we have a specific instance shared for this example so I'll put the link in the chat box. So the user name and password are given on the landing page so you can use that. So basically in this instance we'll have a look at the relationship tracing app so if you go to the apps menu you'll see relationship tracing. Once you click on that. It will show you a saved visualization which was created for the index cases and contacts, and you could also add a new visualization from here. So let's review the existing visualization that we had so this visualization was mapping the index cases with their respective contacts so once you click on the visualization, it will ask for the enrollment dates. So, so as to pull data for tracker enrollments which happened between the enrollment started and enrollment ended. So the data which is available in the database is for March 2020 from 16th March to 18th March so please select the same dates so that you can see the outputs that that can be produced using this app. So I select 16 to 18. So now it will download all the enrollments which happened in the case based surveillance program, and also the data for relationships which were created as part of the contact tracing program so the contact registration follow program and the case based surveillance programs as we saw were linked together. So then these, these data from these two programs pull together and the relationships that was established in the program and data entry. They were used to create a hub and spoke model to see how many contacts are there per index case and how they link together. So if you click on the blue circle, you will see the details of the index case, which was for the link to the different contacts which were, which were added as potential suspect cases for this respective index case. If you click on the blue circle, if you click on it, you'll see the potential the index case which is added. And if you click on the small circle, the purple circle you'll see the person who was identified as a contact and was registered into the COVID-19 contact registration and follow up program. Through this you were able to see that potentially. If you see here that they were 37 cases, which were identified in this period and they were 50 at contacts to potentially every index case had around more than one contact. So you could be the sort of analysis and see what's the proportion in terms of the spread of the disease when compared to an index, how many individuals this is the getting COVID-19 through their index cases. If you wanted to do further investigation on the data that has been captured, you click on the blue icon, and you can also open the record and tracker capture. So you click on the blue circle, and you see the record if you need more information, you click on open and tracker capture and the record will open for the index case you could see the relationships which are added for this respective person, and the data which has been added. So this way, the custom map was linked to the existing tracker captured records. So via the API, they were able to pull the data on interface on a customized interface and and were able to map the data from two programs and able to link the records again with the diagram which was getting generated through the visualization. So another example that so the username and password for this instance is available on the landing page. So if you log out, you see the username and password. So you can log in using these details which are given here. So similarly, we had another application which was developed by the Western Central Africa group. So this is available on your exercise instance. This is the COVID pass that they had developed. So here this is in French because that was predominantly made for friends speaking African countries, but in your browser it will show you the translation options you can select English from here so to translate the language into English. Here the idea was that we could generate a COVID-19 certificate or action certificate or a travel pass for an individual through the national idea of that respective person. So we have a national ID which we can use to generate the information for so I put that ID 21823 and click on the search button. So if there was a record in the system which was matching this national identifier then automatically the information for this respective patient gets pulled into the placeholders and the record gets filled on the demographics that were captured during the COVID vaccine registry program. There is a QR code which has this information embedded as well so it could be scanned on it and the information can be further verified. And then you had the information for the vaccine doses which were given to this respective individual on what date the dose one was given and what date those two was given which vaccine was given and the details for batch numbers and expiration date and where the verification was done for this respective person. So the QR code which is shown here it has the following information the first name surname sex the name of vaccine and dates of the doses. Now, the information to the QR code is dependent upon what information the ministry decides to show as part of the verification process so they were able to decide the information that they wanted to do. Now the only concentration point here is that this health pass was made for internal use only within the country, but during the COVID-19 pandemic we saw that many international schemas were introduced for COVID-19 vaccination certification by the WHO and the European Union. So many countries used those international schemas as well to facilitate the international travel between different countries. So, depending upon the requirements that the ministry has in terms of producing the certificates whether these are for internal consumption for movement within the country. If they are for international consumption and utilization then we could also consider utilizing these international schemas of these vaccine certificate generation their content and their verification process as well. So these schemas were tested in a couple of countries in Laos they did a certificate which was compliant to the EU regulations so that was something which they did for the Laos COVID-19 vaccine registry. So, these were the couple of examples you wanted to discuss to show what additional things you could do with support of a development agency or his group who is working in your country and can support your existing implementations by developing these custom applications. So what we can do is we have around 10-15 minutes we can quickly review both the applications and use the information given in the learner's guide. So there are two instances you can use one is for relationships if you want to see the relationship analysis app which was done by the Sri Lanka team you could use the relationship instance the details I just put on the chat so you can access the app using that. And the COVID-19 certificate app is available on your exercise instance so you can use the exercise instance which you have been using for reviewing the application so I'll just put the link for that again. And the username and password you already are aware but I'll just put it for convenience we can use this. So, please take 10 minutes and then review both the applications in case there are any questions we could continue with that after you do the exercises. And if not then you can proceed towards the next session on the agenda. Can I get your good name please. Yeah, this is Saurabh. Saurabh, there is one question regarding that backend of the custom app development. How can we get the API from this DHIS-2? So, DHIS-2 has its sets of APIs which are introduced on the about page so you have this web API browser tool available here so it has the APIs for the metadata and in the data objects. So you would need some background for the developer to know how the DHIS-2 API and the back-generated database structure operates based on that past understanding they can develop these APIs and then can pull data into the different applications. Yeah, how can we get that background information about the API and their metadata? I mean metadata different from one instance to other instances isn't it? Yeah, so under the scope of this academy we're not covering the development. That's right, from where should we get it then. We do have the past app development courses which have been carried out in the past, the app development academies. We can search for the YouTube channel links where the sessions were hosted so we can share that with you. So you can do the app development course and you will get much more information on this from that course. Thank you very much. Please send me the link on YouTube and also is there any opportunity for back-end development. I have one other question if that DHIS-2 version change should we change the API also? So there are no major changes in the APIs. The idea is to maintain continuity as much as possible but in a scenario where any API-related changes are made then the documentation is shared as part of the version release notes. So I believe when we do the version application we make sure that we test the applications again to ensure that nothing has been affected by the version upgrade. So in an ideal scenario these breaks do not happen but if anything new has been introduced by the global team then they make part of the release documentation and the developers can have a look at that and make necessary changes in the applications that they have developed. Okay, there's another small one. Once we develop those Android apps for something outside it should be a hosted within the DHIS-2 instance so it can be separately work in different places. So the web apps which you want to use on top of your DHIS-2 database they have to be installed on the DHIS-2 instance. So like for example these apps are installed on a DHIS-2 database because then only they'll be able to interact with the database and get the required information. The Android apps if you're developing Android applications which are custom, of course they can be hosted on Google Play Store but then they need to have the necessary URL and the credentials to access the DHIS-2 database through APIs and then show information on the custom interface for Android. So for the web apps they need to be part of the web instance. For the Android applications they need to be just linked up with the DHIS-2 database through the URL and the username and the password. Okay, thank you.