We were creating forms that collect data about human resource. These forms have common data elements both at the district and health facility levels (eg. Number of nurses).
But the responsibility of these staff is different at facility and district levels. While they are doing clinical work at the facility, they are administrative staff at district level.
Here’s the design issue, if we use the same data element in both forms to compare districts by nurses that do clinical work, the number of nurses at district is added as well; which will inflate the ratio.
We are also contemplating creating two different data elements (clinical and admin). But with this one we will have to create indicators to know the total number of nurses in a district (both clinical and admin).
I presume some in the community have gone through this and we are looking for inputs on how best to approach the design.
Hi Seid,
I would probably use one data element with a category combo with the “Admin” and “Clinical” being your options.
I would then create two separate data sets, one for facility and one for district.
Using the “grey fields” functionality of section forms, or a custom form, insert the appropriate data element + category option combo for each data set.
This way, only the correct disaggregation could be collected at the appropriate level.
Your total then be calculated properly in the pivots.
Whether this is less work than two separate data elements with an indicator for this case, is perhaps debatable.
We were creating forms that collect data about human resource. These forms have common data elements both at the district and health facility levels (eg. Number of nurses).
But the responsibility of these staff is different at facility and district levels. While they are doing clinical work at the facility, they are administrative staff at district level.
Here’s the design issue, if we use the same data element in both forms to compare districts by nurses that do clinical work, the number of nurses at district is added as well; which will inflate the ratio.
We are also contemplating creating two different data elements (clinical and admin). But with this one we will have to create indicators to know the total number of nurses in a district (both clinical and admin).
I presume some in the community have gone through this and we are looking for inputs on how best to approach the design.
This might work by enabling the analysis of either one of them (by using the category option combo) or both of them (by the data element).
Of course users have to know which category option combo they are analyzing when they use pivot table and data visualizer - which can be handled via training.
I’ll take it back to the users and present it to them.
Hi Seid,
I would probably use one data element with a category combo with the “Admin” and “Clinical” being your options.
I would then create two separate data sets, one for facility and one for district.
Using the “grey fields” functionality of section forms, or a custom form, insert the appropriate data element + category option combo for each data set.
This way, only the correct disaggregation could be collected at the appropriate level.
Your total then be calculated properly in the pivots.
Whether this is less work than two separate data elements with an indicator for this case, is perhaps debatable.
We were creating forms that collect data about human resource. These forms have common data elements both at the district and health facility levels (eg. Number of nurses).
But the responsibility of these staff is different at facility and district levels. While they are doing clinical work at the facility, they are administrative staff at district level.
Here’s the design issue, if we use the same data element in both forms to compare districts by nurses that do clinical work, the number of nurses at district is added as well; which will inflate the ratio.
We are also contemplating creating two different data elements (clinical and admin). But with this one we will have to create indicators to know the total number of nurses in a district (both clinical and admin).
I presume some in the community have gone through this and we are looking for inputs on how best to approach the design.