Return to Navigation

Purging the EDI TS130 Staging Table and Messages

This section discusses how to purge the EDI TS130 staging table and messages.

Page Name

Definition Name

Navigation

Usage

EDI TS130 Purge Parms (EDI TS130 purge parameters)

ADM_TS130_PUR_PARM

select Student Admissions, then select Application/Transcript Loads, then select TS130, then select Purge Process

Purge records and messages, if applicable, from the EDI TS130 staging table.

Access the EDI TS130 Purge Parms page (select Student Admissions, then select Application/Transcript Loads, then select TS130, then select Purge Process).

Image: EDI TS130 Purge Parms page

This example illustrates the fields and controls on the EDI TS130 Purge Parms page. You can find definitions for the fields and controls later on this page.

EDI TS130 Purge Parms page

Purge Processing Parameter

Field or Control

Definition
All Suspense Rows

Select this option to purge all records in your staging table, regardless of the posting status shown in the Post field of the Process Options and Org Process Options pages.
Marked Suspense Rows

Select this option to purge only those records in your staging table marked Purge in the Post field of the Process Options and Org Process Options pages.

Purge Option for Marked Rows

This group box appears when you select the Marked Suspense Rows option.

Field or Control

Definition
All Marked Suspense Rows

Select this option to purge all the records in your staging table that are marked Purge in the Post field of the Process Options and Org Process Options pages.
Rows Loaded before or on

Select this option and enter a date to purge only those staging records that were loaded on or before the specified date and that are marked Purge in the Post field of the Process Options and Org Process Options pages.

Use the Dt Loaded (date loaded) field on the EDI TS130 Process Options page to see when you loaded a record.

Suppose you loaded transcripts on May 10, 2008. Subsequently, you loaded another set of transcripts on May 15, 2008. If you select the Rows Loaded before or on option and specify the date as May 15, 2008, the purge process deletes the transcript records marked Purge that were loaded on May 15, 2008, and May 10, 2008.

Rows Posted before or on

Select this option and enter a date to indicate that you want to purge only those staging records that are marked Purge in the Post field of the Process Options and Org Process Options pages and that were posted on or before the specified date.

Use the Dt Posted (date posted) field on the EDI TS130 Process Options page to see when you posted a record.

Suppose you posted transcripts on May 10, 2008. Subsequently, you posted another set of transcripts on May 15, 2008. If you select the Rows Posted before or on option and specify the date as May 15, 2008, the purge process deletes the transcript records marked Purge that were posted on May 15, 2008, and May 10, 2008.

Message Purge Parameters

Field or Control

Definition
Retain Associated Messages

Select this option if you do not want to purge messages associated with the files that you are purging.

Remove Associated Messages

Select this option if you do want to purge messages associated with the files that you are purging.

Click the Run button to run the EDI TS130 Transcript Purge process at user-defined intervals.