Create Government Submission Snapshot - STAJ0110

Subsystem

Statistics

Purpose

To produce a point in time snapshot of enrolment, government fee liability and load data contained in the System for use in producing government statistical returns

Normally Run By

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

Anticipated Frequency

 Must be run once for each government submission but is likely to be run a number of times for each submission in order to identify missing or errant data. May be run to reproduce previous exception reports

Parameter Sample

Related/Dependent Jobs

This job produces an exception report (STAR0110)

 

Run Details

The Government Submission Snapshot process is run in order to capture a snapshot of data from Callista. The 'snapshot' consists of collecting data from throughout Callista and storing it in separate Callista tables. The database tables populated by this process contain all the data required to create the extract files used in DESTPAC. Separate jobs are run to create each extract file from the Government Snapshot (refer to The Government Statistics Process).

Details of the data included in the snapshot are provided in How the Government Statistics Process Works.

Government Snapshot tables can be used to check data, to trial data through the government submission process for the purpose of ensuring data integrity and as a source of statistical information if the institution desires.

At an appropriate time after the census date, one of the Enrolment Snapshots is selected as being representative of the enrolment situation at the census date, and is used in the production of the Government Snapshot. The Enrolment Snapshot used is specified as a parameter to this job.

Details of the exception report produced for this job are provided below. It should be noted that in extraordinary circumstances this job will fail. This will occur if pre-requisite data has not been set up correctly. If the job fails, an error is written to the Job Run Log. This error should be checked against the setup pre-requisites and the problem fixed. Correct setup will ensure that these errors do not occur. The following is a list of those circumstances which could cause this job to fail. They all relate to setup problems. Refer to pre-requisites section for further information:

  • cannot determine the default Attendance Type value (part time).
  • cannot determine the default Attendance Type value (full time).
  • cannot determine the Attendance Mode value (Internal).
  • cannot determine the Attendance Mode value (External).
  • cannot determine the Attendance Mode value (Multi-modal).
  • cannot determine the Government Semester for - <load calendar instance, teaching calendar type>
  • cannot determine the Teaching Census Date for - <teaching calendar instance>
  • cannot determine the government submission reportable value <details of record>
  • person data not found for person - <person id>
  • cannot find student course attempt data - <student course attempt>
  • cannot determine the attendance type for - <student course attempt>
  • cannot determine the attendance mode for - <student course attempt>
  • cannot find unit data - <unit version>
  • cannot find student course attempt data - <student course attempt>

 

Job Parameters

Parameter

Description

Submission

Used to specify the submission for which the Government Snapshot is being run e.g. 1998 1, 1998 2 Select a submission from the list of values

Enrolment Statistics Snapshot

Used to specify the Enrolment Statistics Snapshot to be used, by this job, to produce the Government Snapshot. Either specify a snapshot here, or leave this parameter blank and use the next parameter

Use Most Recent Enrolment Statistics Snapshot

Options are to have the box ticked or unticked. By ticking the box, causes the most recently produced Enrolment Snapshot to be used by this process. If the box is ticked, the Enrolment Statistics Snapshot parameter must be blank. This parameter must be unticked where a snapshot has been specified for the previous parameter.

Use RTS EFTSU Calculation

This can be used to indicate if the snapshot should use the special flat-rate RTS EFTSU calculation instead of the standard EFTSU calculation for RTS students. The flat-rate RTS EFTSU calculation is based on the nominated student course attempt attendance type.

Previous Log Creation Date

By specifying a Previous Log Creation Date, the exception report from a previous run of this job can be reproduced. Select a previous log record from the list of values. If this parameter is used, the Enrolment Statistics Snapshot parameter must be blank and the 'Use Most Recent.....' parameter must be unticked.

Report Level

Options are 'SUMMARY ONLY' or 'ALL'. SUMMARY ONLY should be used for an initial run of this job for a particular government submission. This produces a statistical summary of the various errors (exceptions) logged during the process. Large volume errors can then be addressed en-masse. Subsequent runs should use the ALL option, so that lower volume errors can be addressed on a record by record basis.

Message Number

Specifying an error log message number here, causes only those records with that message number to be displayed in the exception report. This is useful for isolating, and dealing with, one error at a time.

 

Output

Exception Report (STAR0110)

 

This is a report of exceptions that are logged while creating the Government Submission Snapshot. It is used to identify data anomalies for rectification. The aim is to provide a 'clean' set of data for the government submission files and for internal reporting.

 

Updated 11 March 2002