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)