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