Process Number: 116	Revision Date: 2/27/2001 10:59:12 PM
Revision #: 1	Back | Access Password:

SBVC Puente Reporting file generation

Office Responsible:

DCS - District - Computing Services

Process Type:

internal

Position Title:	Sr. Programmer/Analyst		Author:	BNoble
Cross Trained Staff:		Manager:	DHarris	Vice Pres.:	RTemple

Timeline (Deadlines or Time-Constraints) :

Whenever the SBVC Puente Staff requests

What must be done before this process is started:

Which processes are waiting for this process:

1. The Puente staff at SBVC submits the file to the Puente Project Office, or DCS can submit it directly if requested to do so. At the time of this writing, the submission is done by e-mailing the file to Vivian Calderon at "Vivian.Calderon@ucop.edu". 2. The Puente staff at SBVC submits a follow-up file. This is a Microsoft Excel file containing the same data as the text file plus a few additional data fields which they must enter manually.

Source documents or communication with information needed for this process:

Each semester one new English section is identified with the Puente program. For Fall semesters it is always an ENGL-015 section, and for Spring semesters it is always an ENGL-101 section. The SBVC Puente staff needs to identify for us the section number we will use for reporting. Currently, the Puente staff involved are Dolores Moreno (Puente teacher) and Laura Gomez Guillen (Puente counselor).

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

A text file and a Microsoft Excel file.

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

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

1. Modify the "S02.PUENTE.SEC" file in the "BRETT" directory to identify the ENGLISH section numbers to be used for the reporting. 2. Run the "S02.PUENTE" program in the "BRETT" directory. The program is also on the S02 menu under "A/R"->"Records". The output will be e-mailed to the user. This file should be e-mailed to the SBVC Puente staff or directly to the Puente Project office. 3. Convert the text file to a Microsoft Excel file and e-mail the file to the SBVC Puente Staff.

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

Notes (Cautions, suggestions for improvement, etc.)

Brett has a physical folder labeled "Puente" which contains the file specs and some administrative information about the Puente Project.