TETM

JOB NAME: TETM

JOB TITLE: COF PRE-INVOICING REPORT

DESCRIPTION:

This job reads the SIS database and reports students with a COF authorization flag of 'Y' for the year/term/institution specified on the control record. COF eligible hours and tuition calc stipend hours will be compared to produced a summary report of variances between the two. Exception and error reports will also be produced. A detail report and/or detail file will be produced when specified on the control record.

NOTE: Exceptions are students whose COF eligible hours and tuition calc stipend hours are not equal. These would be students that are concurrent, have withdrawn, have reached their limit, etc. Exceptions should be able to be verified through SIS.

Errors are students that do not have one of the necessary database records needed to be reported. If database records are missing, the students will not show on the detail or summary reports. Depending on what record(s) are missing, it would be possible for the student to be on the invoicing file from records but missing from the TETM reports. Consult with programming staff on any student that appears on this report.

INPUT:
SIS database

CONTROL PARAMETERS:

Title: COF Pre-invoicing Control Record

Example:

DN,D1,YT=057,DETLRPT=Y
12345678901234567890123456789012345678901234567890123456789012345678901234567890

DN,D1,YT=057,DETLRPT=Y 12345678901234567890123456789012345678901234567890123456789012345678901234567890

    Format:

POSITION FIELD VALUE

1    2 INSTITUTION Institution to be reported.

3    3 DELIMITER Space or comma (,)

4    5 AU Academic unit to be reported

6    6 DELIMITER Space or comma (,)

7    9 FIELD LABEL YT=

10   12 YEAR/TERM Year and term to be reported.
Format: YYT

13   13 DELIMITER Space or comma (,)

14   21 FIELD LABEL DETLRPT=

22   22 DETAIL REPORT Option specifying whether or not to produce a printed detail report
Y = Yes, produce a detail report
N = No, do not produce a detail report

POSITION	FIELD	VALUE
1 2	INSTITUTION	Institution to be reported.
3 3	DELIMITER	Space or comma (,)
4 5	AU	Academic unit to be reported
6 6	DELIMITER	Space or comma (,)
7 9	FIELD LABEL	YT=
10 12	YEAR/TERM	Year and term to be reported. Format: YYT
13 13	DELIMITER	Space or comma (,)
14 21	FIELD LABEL	DETLRPT=
22 22	DETAIL REPORT	Option specifying whether or not to produce a printed detail report Y = Yes, produce a detail report N = No, do not produce a detail report

REPORT INFO:
COF pre-invoicing summary report
COF pre-invoicing exception report
COF pre-invoicing error report
COF pre-invoicing detail report (if requested)

OTHER OUTPUT:
Pre-invoicing detail file, SIS.DOWNLD.TETM&INST - may be used as input into TETMF.
Backup tape of pre-invoicing detail file (SIS.TETM.&INST.V&IDENT) - will be used as input into post-invoicing report job, TETO