JOB NAME:     LLRB – Loan Enrollment Exception Reports
 
JOB PURPOSE:  This job determines whether students on the loan master
              file have the correct status code for their current 
              enrollment status.  Enrollment is determined by job TQIC,
              which creates a file for the NSL clearinghouse indicating
              whether students are full-time, half-time or less than half-
              time.
                
             Two reports are printed:  enrolled student exceptions and
             non-enrolled student exceptions.  Labels
             may print for non-enrolled borrowers, if the label
             option is selected.
 
(This job is a replacement for job LLTD for HSC, but could also be run by the other campuses.)
 
 
JOB SUBMISSION:
 
     *Normal Run Frequency:  Once per campus/semester upon request by any campus 
 
 
     *Conflicts:  This job should not be run while LLDA (Campus Partners 
         Master File Build) is running, nor while TQIC is running for the
         requested campus/term.
 
     *Dependencies: Run LLRB after LLDA, if scheduled on the same 
         day/night.  
                                
     *Run Considerations:  This job reads the latest loan master file, 
         LAMV.LOAN.MASTER, and the NSL clearinghouse file created by TQIC
         for the requested campus and term. 
 
        TQIC for the requested campus/term must have already been run and
        the NSL file created.  If the necessary SIS.&CAMPUS..TQIC.NSL.T&TERM
        file is not available, check with the records and registration customer
        coordinator to see when it is scheduled to run and notify the loan staff.
 
 
PROGRAM LIST: 
 
     *LAPR025 – Loan enrollment exception program  - LLRB#5
 
     *LLRB7 – Easytrieve -- Prints enrolled and non-enrolled exception
      reports. Labels for non-enrolled students may also be printed, if 
      selected by control card option. 
 
 
JOB SETUP:
 
     *Symbolic Parameters:
 
       LINE #   Parameter     DESCRIPTION                                         
       0050     CAMPUS     ('BD', 'DN', 'HS', OR 'CS')                    
       0070     TERM       (YYT)                                          
       0090     PRTM1             OUTPUT PARAMETERS FOR ENROLLED REPORT                    
       0110     PRTM2             OUTPUT PARAMETERS FOR NON-ENROLLED REPORT                
0130     PRTL1             OUTPUT PARAMETERS FOR LABELS FOR NON-ENROLLED  
                                                                    STUDENTS
     *Control record:   
 
       01 07 PROGRAM ID    'LAPR025'   
 
       08 13 LITERAL VALUE ',INST='
                                                                                                                                                    
       14 15 INSTITUTION   ('BD', 'HS', 'DN', or 'CS') 
 
       16 23 LITERAL VALUE ',CAMPUS='               
                                                               
       24 25 CAMPUS        (UCB=01, HSC=02, UCD=03, UCCS=04) 
                                                               
       32 34 YEAR-TERM     (YYT) 
 
        35 42 LITERAL VALUE ',LABELS='
                                                               
       43 43 LABEL CREATE SWITCH  ('Y' = 'YES, CREATE LABELS',        
                            'N' = 'NO, DO NOT CREATE LABELS') 
 
       45 80 NOT USED 
                                                               
 
FILES:
     *Input:
       (D) LAMV.LOAN.MASTER                STUDENT LOAN MASTER FILE 
       (D) SIS.&CAMPUS..TQIC.NSL.T&TERM    NSL FILE FROM TQIC       
       (D) LAM.PROG.CONV.TABLE             LOAN PROGRAM # CONVERSION TABLE
 
 
REPORTS:
     *Title:        IN-SCHOOL STATUS REPORT - ENROLLED STUDENTS (BY CAMPUS)
     *Description:  List of borrowers enrolled at least half time in 
                    current term whose status should be changed to 10 or 11. 
 
     *Title:         IN-SCHOOL STATUS REPORT - NONENROLLED STUDENTS (BY CAMPUS)     
     *Description:   List of borrowers not enrolled at least halftime in
                     current term whose status should be changed from 10 or 11.
 
 
PROGRAM NAME AND DESCRIPTION:
 
     *LAPR025 -   Loan enrollment exception report extract program
 
       Summary:
 

1.   Initialization – reads and edits a control card, opens files, initializes data fields

 

2.   Processes the loan file as follows:

a.   Reads a loan record

b.   Determines whether to skip this record.  Skip if already processed, already paid in full, loan status > 21, or campus related to program number not = control card campus

c.   Find matching NSL record with enrollment status ‘H’ or ‘F’, indicating ‘enrolled’

d.   If loan status = 20 or 21 and borrower is enrolled, write print record, including the

following data:

   PROGRAM NUMBER, LOAN NUMBER, SEQUENCE NUMBER,

      STUDENT NAME AND STATUS     

e.   If loan status = 10 or 11 and borrower is not enrolled, format label (if requested by control card) and write print record (same as above, plus address information)

 

3.   Closes files; prints totals

 

 
 
VALIDATION PROCEDURE:
     * Check JCL messages for error condition return codes in any step. 
 
 
 
RERUN INSTRUCTIONS:
·        For all errors: check error message; correct problem and rerun job.
·         
STEP#: 01     PROGRAM NAME:  IEFBR14 – Correct problem and rerun job
 
  MESSAGE: ANY                                             
    ACTION: REFER TO SYSTEM MESSAGES MANUAL; CORRECT PROBLEM
 
