Student Head Count Trend {MISTAB-12}


This menu option will count the number of students for the year as per user selection as well as the previous two years.

This option is for use with the Executive Web System

  
User Selection Prompt Text
* an item between square brackets [ ] is the default answer 		Type
&
Length		 Comments
    Year
 YYYY    
 
 
Sort Order Per Comments
      INCLUSIONS:  This program will count students for the year entered as well as the previous two years as follows:

Registrations where the year in the user selection is between the Academic Year and the End Year.
Only Primary Registrations.
To cater for academic blocks that are longer than a year,  the system will use the record for a particular student with the highest year/qualification number combination that was not awarded to the student prior to the year for which students are counted.

EXCLUSIONS:  Non-Primary Qualification enrolments.
Registrations for “Examination Only” Blocks
Enrolments with a Cancellation Date smaller than the Census Date {GOPS-1b1}		      


System Select     
     No special system selection


The data is available using the ORACLE View named Mw1v_All_Cross_Tables where the column program number is 16. The columns of the view should be interpreted as follows

A. Program_Number. The number of the program that generated the data. For this program it will always be 16.
B. Request_Number. The unique request number.
C. Date_Changed. The date on which the set of data for the request number was last updated.
D. Original_User. The user who generated the set of data.
E. Header_1. Will always be “Student Headcount Figures”.
F. Header_2. Will indicate for which years the students were counted. It will be in the format “For the years nnnn, xxxx and yyyy”.
G. Header_3. The year entered in the user selection.
H. Header_4. Will always be null for this program.
I. Row_Number. A sequential row number.
J. Row_Description_Line_1. An indication whether the students were Post Graduate Students, and an indication of the Gender of the Students. The column will be in the format “XY” where X is (P)ost Graduate or (U)nder Graduate and Y is (F)emale, (M)ale or ( ) if no gender was indicated.
K. Row_Description_Line_2. The name of the Ethnic Group Name of the Student.
L. Description_Line_3. The Name of the Faculty.
M. Column_Number. Data in records where the column number is 1 is for figures of year – 2, data in records where column number is 2 is for figures of the previous year and data in records where column number is 3 is for the year entered in the user selection.
N. Numerical_Decimal_Field. The number of students.

See Also:
History of Changes

Date System Version By Whom Job Description
30-Nov-2008
 v01.0.0.0 Frans Pelser
 f154412 New manual format.