JOB NAME: LLTB/LLTD - Student loan/SIS in-school status reports
JOB PURPOSE: This job determines the enrollment status for active
borrowers on the student loan master file. Three
reports are printed: enrolled students, non-enrolled
students and deferred students. Separation dates may
be updated for borrowers (based on home-AU and loan
status) when the tape create option is selected. Labels
may print for non-enrolled borrowers, if the label
option is selected.
JOB SUBMISSION:
*Normal Run Frequency: Once per campus/semester as requested
by each campus.
*Conflicts: This job should NOT be run while LLDA (EduServe
Master File Build) is running.
*Dependencies: Run LLTB after LLDA, if scheduled on the same
day/night.
*Run Considerations: This job reads the weekly loan master file
LAMV.LOAN.MASTER. The customer coordinator should load the
latest EduServ tape received before running this job to ensure
the most accurate results for all reports created by this job.
LLDA is a weekly job and will usually run on Thursdays during
the day. After the high number in the EduServ batch number range
is used, then go back to the beginning batch range number for the
next EduServ tape create for that campus.
EduServ batch numbers:
UCB: Use batch number range 732 - 762 and increment by 1 with
each tape created.
HSC: Use batch number range 794 - 824 and increment by 1 with
each tape created.
UCD: Use batch number range 856 - 886 and increment by 1 with
each tape created.
CS: Use batch number range 918 - 948 and increment by 1 with
each tape created.
PROGRAM LIST:
*LAPR005 - In-school status enrollment program for Boulder, Denver,
Colorado Springs and Health Sciences Center professional students
only.- LLTB#3
*LAPR007 - In-school status enrollment status program for Health
Sciences Center undergraduate and graduate students only. - LLTD#3
*LLTB4 - Prints enrolled, non-enrolled and deferred/in-repayment status
reports. Labels for non-enrolled students may also be printed, if
selected by control card option. - LLTB#4 AND LLTD#4
JOB SETUP:
*Symbolic Parameters:
CAMPUS - Campus abbreviation in two character format
YEAR/TERM - Year/term selection
PRTM1 - Dispatch parameters for reports
PRTL1 - Dispatch parameters for labels
*Control records:
0120 LAPR005A SETUP RECORD PRECEDES
01 07 PROGRAM ID - VALUE 'LAPR005'.
08 08 RECORD TYPE - VALUE 'A'.
09 14 LITERAL VALUE ',INST='.
15 16 INSTITUTION. VALUE 'BD'=BOULDER
'CS'= COLORADO SPRINGS
'DN'= DENVER
'HS'= HEALTH SCIENCES
17 22 LITERAL VALUE ',TERM='.
23 25 REPORT ENROLLMENT TERM - FORMAT YYT.
26 30 LITERAL VALUE ',AU1='.
31 32 HOME AU1 OF SELECTED CAMPUS UCB=B1
HSC=H1
UCD=D1
UCCS=C1
33 37 LITERAL VALUE ',AU2'.
38 39 HOME AU2 OF SELECTED CAMPUS UCB=B2
HSC=H2
UCD=D2
UCCS=C2
40 50 LITERAL VALUE ',STARTDATE='.
51 56 TERM START DATE CORRESPONDING TO
ABOVE TERM - FORMAT MMDDYY.
57 65 LITERAL VALUE ',ENDDATE='.
66 71 TERM END DATE CORRESPONDING TO
ABOVE TERM - FORMAT MMDDYY.
72 80 NOT USED.
0120 LAPR005B SETUP RECORD PRECEDES
01 07 PROGRAM NAME - VALUE 'LAPR005'
08 08 SETUP RECORD TYPE - VALUE 'B'.
09 16 LITERAL VALUE ',CAMPUS='.
17 18 CAMPUS (UCB=01, HSC=02, UCD=03, UCCS=04).
19 27 LITERAL VALUE ',SEPDATE='.
28 33 SEPARATION DATE FOR CURRENTLY
ENROLLED STUDENTS -FORMAT
MMDDYY.
34 40 LITERAL VALUE ',BATCH='.
41 45 EDUSERV BATCH NUM (0732-0948) FOR
SEPARATION DATE UPDATE TAPE. (SEE
NOTES SCREEN FOR PROPER USAGE OF
BATCH NUMBERS BY CAMPUS.)
46 56 LITERAL VALUE',BATCHDATE='.
57 62 EDUSERV BATCH DATE FOR SEP. DATE
UPDATE TAPE IN FORMAT MMDDYY.
(USE RUN DATE FOR EDUSERV BATCH
DATE.)
63 68 LITERAL VALUE ',TAPE='.
69 69 TAPE CREATE SELECT: Y= CREATE SEPARATION
DATE UPDATE TAPE
N= DON'T CREATE SEP.
DATE UPDATE TAPE
70 80 NOT USED.
0120 LAPR005C SETUP RECORD PRECEDES
01 07 LITERAL VALUE 'LAPR005'.
08 08 LITERAL VALUE 'C'.
09 16 LITERAL VALUE ',LABELS='.
17 17 LABEL CREATE OPTION: Y= CREATE LABELS FOR
NON-ENROLLED.
N= DON'T CREATE LABELS.
18 80 NOT USED.
FILES:
*Input:
(D) LAMV.LOAN.MASTER
(D) SIS DATABASE
*Output:
(T) LAM.&CAMPUS..EDU.SEPDATES (optional)
(T) LAM.&CAMPUS..EDU.SEPDATES.BACKUP (optional)
*I/O:
NONE
REPORTS:
*Title: ENROLLED STUDENTS REPORT (BY CAMPUS)
*Description: List of borrowers enrolled at least half time in
current term.
*Title: NON-ENROLLED STUDENTS REPORT (BY CAMPUS)
*Description: List of borrowers not enrolled at least halftime in
current term.
*Title: DEFERRED/IN-REPAYMENT REPORT (BY CAMPUS)
*Description: List of borrowers in deferred payment status.
PROGRAM NAME AND DESCRIPTION:
*LAPR005 - IN-SCHOOL STATUS ENROLLMENT PROGRAM FOR BOULDER, DENVER,
COLORADO SPRINGS AND HEALTH SCIENCES CENTER PROFESSIONAL
STUDENTS ONLY.
MESSAGE: INVALID PROGRAM NAME IN CONTROL CARD1.
ACTION: CORRECT PGM ID 1 AND RERUN JOB.
MESSAGE: INVALID PROGRAM NAME IN CONTROL CARD2.
ACTION: CORRECT PGM ID 2 AND RERUN JOB.
MESSAGE: INVALID PROGRAM NAME IN CONTROL CARD3
ACTION: CORRECT PGM ID 3 AND RERUN JOB.
MESSAGE: CC-YEAR NOT NUMERIC.
ACTION: CORRECT YEAR/TERM AND RERUN JOB.
MESSAGE: CC-TERM NOT NUMERIC.
ACTION: CORRECT YEAR/TERM AND RERUN JOB.
MESSAGE: INVALID CC-TERM.
ACTION: CORRECT YEAR/TERM AND RERUN JOB.
MESSAGE: CC-CAMPUS NOT NUMERIC
ACTION: CORRECT CAMPUS AND RERUN JOB.
MESSAGE: CC-DEF-START-DATE NOT NUMERIC.
ACTION: CORRECT START DATE AND RERUN JOB.
MESSAGE: CC-DEF-END-DATE NOT NUMERIC.
ACTION: CORRECT END DATE AND RERUN JOB.
MESSAGE: CC-TAPE-CREATE-SW INVALID.
ACTION: CORRECT TAPE CREATE SWITCH AND RERUN JOB.
MESSAGE: CC-LABEL-CREATE-SW INVALID.
ACTION: CORRECT LABEL CREATE SWITCH AND RERUN JOB.
MESSAGE: CC-BATCH-NUMBER NOT NUMERIC.
ACTION: CORRECT BATCH NUMBER AND RERUN JOB.
MESSAGE: AU SYSTEM CONTROL RECORD NOT
FOUND (FOR AU1 IN SIS).
ACTION: CHECK CONTROL CARD AU1. IF BAD, FIX AND
RERUN; OTHERWISE CALL DBA.
MESSAGE: CONVERSION FAILED FOR LOAN DATA (LOAN PGM
NUMBER NOT FOUND IN CONVERSION TABLE)
ACTION: NOTIFY LOAN SYSTEMS ANALYST.
MESSAGE: MISSING AU RECORD.
ACTION: EITHER BAD CC-AU'S (FIX/RERUN) OR PGM
PROBLEM (CALL PGMR TO FIX).
MESSAGE: AU TERM SUFFIX MATCH NOT FOUND FOR CC-TERM.
ACTION: PROBABLE BAD SETUP YEAR/TERM; FIX AND
RERUN JOB.
MESSAGE: ENROLLMENT LEVEL NOT U, G OR P
ACTION: INFORMATIONAL MESSAGE ONLY.
MESSAGE: TERM CONTROL RECORD NOT FOUND.
ACTION: PROBABLE PGM OR DATABASE PROBLEM, CALL
PGMR, FIX AND RERUN.
MESSAGE: CULLINET ABORTED - MESSAGES FOLLOW.
ACTION: SEE IDMS MANUAL, FIX ERROR AND RERUN JOB.
MESSAGE: NOTE: SEPARATION TAPE NOT CREATED.
ACTION: INFORMATIONAL MESSAGE ONLY.
*LAPR007 - IN-SCHOOL STATUS ENROLLMENT STATUS PROGRAM
FOR HEALTH SCIENCES CENTER UNDERGRADUATE
AND GRADUATE STUDENTS ONLY. - LLTD#3
MESSAGE: INVALID PROGRAM NAME IN CONTROL CARD1.
ACTION: CORRECT PGM ID 1 AND RERUN JOB.
MESSAGE: INVALID PROGRAM NAME IN CONTROL CARD2.
ACTION: CORRECT PGM ID 2 AND RERUN JOB.
MESSAGE: INVALID PROGRAM NAME IN CONTROL CARD3
ACTION: CORRECT PGM ID 3 AND RERUN JOB.
MESSAGE: CC-YEAR NOT NUMERIC.
ACTION: CORRECT YEAR/TERM AND RERUN JOB.
MESSAGE: CC-TERM NOT NUMERIC.
ACTION: CORRECT YEAR/TERM AND RERUN JOB.
MESSAGE: INVALID CC-TERM.
ACTION: CORRECT YEAR/TERM AND RERUN JOB.
MESSAGE: CC-CAMPUS NOT NUMERIC
ACTION: CORRECT CAMPUS AND RERUN JOB.
MESSAGE: CC-DEF-START-DATE NOT NUMERIC.
ACTION: CORRECT START DATE AND RERUN JOB.
MESSAGE: CC-DEF-START-DATE NOT NUMERIC.
ACTION: CORRECT START DATE AND RERUN JOB.
MESSAGE: CC-DEF-END-DATE NOT NUMERIC.
ACTION: CORRECT END DATE AND RERUN JOB.
MESSAGE: CC-TAPE-CREATE-SW INVALID.
ACTION: CORRECT TAPE CREATE SWITCH AND
RERUN JOB.
MESSAGE: CC-LABEL-CREATE-SW INVALID.
ACTION: CORRECT LABEL CREATE SWITCH AND
RERUN JOB.
MESSAGE: CC-BATCH-NUMBER NOT NUMERIC.
ACTION: CORRECT BATCH NUMBER AND RERUN JOB.
MESSAGE: AU SYSTEM CONTROL RECORD NOT FOUND
(FOR AU1 IN SIS).
ACTION: CHECK CONTROL CARD AU1. IF BAD, FIX AND
RERUN; OTHERWISE CALL DBA.
MESSAGE: CONVERSION FAILED FOR LOAN DATA
(LOAN PGM NUMBER NOT FOUND IN
CONVERSION TABLE)
ACTION: NOTIFY LOAN SYSTEMS ANALYST.
MESSAGE: MISSING AU RECORD.
ACTION: EITHER BAD CC-AU'S (FIX/RERUN) OR PGM
PROBLEM (CALL PGMR TO FIX).
MESSAGE: AU TERM SUFFIX MATCH NOT FOUND FOR CC-TERM.
ACTION: PROBABLE BAD SETUP YEAR/TERM; FIX AND
RERUN JOB.
MESSAGE: ENROLLMENT LEVEL NOT U, G OR P
ACTION: INFORMATIONAL MESSAGE ONLY.
MESSAGE: TERM CONTROL RECORD NOT FOUND.
ACTION: PROBABLE PGM OR DATABASE PROBLEM, CALL
PGMR, FIX AND RERUN.
MESSAGE: CULLINET ABORTED - MESSAGES FOLLOW.
ACTION: SEE IDMS MANUAL, FIX ERROR AND RERUN JOB.
MESSAGE: NOTE: SEPARATION TAPE NOT CREATED.
ACTION: INFORMATIONAL MESSAGE ONLY.
*LLTB4 - PRINTS ENROLLED, NON-ENROLLED AND DEFERRED/
IN-REPAYMENT STATUS REPORTS. LABELS FOR NON-
ENROLLED STUDENTS MAY ALSO BE PRINTED, IF
SELECTED BY CONTROL CARD OPTION.
- LLTB#4 AND LLTD#4
MESSAGE: SEPARATION TAPE CREATED BY THIS RUN.
ACTION: INFORMATION MESSAGE ONLY.
MESSAGE: SEPARATE TAPE WAS NOT CREATED.
ACTION: INFORMATIONAL MESSAGE ONLY.
VALIDATION PROCEDURE:
* Check JCL messages for error condition return codes in any step.
Condition code 0004 is valid in LLTB#4 and LLTD#4 when tape
create option "N" is selected in the control card for LLTB#2 and
LLTD#2.
* Review miscellaneous output report for LLTB4 to determine whether
an EduServ Separation Date Tape was created by the run. Look for a
message stating whether a separation date tape was created or not. If
the tape was created, it must be sent promptly to EduServ for updating
to their database.
RERUN INSTRUCTIONS:
LLTB Setup # Program Name
1 CORRECT ERROR AND RERUN JOB. IEFBR14
MESSAGE: SEE SYSTEM UTILITIES MESSAGES MANUAL.
ACTION: CORRECT ERROR AND RERUN JOB.
2 CORRECT ERROR AND RERUN JOB. IEBGENER
MESSAGE: SEE SYSTEM UTILITIES MANUAL.
ACTION: CORRECT ERROR AND RERUN JOB.
3 CORRECT ERROR AND RERUN JOB. LAPR005
MESSAGE: INVALID PROGRAM NAME IN CONTROL CARD1
ACTION: CORRECT PGM ID 1 AND RERUN JOB.
MESSAGE: INVALID PROGRAM NAME IN CONTROL CARD2
ACTION: CORRECT PGM ID 2 AND RERUN JOB.
MESSAGE: INVALID PROGRAM NAME IN CONTROL CARD3
ACTION: CORRECT PGM ID 3 AND RERUN JOB.
MESSAGE: CC-YEAR NOT NUMERIC.
ACTION: CORRECT YEAR/TERM AND RERUN JOB.
MESSAGE: CC-TERM NOT NUMERIC.
ACTION: CORRECT YEAR/TERM AND RERUN JOB.
MESSAGE: INVALID CC-TERM
ACTION: CORRECT YEAR/TERM AND RERUN JOB.
MESSAGE: CC-CAMPUS NOT NUMERIC
ACTION: CORRECT CAMPUS AND RERUN JOB.
MESSAGE: CC-DEF-START-DATE NOT NUMERIC.
ACTION: CORRECT START DATE AND RERUN JOB.
MESSAGE: CC-DEF-END-DATE NOT NUMERIC.
ACTION: CORRECT END DATE AND RERUN JOB.
MESSAGE: CC-TAPE-CREATE-SW INVALID.
ACTION: CORRECT TAPE CREATE SWITCH AND RERUN JOB.
MESSAGE: CC-LABEL-CREATE-SW INVALID.
ACTION: CORRECT LABEL CREATE SWITCH AND RERUN JOB.
MESSAGE: CC-BATCH-NUMBER NOT NUMERIC.
ACTION: CORRECT BATCH NUMBER AND RERUN JOB.
MESSAGE: AU SYSTEM CONTROL RECORD NOT FOUND
(FOR AU1 IN SIS).
ACTION: CHECK CONTROL CARD AU1. IF BAD, FIX AND
RERUN; OTHERWISE CALL DBA.
MESSAGE: CONVERSION FAILED FOR LOAN DATA (LOAN
PGM NUMBER NOT FOUND IN CONVERSION TABLE).
ACTION: NOTIFY LOAN SYSTEMS ANALYST.
MESSAGE: MISSING AU RECORD
ACTION: EITHER BAD CC-AU'S (FIX/RERUN) OR PGM
PROBLEM (CALL PGMR TO FIX).
MESSAGE: AU TERM SUFFIX MATCH NOT FOUND FOR
CC-TERM.
ACTION: PROBABLE BAD SETUP YEAR/TERM; FIX AND
RERUN JOB.
MESSAGE: ENROLLMENT LEVEL NOT U, G OR P.
ACTION: INFORMATIONAL MESSAGE ONLY.
MESSAGE: TERM CONTROL RECORD NOT FOUND.
ACTION: PROBABLE PGM OR DATABASE PROBLEM; CALL
PROGRAMMER, FIX AND RERUN.
MESSAGE: CULLINET ABORTED - MESSAGES FOLLOW
ACTION: SEE IDMS MANUAL, FIX ERROR AND RERUN JOB.
MESSAGE: NOTE: SEPARARION TAPE NOT CREATED
ACTION: INFORMATIONAL MESSAGE ONLY.
4 CORRECT ERROR AND RERUN JOB. EZTPA00
MESSAGE: SEPARATION TAPE CREATED BY THIS RUN.
ACTION: INFORMATION MESSAGE ONLY.
MESSAGE: SEPARATION TAPE WAS NOT CREATED.
ACTION: INFORMATIONAL MESSAGE ONLY.
5 CORRECT ERROR AND RERUN JOB. SORT
MESSAGE: SEE SYSTEM SORT MESSAGES MANUAL.
ACTION: CORRECT ERROR AND RERUN JOB.
6 CORRECT ERROR AND RERUN JOB SORT
MESSAGE: SEE SYSTEM SORT MESSAGES MANUAL.
ACTION: CORRECT ERROR AND RERUN JOB.
CHANGE LOG:
931129 New job replaces NPAS (PN) SR6889