Process Number: 112	Revision Date: 7/28/2005 1:29:00 PM
Revision #: 2	Back | Access Password:

Section Labels(THIS PRCSS HAS BEEN REPLACED W/XSLB

Office Responsible:

DCS - District - Computing Services

Process Type:

internal

Position Title:	Programmer		Author:	CGreen
Cross Trained Staff:		Manager:		Vice Pres.:	RTemple

Timeline (Deadlines or Time-Constraints) :

What must be done before this process is started:

I receive a request for labels for a specific class or section. Ask the requestor for the synonym number of the class or section and if they want the labels in zip code or name sequence and how may copies they want.

Which processes are waiting for this process:

Source documents or communication with information needed for this process:

What is the end-result of this process, or the hand-off

The output is address labels for the requested section in zip or name sequence. If more then 1 copy is requested, run the FPR screen for the requested number of copies.

What steps must be taken independent of the computer system (Manual Process)

Which steps must be taken on a computer (Electronic Process):

The following SELECT statements are run: 1. SELECT COURSE.SECTIONS WITH SEC.LOCATION EQ `` AND SEC.TERM EQ `` AND SEC.SYNONYM EQ `` AND SEC.NO EQ `` SAVING UNIQUE SCS.ACTIVE.STUDENTS 2. SELECT STUDENT.COURSE.SEC SAVING UNIQUE SCS.STUDENT. 3. If name sequence is desired, enter; A. SELECT PERSON BY LAST.NAME BY FIRST.NAME BY @ID 4. If zip code sequence is desired, enter; A. SELECT PERSON BY ZIP BY LAST.NAME BY FIRST.NAME BY @ID 5. SEE Faculty Division/Department Labels for the running of the label program and printing the labels.

Related Documents to Process (e.g. Datatel documentation, Government code books, etc.)

Notes (Cautions, suggestions for improvement, etc.)