Student Comments {SREGB-12}

Student Comments can be entered here, for either a Qualification / Subject or for the Student per Academic Year.

This option exist of two Tabs that contains the same data.

Tab "Enter / View Comments - Entity View" allows entry for comments for multiple students for the same Year, Reporting Period, Textual Data Type, Entity Indicator, Entity Code. (All students can be entered / viewed for the same Textual Data Type)

Tab "Enter / View Comments - Student View" allows entry for comments for multiple Entity Indicators and Entity Codes for the same Year, Reporting Period, Texual Data Type and Student Number. (All comments can be seen for the same student)

Tab: Entity View:

All the fields in the first (Search) panel box needs to be entered to create data on the second panel box with the 'Insert Student Comments' button.
To query data on the second panel box the 'Academic Year', 'Reporting Period' and 'Textual Data Type' fields are mandatory.
Users to use the provided 'arrow' working buttons to move to the 'next / previous' etc set of the students data.

Field

Type
&
Length

Description

Academic Year

YYYY

The Academic Year that the comment is valid for.

When the 'Entity Selection' is 'Q-Qualification' the year will be selected from (SACADO-1).
When the 'Entity Selection' is 'S-Subject' the year will be selected from {SACADO-10}.

Reporting Period

The Reporting Period as defined in {SCODE3-12}. Different reporting Periods per year can be created to enter different comments for the same Textual Data Type.

A LOV's will be available with all the active 'Reporting Periods' as defined on {SCODE3-11}.

Textual Data Type

A10

The Textual Data Type as defined in {SCODE3-12}. Different Textual Data Types can be created for different Entity Indicators.

A LOV's will be available with all the active 'Textual Data Types' as defined on {SCODE3-8}.

Entity Indicator

Dropdown with the following values:

(Q) for Qualification or
(S) for Subject or
(T) for Student.

Will be validated against Textual Data per Reporting Period structure {SCODE3-12}.

Entity Code

Qualification or Subject Code depending of the value of the Entity Indicator e.g. either:

Q - Qualification or;
S - Subject.

A NULL value is displayed If the Entity Indicator is T - Student. The qualification will be validated against the academic structure for either the qualification or subject.

Comments

A4000

Comment Text on the entity can be entered.

Date

DD-MON-YYYY

System Date when the record was created.

User Name

User Id who has created the record.

Insert Student Comments

Button

Click this button to create the comment records for all the students that match the Comment Parameter values.

Processing Rules:

For records to be generated, the Academic Year, Reporting Period, Textual Data Type and Entity Indicator fields must be entered. Entity Codes is not mandatory so that all 'T' entity codes can be generated.

Entity Indicator	Entity Code
T - Student	Empty	Validate against {SCODE3-12} and select all active records for the input Year, Reporting Period and Textual Data Type where the indicator is 'T'. Only ‘T – Student’ comment records will be created for all students that are registered for the Academic Year.
Q - Qualification	Empty	Validate against {SCODE3-12} and select all active records for the input Year, Reporting Period and Textual Data Type. Only ‘Q – Qualification’ comment records will be created for all students that are registered for the Qualifications Codes for the Academic Year.
	Not Empty. Specific Qualification Code entered	Validate against {SCODE3-12} and select all active records for the input Year, Reporting Period and Textual Data Type and the ‘Entity Code’. Only ‘Q – Qualification’ comment records for the specified ‘Entity Code’ will be created for all students that are registered for the Qualifications Codes for the Academic Year.
S - Subject	Empty	Validate against {SCODE3-12} and select all active records for the input Year, Reporting Period, Textual Data Type. Only ‘S – Subject’ comment records will be created for all students that are registered for the Subject Codes for the Academic Year.
	Not Empty. Specific Qualification Code entered.	Validate against {SCODE3-12} and select all active records for the input Year, Reporting Period and Textual Data Type and the ‘Entity Code’. Only ‘S - Subject’ comment records for the specified ‘Entity Code’ will be created for all students that are registered for the Subject Codes for the Academic Year.

