TEVI$

JOB NAME: TEVI$

JOB TITLE: SCHOLARSHIP GENERATOR PURGE

DESCRIPTION:
This job purges scholarship generator request records (control, student, and appointment records) if they match a specified year/term and campus. The purged records are written to a tape dataset and can be restored to the database using job TEVJ$.

INPUT:
SIS database

CONTROL PARAMETERS:

Title: Scholarship Generator Purge Control Record (SIPR599)

Example:

PGM=SIPR923 ,AU=B1 ,TERM=977,UPDATE=N,EXT=1 ;
12345678901234567890123456789012345678901234567890123456789012345678901234567890

PGM=SIPR923 ,AU=B1 ,TERM=977,UPDATE=N,EXT=1 ; 12345678901234567890123456789012345678901234567890123456789012345678901234567890

Format:

01 04 FIELD LABEL 'PGM='

05 11 PROGRAM ID 'SIPR923' Required.

12 12 DELIMITER Space or comma (,)

13 15 FIELD LABEL 'AU='

16 17 ACADEMIC UNIT Academic unit to be purged. Required.
Valid = B1, B2, B3, C1, C2, C3, D1, D2, D3, H1, H2, or H3

18 18 DELIMITER Space or comma (,)

19 23 FIELD LABEL 'TERM='

24 26 YEAR/TERM Year and term of records to be purged. Required.
Must be numeric.

27 27 DELIMITER Space or comma (,)

28 34 FIELD LABEL 'UPDATE='

35 35 UPDATE OPTION Y=Yes, purge records from the SIS database
N=No, do not purge - report only

36 36 DELIMITER Space or comma (,)

37 40 FIELD LABEL 'EXT='

EXTERNAL External indicators to be included in the purge. The external indicator on the student scholarship generator request record must match one of the external indicators to be included in the purge. Space is a valid external indicator. Up to five (5) external indicators may be specified.

41 41 EXTERNAL 1 First external indicator to be included.

42 42 EXTERNAL 2 Second external indicator to be included.

43 43 EXTERNAL 3 Third external indicator to be included.

44 44 EXTERNAL 4 Fourth external indicator to be included.

45 45 EXTERNAL 5 Fifth external indicator to be included.

01 04	FIELD LABEL	'PGM='
05 11	PROGRAM ID	'SIPR923' Required.
12 12	DELIMITER	Space or comma (,)
13 15	FIELD LABEL	'AU='
16 17	ACADEMIC UNIT	Academic unit to be purged. Required. Valid = B1, B2, B3, C1, C2, C3, D1, D2, D3, H1, H2, or H3
18 18	DELIMITER	Space or comma (,)
19 23	FIELD LABEL	'TERM='
24 26	YEAR/TERM	Year and term of records to be purged. Required. Must be numeric.
27 27	DELIMITER	Space or comma (,)
28 34	FIELD LABEL	'UPDATE='
35 35	UPDATE OPTION	Y=Yes, purge records from the SIS database N=No, do not purge - report only
36 36	DELIMITER	Space or comma (,)
37 40	FIELD LABEL	'EXT='
	EXTERNAL	External indicators to be included in the purge. The external indicator on the student scholarship generator request record must match one of the external indicators to be included in the purge. Space is a valid external indicator. Up to five (5) external indicators may be specified.
41 41	EXTERNAL 1	First external indicator to be included.
42 42	EXTERNAL 2	Second external indicator to be included.
43 43	EXTERNAL 3	Third external indicator to be included.
44 44	EXTERNAL 4	Fourth external indicator to be included.
45 45	EXTERNAL 5	Fifth external indicator to be included.

REPORT INFO:
SIPR923 - Scholarship Generator Purge report

OTHER OUTPUT:
Updated SIS database
Backup tape file of purged scholarship generator records (SIS.TEVI.PURGE.&campus..D&date)
[This file may be used as input into the Restore Scholarship Generator Records job (TEVJ$).]