This dashboard provides an overview of the human resources in the DWS. The following type of information is provided in this dashboard:
The purpose of the dashboard is to give an overview of the demographics of the employees in DWS, i.e. how many people are employed, is the workforce aged or quite young, where are vacant posts, are the skills profiles of the regional offices similar etc. This type of information helps to identify possible deficiencies in the work-force, and also allows for an improved appreciation of the skills competence in DWS.
What divisional reporting of human resources is possible in NIWIS?
Human resources information will be reported on per province and national picture, with a breakdown of the information being available for employees in:
Is information of DWS staff available for many years?
The structure of the Department of Water has changed over the year. For example, a few years ago it was the department of Water Affairs and Forestry, thereafter it was re-structured to be the Department of Water and Environmental Affairs (DWAE), and recently it has been restructured to be the Department of Water and Sanitation. The Department has kept accurate records of its staff, however due to the changing nature of the Department it is difficult to report on staff over a period of a number of years. This dashboard gives a snap-shot of the DWS staff as at the 2014/15 DWS financial year.
The dashboard helps to answer the following types of questions:
The dashboard can allow a comparison to be made of human resources (age, race, skills etc) between the various provinces, and also between NWRI, regional office and head office.
Human resource information is extracted from the DWS PERSAL database. PERSAL is the human resource management system of the DWS.
The data required for the NIWIS dashboards are extracted from PERSAL as csv files twice a year. The extracted files are then saved on the n-drive of the DWS. The csv files are imported via a script that is initiated monthly. The imported files are saved in the MIKE CUSTOMISED database.
Few calculations are required in NIWIS. The dashboards utilise the information from PERSAL which has been stored in the NIWIS database.
The data is extracted monthly.
The assumption is made that the procedures to extract the data from PERSAL are appropriate.
Yes, please refer to the below:
The data currently represented is not a complete representation of the human capital demographics for DWS. This is due to the current unavailability of data which will come from the SAP system because development work is still being done to finalise the data integration with SAP. NWRI data is not part of the current dataset for example, as it will come via the SAP system into NIWIS.
Copyright: The copyright of the data/information remains with the Department of Water and Sanitation.
This approval to use the data/information cannot be construed as a transfer of copyright.
Usage: All data is supplied free of charge and may not be sold to third parties. The use of information data is restricted to use for academic, research or personal purposes.
Quality: All data is supplied with no expressed or implied warranty as to its suitability for purpose, accuracy or completeness.
Status: Meanwhile data is continuously updated; the data set(s) supplied are already historical on the day of supply.
Acknowledgement: Whenever used in publications or the electronic media, the Department Water and Sanitation is to be mentioned as the proprietor of the relevant copyright.