Department

Circulation

Purpose

Twice a year the library will be sending a list to student accounts to have billed/lost items replace. These lists will be run at the start of finals week and sent on the last day of finals.

Overview

This is the process that is used during finals week during both fall and spring semesters to create the list to send to student accounts and when the items are paid for to notify Library Administration of items that have been paid for replacement purposes.

Required Knowledge/Skills

Access to Sierra create lists, Google sheets, and gmail

Safety Issues/Precautions

N/A

Equipment/Supplies

Computer access

Procedure

Using personal login information log into Sierra and go to the "Create Lists" function
Choose an open list to create the list
Click on "Search Records"
In the bottom center chose "Retrieve Saved Query"
Scroll down until "Billed student accounts" is located
Click on "Select"
At the top left of the screen in the "Review File Name" box name the list
In "Store Record Type" use the drop-down menu to choose "Item"
Edit the dates of the query: Spring list dates should run from the end of the previous semester to date list is being run: December list should run the start of the end of the previous semeste-Date in December that the list is run.
Click on "Search"
Once the search has run click on "Export Records"
In the next box under "Type" choose Patron
In "Field" Choose "Patron Name"
Click on "Append" to add another line
In "Type" choose Patron
Field choose "UNIV ID"
Append
"Type" should be Bibliographic
"Field" should be title
Click on browse at the lower right side of the screen.
Choose a location and title the export.
In the "Files of Type" dropdown box choose "Text Files (*.txt)
Save
Click "OK"
Once the list has been exported open excel
Under the Data tab click on the "From Text" icon top left corner.
Find the export file and open it.
Under "Original data type" choose Delimited
Click "Next"
Check the "Comma" box
Click on "Finish"
Make sure the A1 cell
Click "OK"
Remove the duplicate names
Check stacks to make sure items haven't been returned.
contact Acquisition specialist to get prices of each item
once the cost of items has been provided add a $15 processing fee.
To prepare the list to send to student accounts make sure the following information is on the excel spreadsheet in the following order:
1. First name
2. Last Name
3. ID
4. Cost (Total cost for the student if multiple items are billed)
5. Term (i.e Fall 2021 etc.)
Copy and paste the information into the google sheet called " Billed Students"
Add "Title/author", "Call Number", and "Due Date"
Email the spreadsheet to: studentaccounts@valpo.edu
If an item is returned Fill out the google sheet called "LIbrary return credit"
Download the sheet and email it to: studentaccounts@valpo.edu
Circulation managers have training and access for looking up payments made by running a Colleague ACBL report. The Library administrative assistant and Library acquisition associate can serve as backup for running an ACBL report and an AHST report for reviewing end-of-spring semester charges.
Once an item is paid for a manager will fill out the Replacement form to initiate the replacement process.
After the replacement form is filled out a manager will send an email from valpolibrary@valpo.edu letting the student know that they can keep the item if it is found. A template can be found in the library email account.
Check to make sure that there isn't a separate hold placed on the account in Ellucian if there is a hold remove that if there is one, and note that on the spreadsheet.

Browser not supported