Student Tables {STOPS-2}  

General Notes on the Student Tables

1. All of these tables are year-of-registration bound, with the exception of Tables 2.11 and 2.21.   Some tables, such as 2.14, will also scan back into the history of students.  However, all years will be compared to the current SAPSE reporting year as defined in option {STMNT-1}.  It is important that census dates for all relevant periods (including the history periods) exist under option {GOPS-1}.
2. The census date for headcount tables is always taken as the first Tuesday in June: and this is hard-coded in the system.  However, for FTE Tables, census dates are taken per block as specified in option {GOPS-b1/b2}.  (See SAPSE Manual 011, Section 2.1)
3. The Academic Structure of the year in the STATS Control File will be used when tallying the particulars of students into the Student SAPSE tables. For example, when table 2.14 is generated for year n, and a student graduated in year n, but registered for and completed a number of subjects in year n-1, the credit value on the Academic Structure of year n will be used for the subjects passed in year n-1.
4. The system determines whether a student is an under-graduate or post-graduate from the indicator "QUALIFICATION TYPE" in the Academic Structure (option {SACADO-1}), for the qualification for which the student is registered.
5. The break-up of students into race groups and gender is selected from the biographic detail of students, i.e. from the fields "GROUP" in option {SREGB 1b1p4}, and "GENDER" in {SREGB-1b1p3}.
6. The classification in CESM categories is taken from the SAPSE Row Codes and Major Areas defined in the Academic Structure at both Qualification and Subject level.
7. The following tables are three-dimensional:
   

8. Subsidy Type {GCS-5} also plays a role in these tables.  Subsidy type "None (C)" is ignored for all tables.  Tables 2.19 => 2.22 are for subsidy types "Distant (B)" and "Mixed (M)", and a combination of subsidy types "Normal (A)", "Distant (B)" and "Mixed (M)": is used for Tables 2.9 => 2.11 and 2.17.

1. Adjustment of STATS Credit values to meet the requirements of the so-called 2% Test is done automatically in the system. (See the Section "2% TEST " below)
2. The following tables are always generated together, since they are inter-dependent: Tables 2.9, 2.10, 2.11, 2.14, 2.19, 2.20. and 2.21. They are explained in the points below.
3. SAPSE Table 2.14 is first generated using the STATS credits as entered in {SACADO-17}. We will refer to this credit value as the nominal credit.
4. A special program will then automatically be run to calculate an adjustment factor for each Approved Qualification {SACADO-1} by which the nominal STATS Credits {SACADO-17} for the qualification will be adjusted so as to ensure that the requirements of the 2% Test is met. (See the Section "2% TEST " below).
5. SAPSE Table 2.14 is generated again with the 2% factors if (Y)es was selected in the field "Do the 2% Test" in the SAPSE control file {STMNT 1}: otherwise only the nominal credits are used.
6. An "interim" 2.9 is generated and the information is stored in a special database.  This can be printed using option {STP2A-1} "Interim 2.9".
7. An "interim" 2.11 is generated and also stored in the special database.  This can be printed using option {STP2A-3} "Interim 2.11".
8. An "interim" 2.10 is generated by using the 2.9 and 2.11 information in the special database: it is also stored there.  This can be printed using option {STP2A-2} "Interim 2.10".
9. 2.19 and 2.21 are generated: 2.20 is generated using the stored information of 2.19 and 2.21.  In this case Table 2.20 will be calculated as two-thirds of the average of 2.19 and 2.21.
10. A special program will automatically run to add 2/3 of Tables 2.19 and 2.21 to the interim Tables 2.9 and 2.11: as well as to add the figures of 2.20 to those in 2.10 in the special database.  These are then stored in the standard database as the final Tables 2.9, 2.10, 2.11.
11. Note that the Entrance Category (FTEN Status) of students is calculated via option {SREGS 2}, which must be run before any Student Tables are generated.
12. Also note that, as a first step of this generate process, the SAPSE indicator on the subjects will be updated.  The same update can be done via option {SREGS-6}, which also allows both a Trial and an Update run.  The user is advised to do a trial run of this option, in order to find and correct possible mistakes in the data, before generating the SAPSE subsidy tables.

• This so-called "2% test" is presumably applicable to both Technikons and Universities.  In the case of Technikons, however, the SAPSE credits are defined in SAPSE 151,: it can be assumed that the 2% test, if carried out, would indicate that adjustments in the credit values are not called for.  It will only be performed for Qualifications where "Do the 2% Test" is indicated with (Y)es in {SACADO-1}
• The "Stats Credit" that is entered for every Qualification / Subject / Offering Type combination in the Academic Structure, (option {SACADO-17}) should be regarded as the "nominal credit" that is calculated on the basis of the structure of the curriculum only.  The 2% test establishes whether this credit needs to be adjusted, and if an adjustment is required, the adjustment factor is calculated.
• A pre-requisite for carrying out the 2% test is that the study records of all students who gained qualifications in the reporting year should be correctly reflected on the system for all years of study for that qualification.  Report {SREGS-5} can be used to compare the nominal credits obtained by each graduate to the minimum formal time for the qualification.  Discrepancies that occur could be caused by incomplete historical records, by exemption subjects that were not entered in the system, or by students who changed from one qualification to another.   
  

1. Those students who obtained qualifications in the reporting year are identified from the entries under option {SSTUD7-2b2}, and are grouped per (formal) qualification.
2. The credits obtained by each student towards his/her qualification are summed in the same way as in the validation report referred to above. (Steps 1 and 2 are performed by the system when SAPSE Table 2.14 based on the nominal credit values is generated.)
3. The average credit per graduate for a particular approved qualification is determined and compared to the minimum formal time of the qualification.  An adjustment factor is calculated which will bring the average credit to just below the 102% limit if it should be applied to the nominal credit.
4. This factor is applied to the nominal credits to calculate "adjusted credits", which are then used to calculate Tables 1.3, 2.9 => 2.11, 2.14 and 2.19 => 2.21. 

5. These adjusted credits are shown in report {STP2A-5} "Adjusted Credits for Table 2.14" (refer to the sample below).
6. In the case of Masters and Doctoral qualifications the same procedure is applied, but with the following adaptation:
   

• Procedures:
• None