JOB TITLE: COF POST-RECONCILIATION 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 reconciliation accepted hours and tuition calc stipend hours will be compared to produce 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 reconciliation 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 reconciliation file from records but missing from the TETP reports. Consult with programming staff on any student that appears on this report.
INPUT:
SIS database
CONTROL PARAMETERS:
Title: COF post-reconciliation 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-reconciliation summary report
COF post-reconciliation exception report
COF post-reconciliation error report
COF post-reconciliation detail report (if requested)
OTHER OUTPUT:
Post-reconciliation detail file - (SIS.DOWNLD.TETP.&INST)
- may be used as input into TETPF.
Backup tape of post-reconciliation detail file - SIS.TETP.&INST.V&IDENT