Namibia Hemis Subjects extract process
This program may be used to extract Subject Data for reporting to the Namiba Department of Higher Education.
| Processing Rules |
|
|---|---|
| 1 | Data
for the "Subject Database" as required by Ministry of Education is
extracted from the ITS Integrator System and written to the HEMIS Table
{HEMIS1-6} |
| 2 |
The data for the extract can be
identified with Table Code 2002 |
| 3 |
Existing data for the Table Code
and Reporting Year will be deleted before data from this extract run is
inserterd 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 | Number of Subject Registrations {SREGAR-1} where the Academic Year is equal to
the HEMIS Reporting Year for Subject Data as set in the record for
Table
Sequence 2 in the Stats Control File {STMNT-1} |
| 2 |
Cancellations for before the
Census Date {GOPS-1} is excluded. |
| 3 |
Records for Offering Types
{GCS-5} with Subs. Type "C - None" is excluded. |
| 4 |
Records where the Approved
Qualification {SACADO-7} has a
Qualification Type {SCODE3-1} with Type "A
- Access", "F - Foundation" or "Q - Qualifier" is excluded. |
| Sort Order | Per | Comments |
|---|---|---|
| 1 | Student Number |
| Table Code |
Column |
Element | Data obtained from | Database reference |
| 2002 | 1 |
Academic Year |
Academic Year of the Curriculum - Record {SACADO-17} |
IAKCYR |
| 2002 | 2 |
HEI Name |
Institution
Name {GCS-2} |
GADNAME |
| 2002 | 3 |
HEI Code |
Institution Code {GCS-1}, translated with {GOPS-21} into the NCHE code using External Code Type INS | GAOCODE |
| 2002 | 4 |
Campus Name |
The Campus Code
linked to the Offering Type of the Subject Registration record {SREGAR-1}, translated
with {GOPS-21} into the NCHE code using
External Code Type CMP |
GASGCAM |
| 2002 | 5 |
Remote Campus / Centre |
Campus Name
in {SPCS-1} |
SAJNAME |
| 2002 | 6 |
Faculty School Name |
Name of the
Faculty {GCS-3} linked to the Primary
Qualification {SACADO-1}. |
GAENAME |
| 2002 | 7 |
Department Name |
Name of the
Faculty {GCS-4} linked to the Primary
Qualification {SACADO-1}. |
GACNAME |
| 2002 | 8 |
Qualification Name |
Qualification
Name {SACADO-1}. |
IAIDESC |
| 2002 | 9 |
Qualification Type NQF |
The
Qualification Type {SACADO-1}, translated
with {GOPS-21} into the NCHE Code
using External Code Type QTU |
IDNTYPE |
| 2002 | 10 |
Qualification Level NQF |
National
Level linked to Qualification Type {SCODE3-1},
translated with {GOPS-21} into
the NCHE Code using External Conversion Type NQF |
IBSNQFLEV |
| 2002 | 11 |
Qualification NQF Field of Learning |
National
Field of Learning {SACADO-1}, translated
with {GOPS-21} into the NCHE Code
using External Conversion Type FOL |
IAIFOLC |
| 2002 | 12 |
Year of Study |
Qualification {SACADO-5}, translated with {GOPS-21} into the NCHE Code using External Conversion Type YRS | IAKPERSTUDY |
| 2002 |
13 |
Subject Name |
Subject Name {SACADO-10} | IALDESC |
| 2002 |
14 |
Subject Code |
Subject Code. | IAKSUBJ |
| 2002 |
15 |
Field of Learning |
National Subfield of Learning as in the Subject Structure {SACADO-10}, translated with {GOPS-21} into the NCHE Code using External Conversion Type NSL | IAIFOLC |
| 2002 | 16 |
Offering Type |
Offering Type linked to the Subject, translated with {GOPS-21} into the NCHE Code using External Conversion Type OT | GASOFFT |
| 2002 | 17 |
Credits |
National Credit of the Subject {SACADO-10} | IALNCRED |
| 2002 | 18 |
Number of Registrations |
Number of Students Registered for the Qualification / Subject
/ Offering Type combination in the Reporting Year.
|
| Date | System Version | By Whom | Job | Description |
|---|---|---|---|---|
| 25-Jan-2016 |
v03.0.0.0. | Mmasadi Matseke |
t205130 |
New manual |
| 26-Jun-2019 |
v04.1.0.0 |
Frans Palser |
t237245 |
Update Academic Structure References |