Process Number: 239	Revision Date: 6/23/2014 6:26:00 PM
Revision #: 6	Back | Access Password:

Process to create report of Middle College Student
**PROCESS OBSOLETE**

Office Responsible:

DCS - District - Computing Services

Process Type:

internal

Position Title:	User Liaison		Author:	dwalter
Cross Trained Staff:		Manager:		Vice Pres.:

Timeline (Deadlines or Time-Constraints) :

on request

What must be done before this process is started:

Which processes are waiting for this process:

Source documents or communication with information needed for this process:

Request (usually email) from Middle College program administrator.

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

An excel file of Middle College students and sections they are enrolled in, for term requested, is emailed to the program administrtor (currently, 9/06 Gloria Fisher).

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

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

1. Login to Datatel Terminal. 2. At the colon prompt enter SELECT STUDENT.TERMS WITH STTR.TERM = “term code” and STTR.ACAD.LEVEL = "UG". (term code example 2006FA) 3. After the records have been selected enter SELECT STUDENT.TERMS SAVING UNIQUE S02.STUDENT.ID 4. After those records have been selected enter SELECT STUDENTS WITH S02.CURRENT.TYPE LIKE “MC…” AND S02.CURRENT.TYPE.END.DT = “” 5. After the records have been selected enter SAVE.LIST S02.name of save list (i.e. SAVE.LIST S02.MIDCOLSTU) 6. At the colon prompt enter EDIT.LIST save list name (S02.MIDCOLSTU) 7. At the next colon prompt enter A9999 *termcode*UG (term code example 2006FA)this adds the termcode and UG after the ID. When this is completed enter FI to file it. 8. At the colon prompt enter GET.LIST save list name (S02.MIDCOLSTU) 9. Enter SELECT STUDENT.TERMS SAVING UNIQUE STTR.STUDENT.ACAD.CRED – to get sections middle college students are taking. 10. After the records have been selected enter SAVE.LIST S02.name of this save list (i.e. SAVE.LIST S02.MIDCOLSTU1) 11. Logout of Datatel Terminal(LO press enter) 12. From the Datatel Menu click on Options then Query Builder. 13. Click on Open and find the query named Middle College Students.wis 14. Verify that in the Before field has the name of the last saved list from step 10 (i.e. S02.MIDCOLSTU1) 15. Click on OK to run the query. 16. Now the data is in Excel. (format the Person ID and Added by column to a 7 digit numeric field) 17. Email excel document to Middle College program administrator (9/06 Gloria Fisher)

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

Notes (Cautions, suggestions for improvement, etc.)