This program may be used to extract Student Data for reporting to the Namiba National Council for Higher Education.
| Processing Rules |
|
|---|---|
| 1 | Data
for the "Student Database" as required by Ministry of Education is
extracted from the ITS Integrator Student System and written to the HEMIS Table {HEMIS1-6} |
| 2 |
The data for the extract can be
identified with Table Code 2001 |
| 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 | Primary Qualification Registrations {SREGAR-1}
where the Academic Year is equal to the HEMIS Reporting Year for
Student 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 |
Registrations for Offering Types
{GCS-5} with Subs. Type "C - None" is excluded. |
| 4 |
Registrations 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 |
| 2001 |
1 |
Student Identifier |
Student number as from {SREGB-1}, for all students with a qualification enrollment in the HEMIS year. | IAGSTNO |
| 2001 | 2 |
Academic Year |
Academic Year of the Primary Qualification Registration {SREGAR-1} |
IAGCYR |
| 2001 | 3 |
HEI Name |
Institution Name {GCS-2} |
GADNAME |
| 2001 | 4 |
HEI Code |
Institution Code {GCS-1}, translated with {GOPS-21} into the
NCHE code using External Code Type INS |
GAOCODE |
| 2001 | 5 |
Campus Name |
The Campus Code linked to the Offering Type of the
Primary Qualification Registration record {SREGAR-1}, translated with
{GOPS-21} into the NCHE code using External Code Type CMP |
GASGCAM |
| 2001 | 6 |
Remote Campus / Centre |
Campus Name in {SPCS-1} |
SAJNAME |
| 2001 | 7 |
Faculty School Name |
Name of the Faculty {GCS-3} linked to the Primary
Qualification {SACADO-1}. |
GAENAME |
| 2001 | 8 |
Department Name |
Name of the Depatment {GCS-4} linked to the Primary
Qualification {SACADO-1}. |
GACNAME |
| 2001 | 9 |
Qualification Code |
Student Primary Qualification {SREGAR-1} |
IAGQUAL |
| 2001 | 10 |
Qualification Name |
Qualification Name {SACADO-1} | IAGDESC |
| 2001 | 11 |
Qualification Type NQF |
The Qualification Type {SACADO-1}, translated with {GOPS-21}
into the NCHE Code using External Code Type QTU |
IDNTYPE |
| 2001 | 12 |
Qualification Level NQF |
National Level linked to Qualification Type {SACADO-1},
translated with {GOPS-21} into the NCHE Code using External Conversion
Type NQF |
IBSNQFLEV |
| 2001 | 13 |
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 |
| 2001 | 14 |
Year of Study |
Study Period linked to Primary Qualification record
{SREGAR-1}, translated with {GOPS-21} into the NCHE Code using External
Conversion Type YRS |
IAGPERSTUDY |
| 2001 | 15 |
Offering Type |
Offering Type linked to the Primary Qualification,
translated with {GOPS-21} into the NCHE Code using External Conversion
Type OT |
GASOFFT |
| 2001 | 16 |
New / Repeater |
At this stage, this is a placeholder, populated with "N" for
all |
|
| 2001 | 17 |
Previous Higher Qualification |
The National Level of the Previous Qualification {SREGB-7}
with the last "To Year" for the Student, translated with {GOPS-21} into
the NCHE Code using External Conversion Type NQF |
IDJNQFLEV |
| 2001 | 18 |
Year of Previous Higher Qualification | The "To Year" of the Previous Qualification {SREGB-7} with the last "To Year" for the Student | IDJNQFLEV |
| 2001 | 19 |
Previous Institution |
The "Institution Code" of the Previous Qualification
{SREGB-7} with the last "To Year" for the Student, translated with
{GOPS-21} into the NCHE Code using External Conversion Type INS |
IDJINS |
| 2001 | 20 |
Name of Previous Institution |
The Institution Name {GCS-2} of
Institution Code entered in {SREGB-7} |
GADNAME |
| 2001 | 21 |
Gender |
As in the Student Biographical {SREGB-1} |
IADSEX |
| 2001 | 22 |
Region of Origin |
At this stage, this is a placeholder, populated with "#N/A" for all | |
| 2001 | 23 |
Region of Grade 12 |
New Fields "Region Type" and "Region Code" on Secondary
School {SCODE-1}. Region Type and Region Code is maintained in {GCS-35}. |
IBCREGC. |
| 2001 | 24 |
Nationality |
Citizenship Code {SREGB-1},
translated with {GOPS-21} into the NCHE Code using External Conversion
Type CTZ |
IADCITZ |
| 2001 | 25 |
Age |
Age on 30 April of the reporting
year |
IADBIRDAT |
| 2001 | 26 |
Marital Status |
Marital Status from {SREGB-1},
translated with {GOPS-21} into the NCHE Code using External Conversion
Type MAS |
IADMARSTAT |
| 2001 | 27 |
Financial Sponsor | Source of Funding in the Student Biographical {SREGB-1}, translated with {GOPS-21} into the NCHE Code using External Conversion Type FSP | IADFBI |
| 2001 | 28 |
Societal Status: Marginalized |
"1" if the Student is linked to Certificate Code {SREGB-8} defined in {SMNT-12}, SOD code MC/RE “Marginalized” Status, otherwise "2" | IDISTNO |
| 2001 | 29 |
Societal Status: Disabilities |
"Yes"
if the Student has a Disability {SREGB-10},
otherwise "N" |
IVASTNO |
| 2001 |
30 |
Societal Status: OVC |
"1" if the Student is linked to Certificate Code {SREGB-8} defined in {SMNT-12}, SOD Code OC/RE “OVC” Status, otherwise "2" | IDISTNO |
| 2001 | 31 |
Profession of Guardian |
Profession in Associations {SREGB-13} |
JRMPROFCDE |
| 2001 | 32 |
Relationship to Guardian |
Relationship in Associations {SREGB-13} where the Role is "Guardian",
translated with {GOPS-21} into the NCHE Code using External Conversion
Type REL |
JRMRELAT |
| 2001 |
33 |
Profession of the Student |
Occupation in the Student
Biographical {SREGB-1}, translated with
{GOPS-21} into the NCHE Code using External Conversion Type OCC |
IADOCCUP |
| 2001 |
34 |
Annual Result |
Student Annual Result of Primary
Qualification {SSTUD7-2}, translated with
{GOPS-21} into the NCHE Code using External Conversion Type RES |
IAGRESULT |
| Date | System Version | By Whom | Job | Description |
|---|---|---|---|---|
| 29-Sep-2015 |
v03.0.0.0 |
Sakhile Ntimane |
t205127 |
New Development |
| 01-Mar-2017 | v03.0.0.1 | Mmasadi Matseke | f 219838 | Link the HEMIS1-6 to correct link |
| 04-April-2017 | v04.0.0.0 | Thelma Komana | T220228 | Fixing links |