Skip to Main Content

About the DLC: Reports that can be run

Reports

The reports that are run for all schools automatically:

  • Monthly Stats:
    • Run first day of the month
    • Emailed to librarian.
    •  A basic report showing circulation stats.
      • If you do not see these reports please contact Cathy Drew.
    PGSS MONTHLY STATISTICS

    Produced Friday, 1 May, 2020 at 1:30 AM


    Report for:
    All Location(s)


    Location
    TOTAL PIECES CIRC

    ENG_BKRM 7 7

    FICTION 177 177

    HMEC_BKRM 1 1
  • Overdue reports
    • Set up and scheduled to run on your schedule.
      • Please let Cathy Drew know when you would like it to run.
    PGSS_List Overdues by Homeroom

    Produced Monday, 1 June, 2020 at 3:15 PM

    Item id Title Checked out Due Date Price
    -------------------------------------------------------------------------------
    User Name: Person, Notta (PGSS) User ID: PGSS123456
    31511018264035 Carry on : the rise a 7/5/2020 21/5/2020 $15.99
    31511015532525 The amazing Maurice a 7/5/2020 21/5/2020 $4.78
    31511018593763 Solo / Kwame Alexande 7/5/2020 21/5/2020 $12.50
  • Staff overdue notice
    • These are scheduled to run once a year in June.
    • Results are emailed to librarian.

Reports that can be requested:

  • Bill notices
    • This report is generated at librarian’s request.
    • It shows items that are overdue by a certain date (1 month overdue)
      • You choose how long overdue you want report to be
    • Generates a form letter (see attachment) to give to students or send to parents.
    Tuesday, 27 June, 2017

    Prince George Secondary Library

    ID: PGSS123456
    Notta Person
    Parents/Guardians of Notta Person
    1234 Fake Pl
    Prince George BC VXX XXX

    Group ID:RM640

    Dear Notta Person,
    The following material is overdue from Prince George Secondary School. Please
    pay this bill or return the item(s) listed below as soon as possible.
    NOTE: If items were returned after the billing date (at top of page), please
    see the library clerk in the library to verify returned items. Thank you.

    Mathematics 10 / authors, Bruce McAskill ... [et al.].
    McAskill, Bruce.
    1 call number:TEXTBOOK MATH ID:31511015158644
    due:15/6/2017,18:00 price:$69.95
  • Weeding reports
    • Shows items that have not been charge within certain criteria.
    Report Log for PGSS NO_CHARGES_IN3YRS FICTION
    Report invlist scheduled as PGSS NO_CHARGES_IN3YRS FICTION
    PGSS NO_CHARGES_IN3YRS FICTION

    Symphony catalog selection 3.5.3 started on Thursday, 4 June, 2020, 1:21 PM
    1357 catalog record(s) printed.
    0 catacnt record(s) printed.
    1357 call number record(s) printed.
    1357 item record(s) printed.
    0 itemacnt record(s) printed.
    Symphony item printing finished on Thursday, 4 June, 2020, 1:21 PM

    PGSS NO_CHARGES_IN3YRS FICTION

    Produced Thursday, 4 June, 2020 at 1:21 PM

    2014 Personal Author: Adichie, Chimamanda Ngozi, 1977-
    Title: Americanah / Chimamanda Ngozi Adichie.
    F ADI
    copy:1 id:31511016777749 library:PGSS
    price:$21.00
    cat1:ENGLISH cat2:Y
    cat3: cat4: cat5:
    type:BOOK
    home location:FICTION created:29/5/2015 permanent
    current location:FICTION pieces:1

    2008 Personal Author: Adlington, L. J. (Lucy J.), 1970-
    Title: Cherry Heaven / L.J. Adlington.
    F ADL
    copy:1 id:31511013206320 library:PGSS
    price:$11.36
    cat1:ENGLISH cat2:N
    cat3: cat4: cat5:
    type:BOOK
    home location:FICTION created:31/5/2010 permanent
    current location:FICTION pieces:1
  • Inventory reports (See instructions in Workflows sub-folder in TL folder)
    • Items checked out to users are accounted for so inventory does not have to be done at the end of the year when all books are back. It can be done throughout the year to make it easier.
    Report Log for HHLD INVENTORY DATE EASY
    Report invlist scheduled as HHLD INVENTORY DATE EASY
    HHLD INVENTORY DATE EASY

    55 catalog record(s) printed.
    0 catacnt record(s) printed.
    0 call number record(s) printed.
    55 item record(s) printed.
    0 itemacnt record(s) printed.
    Symphony item printing finished on Thursday, 4 June, 2020, 12:48 PM


    HHLD INVENTORY DATE EASY

    Produced Thursday, 4 June, 2020 at 12:48 PM

    E ADL 2012
    Personal Author: Adler, David A.
    Title: Bones and the dog gone mystery / by David A. Adler ;
    illustrated by Barbara Johansen Newman.
    copy:1 id:31511013938732 library:HHLD
    location:EASY

    E ARN 2012
    Personal Author: Arnold, Tedd.
    Title: Ride, Fly Guy, ride! / Tedd Arnold.
    copy:1 id:31511016289430 library:HHLD
    location:EASY

    E BEL 2002
    Personal Author: Bellefontaine, Kim (Kim Anne)
    Title: ABC of Canada / illustrated by Per-Henrik G*urth ;
    written by Kim Bellefontaine.
    copy:2 id:31511008499617 library:HHLD
    location:EASY
  • Grant applications (Contact Cathy Drew)
    • Sometimes when applying for grants you are asked for certain information.
      • Average publication date of collection.
      • Size of collection etc.