JOB TITLE: FX STOPS FOR WITHDRAWN STUDENTS
DESCRIPTION:
This job creates
an FX stop file for students who have dropped their last class or who have
withdrawn from all classes.
This is a non-update job, but the UPDATE=N switch is used when a
Stops file is not to be created.
INPUT:
SIS
database
CONTROL PARAMETERS:
Title: FX Stop control record (SIPR782)
Example:
Parameter records may be specified in any order. A
parameter record with all asterisks in the program id field will be considered a
"comment" by the program.
******* CARDS CAN BE IN
ANY ORDER SIPR782:DEST=BD SIPR782:INST=BD SIPR782:AU=B1 SIPR782:SORT=N SIPR782:TERM=20034 SIPR782:DATE=********-******** SIPR782:UPDATE=N |
DEST control record (SIPR782)
Example:
SIPR782:DEST=BD
12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR782' |
08 08 | DELIMITER | Colon (:) or space |
09 13 | FIELD LABEL | 'DEST=' |
14 15 | DESTINATION | Destination for report print. |
TERM control record (SIPR782)
Example:
SIPR782:INST=BD 12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR782' |
08 08 | DELIMITER | Space or colon (:) |
09 13 | FIELD LABEL | 'INST=' |
14 15 | INSTITUTION | Institution of students to be selected |
AU control record (SIPR782)
Example:
SIPR782:AU=B1 12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR782' |
08 08 | DELIMITER | Space or colon (:) |
09 11 | FIELD LABEL | 'AU=' |
12 13 | ACADEMIC UNIT | Academic unit of students to be selected |
SORT control record (SIPR782)
Example:
SIPR782:SORT=N 12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR782' |
08 08 | DELIMITER | Space or colon (:) |
09 13 | FIELD LABEL | 'SORT=' |
14 14 | SORT | Sort option for stop file A=Alphbetic - student name N=Numeric - student id C=Rebate code |
TERM control record (SIPR782)
Example:
SIPR782:TERM=20034
12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR782' |
08 08 | DELIMITER | Space or colon (:) |
09 13 | FIELD LABEL | 'TERM=' |
14 18 | TERM | Term of students to be evaluated for FX stop |
DATE control record (SIPR782)
Example:
SIPR782:DATE=********-********
12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR905' |
08 08 | DELIMITER | Space or colon (:) |
09 13 | FIELD LABEL | 'DATE=' |
14 21 | START DATE | Start date to which withdraw date will be
compared. All asterisks (*) indicates all dates will be selected. Format: CCYYMMDD |
22 22 | DELIMITER | Hyphen (-) or space |
23 31 | END DATE | End date to which withdraw date will be compared.
All asterisks (*) indicates all dates will be selected. Format: CCYYMMDD |
UPDATE control record
Example:
SIPR782:UPDATE=N
12345678901234567890123456789012345678901234567890123456789012345678901234567890 |
Format:
POSITION | FIELD | VALUE |
01 07 | PROGRAM ID | 'SIPR782' |
08 08 | DELIMITER | Space or colon (:) |
09 15 | FIELD LABEL | 'UPDATE=' |
16 16 | UPDATE | Option indicating whether to create a file of FX
stops transactions. N=no, do not create a stops file Y=yes, create a stops file |
REPORT
INFO:
Processing counts
OTHER
OUTPUT:
Stops file - input into TEUF$ (SIS.TEFJ.STOPS.V&IDENT)