JOB NAME:   TETO

JOB TITLE:      COF POST-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 invoice accepted hours and tuition calc stipend hours will be compared to produced a summary report of variances between the two.  An exception report, error report, and downloadable detail file will also be produced.  A detail report will be produced when specified on the control record.

NOTE:  Exceptions are students whose COF invoice accepted  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 the Student Information System (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 TETO reports.  Consult with programming staff on any student that appears on this report.

In addition to the reconciliation reports, the detail file from the pre-invoice report (TETM) is compared to the detail file from the post-invoicing report (TETO).  The resulting comparison reports are a tool to be used to better understand the changes in the COF receivable accounts.

INPUT:
SIS database
Backup tape of the pre-invoicing detail file (SIS.TETM.&INST.V&IDENT)

CONTROL PARAMETERS:

    Title:  COF Post-invoicing Control Record

    Example:
 
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

REPORT INFO:
COF post-invoicing summary report
COF post-invoicing exception report
COF post-invoicing error report
COF post-invoicing detail report (if requested)
INVOICED, NO LONGER ELIGIBLE
NOT INVOICED, NOW ELIGIBLE
STUDENTS WITH HOURS CHANGES
STUDENTS WITH ACCEPTED HOURS LESS THAN INVOICED

OTHER OUTPUT:
Post-invoicing detail file - (SIS.DOWNLD.TETO.&INST) -  may be used as input into TETOF
Backup tape of post-invoicing detail file - SIS.TETO.&INST.V&IDENT