This program may be used to extract Personnel Data for reporting to the Namibia National Council Higher Education.
| Processing Rules |
|
|---|---|
| 1 | Data
for the "Personnel Database" as required by Ministry of Education is
extracted from the ITS Integrator Personnel System and written to the HEMIS Table {HEMIS1-6} |
| 2 |
The data for the extract can be
identified with Table Code 2003. |
| 3 |
Existing data for the Table Code
and Reporting Year will be deleted before data from this extract run is
inserted into the table. |
| 4 |
For code values where the
External Conversion Code {GOPS-21}
is not set-up the
"untranslated code" will be extracted. External Body "HMS" is used for
all Code Conversions. |
| System Select | |
|---|---|
| 1 | Personnel Members with Active Service Records {PBOP-2} between 1 January and 31 December of the HEMIS Reporting Year for Personnel Data as set in the record for Table Sequence 3
in the Stats Control File {STMNT-1}. |
| 2 |
For Personnel Members with multiple Service Records in the year, the last active Service Record. |
| 3 |
Records for Stats Category "8 - Excluded from STATS Reports" is excluded. |
| Sort Order | Per | Comments |
|---|---|---|
| 1 | Personnel Number |
| Table Code |
Column |
Element | Data obtained from | Database reference |
| 2003 | 1 |
Staff Identifier |
Personnel Number in the Service Record {PBOP-2} |
PAQNUM |
| 2003 |
2 |
Academic Year |
The reporting year for Table Sequence 3 in {STMNT-1} |
RAZCYR |
| 2003 | 3 |
HEI Name |
Institution Name in {GCS-2} |
GAONAME |
| 2003 | 4 |
HEI Code |
Institution code in {GCS-1} translated with {GOPS-21} into the NCHE code using External Code Type INS | GADCODE |
| 2003 | 5 |
Campus |
The Campus on the Service Record {PBOP-2}, translated with {GOPS-21} into the NCHE code using External Code Type CMP. |
PAQCAMP |
| 2003 | 6 |
Remote Campus / Centre |
Campus Name in {SPCS-1} |
SAJNAME |
| 2003 | 7 |
Faculty School Name |
Name of the Faculty {GCS-3} linked to the Primary Department of the Post {PACS-4}. |
GAENAME |
| 2003 | 8 |
Department Name |
Name of the Primary Department {GCS-4} of the Post {PACS-4} |
GACNAME |
| 2003 | 9 |
Type of Staff |
The Stats Category in {PBOP-2} translated with {GOPS-21} into the NCHE code using External Code Type SCA. |
PAQCAT |
| 2003 | 10 |
Belonging to the Institution |
"2" if the Equity Status in the Appointment Type {PACS-1} is "Other", otherwise "1" |
PAEPERM |
| 2003 | 11 |
Full / Part Time |
Mode of Appointment in the Appointment Type {PACS-1}, translated with {GOPS-21} into the NCHE code using the External Code Type NOA |
PAEHESAMOE |
| 2003 | 12 |
Highest Qualification |
The NQF Level {PACS-26} of Highest Qualification {PBOP-8} of the Person translated with {GOPS-21} into the NCHE code using the External Code Type HQF |
PBFNQF |
| 2003 | 13 |
Age |
Age of the person on 30 April of the reporting year |
PAABDTE |
| Date | System Version | By Whom | Job | Description |
|---|---|---|---|---|
| 07-Sep-2015 |
v03.0.0.0. | Mmasadi Matseke |
t205340 |
New manual |