JOB NAME:     TAEL

JOB TITLE:     CREATE COF NOT APPLIED, NOT AUTH., REFUSED AUTHORIZATION FILES

DESCRIPTION:
This job reads the SIS database and reports on enrolled students that have not applied for COF, or have not authorized COF, or have refused COF authorization.  Only COF eligible students are reported.  Downloadable files may be transferred to the FTP server using job TAELF.

Program logic:  Program student term records (IARRCRT) for students with a term record that matches the acacemic unit and term specified on parameter record 1.  Students with registration types RCS, DGO, RCC, RCW, RCE, and RIE are bypassed.  Students that do not pass the "standard" COF eligibility requirements are bypassed.

INPUT:
SIS database

CONTROL PARAMETERS:

    Title:  Authorization Report parameter record 1 (TAEL01)

    Example:
 


PGMID=TAEL01,PARMREC=1,AU=B1,TERM=20061,CONTINUING-ONLY=N
12345678901234567890123456789012345678901234567890123456789012345678901234567890

    Format:
 


POSITION FIELD VALUE
 01  06  FIELD LABEL  PGMID=
 07  12   PROGRAM ID  TAEL01    Required.
 13  13  DELIMITER  Space or comma (,)
 14  21  FIELD LABEL  PARMREC=
 22  22  RECORD IDENTIFIER  Parameter record identifier.  Valid = 1 Required.
 23  23  DELIMITER  Space or comma (,)
 24  26  FIELD LABEL  AU=
 27  28  ACADEMIC UNIT  Academic unit to be reported        Required.
 Valid: B1, B2, B3, C1, C2, C3, D1, D2, D3, H1, H2, H3
 29  29  DELIMITER  Space or comma (,)
 30  34  FIELD LABEL  TERM=
 35  39  TERM  Term to be reported.   Required.
 Format:  CCYYT
 40  40  DELIMITER  Space or comma (,)
 41  56  FIELD LABEL  CONTINUING-ONLY=
 57  57  CONTINUING ONLY   Option specifying whether to select only students with "continuing" registration types.      Required.

"Continuing" registration types are defined as CON, RSO, CIU, RIU, CCD, RTO, and RTR only.  All other registration types will be  bypassed when this option is set to 'Y'.

Valid:
Y = Yes, select only students with "continuing" registration types
N = No, do not limit report to "continuing" students.

    Title:       Authorization Report parameter record 2 (TAEL01)

    Example:
 


PGMID=TAEL01,PARMREC=2,NOTAPPLIED=Y,NOTAUTH=Y,REFUSEDAUTH=Y
12345678901234567890123456789012345678901234567890123456789012345678901234567890

    Format:
 


POSITION FIELD VALUE
 01  06 FIELD LABEL PGMID=
 07  12 PROGRAM ID TAEL01    Required.
 13  13 DELIMITER Space or comma(,)
 14  21 FIELD LABEL PARMREC=
 22  22 RECORD IDENTIFIER Parameter record identifier.  Valid = 2  Required.
 23  23 DELIMITER Space or comma(,)
 24  34 FIELD LABEL NOT APPLIED=
 35  35 NOT APPLIED OPTION  Option specifying whether to report students that have not submitted an application to receive Colorado Opportunity Fund monies from the state.     Required.
Valid:
Y = Yes, Report students who have not applied for COF
N = No, do not report students who have not applied
36  36 DELIMITER Space or comma(,)
37  44 FIELD LABEL NOT AUTH=
45  45 NOT AUTHORIZED OPTION Option specifying whether to report students that have not authorized use of their COF hours in the term being reported.   Required.
Valid:
Y = Yes, Report students who have not authorized COF
N = No, do not report students who have not authorized
46  46 DELIMITER Space or comma(,)
47  58 FIELD LABEL REFUSEDAUTH=
59  59 REFUSED AUTHORIZATION OPTION Option specifying whether to report students that have not authorized use of their COF hours in the term being reported.   Required.
Valid:
Y = Yes, Report students who have not authorized COF
N = No, do not report students who have not authorized

REPORT INFO:
Not Applied Report
Not Authorized Report
Refused Authorization Report.

OTHER OUTPUT:
Not applied download file (SIS..TD.TAEL.COFEMAIL.REG.NOAPP.&au)
Not authorized download file (SIS.TD.TAEL.COFEMAIL.REG.NOAUTH.&au)
Refused authorization download file (SIS.TD.TAEL.COFEMAIL.REG.REFAUTH.&au)