JOB TITLE:     COF COMPARE FILE TO BR FILE

DESCRIPTION:
This job reads a  Records COF file (invoice or reconciliation) and expands the file to include student id number.  The expanded file is then compared to a BRS COF download file (pre-invoice, invoice, or reconcilation).  Mismatch reports are produced listing students not found on both of the files.  A report is also created if there is a difference in COF eligible hours on the  files.
 

INPUT:
Records COF file (from TAEI or TAER)
BR COF downloadable file (from TETM, TETO, or TETP)

CONTROL PARAMETERS:

    Title:  COF Compare control record

    Example:
 

BD,B1,YT=064,FROM BR JOB=TETM,FROM RECORDS JOB=TAEI 12345678901234567890123456789012345678901234567890123456789012345678901234567890

    Format:
 

POSITION	FIELD	VALUE
01 02	INSTITUTION	Institution id of campus to be reported.
03 03	DELIMITER	Space or comma (,)
04 05	ACADEMIC UNIT	Academic unit of campus to be reported.
06  06	DELIMITER	Space or comma (,)
07  09	FIELD LABEL	'YR='
10  12	YEAR/TERM	Option specifying the year and term to be reported. Format :, CCYYT
13  13	DELIMITER	Space or comma (,)
14  25	FIELD LABEL	FROM BR JOB=
26  29	BR SOURCE	Name of job that created the BR COF downloadable file.  This field is used to format the titles on the reports. Valid: TETM. TETO, TETP
30  30	DELIMITER	Space or comma (,)
31  47	FIELD LABEL	FROM RECORDS JOB=
48  51	RECORDS SOURCE	Name of job that created the Records COF file.  This field is used to format the titles on the reports. Valid:  TAEI, TAER

    REPORT INFO:
Missing Records report (MISSINV)
Missing BR report (MISSBR)
Hours Difference report (DIFFER)