DHIS2 Data Sets and Data Entry Forms – Details

Objectives of Data Sets and Data Entry Form

Define best practices
Demonstrate how to create a default dataset
Demonstrate how to create a section dataset
Demonstrate how to create a section dataset
Introduce participants to custom data collection forms
Scripting in Data Entry Form
Live Demo
Exercise

Data Sets

Collection of data elements
Used for data entry
Based on a set collection frequency (ie. monthly, weekly, etc.)
Assigned to org units and user roles
Can use categories to attribute different parameters to the data set
Form types include: Default, Section and Custom
NOTE: In database design, data values are NOT linked to the dataset, rather they are linked to DE, they were collected in (only to the data elements)

Input DOES NOT = Output

DHIS2 Data Form Types

Default form: Sections based on category combinations
Section form: Configurable form sections based on related data elements (category combinations)
Custom Forms: Allow for completely flexible design – replica of paper forms

Data set Categories

A scenario when you need to capture a data entry form for implementing partners or funding mechanisms and/or projects.
Create category options and categories for all partners mechanisms and projects, link them in a new category combination and assign to dataset
Data set in data entry module, the partner, mechanism and project categories will automatically be rendered as drop-down boxes

Default Data Entry form

Section Forms

Tabular forms, automatically generated based on dataset sections
Split a data set into multiple sections: Each section has only 1 category combination (set of columns)
Support sub-tables (sections) and sub-headings
Possible to disable (grey out) not applicable fields in the table
Can use data element form names (if available)
Sub-totals and totals available in data set reports
Can insert indicators into the sections, Automatically updated whenever there are changes in the dataset,(i.e. adding, removing, or changing data elements)
Recommended starting approach in country as it is very fast, offers clean design and can be maintained easily

Custom Forms

100% flexibility in the design including using different elements of scripting
Each data field needs to link to a data element + category option combination
Supports the use of indicators to provide flexible on-the-fly calculations in the form (based on data elements in the dataset)
Take a lot more time to design and maintain
More resources required to maintain over time when there are changes to the forms (e.g. adding, removing, or changing data elements)
Example to design Custom form

Custom Forms Example

Business Requirements: The University of Oslo wants to collect aggregated data on “DHIS2 Academies” over the world. So we have to design a data entry form for collecting academies information.

DHIS2 Level-1 Academy Information

Academy Information	Data
Country Name
Academy Name
Opening Date
Closing date
Number of Participants
Number of Organization
Total Male
Total Female
Comments

Custom Forms Design using Excel

Open your excel sheet, design your data entry screen:

Copy the excel table and paste it in DHIS2 data entry form editor:

Custom Form Scripting

Custom Form Scripting – Live Demo

                

                 Example of Custom form calculation: 
                <-script type="text/javascript">

                    dhis2.util.on( 'dhis2.de.event.formReady', function( event,iReVg2xgFPL ) {
                          var periodN= $( '#selectedPeriodId' ).val();// From DHIS2 Selection Param
                          var nextPeriod=(+periodN) + (+1);//201611,201612,201613
                          var nextPeriodSeperate=periodN.toString().substring(0, 4);
                          var year=parseInt(nextPeriodSeperate.trim());
                          var month=parseInt(periodN % 100);
                          if(month==12){
                            year++;
                            month='01';
                            nextPeriod=year+'01';   
                            //console.log("Next period: "+nextPeriod);
                          } 
                         $('.selectedDate').val(nextPeriod);
                    });
                    function validateStockOutNumber(stockoutDays){
                        var sOut=$(stockoutDays).val();
                        if(sOut>31){
                          $(stockoutDays).val(' ');
                          $(stockoutDays).val(0);
                          alert('Sorry the number of stockout days can not be greater than 31 ');
                        }
                    }
                    function closingBL(op,re,adplus,adminus,con,closingid,opnextId,period){
                    // All id pick
                     var opbalance= new Number(document.getElementById(op).value);
                     var receipts= new Number(document.getElementById(re).value);
                     var adjustPlus= new Number(document.getElementById(adplus).value);
                     var adjustMinus= new Number(document.getElementById(adminus).value);
                     var consump= new Number(document.getElementById(con).value);
                     var nextPeriod= $(period).val();
                    // Closing Balance text data set
                    var clobalance=opbalance+receipts+adjustPlus-adjustMinus-consump;
                    $(closingid).val(clobalance);// Display closing balance at the text field
                    $(opnextId).val(clobalance);// Display closing balance at the text field
                    $(closingid).change();
                    $(opnextId).change();
                    $(closingid).prop("readonly",true);
                    $(opnextId).prop("readonly",true);
                    // Spliting Element ID
                    var ArrayFromString = op.split("-");
                    var elementId=ArrayFromString[0];

                    //console.log('Element Id: '+elementId);
                    //console.log('nextPeriod Id: '+nextPeriod);
                    var valueSaver = new ValueSaver( elementId,nextPeriod, 'dCWAvZ8hcrs', clobalance, null, 'red' );
                    valueSaver.save();

                    }
                    <-/script>

Detail

Live Demo

Exercise # 1

Exercise # 2