Banner and peoplesoft patron database updates who s on first
Download
1 / 34

Banner and PeopleSoft Patron Database Updates: Who s on First - PowerPoint PPT Presentation


  • 66 Views
  • Uploaded on

Why?. Because!. Banner and PeopleSoft Patron Database Updates: Who’s on First?. Tomorrow. Scott Gillies, Information Systems Librarian and Joy Garmon, Coordinator of Access Services Georgia Gwinnett College Library GUGM – Ft. Valley State University May 17, 2007. I Don’t Give a Darn!.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Banner and PeopleSoft Patron Database Updates: Who s on First' - corbin


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Banner and peoplesoft patron database updates who s on first

Why?

Because!

Banner and PeopleSoft Patron Database Updates: Who’s on First?

Tomorrow.

Scott Gillies, Information Systems Librarian

and

Joy Garmon, Coordinator of Access Services

Georgia Gwinnett College Library

GUGM – Ft. Valley State University

May 17, 2007

I Don’t Give a Darn!

What?

I Don’t Know…

Who?

Today?


Gil policies
GIL Policies

  • When are updates run?

  • Who initiates the update run?


Institutional policies
Institutional Policies

  • Who is going to run the updates?

  • What about mapping?

    Important – Student employee borrowing privileges. Contact site coordinator to have them mapped the way you want.


When important dates to consider
When? Important Dates to Consider

  • First day of classes

  • Last day to drop/add

  • Last day to withdraw

  • Mini-mesters

  • Half semesters

  • Expiration Date


Peoplesoft employee codes
PeopleSoft Employee Codes:

  • # B06 Full-time Biweekly

  • # B07 Students

  • # B08 Part-time Biweekly

  • # BFX Biweekly Flex Schedule

  • # M01 Monthly Full-Time

  • # M03 Academic Faculty

  • # M04 Part-time Monthly

  • # MEX Monthly Flex Schedule

  • # MFX Monthly Faculty Flex Schedule

  • # RET Billing – Retirees, LOA, Disab

  • # RTB Retirees – Working Biweekly

  • # RTM Retirees – Working Monthly

  • # SUM – Summer Faculty


Zorvlib banner student update
ZORVLIB – Banner Student Update

http://ggc-admin.gabest.usg.edu/






Finishing the zorvlib process
Finishing the ZORVLIB Process blocks.

When this screen appears, click OK to end the process.

Now, you must use a secure FTP client to connect to Banner File Manager and copy the ZORVLIB output to your local computer, so that you can send it to your GIL Site Coordinator.



File manager security risk
File Manager = Security Risk blocks.

Even though you logged in to File Manager with your own username and password, you can see all other jobs run for your institution.


This is a local folder that you need to create. blocks.

This is the folder where your institution’s jobs are saved.



If your database is hosted at gsu
If your database is hosted at GSU… blocks.

…the resulting patron files are sent directly to

the host server via a Secure FTP connection.


If you are hosted at UGA: blocks.

Go to the following URL:https://gil.uga.edu/patron/


What happens next
What happens next? blocks.

  • At UGA, a job runs that transfers the file to your actual Voyager server

  • At GSU files have already been transferred to the Voyager server.


Additional examination of files
Additional examination of files… blocks.

  • Screening of the data to insuring that the patron groups are set for the Banner files

  • Checking patron addresses, etc.

  • Banner & PS patron groups are translated to the voyager PATRON_GROUP_CODE for the institution patron data being processed. For example, UNDERGRAD => "STUDENT"

  • Files are then converted into the Voyager Patron Record Standard Interface File (SIF).


Sif conversion
SIF Conversion… blocks.

  • …often results in a number of error messages where the incoming record has a different Patron Group Code than that of the existing Patron Group Code.

  • For some institutions, vendor supplied barcodes are added at this point.

  • Additional processing can also include using different .sif formatting scripts which accommodate the institutions’ local preferences regarding institutional ids.


Voyager patron update program
Voyager Patron Update Program blocks.

  • Commonly known as Pptrnupdt, this Voyager utility takes the .sif input and updates or loads the patron data into the Voyager databases.

  • Generates information about the load: number of input records processed, number of records added, existing patrons updated, etc.


Example of pptrnupdt e mail
Example of Pptrnupdt E-mail blocks.

record# 3 with id #########:

patron group of update record conflicts with database patron group record# 6 with id #########:

patron group of update record conflicts with database patron group record# 13 with id #########:

patron group of update record conflicts with database patron group record# 15 with id ######### : UB patron record# 18 with id ######### : UB patron record# 19 with id ######### : UB patron record# 24 with id ######### : UB patron record# 28 with id ######### : UB patron record# 32 with id ######### : UB patron record# 38 with id ######### : UB patron record# 74 with id #########:

patron group of update record conflicts with database patron group #records processed = 83 #UB records skipped = 7 #records with problem patron group skipped

RUN PARAMETERS:

Input File Name: /m1/voyager/gucdb/local/patron/gucdb_staff-vsif

Audit File Name: /gil/gucdb/html/reports/circ_reports/patron-audit-06-09-28.22:02

Error File Name: /gil/gucdb/html/reports/circ_reports/patron-error-06-09-28.22:02

Index Type: D: Program Chooses

Default Notes type: General

Overlay Notes: Add New Notes

Extended Notes Processing: OFF

Monitor records processed every: 50

Number of records to process: ALL

50 input records processed!

GRAND TOTALS

Input Patron Records Received: 72

New Patrons Added: 0

Existing Patrons Updated: 72

Records Written To Exception File: 0

Stub Records Skipped: 0

CONVERSION/UPDATE COMPLETE


Post update processing uga site
Post Update Processing (UGA Site): blocks.

  • Compares the existing load/update records against previous load/update records.

  • Records which are among the previous load records, but are not among the current loaded records are extracted from the Voyager database.

  • These records are then updated with a new expire date (today's date) and reloaded into the Voyager database via the Voyager Patron Update Program (Pptrnupdt). The result is an expired patron with no borrowing privileges.


Questions
Questions??? blocks.


ad