STEP#: 02     PROGRAM NAME: IEBGENER – Correct problem and rerun job 
                                                             
  MESSAGE: ANY                                               
    ACTION: REFER TO SYSTEM MESSAGES MANUAL; CORRECT PROBLEM  
 
STEP#:  03    PROGRAM NAME:  SORT – Correct problem and rerun job   
                                                     
 MESSAGE: ANY                                        
   ACTION: SEE SYSTEM SORT MANUAL; CORRECT PROBLEM    
 
STEP#:  04    PROGRAM NAME:  SORT – Correct problem and rerun job                       
                                                                         
 MESSAGE: SORTIN NOT FOUND (TQIC'S NSL FILE FOR THIS CAMPUS/TERM)        
   ACTION: CHECK WITH PRODUCTION SERVICES - HAS TQIC CREATED THIS FILE?   
                                                                         
 MESSAGE: ALL OTHER MESSAGES                                             
   ACTION: REFER TO SYSTEM SORT MANUAL; CORRECT PROBLEM                   
 
STEP#:  05    PROGRAM NAME:  LAPR025 – Correct problem and rerun job                                 
 
  MESSAGE: LAPR025 - LOAN ENROLLMENT EXCEPTION REPORT           
    ACTION: INFORMATION ONLY; NO ACTION NECESSARY                
                                                                  
  MESSAGE: INVALID PROGRAM NAME IN CONTROL CARD                   
    ACTION: CHANGE TO 'LAPR025'                                    
                                                                   
  MESSAGE: INVALID INSTITUTION                                    
    ACTION: CHANGE TO 'BD', 'HS', 'DN' OR 'CS'                     
                                                                  
  MESSAGE: NON-NUMERIC CAMPUS NUMBER                              
    ACTION: CHANGE TO '01', '02', '03' OR '04'                     
                                                                  
  MESSAGE: CC-YEAR NOT NUMERIC                                    
    ACTION: CORRECT YEAR                                           
 
  MESSAGE: INVALID PROGRAM NAME IN CONTROL CARD                   
    ACTION: CHANGE TO 'LAPR025'                                    
                                                                   
  MESSAGE: INVALID INSTITUTION                                    
    ACTION: CHANGE TO 'BD', 'HS', 'DN' OR 'CS'                     
                                                                   
  MESSAGE: NON-NUMERIC CAMPUS NUMBER                              
    ACTION: CHANGE TO '01', '02', '03' OR '04'                     
                                                                   
  MESSAGE: CC-YEAR NOT NUMERIC                                    
    ACTION: CORRECT YEAR                                           
                                                                   
  MESSAGE: CC-TERM  NOT NUMERIC                                   
    ACTION: CORRECT TERM                                           
 
  MESSAGE: CC-TERM  NOT NUMERIC                                      
    ACTION: CORRECT TERM                                              
                                                                    
  MESSAGE: CC-LABEL-CREATE-SW INVALID                                
    ACTION: CHANGE TO 'Y' OR 'N'                                      
                                                                    
  MESSAGE: CONVERSION FAILED FOR LOAN DATA                           
    ACTION: CONTACT BRS PROGRAMMER (NEXT WORK DAY WILL BE FINE)       
                                                                    
  MESSAGE: *** PROCESSING NSL FILE FOR TERM:                         
    ACTION: INFORMATION ONLY; NO ACTION NECESSARY                     
                                                                    
  MESSAGE: ***    TOTAL NSL RECORDS IN THIS FILE:                    
    ACTION: INFORMATION ONLY; NO ACTION NECESSARY                     
 
  MESSAGE: ***    TOTAL NSL RECORDS IN THIS FILE:                    
    ACTION: INFORMATION ONLY; NO ACTION NECESSARY                     
                                                                    
 MESSAGE: ### NSL REC TYPE UNKNOWN:                                 
   ACTION: INFORMATION ONLY FOR PROGRAMMER; NO ACTION NECESSARY      
                                                                    
 MESSAGE: TOTAL LOAN RECORDS READ:                                  
   ACTION: INFORMATION ONLY; NO ACTION NECESSARY                     
                                                                    
 MESSAGE: TOTAL NSL RECORDS READ:                                   
   ACTION: INFORMATION ONLY; NO ACTION NECESSARY                     
                                                                    
 MESSAGE: TOTAL NON-ENROLLED STUDENTS REPORTED:                     
   ACTION: INFORMATION ONLY; NO ACTION NECESSARY                     
 
 MESSAGE: TOTAL NON-ENROLLED STUDENTS REPORTED:                
   ACTION: INFORMATION ONLY; NO ACTION NECESSARY                
                                                               
 MESSAGE: TOTAL ENROLLED STUDENTS REPORTED:                    
   ACTION: INFORMATION ONLY; NO ACTION NECESSARY                 
                                                               
 MESSAGE: USER COMPLETION CODE=4039                            
   ACTION: CONTROL CARD IS MISSING; INSERT IN JOB STREAM        
 
STEP#:  06    PROGRAM NAME:  SORT -- Correct problem and rerun job                                        
 
 MESSAGE: ANY                                             
   ACTION: REFER TO SYSTEM SORT MANUAL; CORRECT PROBLEM    
 
STEP#:  07    PROGRAM NAME:  EZTPA00  -- Correct problem and rerun job                                              
                                                           
 MESSAGE: ANY                                              
   ACTION: REFER TO EASYTRIEVE MANUAL; CORRECT PROBLEM