Diploma Hold List

The process has been replaced and is no longer in use.

Purpose: Find students who are ineligible to receive diplomas due to account balances (current/past charges, not future)

People involved in the process: Angela Garbarino (ARR), Lucy Ip, Chen-Che Lee

Old Access Database Process:

The following is just a description of each step.

Save the files from steps 1-3 in [\\psu\bao\databases\BUR - Diploma Hold List]

1. Process run through Banner: ZSRDIPL

Save the file as [diplomalist.txt] Term : YYYY00 (i.e. 200401)

Level: '%'

Note: Angela Garbarino may email this file to you!

2. Run query in warehouse.

Save results as holds.txt in "\psu\bao\databases\BUR - Diploma Hold List" directory

3. Ask AR (Kathy Fishler) to create the 'outbound.seq' file from Sal-Sys (\\psu\bao\Common\Shared\Databases\sal-sys\outbound.seq).

Copy outbound.seq to [\\psu\bao\databases\BUR - Diploma Hold List] and save as outbound.txt.

4. Run Access process [\\psu\bao\databases\BUR - Diploma Hold List\diplomahostlist.mdb]

a. [Clear Database] Button; run delete queries 001 – 003

b. [Import Data] Button; import text files 1 – 3

c. [Processing Queries] Button; runs multiple queries to massage data

Let Lucy knows that their lists are ready to review. It will take them a few days to review their lists. Steps d and e are done by Lucy

d. [Perkins List] Button; Form for Lucy to evaluate, un-check those records to be removed from hold.

e. [AR List] Button; Form for Lucy to evaluate, un-check those records to be removed from hold.

f. [Print Diploma Book by SID] Button; generates report, save to PDF or print and deliver to send to Angie Garbarino.

Save the PDF on our intranet site:

g. Perkins/NDS

h. AR

5. Send master list to Angela Garbarino in Degree Requirements, copy to Lucy