Student FTE Figures {MISTAB-14}


This menu option will sum the number of Full Time Equivalent Students for the year as per user selection criteria.
The view M02v_Subject_Enrolment is used as a base froim which the summary is done.
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
1 Academic Year
 YYYY     
2 Start Examination Year and Month for Examination Data YYYYMM  
3 End Examination Year and Month for Examination Data YYYYMM  
 
 
System Select     
1 The program will summarize data from the view M02V_Subject_Enrolment where
  • The Census Date of the Block is in the Academic Year or
  • The Examination Year and Month is between the Start- and End Examination Year and Month as entered by the user
2 Subject Exemption records are excluded
3 Records where the Subsidy Type in M02v_Subject_Enrolment is "Non-Formal" is excluded.
4 For institution type 'C'ollege, the program read credits from the Subject Structure on {SACADO-10} for the purpose of FTE (Full Time Equivalent) calculations.  The program read credits from the Curriculum Structure on {SACADO-17} for other types of institutions.


The data is available using the ORACLE View named MW3V_Fte_Student_Summary. The columns of the view should be interpreted as follows

A. Request_Number. The unique request number.
B. Date_Changed. The date on which the set of data for the request number was last updated.
C. Original_User. The user who generated the set of data.
D. Heading_Line_1_Part_1. Will always be “FTE Figures”.
E. Heading_Line_1_Part_2. Will indicate the Academic Year as Entered by the User
F. Heading_Line_2_Part_1. This column is reserved for future use
G. Heading_Line_2_Part_2. This column is reserved for future use
H. Row_Number. A sequential row number.
I. Subsidy_Type as in M02v_Subject_Enrolment
J. Academic_Block_Code as in M02v_Subject_Enrolment
K. Human_or_Natural_Sc. An indication whether the subject is Humanities or Natural Sciences as derived from the Stats_2_9_Row_Code as in M02v_Subject_Enrolment
L. Faculty_School_Name  as in M02v_Subject_Enrolment
M. Department_Name  as in M02v_Subject_Enrolment
N. Academic_Block_Name_Desc  as in M02v_Subject_Enrolment
O. Course_Level_Description as in M02v_Subject_Enrolment
P Faculty_School as in M02v_Subject_Enrolment
Q. Department_Code as in M02v_Subject_Enrolment
R. Campus as in M02v_Subject_Enrolment
S. Stats_Course_Level as in M02v_Subject_Enrolment
T. Column_Description
  • For Column_Number 1, "Fte Students"
  • For Column_Number 2, "Degree Credits"
U. Column_Number. The column number
V. Numerical_Decimal_Field
  • For Column_Number 1, the sum of the FTE Students in the Year calculated as the sum of the product of the Stats_Credit and the Number_Of_Normal_Enrolments where the Census_Date is within the Academic_Year  
  • For Column_Number 2, the sum of the product of the Stats_Credit and the Total_#_Of_Subjects_Passed. For "Research Course_Levels", the Stats_Credit is substituted by the Qual_Minimum_Research_Time
The Two_Percent_Factor is applied to all the values if it is available

For more information about the fields used in the calculation, refer to the section on M02v_Subject_Enrolment in the on-line help of MISS Views and Summaries {MISOPS-3}

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.
18-Jun-2019
 v04.1.0.0 Precious Diale
 t231409 Add info regarding where the program read credits.