Create Past Course Completions File - STAJ0070

Subsystem

Statistics

Purpose

To create the Past Course Completions file for use in DESTPAC

Normally Run By

 As a batch job, by the statistics specialist, as required

Anticipated Frequency

 For government submission 1

Parameter Sample

Related/Dependent Jobs

This job is independent of other statistics jobs for the current submission year.

 

Run Details

The job is run to create an extract file, containing details about award courses completed by students in the year prior to the collection year. The file also reports certain characteristics of those students. The file is created in accordance with the DEST file specification, for loading into DESTPAC and is only created for submission 1.

The majority of this data is sourced from the main database tables. i.e. not from the Enrolment or Government Submission snapshots. The exceptions are the derived attendance mode and type which are sourced from the previous submission's GOVT_STUDENT_ENROLMENT data.

The specialisation code in each record is derived in the following way:

  • For each student/course combination, up to three specialisations can be reported.
  • If a student course attempt has either candidature fields of education or unit set fields of education recorded, these are used. If the student course attempt has neither recorded, the major field of education for the course version is used.

Records are selected where a student course attempt's 'Course Requirements Complete' indicator (PRGF4170) is set to 'yes', the Course Type of the course has its Award Course indicator set to 'yes' (CRSF1210 & CRSF1110) and the course attempt's requirements complete date (PRGF4170) is in the 12 month period ending on the course completion cutoff date alias instance (ENRF01F0, CALF0511).

The process then determines whether or not a course attempt record is reportable using the logic which determines if records are government reportable in the enrolment statistics snapshot process.

These records are stored in the institution specific PS file (with which statistics specialists will be familiar), in a directory specified by the 'KEEP' environment variable. This is a secure directory which users cannot (and do not need to) access.

The process 'Copy Extract Files From Secure Area' (STAJ0120) allows the PS file to be copied from the 'KEEP' directory to an accessible directory, specified by the 'USER' environment variable (refer to your system administrator).

 

Job Parameters

The Past Academic Period parameter is used to specify the previous academic period. The course completion cutoff date assigned to this calendar is used to determine which completed student course attempts to include in the extract file.

The Submission Year parameter is used to determine which of each student's person statistics records (prior to the submission year) should be used as the source of statistical data extracted by this job.

Output

 Output is in the DEST file specification format.

 

Updated 19 September 2002