JOB NAME: LLTA - STUDENT LOAN/SIS GRADUATION LIST
JOB PURPOSE: Job selects graduating students from records and registration
flat file. It then matches against SIS to select GSL loans,
against EduServ master to select student loans. Reports and
labels are produced along with a tape to update student
separation date for loans with a status of 10 or 11 (if tape
option on setup card 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 (EduServ Master
File Build) is running.
*Dependencies: Run LLTA 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. Make sure the latest
EduServ tape has been loaded to LAMV.LOAN.MASTER via job LLDA before
running this job to ensure the most accurate results for all reports
created by this job. LLDA is a weekly job. After the highest 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 701-731 and increment by 1
with each tape created.
HSC: Use batch number range 763-793 and increment by 1
with each tape created.
UCD: Use batch number range 825-855 and increment by 1
with each tape created.
CS: Use batch number range 887-917 and increment by 1
with each tape created.
Do not send tape to EduServ unless approved by the user.
Include a copy of the LLTAB5 report with tape.
Step #5, if you have a condition code 004 and tape = N in
set-up card, this is okay.
PROGRAM LIST:
*LLTA3 - EXTRACTS GRADUATE FILE FROM SIS FOR ALL CAMPUSES BASED
ON CONTROL CARD YEAR/TERM - LLTA#3
*LLTA4 - CREATE GSL GRADUATE REPORT - LLTA#4
*LLTA5 - THIS PROGRAM PRODUCES 4 VARIETIES OF LOAN/SIS GRADUATION
REPORTS. GRADUATES WITH STATUS OF 10 or 11 HAVE A
TRANSACTION CREATED TO UPDATE THEIR SEPARATION DATE ON
THE EDUSERV SYSTEM VIA TAPE - LLTA#5
*LLTA7 - CREATE SUMMARY REPORTS FOR PERKINS AND GSL CATEGORIES
AND LABELS FOR GSL GRADUATES - LLTA#7
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:
0140 LLTA JCL Line # SETUP CARD PRECEDES THIS LINE.
01 07 LITERAL. VALUE 'CAMPUS='.
08 09 CAMPUS SELECTION:
(01=UCB,02=UCHSC,03=UCD,04=UCCS)
10 20 LITERAL. VALUE ',YEAR/TERM='.
21 23 GRADUATION YEAR/TERM IN FORMAT
YYT (SIS YEAR/TERM).
24 31 LITERAL. VALUE ',HOMEAU='.
32 33 HOME AU OF CAMPUS SELECTED:
(B1=UCB,H1=UCHSC,D1=UCD,C1=UCCS)
34 39 LITERAL. VALUE ',TAPE=',
40 40 TAPE CREATE OPTION:
Y=CREATE SEP. DATE UPDATE TAPE.
N=DON'T CREATE SEP. DATE UPDATE TAPE.
41 47 LITERAL. VALUE ', TAPE='.
48 52 EDUSERV BATCH NUM (0700-0999) FOR
SEPARATION DATE UPDATE TAPE. (SEE
NOTES SCREEN FOR PROPER USAGE OF
BATCH NUMBERS BY CAMPUS)
53 63 LITERAL. VALUE 'BATCHDATE='.
64 69 EDUSERV BATCH DATE FOR SEP. DATE
UPDATE TAPE IN FORMAT MMDDYY.
(USE RUN DATE FOR EDUSERV BATCH DATE).
70 76 LITERAL. VALUE ',LABEL='.
77 77 LABEL CREATE OPTION:
Y = CREATE LABELS.
N = DON'T CREATE LABELS
78 80 NOT USED.
0170 REPORT SEQUENCE/CAMPUS PARAMETER PRECEDES THIS LINE.
01 05 LITERAL. VALUE 'SORT='.
06 06 SORT SEQUENCE SELECTION
(A=ALPHA; N=NUMERIC).
07 14 LITERAL. VALUE ',CAMPUS='.
15 16 CAMPUS SELECTION CODE:
(01=UCB,02=UCHSC,03=UCD,04=UCCS).
17 80 NOT USED.
FILES:
*Input:
(D) SIS.&CAMPUS..RRFF.T&TERM
(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: GSL GRADUATION REPORT
*Description: List of GSL Graduates.
*Title: PERKINS/NDSL STATUS EQUAL TO 10 or 11
*Description: Status 10 or 11 Perkins report.
*Title: INSTITUTIONAL LOANS STATUS EQUAL TO 10 or 11
*Description: Status 10 or 11 Institutional loans report.
*Title: DISADVANTAGED STUDENTS LOANS
*Description: HSC Disadvantaged students report.
*Title: FEDERAL NURSING STUDENT LOANS
*Description: HSC Federal Nursing student loans report.
*Title: HEALTH PROFESSIONS STUDENT LOANS
*Description: HSC Health Professions student loans report.
*Title: GRADUATES WITH STATUS EQUAL TO 21, 52, 59
*Description: Graduates with status 10, 11, 21, 52, or 59 report.
*Title: STATUS NOT EQUAL 10, 11, 21, 52, 59
*Description: Status not equal 10, 11, 21, 52, or 59 report.
*Title: GRADUATES WITH NDSL/PERK AND GSL/STAFFORD LOANS
*Description: Graduates with Perkins and/or GSL loans report.
*Title: LOAN SUMMARY FOR GRADUATING STUDENTS
*Description: Summary counts for GSL and Perkins loans.
PROGRAM NAME AND DESCRIPTION:
*LLTA3 - EXTRACTS GRADUATE FILE FROM SIS FOR ALL CAMPUSES
BASED ON CONTROL CARD YEAR/TERM
MESSAGE: SETUP CAMPUS NOT NUMERIC ON SETUP RECORD.
ACTION: CORRECT SETUP CAMPUS AND RESUBMIT JOB.
MESSAGE: INVALID CAMPUS ON SETUP RECORD.
ACTION: CORRECT SETUP CAMPUS AND RESUBMIT JOB.
MESSAGE: SETUP YEAR/TERM NOT NUMERIC ON SETUP RECORD.
ACTION: CORRECT SETUP YEAR/TERM AND RERUN JOB.
MESSAGE: HOME AU INCORRECT ON SETUP CARD.
ACTION: CORRECT HOME AU AND RESUBMIT JOB.
MESSAGE: INVALID TAPE SELECTION ON SETUP RECORD.
ACTION: CORRECT TAPE SELECTION AND RESUBMIT JOB.
MESSAGE: SETUP BATCH NOT NUMERIC ON SETUP RECORD.
ACTION: CORRECT SETUP BATCH AND RESUBMIT JOB.
MESSAGE: BATCH DATE NOT NUMERIC ON SETUP RECORD.
ACTION: CORRECT BATCH DATE AND RESUBMIT JOB.
MESSAGE: ID NOT FOUND
ACTION: NO ACTION NEEDED (THIS IS INFORMATIONAL ONLY).
*LLTA4 - CREATE GSL GRADUATE REPORT
MESSAGE: STATUS ON IDMS BINDS
ACTION: IS THE DATABASE AVAILABLE? OTHERWISE
PROGRAMMER/DBA PROBLEM.
*LLTA5 - THIS PROGRAM PRODUCES 4 VARIETIES OF LOAN/SIS GRADUATION
REPORTS. GRADUATES WITH STATUS OF 10 or 11 HAVE A
TRANSACTION CREATED TO UPDATE THEIR SEPARATION
DATE ON THE EDUSERV SYSTEM VIA TAPE
MESSAGE: INVALID CAMPUS SELECTED
ACTION: CORRECT SETUP CAMPUS AND RESUBMIT JOB.
MESSAGE: STATUS ON IDMS BINDS
ACTION: IS DATABASE AVAILABLE? OTHERWISE
PROGRAMMER/DBA PROBLEM.
MESSAGE: ***NOTE: SEPARATION TAPE WAS NOT CREATED***
ACTION: INFORMATION MESSAGE ONLY; NO ACTION
UNLESS USER SETUP CARD ERROR.
MESSAGE: ****SEPARATION TAPE CREATED BY THIS RUN****
ACTION: INFORMATIONAL MESSAGE ONLY; NO ACTION
UNLESS USER SETUP CARD ERROR.
MESSAGE: **** NOTE: NO STATUS 10 or 11 GRADUATES****
ACTION: USER MOST LIKELY SELECTED INVALID
YEAR/TERM ON SETUP.
*LLTA7 - CREATE SUMMARY REPORTS FOR PERKINS AND GSL
CATEGORIES AND LABELS FOR GSL GRADUATES
MESSAGE: ******INVALID KEY -
ACTION: INFORMATIONAL MESSAGE ONLY; NO ACTION
REQUIRED BY CUST. CORD.
MESSAGE: STATUS ON IDMS BINDS
ACTION: IS DATABASE AVAILABLE? OTHERWISE
PROGRAMMER/DBA PROBLEM.
MESSAGE: NO ADDRESS FOR:
ACTION: INFORMATIONAL MESSAGE ONLY; NO ACTION
REQUIRED BY CUST. CORD.
VALIDATION PROCEDURE:
* Check JCL messages for error condition return codes in any step.
Condition code 0004 is valid in LLTA#5 when tape create option "N"
is selected in the control card for LLTA#2.
* Review misc. output report for LLTA5 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:
LLDA Step # Program #
1 CORRECT ERROR AND RESUBMIT. IEFBR14
MESSAGE: SEE SYSTEM UTILITIES MESSAGES MANUAL.
ACTION: CORRECT ERROR AND RESUBMIT
2 CORRECT ERROR AND RESUBMIT. IEBGENER
MESSAGE: SEE UTILITIES MESSAGE MANUAL.
ACTION: CORRECT ERROR AND RESUBMIT.
3 CORRECT ERROR AND RESUBMIT. EXTPA00
MESSAGE: SETUP CAMPUS NOT NUMERIC ON SETUP RECORD.
ACTION: CORRECT SETUP CAMPUS AND RESUBMIT JOB.
MESSAGE: INVALID CAMPUS ON SETUP RECORD.
ACTION: CORRECT SETUP CAMPUS AND RESUBMIT JOB.
MESSAGE: SETUP YEAR/TERM NOT NUMERIC ON SETUP RECORD.
ACTION: CORRECT SETUP YEAR/TERM AND RESUBMIT JOB.
MESSAGE: HOME AU INCORRECT ON SETUP CARD.
ACTION: CORRECT HOME AU AND RESUBMIT JOB.
MESSAGE: INVALID TAPE SELECTION ON SETUP RECORD.
ACTION: CORRECT TAPE SELECTION AND RESUBMIT JOB.
MESSAGE: SETUP BATCH NOT NUMERIC ON SETUP RECORD.
ACTION: CORRECT SETUP BATCH AND RESUBMIT JOB.
MESSAGE: BATCH DATE NOT NUMERIC ON SETUP RECORD.
ACTION: CORRECT BATCH DATE AND RESUBMIT JOB.
MESSAGE: ID NOT FOUND
ACTION: NO ACTION NEEDED (THIS IS INFORMATIONAL ONLY).
MESSAGE: ANY EASYTRIEVE ERRORS
ACTION: SEE EASYTRIEVE MESSAGES MANUAL TO CORRECT.
4 COREECT ERROR AND RESUBMIT EZPAT00
MESSAGE: STATUS ON IDMS BINDS
ACTION: IS THE DATABASE AVAILABLE? OTHERWISE
PROGRAMMMER/DBA PROBLEM.
MESSAGE: ANY EASYTRIEVE ERRORS
ACTION: SEE EASYTRIEVE MESSAGES MANUAL TO CORRECT.
5 CORRECT ERROR AND RESUBMIT EZTPA00
MESSAGE: INVALID CAMPUS SELECTED
ACTION: CORRECT SETUP CAMPUS AND RESUBMIT JOB.
MESSAGE: STATUS ON IDMS BINDS
ACTION: IS DATABASE AVAILABLE? OTHERWISE
PROGRAMMER/DBA PROBLEM.
MESSAGE: ANY EASYTRIEVE ERROR MESSAGES
ACTION: SEE EASYTRIEVE MESSAGES NAMUAL TO CORRECT.
MESSAGE: ****NOTE: SEPARATION TAPE WAS NOT CREATED****
ACTION: INFORMATION MESSAGE ONLY, NO ACTION UNLESS
USER SETUP CARD ERROR
MESSAGE: ****SEPARATION TAPE CREATED BY THIS RUN****
ACTION: INFORMATIONAL MESSAGE ONLY, NO ACTION REQUIRED.
MESSAGE: ****NOTE: NO STATUS 10 or 11 GRADUATES****
ACTION: USER MOST LIKELY SELECTED INVALID YEAR/TERM
ON SETUP.
6 CORRECT ERROR AND RESUBMIT SORT
MESSAGE: SEE SORT ERROR MESSAGES MANUAL.
ACTION: CORRECT ERROR AND RERUN JOB.
7 CORRECT ERROR AND RESUBMIT EZTPA00
MESSAGE: ****** INVALID KEY-
ACTION: INFORMATIONAL MESSAGE ONLY, NO ACTION
REQUIRED BY CUST. CORD.
MESSAGE: STATUS ON IDMS BINDS
ACTION: IS DATABASE AVAILABLE? OTHERWISE
PROGRAMMER/DBA PROBLEM.
MESSAGE: NO ADDRESS FOR:
ACTION: INFORMATIONAL MESSAGE ONLY, NO ACTION
REQUIRED BY CUST. CORD.
MESSAGE: ANY EASYTRIEVE ERROR MESSAGES
ACTION: SEE EASYTRIEVE MESSAGES MANUAL, CORRECT
AND RESUBMIT JOB.
8 CORRECT ERROR AND RESUBMIT. SORT
MESSAGE: SEE SORT ERROR MESSAGES MANUAL.
ACTION: CORRECT ERROR AND RESUBMIT JOB.
9 CORRECT ERROR AND RESUBMIT. SORT
MESSAGE: SEE SORT MESSAGE MANUAL.
ACTION: CORRECT ERROR AND RESUBMIT JOB.
CHANGE LOG:
930322 NEW JOB (PN) SR#6890 REPLACES NPAT.
930718 ADDED FURTHER DESCRIPTION FOR BATCH
NUMBER USAGE (PN) SR6890
940103 ADDED LABEL CREATE OPTION. (PN) SR6890