The program will automatically run in batch (background) mode and will extract personnel data for both the personnel files at the same time. The data will be extracted from the database for the HEMIS year equal to the STATS year, as set in the STATS Control File {STMNT-1} for table sequence 3.
| User Selection | Prompt Text * an item between square brackets [ ] is the default answer |
Type & Length |
Comments |
|---|---|---|---|
| 1 | Do you want to do the FTE calculation (Y)es / (N)o? | A1 | If (Y)es is selected, the system will automatically execute the program Calculate FTE Values {PSOP-3}. |
| 2 | Enter Calendar Year For FTE Update. |
N4 |
| System Select | |
|---|---|
| 1 | All Personnel Members with active Service Records in the reporting year. |
| 2 | All Service Records with STATS Category "8 - Exluded from Stats Personnel Reports" are ignored. |
| 3 | If a person has more than one Service Record in the reporting year, the latest active Service Record for the reporting year is used. |
| Table and Column | Element | Data obtained from | Database reference |
| 1007 C1, 1008 C1 |
037 | Personnel number | PAANUM from PAAPR1. |
| 1007 C2 | 038 | The appointment date, as in the Personnel Biographical Information {PBOP-1} is taken, since this represents the start of the last continuous length of service of the personnel member. | PAAADTE from PAAPR1. |
| 1007
C3, 1008 C2 |
039 | Stats category as on the Service record {PBOP-2}. If the Stats Category is 10 or 11, a 1 will be reported in the file. Note that all category 8 personnel members will be excluded from HEMIS. |
PAQCAT from PAQSAL. |
| 1007 C4 | 040 | The External Code of the STATS Level linked to the rank of
the personnel member, as recorded on the Service Record {PBOP-2}. The STATS Level on the rank is translated to the HEMIS code with the External Code Type UN for External Body HEM, as entered in External Conversion Codes {GOPS-21}. |
PAFLVL from PAFRAK translated to External Code. |
| 1007 C5 | 011 | The Birth Date of the personnel member in the Personnel Biographical Information {PBOP-1}. | PAABDTE from PAAPR1. |
| 1007 C6 | 012 | The Gender of the personnel member, as in the Personnel Biographical Information {PBOP-1}. | PAASEX from PAAPR1. |
| 1007 C7 | 013 | The personnel member’s group code, as in the Personnel Biographical Information {PBOP-1}, is
linked to a Status Group in Group Codes {GCS-7}, which gives the four main groups or Other.
If the personnel member’s data indicates Other, or is not filled in, then this field will be given a Z. |
GALGRP from GALGRP. |
| 1007 C8 | 014 | The field used to indicate in which country the passport was
issued, as the Personnel Biographical Information {PBOP-1}. Note that if no country code is filled in, then the personnel member is automatically labeled as South African. The numeric code on the field is translated to the HEMIS code with the External Code Type CTZ for External Body HMS, as entered in External Conversion Codes {GOPS-21}. |
PAAPASSPCOI from PAAPR1. |
| 1007 C9 | 041 | If the Appointment Type {PACS-1} of the person, as on the Service Record {PBOP-2}, is defined as (P)ermanent type, this element is given the code ‘PE’, otherwise a ‘TE’ code is given. | PAETYPE from PAEAPP. |
| 1007 C10 | 042 | If the FTE value linked to the Appointment type of the personnel member, as on the current service record, is 1, then this element is coded as ‘FT’ (full-time) otherwise ‘PT’ (part-time) | PAEFTE from PAEAPP. |
| 1007 C11 | 046 | The "Stats Row" of the highest Qualification {PACS-26} of the personnel member, as recorded in Qualifications {PBOP-8}. | PBFLVL from PBFQAL. |
| 1007 C12 | 047 | If the only PCS program entered for this personnel member in the STATS Allocation for Personnel {PSOP--6} is the
program 13.0, then this element gets the value ‘J’. If the personnel member is linked to a PCS 13.0, but with a percentage of less than 100%, then a value ‘B' is given. Otherwise the person gets a value of ‘N’. |
Using PABSCDE from PABPRG. |
| 1007 C13 | 048 | ‘P’ if the staff member has a service record that spans 15 September of the reporting year otherwise ‘N.’ | Using PAQDTE and PAQEDTE from PAQSAL. |
| 1007 C14 | 094 | If the Stats category as on the Service record {PBOP-2} is: 10 "PD - Post Doctorate" if it is 11, "RW - Research Fellow" otherwise "NN - None of the Above" | Using PAQCAT FROM PAQSAL. |
| 1008 C3 | 043 | The FTE value of the personnel member for the HEMIS year, as calculated by Calculate FTE Values {PSOP-3} or updated in STATS Allocation for Personnel {PSOP-6}, split according to the PCS and CESM percentages recorded in the same option (i.e. the FTE value multiplied by the relevant percentages) | PAAFTE from PAAPR1 times PABPER from PABPRG. This value should not be higher than 1. |
| 1008 C4 | 044 | The PCS program code, as recorded in the STATS Allocation for Personnel {PSOP-6}. Note that PCS 13.0 is not reported. Therefore any PCS information linked to category 13.0 will simply be excluded from HEMIS reporting. | PABSCDE * 10 from PABPRG. |
| 1008 C5 | 045 | The “major area” four digit CESM code as recorded
on the subject information in the Academic Structure {SACAD-1} of the subject linked to the
personnel member in the STATS Allocation for Personnel {PSOP-6}, if applicable. If no CESM area is applicable, then a ZZZZ is inserted, for instance if a PCS of 3 or higher is applicable. |
PACSUBJ from PACSUB linked to IALSUBJ from IALSUB to get the IALMAJA value. |
| Date | System Version | By Whom | Job | Description |
|---|---|---|---|---|
| 04-Jan-2006 | v01.0.0.0 | Frans Pelser | t125202 | STATS Rank Codes for Comprehensive Institutions. |
| 15-Jul-2008 | v01.0.0.0 | Magda van der Westhuizen | t149068 | Update Manual - Language Editing. |
| 23-Feb-2009 | v01.0.0.1 | Frans Pelser | t151619 | Stats Rowcode for Qualifications moved to Qualification Definition |
| 15-May-2009 | v01.0.0.2 | Frans Pelser | t158780 | Add rule for NN to element 094 |