Results File for Publication

Results File For Publication - ASSJ5410

Subsystem	Assessments
Purpose	This job produces files (via email) containing formatted finalised results data suitable for export to a spreadsheet, database, word processor or other program.
Normally Run By	Assessments specialist and/or Scheduled to run automatically at regular intervals
Anticipated Frequency	Each assessment period.
Parameter Sample
Output File Sample
Related/Dependent Jobs	N/A

Run Details

Depending on parameter selection, this job provides an output file with student results information suitable for publication either –

on a university notice board
in a newspaper
in official notifications, or
as a document for internal institution use.

In each case, the output is made available via email as a comma-delimited file.

Timing and method

This job is normally run at the end of each assessment period. It can only be run in batch mode. Refer to the Job Control and Scheduling subsystem for further details.

Email address

The email address to which output is directed can be set as a part of the job, using form JBSF4120. This is convenient when all results information will be handled by the same person every time the job is run.

Alternatively, an email address can be set for the request, each time the job is run. This is done in JBSF5230, which is accessed from the request form, JBSF5210.

Identifying output

Each file created is identified in the HEADER line by its request job run ID (see layout details, below). This ID is given in the run log for the job.

Job Parameters	Extract Comment	optional – can be used to add identifying details to the output file, which has a COMMENTS line. A recommendation is to include the file type and/or description.
	File Type	required – determines the type of output file produced – e.g. the newspaper results file, the official notification results file. The four file types are NB-RESULTS (noticeboard), INT-RESULT (internal documents), OFL-RESULT (official notification) and PRESS-RLTS (newspaper). The type selected has an effect on which students will be reported, which of their results will be shown, and how. This is explained in more detail under the heading How are records selected?
	Include Student Names	if set to 'Y' – a student's name, as well as their Person ID, will be recorded in the file for the three file types NB-RESULTS, INT-RESULT and OFL-RESULT. For PRESS-RLTS (newspaper publication), names are never included. Setting this parameter to N is enforced.
	Assessment Calendar	required – the job runs for a single specified assessment period. The parameter defaults to the current assessment period.
	Course Owning Org Unit OR	optional – select a value to restrict results reporting to students enrolled in courses owned by the organisational unit – for example, to restrict to students in a particular faculty. (The responsible organisational units are recorded against courses in CRSF1210.)
	Org Unit Member Type	optional – select a value to restrict to students enrolled in courses owned by any organisational unit of that type. (Member types are assigned in ORGF0141, and defined in ORGF0112. Possible examples are FACULTY, SCHOOL).
	Include Child Org Units	if set to 'Y' – selection includes any organisational units which are in a dependent relationship (as specified in ORGF0143) to those already selected as a result of the previous two parameters. Child organisational units do not have to match the member type parameter.
	Course Type	optional – select a value to restrict selection to students enrolled in courses of this type.
	Course Code	optional – select a value to restrict selection to students enrolled in this course.
	Correspondence Category	optional – select a value to restrict selection to students with this correspondence category recorded against their course attempt.

Output Files

How are records selected?

Background structure

Every unit offering option has a grading schema assigned in CRSF2500. For each grade in a grading schema, 'grade inclusion' indicators are set (in ASSF5110) for each of the four types of publication (i.e.output file types). A checkmark against an indicator allows the grade to be reported in the corresponding type of publication.

The file types set in this job are the same as correspondence types, and are system generated. The correspondence types (e.g. NB-RESULTS) can be seen in the form CORF2110.

Processing

For students meeting parameter selection criteria, completed or discontinued unit attempts are examined. The grading schema for the student's unit attempt is checked. If the 'grade inclusion' indicator matching the file type is set for the grade obtained by the student, this student's finalised unit grade is considered for output.

For example, a student gets a 'credit' grade for a unit associated with the STANDARD grading schema. In this grading schema, the 'credit' grade has the 'grade inclusion' Noticeboard indicator checked, and therefore the student can be considered when this job is run with a file type parameter of NB-RESULT.

But students must also have a matching correspondence type (e.g. NB-RESULT) in the correspondence category assigned to the course attempt under which the unit was studied. If a match is made, the student's grade will be reported unless they have an encumbrance with

a RESULT-BLK system encumbrance effect, or

a RVK_SRVC or S_COR_BLK system encumbrance effect, and the Block When Encumbered indicator is set in CORF2110 for the correspondence type (file type) of the output file selected.

For example, a student has an encumbrance with the RVK_SRVC effect. If NB-RESULTS is the file type selected, and the NB-RESULTS correspondence type has its Block When Encumbered indicator checked for the correspondence category assigned to the student's course attempt, grades for units in that course attempt will not be selected for the output file. With a RESULT-BLK, a student's grades will never be reported, irrespective of the setting of the Block when Encumbered indicator.

What is shown?

The layout of the four types of output file is the same. The data reported varies depending on the file type and on parameter selection. The PRESS-RLTS file type never reports students' names.

Translated grades. A student's unit attempt grade is reported unless that grade has been translated (refer to translating grading schemas in the Specialist Overview, and ASSF5120). Translated grades for a student can be seen in ASSF53B0, or the history form AUDF3102.

External/standard grades. For NB-RESULTS (noticeboard), OFL-RESULT (official notification) and PRESS-RLTS (newspaper), external grades are shown, if recorded in ASSF5110. For INT-RESULT (internal documents), the internal grade is shown.

Sort sequence

The file is sorted:

Alphabetically by student name if included, otherwise on person ID, within
Course sorted alphabetically on short course title, within
Course type in ascending order (1, 2, 3 …), within
Organisational unit, sorted alphabetically.

Layout

See sample output file.

The file is organised with an initial HEADER, showing: institution name (local), output file name (from JBSF4110), request job run ID.

Except for the COMMENTS line, subsequent data lines are preceded by a header line identified by the suffix 'H' in the first word. For example, the COURSEH header line lists the contents of the following COURSE data line.

Last Modified on 26 September 2001