Student Headcount {MISTAB-8}

It is possible for one student to enroll for more than one qualification within a given year. The system will always regard the last qualification for which the student registered in any given year the Primary Qualification. This is user updateable.

Some institutions have the necessity to report on the characteristics of students which could change when the Primary Qualification for a year changes. An example is an institution with first- and second semester enrolments which require the number of students per qualification for each semester. If a student enrolls for a qualification in the first semester, and enrolls again in the second semester, only one of these enrolments (The second semester) will be marked as the Primary Qualification.

This menu option will count the number of students enrolled as per user selection as at the Census Date indicated in {GOPS-1b1} and store the data. If no Census Date is found in {GOPS-1b1}, the system date is used as Census Date.

The intention is that the user will execute this option at regular intervals, for example after each registration period.

The corresponding ORACLE View is named M14v_Student_Headcount and it contains following columns:

A.    Request_Detail. The unique request number, user ID and the generation date (that is the date on which this menu option was run
by the user in order to generate the data).

B.    Heading_Line_1_Part_1.   This column contains a description of the type of data in the view.

C.    Heading_Line_2_Part_1. This column contains the first part of the parameters supplied by the user when the particular set of
data was generated.

D.    Status_Field_Number_1. This column contains the number of records read, the number of errors and the number of warnings
encountered when the particular set of data was generated. The sequence is Records Read: Errors: Warnings.

E.    Row_Number. The rows in the summarized data set are numbered. This column contains a row number for the set of data as stored
on the database.

F.    Calendar_Year. Indicated on the qualification registration. Details of the qualification registrations can be viewed in option
{SSTUDY-21b2}.

G.    Qualification_Code. This is the code of the primary qualification as indicated on the registration detail and defined in option
{SACAD-13b2}. Details of the qualification registrations of students can be viewed in option {SSTUDY-21b2}.

H.    Qualification_Name. The description of the primary qualification as indicated on the registration detail and defined in option
{SACAD-13b2}.

I.    Faculty_School. The code of the Faculty or School indicated on the qualification {SACAD-13b2} as defined in {GCS-3}.

J.    Faculty_School_Name. The name of the Faculty or School indicated on the qualification {SACAD-13b2} as defined in {GCS-3}

K.    Qualification_Type_Code. The code of the Qualification Type of the Approved Qualification indicated on the Approved
Qualification Definition in {SACAD-13b8}. Approved Qualifications are linked to Qualifications in {SACAD-13b2} and Qualification
Types can be viewed in the Student Code System option {SCODE3-1b1}.

L.    Qualification_Type. The name of the Qualification Type of the Approved Qualification indicated on the Approved Qualification
Definition in {SACAD-13b2}.   Approved Qualifications are linked to Qualifications in {SACAD-13b8} and Qualification Types can be
viewed in the Student Code System option {SCODE3-1b1}.

M.    Post_Graduate. Is the Qualification considered as Post Graduate or Under Graduate according to the Qualification Type on the
academic structure and its links to the codes in the Student Code System option {SCODE3-1b1}.

N.    Period_Of_Study. Indicated on the qualification registration detail and defined in option {SCODE-30}. Details of the
qualification registrations can be viewed in option {SSTUDY-21b2}.

O.    Period_Of_Study_Name Indicated on the qualification registration detail and defined in option {SCODE-30}.

P.    Academic_Block_Code. Indicated on the qualification registration details and defined in option {SCODE2-1}. Details of the
subject registrations and results of students can be viewed in option {SSTUDY-21b2}.

Q.    Academic_Block_Name_Desc. Indicated on the qualification registration details and defined in option {SCODE2-1}.

R.    Off_Type_Code. The code of the Offering Type indicated on the qualification registration detail and defined in option {GCS-5}.
Details of the subject registrations and results of students can be viewed in option {SSTUDY-21b2}.

S.    Offering_Type. The name of the Offering Type indicated on the qualification registration detail and defined in option {GCS-5}.
Details of the subject registrations and results of students can be viewed in {SSTUDY-21b2}.

T.    Campus_Code. Indicated on the Offering Type and defined in {SPCS-1}.

U.    Campus_Name. Indicated on the Offering Type and defined in {SPCS-1}.

V.    Subsidy_Type. Contact Tuition, Distance Tuition or Non-Formal Tuition? It is indicated on the Offering Type in {GCS-5}.

W.    Dept_Code. Department Code indicated on the qualification Definition {SACAD-13b2} as defined in {GCS-4}.

X.    Department_Name. The Name of the Department indicated the qualification definition {SACAD-13b2} as defined in {GCS-4}.

S.    Number_Of_Students. The number for the individual Students as generated and stored in the set of data.

User Selection	Prompt Text ^{* an item between square brackets [ ] is the default answer}	Type & Length	Comments
	Calendar Year	YYYY
	First Offering Type Code or ALL	A2
	First Offering Type Code to exclude or ALL	A2
	First Block Code or ALL	A2
	First Block Code to Exclude or ALL	A2

Sort Order	Per	Comments
	None

System Select
	All Primary Qualification enrolment records. EXCLUSIONS: Non-Primary Qualification enrolments. Enrolments with a Cancellation Date smaller than the Census Date {GOPS-1b1}

Example:

Processing Rules
	No special processing rules