Example:

Tab 2: Student View

Take note of the following rules regarding the use of the 'Student Number':

1. To generate all possible records for a student with the 'Insert Comment Records' button (student / qualification / subjects) enter the Academic Year, Reporting Period, Textual Data Type and Student Number. (Student number is in this scenario a 'mandatory' field).
2. To 'search' for data, mandatory fields are the 'Academic Year', 'Reporting Period' and 'Textual Data Type', the 'Student Number' is NOT a mandatory field.

Users to use the provided 'arrow' working buttons to move to the 'next / previous' etc. set of the students data.

Field	Type & Length	Description
Academic Year	YYYY	The Academic Year that the comment is valid for. When the 'Entity Selection' is 'Q-Qualification' the year will be selected from (SACADO-1). When the 'Entity Selection' is 'S-Subject' the year will be selected from {SACADO-10}.
Reporting Period	N3	The Reporting Period as defined in {SCODE3-12}. Different reporting Periods per year can be created to enter different comments for the same Textual Data Type. A LOV's will be available with all the active 'Reporting Periods' as defined on {SCODE3-11}.
Textual Data Type	A10	The Textual Data Type as defined in {SCODE3-12}. Different Textual Data Types can be created for different Entity Indicators. A LOV's will be available with all the active 'Textual Data Types' as defined on {SCODE3-8}.
Student Number	N9	The student number that the comment is valid for. (See Rules above regarding the student number).
Entity Indicator	A1	Dropdown with the following values: (Q) for Qualification or (S) for Subject or (T) for Student. Will be validated against Textual Data per Reporting Period structure {SCODE3-12}.
Entity Code	A7	Qualification or Subject Code depending of the value of the Entity Indicator e.g. either: Q - Qualification or; S - Subject. A NULL value is displayed If the Entity Indicator is T - Student. The qualification will be validated against the academic structure for either the qualification or subject.
Comments	A40000	Comment Text on the entity can be entered.
Date	DD-MON-YYYY	System Date when the record was created.
User Name	A8	User Id who has created the record.
Insert Comment Records	Button	Click on this button, if the comment records needs to be generated automatically for the criteria above. Processing Rules: To generate all possible records for a student (student / qualification / subjects) enter the Academic Year, Reporting Period, Textual Data Type and Student Number. Then click on the "Insert Comment Records" button. Comment records will only be created for the student if the student is registered for the Academic Year. Records on {SCODE3-12} for the input Year, Reporting period and Textual Data Type will be used to create comment records for the student. Where the indicator on {SCODE3-12} is 'T', all records will be used. Where the indicator on {SCODE3-12} is 'Q', the qualification the student is registered for (in the academic year), will be used. Where the indicator on {SCODE3-12} is 'S', the subject(s) the student is registered for (in the academic year) will be used. To enter individual records: click on the 'Create' button. enter the Academic Year, Reporting Period, Textual Data Type, Student Number and Entity Indicator. The user can enter the 'Entity Code' to create a record for a specific 'Entity Code' (Subject / Qualification) or not. If the value for 'Entity Code' is NULL then ALL records for the inserted criteria linked on {SCODE3-12} for the student will be created. Only comments can be entered for Textual Types and entity codes defined in {SCODE3-12}.

Example:

Processing Rules
	No special processing rules.

Date	System Version	By Whom	Job	Description
16-Nov-2009	v02.0.0.0	Bea Swart	T158683	New manual
15-Aug-2011	v02.0.0.1	Magda van der Schyff	F176584	Swop fields 'Entity Code' and 'Entity Indicator'
28-Nov-2011	v02.0.0.2	Magda van der Schyff	F178815	Processing rules.
21-July-2017	v05.0.0.0	Magda van der Westhuizen	T219778	Update the manual with the convertions done on INT5.0.