Worksheet: Standard Datasets

Objective

Document data standards, or standard ways of listing data in dropdown menus.

Use the worksheet to identify all of the lists to be used in iHRIS and develop standard lists of data types for each. These will be added to the systems requirements for customization of iHRIS. While this worksheet documents standardized data lists for iHRIS Manage, it can be adapted to any installation of iHRIS by adding new sheets for each additional menu. Examples of standards used in Namibia are given, but you should develop context-appropriate standards in collaboration with stakeholders. Notice how national standards were added to the worksheet to help enforce consistency; international standards such as the WHO classification of health workers could be imported in the same way. Mapping capability to these standardized codes has already been implemented in iHRIS.

Standardized Data Lists: Concepts

Standardized data lists ensure that health worker data can be effectively analyzed. For example, if health worker cadres are referred to differently in different health facilities, there is no way to aggregate to a national picture of that cadre. Even non-standard usage of abbreviations and spelling can prevent data aggregation. Therefore, it is important to standardize data across all institutions that will use the data. HRH data standards should align with the broader HIS or eHealth standards, as well as with broader national or international standards wherever possible (For more on this, see the Standardized Data Lists tipsheet.)

A framework for enforcing data standards is consistently coding the data the same way throughout the system. To ensure consistent coding, iHRIS uses dropdown lists whenever standardized data is required. The user must select from the list rather than type in the data. This prevents inconsistencies due to typos, abbreviations, or different words used for the same item.

Tool filename (offline version): Tool1-Ea.xlsx; download tool (Internet connection required)