College Unique Job Scheduling
UFxxxxJ UPxxxxJ UUxxxxJ UGxxxx Other

UU2304J
SMS At&T Extract Student ID Cards

This Job creates and formats the SMS AT&T ID Card Extract for students selected using the SMS Student Generalized Extract. The following processing takes place, depending on the student's enrollment status:

ADD RECORD

- If the student is registered for the current or future YRQ's and no UNUSUAL-ACTN-D record is found for this student with a match on ADD-UNUSUAL-ACT or SUSP-UNUSUAL-ACT then we know that this student has never had an ID card printed and this should be considered an ADD situation.

UPDATE RECORD

- If the student is registered for the current or future YRQ's and an UNUSUAL-ACTN-D record is found for this student with a match on ADD-UNUSUAL-ACT, then we know that this student has had an ID card printed and this should be considered an UPDATE situation.

REACTIVATE RECORD

- If the student is registered for the current or future YRQ's and an UNUSUAL-ACTN-D record is found for this student with a match on SUSP-UNUSUAL-ACT, then we know that this student has had an ID card printed and it has been suspended. Since the student is now registered, the card should be REACTIVATED.

SUSPEND RECORD

- If the student is NOT registered for the current or future YRQ's and an UNUSUAL-ACTN-D record is found with a match on ADD-UNUSUAL-ACT, then we know that this student has had an ID card printed and it should be suspended because they are no longer enrolled.


Special Instructions None
Frequency On-request
Scheduling Restrictions Job Group Only
Execution Time Anytime (O, B, P or I)
Job Completion Status NODATA, GROUPFAIL
Job Groups
UG036R     SMS-AT&T Card Extract
Job Dependency None
Operator Instructions None
Estimated Run Time 5 Minutes
Recovery/Restart This job is restartable.


Parameters

ADD-UNUSUAL-ACT Enter an Unusual Action code to be assigned to students that are added to the AT&T ID card system.
PROCESS-MODE Enter a processing mode or a combination of processing modes to be performed. To select a combination of processing modes, enter each code without skipping any spaces (e.g., AUS). The following codes may be selected:
A - Add students that were not enrolled previously
U - Add new students and Update previously enrolled students
S - Suspend students that are not enrolled currently or in the future
Blank - Process all modes
SUSP-UNUSUAL-ACT Enter an Unusual Action code to be assigned to students that are suspended from the AT&T ID card system.
YRQ Enter the year-quarter to be processed.

Distribution: SMS
Created: WED, JAN 04, 2012, 07:46 AM