JOB NAME: LLIB - STUDENT LOAN/FRS INTERFACE
JOB PURPOSE: This job creates journal entry transactions by matching
the EduServ FRS file to campus FRS tables. An FRS interface report
lists all matching transactions by loan program number. An error
report of all EduServ FRS transactions that don't have matching
entries in the campus FRS tables is produced. The journal entry
files for each campus are fed into FDAA, the FRS update job.
JOB SUBMISSION:
*Normal Run Frequency: Once per month after receiving the EduServ
Financial Reporting tape. This job runs once and includes all campuses
*Conflicts: This job should NOT be run while LLDE (EduServ FRS
Archive File Build) is running.
*Dependencies: Run LLIB after LLDE, if scheduled on the same
day/night.
*Run Considerations: This job reads the archive tape
(LAM.FRS.FREEZE.D&MONTH&YEAR) created from the EduServ FRS tape
(received monthly). The customer coordinator must create an
archive copy of the latest EduServ FRS tape received from EduServ
(job LLDE) before running this job. LAM.LLIB.ERRFILE may be used
as an input file to this job (replacing LAM.FRS.FREEZE.D&MONTH&YEAR).
To do this, the customer coordinator must remove the fillholes
for file LAM.LLIB.ERRFILE and change the name of the new output
error file for this run only. Then the error file in SYSD can be
edited to include only those EduServ transactions to be re-fed
to this job. This procedure could be used, for instance, if the
user forgets to add FRS debit/credit account information for a
completely new loan program number. Users would also need to
update their FRS table in UMS.PROD.DATA to include the new loan
program before this job is rerun.
PROGRAM LIST:
*LAPR006 - Monthly EduServ FRS transaction report for all campuses.
Find matches in campus tables for each FRS transaction
and create journal entries files - LLIA#4
*LLIB5 - FRS transaction error report print program - LLIB#5
JOB SETUP:
*Symbolic Parameters:
MONTH - EduServ FRS archive tape month - Format MM
YEAR - EduServ FRS archive tape year - Format YY
PRTM1 - Dispatch parameters for FRS transaction report
PRTM2 - Dispatch parameters for FRS error report
*Control records:
0140 LLIB SETUP RECORD (PRECEEDS THIS LINE)
01 07 LITERAL VALUE 'LAPR006'
08 08 DETAIL OPTION - ('Y' OR 'N' PRODUCE THE SAME REPORT).
09 10 NOT USED.
11 16 LOAN/FRS REPORTING PERIOD - IN FORMAT YYMMDD
17 35 NOT USED. (JOB COMMENT MAY BE PLACED IN THIS FIELD.)
36 41 FRS BATCH NUMBER. This number increments by 4 on
each run (i.e., one batch number per campus per run).
42 43 STARTING CAMPUS NUMBER - ALWAYS USE 01 (FOR UCB).
44 44 NOT USED.
45 46 ENDING CAMPUS NUMBER - ALWAYS USE 04 (FOR
UCCS).
47 47 NOT USED.
48 70 FRS BATCH DESCRIPTION.
71 80 NOT USED.
FILES:
*Input:
(T) LAM.FRS.FREEZE.D&MONTH&YEAR - copy of EduServ FRS tape
(D) LAM.PROG.CONV.TABLE - loan pgm. number conv. table
(D) UMS.PROD.DATA(LLIB3A) - Boulder FRS table
(D) UMS.PROD.DATA(LLIB3B) - HSC FRS table
(D) UMS.PROD.DATA(LLIB3C) - Denver FRS table
(D) UMS.PROD.DATA(LLIB3D) - Colo. Spgs. FRS table
*Output:
(T) LAM.FRS.UCB.TRAN - Boulder journal entry trans
(T) LAM.FRS.HSC.TRAN - HSC journal entry trans
(T) LAM.FRS.UCD.TRAN - Denver journal entry trans
(T) LAM.FRS.UCCS.TRAN - Colo. Spgs. journal entry trans
(D) LAM.LLIB.ERRFILE - Error file of EduServ FRS trans
(D) LAM.LLIB.ERRRPT - Error file of EduServ FRS trans
(D) LAM.LLIB.FRSTBL - Sorted campus FRS tables
*I/O:
NONE
REPORTS:
*Title: LAPR006
*Description: FRS Interface Report by loan program number
*Title: LLIB5
*Description: FRS Error Report for all campuses
PROGRAM NAME AND DESCRIPTION:
*LAPR006 - PROCESS EDUSERV FRS FILE BY LOAN PROGRAM NUMBER
AND CREATE MONTHLY JOURNAL ENTRIES FOR EACH CAMPUS.
MESSAGE: LAPR006 INTERFACE PARAMETER CARDS MISSING.
ACTION: SETUP CARD MISSING, ADD IT AND RERUN JOB.
MESSAGE: LAPR006 INVALID PROGRAM IS ON CONTROL CARD.
ACTION: CORRECT PROGRAM NUMBER ON SETUP CARD AND RERUN JOB.
MESSAGE: LAPR006 INVALID DETAIL OPTION ON CONTROL CARD
ACTION: CORRECT DETAIL OPTION ON SETUP CARD AND RERUN JOB.
MESSAGE: LAPR006 INVALID RUN DATE ON CONTROL CARD.
ACTION: CORRECT RUN DATE ON SETUP CARD AND RERUN JOB.
MESSAGE: LAPR006 INVALID FRS BATCH ON CONTROL CARD
ACTION: CORRECT FRS BATCH NUMBER ON SETUP CARD AND RERUN JOB.
MESSAGE: FRS TABLE MAX EXCEEDED.
ACTION: CALL PROGRAMMER TO INCREASE TABLE SIZE, THEN RERUN JOB.
MESSAGE: INVALID ENTRY-ID.
ACTION: ENTRY-ID NOT NUMERIC IN CAMPUS FRS TABLES -FIX IT, RERUN JOB.
MESSAGE: INVALID DEBIT ACCOUNT.
ACTION: DEBIT ACCNT NOT NUMERIC IN CAMPUS FRS TABLES -FIX IT, RERUN JOB
MESSAGE: INVALID PROGRAM ID.
ACTION: LOAN PROGRAM NUMBER NOT NUMERIC IN CAMPUS FRS TABLES - FIX IT,
RERUN JOB.
MESSAGE: INVALID CREDIT ACCOUNT
ACTION: CREDIT ACCNT NOT NUMERIC IN CAMPUS FRS TABLES -FIX IT, RERUN JOB
MESSAGE: INVALID DR/CR INDICATOR
ACTION: DR OR CR INDICATOR INCORRECT IN CAMPUS FRS TABLES -FIX IT, RERUN
MESSAGE: LAPR006 PROGRAM ABORTED.
ACTION: CHECK FOR OTHER ERROR MESSAGE(S) - CORRECT AND RERUN JOB.
MESSAGE: OTHER ERROR - SEE COBOL/SYSTEM ERROR MESSAGES MANUAL
ACTION: CORRECT ERROR AND RERUN JOB.
*LLIB5 - PRINT FRS TRANSACTION ERROR REPORT.
EZTPA00
MESSAGE: SEE EASYTRIEVE ERROR MESSAGES MANUAL
ACTION: CORRECT ERROR AND RESTART STEP 5
VALIDATION PROCEDURE:
* Check JCL messages for error condition return codes in any step.
* Users must review report for accuracy, preferably before journal
entry transaction files are fed to FRS.
RERUN INSTRUCTIONS:
LLIB Step # IEFBR14
1 RERUN
MESSAGE: SEE SYSTEM UTILITIES MESSAGES MANUAL.
ACTION: CORRECT ERROR AND RERUN JOB.
2 RERUN IEBGENER
MESSAGE: SEE SYSTEM UTILITIES MESSAGES MANUAL.
ACTION: CORRECT ERROR AND RERUN JOB.
3 RERUN SORT
MESSAGE: SEE SORT ERROR MESSAGES MANUAL.
ACTION: CORRECT ERROR AND RERUN JOB.
4 RERUN LAPR006
MESSAGE: LAPR006 INTERFACE PARAMETER CARDS MISSING.
ACTION: SETUP CARD MISSING, ADD IT AND RERUN JOB.
MESSAGE: LAPR006 INVALID PROGRAM ID ON CONTROL CARD.
ACTION: CORRECT PROGRAM NUMBER ON SETUP CARD AND RERUN JOB.
MESSAGE: LAPR006 INVALID DETAIL OPTION ON CONTROL CARD.
ACTION: CORRECT DETAIL OPTION ON SETUP CARD AND RERUN JOB.
MESSAGE: LAPR006 INVALID RUN DATE ON CONTROL CARD.
ACTION: CORRECT RUN DATE ON SETUP CARD AND RERUN JOB.
MESSAGE: LAPR006 INVALID FRS BATCH ON CONTROL CARD.
ACTION: CORRECT FRS BATCH NUMBER ON SETUP CARD AND RERUN JOB.
MESSAGE: FRS TABLE MAX EXCEEDED.
ACTION: CALL PROGRAMMER TO INCREASE TABLE SIZE, THEN RERUN JOB.
MESSAGE: INVALID ENTRY-ID.
ACTION: ENTRY-ID NOT NUMERIC IN CAMPUS FRS TABLES
-FIX IT, RERUN JOB.
MESSAGE: INVALID DEBIT ACCOUNT.
ACTION: DEBIT ACCOUNT NOT NUMERIC IN CAMPUS FRSTABLES -FIX IT, RERUN JOB
MESSAGE: INVALID PROGRAM ID.
ACTION: LOAN PROGRAM NUMBER NOT NUMERIC IN CAMPUS FRS TABLES
-FIX IT, RERUN JOB.
MESSAGE: INVALID CREDIT ACCOUNT.
ACTION: CREDIT ACCOUNT NOT NUMERIC IN CAMPUS FRS TABLES -FIX IT, RERUN.
MESSAGE: INVALID DR/CR INDICATOR.
ACTION: DR OR CR INDICATOR INCORRECT IN CAMPUS FRS TABLES -FIX IT, RERUN.
MESSAGE: LAPR006 PROGRAM ABORTED.
ACTION: CHECK FOR OTHER ERROR MESSAGE(S) - CORRECT AND RERUN JOB.
MESSAGE: OTHER ERROR - SEE COBOL/SYSTEM ERROR MESSAGES MANUAL.
ACTION: CORRECT ERROR AND RERUN JOB.
5 RESTART STEP 5 EZTPA00
MESSAGE: SEE EASYTRIEVE ERROR MESSAGES MANUAL.
ACTION: CORRECT ERROR AND RESTART IN STEP 5.
CHANGE LOG:
931031 New job replaces NMAU. (PN) SR6887