Advertisement
tmccanna

Claims Returned Report

Dec 9th, 2020
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.55 KB | None | 0 0
  1. Claims returned report:
  2.  
  3. List of Claimed Returned items filtered by library and fines stopped date. This report can be used to search the shelves for items that may have been returned but were not checked in. If items are found, they will need to be checked in and removed from the patron accounts.
  4.  
  5. Updated Aug 28 2018
  6. -----------------------------------------
  7. Uses Circulation source. Nullability selection enabled.
  8.  
  9. Displayed Fields:
  10.  
  11. Circulation -> (None) Circulating Item -> (None) Call Number/Volume -> (None) Owning Library -> Short (Policy) Name as "Owning Library"
  12. Circulation -> Shelving Location -> Name as "Shelving Location"
  13. Circulation -> (None) Circulating Item -> (None) Call Number/Volume -> Call Number Label as "Call Number"
  14. Circulation -> (None) Circulating Item -> (None) Call Number/Volume -> (None) Bib Record -> (None) Simple Record Extracts -> Title Proper (normalized) as "Title"
  15. Circulation -> Circulating Item -> Barcode as "Item Barcode"
  16. Circulation -> Patron -> First Name
  17. Circulation -> Patron -> Last Name
  18. Circulation -> Patron -> Current Library Card -> Barcode as "Patron Barcode"
  19. Circulation -> Fine Stop Date/Time (Date) as "Fine Stop Date"
  20.  
  21. Base Filters:
  22.  
  23. Circulation -> (None) Circulating Item -> (None) Call Number/Volume -> (None) Owning Library -> Organizational Unit ID (In list)
  24. Circulation -> Fine Stop Date/Time (Date) (Between)
  25. Circulation -> Fine Stop Reason Equals "CLAIMSRETURNED"
  26. Circulation -> Circulating Item -> Copy Status -> id (Equals) ("1")
  27. Circulation -> Check In Date/Time (Is NULL)
  28. ("1" = "Checked out")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement