Delete Extract Records - GENJ0020

Subsystem

System

Purpose

The process is used to perform a bulk delete of extract records from the system extract and system extract record logs, that are deemed to be no longer required

Normally Run By

Scheduled to run automatically at regular intervals

Anticipated Frequency

Dependent on the institution's data storage and management practices

Update Process(es)

Physically deletes selected Extract Records entries

Parameter Sample

 

Reports

No reports are produced.

 

Update Process

Callista jobs such as testamur, statement of account and enrolment forms produce extract files. These extracts can be accessed to produce reports in a format defined by the institution.

This job is used to remove from the System, extracts that have been recorded for greater than a specified period of time. For example, the job could be run nightly to delete all statement of account extract entries older than 28 days.

 

Run Details

This job is typically run:

  • as a standing request in an 'off-peak' run window
  • as frequently as the institution's data management regime requires, although it is recommended that the job be set to run approximately monthly

 

Job Parameters

Parameters are used to restrict the set of extract entries to be deleted.

  • System Extract Type - (mandatory) restricts the deletion of entries to a specific extract type. The extract type is an abbreviated name for the system extract type that produced the entry. A separate instance of this job must be requested to delete entries of each extract type. This allows entries of each extract type to be deleted at different ages.
  • Days Old - specifying a number causes entries of the specified extract type to be deleted if they are older than that number of days.

 

Last Modified on 26 July 1999