1 | 99990011 | Student file | STUD |
2 | 99990012 | Course enrolment file | COUR |
3 | 99900013 | Course Register | CREG |
4 | 99900014 | Qualification completions file | GRAD |
5 | 99900015 | Subject Completions file | COMP |
User Selection | Prompt Text * an item between square brackets [ ] is the default answer |
Type & Length |
Comments |
---|---|---|---|
Choice of file type to include [1]. | N1 | This option can be run with one of two answers: (1) Course registers for the entire year. This will report all subjects available to students in the given year. (2) All SDR files. NOTE: The SDR extraction process involves a large volume of data and will probably take a few hours to complete. Please see chapter 5 of this manual for a detailed discussion on how each element of the student data files is extracted from the database. |
Table and Column | Ele- ment |
Data obtained from | Database reference |
99990011 C1 | Institution Code as from {GCS–1}. | GAOCODE from GAOINS | |
99990011 C2 |
Student number as from {SREGB-1}, for all students with a qualification enrolment in the SDR year. | IADSTNO from IADBIO | |
99990011 C3 |
The Gender of the student as indicated on {SREGB-1}. | IADSEX from IADBIO | |
99990011 C4 |
The Birth date of the student as from {SREGB-1}. | ADBIRDAT from IADBIO | |
99990011 C5 |
Ethnic Group {SREGB-1}. | ADETHN, IADETHN2, IADETHN3 from IADBIO | |
99990011 C6 |
1st 4 letters from surname and 1st letter from names. | IADSURN, IADNAMES from IADBIO | |
99990011 C7 |
If student type is D then Previous activity as from {SREGB-1} | IADPACT from IADBIO | |
99990011 C8 |
Get Minimum year from previous qualification and qualification enrolments. Previous Enrollments from other institutions {SREGB-7} or {SREGB-1} Previous Qualifications / Subjects under Functions. Previous enrolments at the Open Polytechnic can be seen at {SSTUDY-21b2} |
Min (IDJCYR) from IDJQAL and Min (IAGCYR) from IAGENR |
|
99990011 C9 |
If student type is D then Select Disability then code is given as 1 otherwise it is a 2. {SREGH-1} Medical (Y / N). | IAGMEDICAL from IAGENR | |
99990011 C10 |
If student type is D then Select School code {GOPS – 21}.
|
IKXEXTCODE from IKXETR | |
99990011 C11 |
If student type is D then select Matric date {SREGB -1}. | IADMATDATE from IADBIO | |
99990011 C12 |
If student type is D then select Matric type | IADMATTYPE from IADBIO | |
99990011 C13 |
If alien indicator is P set code to NZP otherwise use External Code on IKXETR
|
IADINDALIEN from IADBIO | |
99990011 C14 |
If student type is D then IAGASSIST | IAGASSIST from IAGENR | |
99990011 C15 |
If student type is D
|
||
99990011 C16 |
If student type is D then select qualification enrolment final year. {SREGAR-1b1} | IAGFINALYEAR from IAGENR | |
99990011 C17 |
If student type is D then select Iwi Affiliation | IADIWI1, IADIWI2, IADIWI3 | |
99990011 C18 |
If student type is D then select Internal Revenue Number. | IADIRDNUM from IADBIO | |
99990011 C19 |
If student type is D or C then select National Student Number. | IADNSNNUMNER from IADBIO | |
99990011 C20 |
Is Empty. The Foreign fee is returned in the CREG file (99990013 C15). According to the MOE’s manual it can only be submitted in one of the files, not both. | |
|
99990011 C21 |
Contains information from student transactions. | From IAMLOG |
|
99990012 C1 |
Institution Code as from {GCS–1} | GAOCODE from GAOINS | |
99990012 C2 |
Student number as from {SREGB-1}, for all students with a qualification enrolment in the SDR year. | IADSTNO from IADBIO | |
99990012 C3 |
External qualification code (SAPSE) {SACADO-1} External code field}. | IAISAPSE from IAIQAL | |
99990012 C4 |
External subject Code {SACADO-10} | IALSDRCODE from IALSUB |
|
99990012 C5 |
The system finds the first block in which the student was registered for the relevant qualification. Then the start date of the block, as recorded on the census date information in menu option {GOPS-1} is used. | GANSDATE from GANSEN | |
99990012 C6 |
|
||
99990012 C7 |
The system finds the first block in which the student was registered for the relevant qualification. Then the end date of the block, as recorded on the census date information in menu option {GOPS-1} is used only if the cancel date is greater then the end date of the block. | GANEDATE from GANSEN | |
99990012 C8 |
Not Used | ||
99990012 C9 |
The subsidy type {GCS-5} of the student according to the offering type on the relevant subject enrolment. | GASSUB from GASOTP | |
99990012 C10 |
The Campus {GCS-5} of the student according to the offering type on the relevant subject enrolment. Note that the campus is translated into the SDR codes using the External Conversion code CMP. | GASGCAM from GASOTP | |
99990012 C11 |
Source of Funding (FIRSRCFUND) as per table (RBCTAB) | RBCROW from RBCTAB | |
99990012 C12 |
Not Used | ||
99990012 C13 |
Legal Resident Status. If value of IAGINDALIEN is Q, default to Y | IAGINDALIEN from IAGENR | |
99990012 C14 |
Fund category (IALROW102) | RBCALTCONTENTS from RBCTAB | |
99990012 C15 |
Course Classification(IALROW103) | RBCALTCONTENTS from RBCTAB | |
99990012 C16 |
NZSCED Field of Study(IALROW209) | RBCROW from RBCTAB | |
99990012 C17 |
Course EFTS Factor {SACADO-10} | IALNCRED from IALSUB | |
99990012 C18 |
A calculation is done to calculate EFTS by Month | ||
99990012 C19 |
National Student Number {SREGB–1} | IADNSNNUMNER from IADBIO | |
99990012 C20 |
The system finds the first block in which the student was registered for the relevant subject. Then the end date of the block, as recorded on the census date information in menu option {GOPS-1} is used. | GANSDATE from GANSEN | |
99990013 C1 |
Institution Code as from {GCS–1} | GAOCODE from GAOINS | |
99990013 C2 |
External subject code (SAPSE) {SACADO-10} | IALSDRCODE from IALSUB | |
99990013 C3 |
The system select the subject’s full name | IALFULLNAME from IALSUB | |
99990013 C4 |
Qualification Code {SACADO-1} External code field | IAISAPSE from IAIQAL | |
99990013 C5 |
Course Classification (IALROW103) | RBCALTCONTENTS from RBCTAB | |
99990013 C6 |
NZSCED Field of Study (IALROW209) | RBCROW from RBCTAB | |
99990013 C7 |
NQF Level (IALNQFLVL) | RBCROW from RBCTAB | |
99990013 C8 |
The system select Subject Credit (IALCREDIT), an error is printed if Subject Credit is greater then 240. {SACADO-10} | IALCREDIT from IALSUB |
|
99990013 C9 |
RBCALTCONTENTS from RBCTAB | ||
99990013 C10 |
EFTS - National Credit (IALNCRED) {SACAD–14b1}. | IALNCRED from IALSUB | |
99990013 C11 |
Period of Study {SACADO-17} Field SP for Study Period} | IAKPERSTUDY from IAKQAL | |
99990013 C12 |
3.12 Fee | ||
99990013 C13 |
The Level of Internet Access {SACADO-11}. | IDCINTERNETACC from IDCSOT | |
99990013 C14 |
Performance Based Research Funding Eligible Course {SACADO-11}. | RBCALTCONTENTS from RBCTAB | |
99990013 C15 |
3.15 Fee | ||
99990013 C16 |
3.16 Fee | ||
99990013 C17 |
Course Exemption from FCCM {SACADO-10}. | IALEXMAXIMA from IALSUB | |
99990014 C1 |
Institution Code as from {GCS–1}. | GAOCODE from GAOINS | |
99990014 C2 |
Student number as from {SREGB-1}, for all students with a qualification enrolment in the SDR year. | IADSTNO from IADBIO | |
99990014 C3 |
The Gender of the student as indicated on {SREGB-1} | IADSEX from IADBIO | |
99990014 C4 |
The Birth date of the student as from {SREGB-1}. | IADBIRDAT from IADBIO | |
99990014 C5 |
Ethnic Group {SREGB -1} | IADETHN,IADETHN2,IADETHN3 from IADBIO | |
99990014 C6 |
If alien indicator is P the set code to NZP otherwise use External Code on IKXETR
|
IADINDALIEN from IADBIO | |
99990014 C7 |
|
IKXEXTCODE from IKXETR | |
99990014 C8 |
Matric Date Year {SREGB-1}. |
IADMATDATE from IADBIO | |
99990014 C9 |
Highest Secondary School Qualification {SREGB-1} Secondary School Information. | IBKCODE from IBKMTP | |
99990014 C10 |
Category of Fees Assessment. {SDREGA-1} Contract information – SDR Assist. |
IAGASSIST from IAGENR | |
99990014 C11 |
External Qualification Code {SACADO-1} External code field. | IAISAPSE from IAIQAL | |
99990014 C12 |
Not Used | ||
99990014 C13 |
External subject Code {SACADO-10} | IALSDRCODE from IALSUB | |
99990014 C14 |
External subject Code {SACAD-14b1} | IALSDRCODE from IALSUB | |
99990014 C15 |
External subject Code {SACADO-10} | IALSDRCODE from IALSUB | |
99990014 C16 |
Iwi Affiliation {SREGB-1} | IADIWI1, IADIWI2, IADIWI3 from IADBIO | |
99990014 C17 |
National Student Number {SREGB – 1} | IADNSNNUMNER from IADBIO | |
99990015 C1 |
Institution Code as from {GCS–1} | GAOCODE from GAOINS |
|
99990015 C2 |
Student number as from {SREGB-1}, for all students with a qualification enrolment in the SDR year. | IADSTNO from IADBIO | |
99990015 C3 |
External subject Code {SACAD-14b1} | IALSDRCODE from IALSUB | |
99990015 C4 |
Result: If the subject result
(IAHERES) = the required result (ICQCOMPULRESULT) this becomes a 4
otherwise the pass / fail indicator (IBQPASSFAIL) is returned. See
below for detail: The various codes are derived as follows: 0: Still to complete course – valid extension or grade not yet available (Register Level 1-8): When there is no result in IAHERES or in IBQPASSFAIL where IBQCODE = IAHERES and the system cycle start date GANSDATE of the subjects block is greater than the IAHSSDATE. 1: Still to complete course – course end date not yet reached (Register Level 1-8): When there is no result in IAHERES or in IBQPASSFAIL where IBQCODE=IAHERES and the system cycle start date GANSDATE of the subjects block is not greater than the subjects start date IAHSSDATE. 2: Completed course successfully: IBQPASSFAIL for the subjects IAHERES is a P. 3: Completed course unsuccessfully: IBQPASSFAIL for the subjects result IAHERES is an F. 4: Did not complete course: When the ICQCOMPULRESULT is not equal to the subjects result code IAHERES. 5: Practicum to complete - on job training (Register Levels 1-8): When IBQPASSFAIL is null and IALINSERV=’Y’ 6: Yet to complete – Register Levels 9 & 10: When IBQPASSFAIL is null and IALNQFLEV = (9 or 0) and the system cycle start date GANSDATE of the subjects block is greater than the IAHSSDATE 7: Extension granted or under moderation – Register Levels 9 & 10: When IBQPASSFAIL is null and IALNQFLEV = (9 or 0) and the system cycle start date GANSDATE of the subjects block is not greater than the IAHSSDATE. |
||
99990015 C5 |
The system finds the first block in which the student was registered for the relevant subject. The the start date of the block, as recorded on the census date information in menu option {GOPS-1} is used. | GANSDATE from GANSEN | |
99990015 C6 |
National Student Number {SREGB–1} | IADNSNNUMNER from IADBIO | |
99990015 C7 |
|
||
99990015 C8 |
Source of Funding {SDREGA-1} or {SREGB-1} Qualification / Subject Registration. | IAHSRCFUND from IAHSUB |
Date | System Version | By Whom | Job | Description |
---|---|---|---|---|
17-Jul-2009 | v01.0.0.0 | Magda van der Westhuizen |
t160160 | New manual format. |
5-Sep-2009 | v01.0.0.1 | Melanie Zeelie |
t161683 | Add info excluded from statutory reporting |
30-Jun-2011 | v01.0.0.2 | Hermien Hartman | t166882 | Updated according to Peter Rombel's input. |
21-JUL-2015 | v03.0.0.0 | Bea Swart | t204758 | Add Legal Residence Status value Q to COUR field 13 |
26-Jun-2019 |
v04.1.0.0 |
Frans Pelser |
t237245 |
Update Academic Structure references |