Assignment Cover Sheets Extract Creation - ASSJ3501

This process extracts information from the database, and updates the database.

Subsystem

Assessments

Purpose

To produce an extract file containing relevant information for inclusion in assignment cover sheets.

Normally Run By

An Assessment administrator.

Anticipated Frequency

Should be scheduled to run after the prerequisite job is run. The prerequisite job is run whenever cover sheets are required - typically weekly.

Parameter Sample

No parameters required. Parameters set in the prerequisite job (ASSJ3500/ASSJ3500R) determine the records extracted.

Prerequisite Jobs 

One of ASSJ3500 or ASSJ3500R is a prerequisite for this job. This job cannot be run alone.

 

 

Extract Process

This job uses the generic 'extract table' structure to store extracted data. This data can then be used for the production of assignment cover sheets. An insitution should custom-build a program to use the extracted data (and data from other Callista tables if required), accessing this data via views specifically created for the assignment cover sheet extract process. This methodology is described in Extract Creation Processes.

As an example of use of this job, institutions may create a program to merge data presented in the assignment cover sheet record view (ASS_COVER_RECORD_V) into Microsoft Word documents to produce assignment cover sheets.

Details of the data available in Assignment Cover Sheet Extract views are available in Assignment Cover Extract - View Details.

Record Extraction

The extract process creates a record in the S_EXTRACT table that identifies the particular instance of the extract job run and the parameters set. It creates corresponding records for assignment cover sheets in the S_EXTRACT_RECORD table. Up to seven different types of record can be held for each assignment cover sheet extracted. These records are:

  • a header record containing a comment (record type = HEADER).
  • records for each student due to receive an assignment cover sheet. For each the following are extracted, where applicable:
    • person details (record type = PERSON).
    • address details (record type = ADDRESSES).
    • details of course attempts (record type = COURSE ATTEMPTS).
    • details of unit attempts (record type = UNIT ATTEMPTS).
    • details of assessment item (record type = ASSESSMENT DETAILS).
  • summary of the number of each of the previous five records extracted (record type = FOOTER).

 

Run Details

Method

This job can be run only in batch mode, through the Job Control & Scheduling subsystem.

ASSJ3500 or ASSJ3500R are prerequisite jobs that must be run before this job. The Job Run ID links the prerequisite job and this job, so the correct data is extracted to the file.

The date and time of extract is stored with the extracted records.

Viewing the extracted data

Data is usually processed by the institution's custom-built assignment cover sheet creation/printing job. Data can be viewed in the S_EXTRACT and S_EXTRACT_RECORD tables, or in a more useable form in the views ASS_COVER_EXTRACT_V and ASS_COVER_RECORD_V, using an ad-hoc query tool. These views are described in detail in Assignment Cover Extract - View Details.

 

Last Modified on 16 December, 1999