JOB NAME:     TEVK$

JOB TITLE:     SET YEAR OF ENTRANCE FOR TUITION ADJUSTMENT STUDENTS

DESCRIPTION:
This job will read the term and BRS extract files created in job TEVH$.  It will select those students from the term extract file who match to the parameter cards.  It will read the  BRS file to determine if the student had a tuition adjustment in that term and will set the year of entrance (YOE) for that student in a future term.  A report will be produced.
           NOTE:  This job needs to be run after the last Tuition Adjustment (TEVH$) for the selection  term and BEFORE the first Tuition Calc (TEUA$) of the update term.

INPUT:
SIS database
Term Extract file from TEVH$ (SIS.TEVH.TERMEXTR.&au&term)
BRS Extract file from TEVH$ (SIS.TEVH.BRSEXTR.&au&term)
 

CONTROL PARAMETERS:

    Title:   Year of Entrance control record  (SIPR938)

    Example:
 
SIPR938,CS,C1 ,   ,20061 ,Y ,A ,05 ,20067
12345678901234567890123456789012345678901234567890123456789012345678901234567890

    Format:
 
 
POSITION FIELD VALUE
 01 07  PROGRAM ID  'SIPR938' 
 08 08  DELIMITER  Space or comma (,)
 09 10  INSTITUTION   Institution to have tuition adjustments calculated
Valid values:
UCB=BD
UCCS=CS
UCD=DN
UCHSC=HS
 11 11  DELIMITER  Space or comma (,)
 12 13  ACADEMIC UNIT Academic unit to have tuition adjustments calculated.
Valid: B1, B2, B3, C1, C2, C3, D1, D2, D3, H1, H2, H3 
 14 14  DELIMITER  Space or comma (,)
 15 15  EXTERNAL INDICATOR External indicator for student population to have tuition adjustments calculated.
 16 16  DELIMITER  Space or comma (,)
 17 21  YEAR/TERM  Year and term to be assigned to the tuition adjustment transactions.  Must be numeric.
Format YYYYT
 22 22  DELIMITER  Space or comma (,)
 23 23  UPDATE SWITCH  Option specifying whether or not to update the SIS database
N=No, do not update the database
Y=Yes, update the database
 24 24  DELIMITER  Space or comma (,)
 25 25  REPORT SEQUENCE Option specifying the sort order for the data on the YOE report.
 A=Sort in student name/id sequence
 N=Sort in student id/name sequence
 26  26  DELIMITER  Space or comma (,)
 27  28  YEAR OF ENTRANCE Year of entrance to be set on the student's term record. Required.
 29  29  DELIMITER  Space or comma (,)
 30  34  YEAR TERM Year and term to which the YOE will be set.
Format: YYYYT

    Title:  Student Attribute Parameter (SIPR938)  - up to 500 student attribute records may be specified.   Student attribute records define the population of students to be considered for tuition adjustments.

    Example:
 


 
STUATTR,LS,R*,FR ,  ,    , , ,0090,0099,0004300,88990,                     061C1
12345678901234567890123456789012345678901234567890123456789012345678901234567890

    Format:
 
 


 
POSITION FIELD VALUE
 01 07  CARD IDENTIFIER  'STUATTR' 
 08 08  DELIMITER  Space or comma (,)
 09 10  COLLEGE  College to be specifically selected.  Spaces indicates all colleges.
 11 11  DELIMITER  Space or comma (,)
 12 13  RESIDENCY  Residency to be specifically selected.   An asterisk (*) in column 13 indicates that all residencies that begin with the value in column 12 are to selected.
 14 14  DELIMITER  Space or comma (,)
 15 17  CLASS Class of students to be specifically selected.
 18 18  DELIMITER  Space or comma (,)
 19 20 YEAR OF ENTRANCE Year of entrance to be specifically selected.  Spaces indicates all years of entrance.
 21 21 DELIMITER Space or comma (,)
 22  5  MAJOR  Student major to be specifically selected.  Spaces indicates all majors are to be selected.
 26 26  DELIMITER  Space or comma (,)
 27 27  FACULTY STAFF STATUS  Faculty/staff status to be selected.  Spaces indicates all statuses.
 28 28  DELIMITER  Space or comma (,)
 29 29  GRAD STATUS  Graduate status to be specifically selected. Spaces indicates all statuses.
 30 30  DELIMITER  Space or comma (,)
 31 34  LOW HOURS  Minimum hours in which a student must be enrolled to be selected.  Format 999V9.  Must be numeric
 35 35  DELIMITER  Space or comma (,)
 36 39  HIGH HOURS Maximum hours in which a student may be enrolled  to be selected.  Format 999V9
Must be numeric.  Must be greater than or equal to LOW HOURS
 40 40  DELIMITER  Space or comma (,)
 41 47  ADJUSTMENT AMOUNT Amount of tuition adjustment for students that match all of the preceding parameters. 
 Format 99999V99 
 Must be numeric.
 48 48  DELIMITER  Space or comma (,)
 49 53  ADJUSTMENT SUBCODE  Subcode to be assigned to the student tuition adjustment transaction.  Must be numeric.
 54 75  DELIMITER  Space or comma (,)
 76 78  YEAR/TERM Year and term of the student attribute parameter card.   Format YYT
Must match the value in the Tuition Adjustment control record (without the century).
 79 80  ACADEMIC UNIT Academic unit of the student attribute  parameter record.  Must match the academic unit in the Tuition Adjustment control record. 

REPORT INFO:
YOE Exception report (SIPR949)
YOE Action report (SIPR949)

OTHER OUTPUT:
Updated SIS database
Report file (SIS.TEVK.REPORT..&au&term)
Term Extract file (SIS.TEVK.TERMEXTR.&au&term)