TETV

JOB NAME: TETV

JOB TITLE: INELIGIBLE STUDENTS WITH SCHOLARSHIPS

DESCRIPTION:
This job reads the SIS database for students with scholarship records for a specified term. The student benefit flag is then checked and reports of INELIGIBLE Students with Scholarships and ELIGIBLE Students with Deleted Scholarships are produced.

INPUT:
SIS database

CONTROL PARAMETERS:

Title: Scholarship Generator Control Record (this is the SAME control record as specified for the Scholarship Generator - TEIB$)

Example:

SCHPGEN,011B1,BD,EFFECT=050901,Y
12345678901234567890123456789012345678901234567890123456789012345678901234567890

SCHPGEN,011B1,BD,EFFECT=050901,Y 12345678901234567890123456789012345678901234567890123456789012345678901234567890

Format:

POSITION FIELD VALUE

01 08 PROGRAM ID Literal value 'SCHPGEN,'

09 11 CURRENT YEAR/TERM Current SIS year and term. Format YYT.

12 13 ACADEMIC UNIT AU being processed. Valid AU.

14 14 DELIMITER Space or comma(,)

15 16 INSTITUTION Institution being processed. Valid SIS institution.

17 24 FIELD LABEL Literal value ',EFFECT='

25 30 EFFECTIVE DATE Effective date for the transactions. Format MMDDYY.

31 31 DELIMITER Space or comma(,).

32 33 UPDATE SWITCH Option specifying whether to update the SIS database.
Y = Update the database (default)
N= Do not update ( See Notes)

POSITION	FIELD	VALUE
01 08	PROGRAM ID	Literal value 'SCHPGEN,'
09 11	CURRENT YEAR/TERM	Current SIS year and term. Format YYT.
12 13	ACADEMIC UNIT	AU being processed. Valid AU.
14 14	DELIMITER	Space or comma(,)
15 16	INSTITUTION	Institution being processed. Valid SIS institution.
17 24	FIELD LABEL	Literal value ',EFFECT='
25 30	EFFECTIVE DATE	Effective date for the transactions. Format MMDDYY.
31 31	DELIMITER	Space or comma(,).
32 33	UPDATE SWITCH	Option specifying whether to update the SIS database. Y = Update the database (default) N= Do not update ( See Notes)

REPORT INFO:
TETV1 Ineligible Students with Scholarships Report
TETV2 Eligible Students with Deleted Scholarships Report