Move Items to Resting Branch for Quarantine

Clearinghouse Repository Polaris Repository
,
1

Move Items to Resting Branch for Quarantine

This is a snip of our code that looks through existing material in the “wild” and moves it to a different branch location. We do this since our main library branch leverages an automated material returns machine and we wanted the material to come off of the patrons record when it was returned.

This runs every hour…

This moves material checked out to our patrons to a specific “resting” branch that the automation machine is also set to. When an item comes across the belt it checks the item “in” and lives in that “resting” branch for a set period of time. Items on hold or that do not fit the standard category are put into the exceptions bin and are handled manually by our staff.

See Remove Items from Resting Branch in Quarantine.sql for follow up.

Contributed by: Derek Brown - Rochester Hills Public Library


UPDATE
    TOP (1000) Polaris.Polaris.CircItemRecords

-- Move Items OUT in the wild from MAIN library to RESTING branch WITHOUT holds
SET
    AssignedBranchID = '14', ShelfLocationID = sl2.ShelfLocationID, StatisticalCodeID = sc2.StatisticalCodeID
FROM
    Polaris.Polaris.CircItemRecords AS [cir] WITH (NOLOCK)
LEFT OUTER JOIN
    Polaris.Polaris.ShelfLocations AS [sl1] WITH (NOLOCK) ON cir.AssignedBranchID = sl1.OrganizationID AND cir.ShelfLocationID = sl1.ShelfLocationID
LEFT OUTER JOIN
    Polaris.Polaris.ShelfLocations AS [sl2] WITH (NOLOCK) ON sl1.Description = sl2.Description AND sl2.OrganizationID = '14'
LEFT OUTER JOIN
    Polaris.Polaris.StatisticalCodes AS [sc1] WITH (NOLOCK) ON cir.AssignedBranchID = sc1.OrganizationID AND cir.StatisticalCodeID = sc1.StatisticalCodeID
LEFT OUTER JOIN
    Polaris.Polaris.StatisticalCodes AS [sc2] WITH (NOLOCK) ON sc1.Description = sc2.Description AND sc2.OrganizationID = '14'
LEFT OUTER JOIN
    Polaris.Polaris.PatronAccount AS [pa] WITH (NOLOCK) ON pa.ItemRecordID = cir.ItemRecordID
LEFT OUTER JOIN
    Polaris.Polaris.Patrons AS [ps] WITH (NOLOCK) ON ps.PatronID = pa.PatronID

-- Items assigned to our main library branch
WHERE
    AssignedBranchID = '3'
AND
    ItemStatusID = '2'
-- Ignore IIL
AND
    ILLFlag = '0'
-- Ignore all econtent
AND
    cir.Barcode NOT LIKE 'econtent%'
-- Ignore all melcat items out to a patron
-- AND ps.Barcode NOT LIKE 'INNREACH%'
AND
    cir.AssociatedBibRecordID NOT IN (
        SELECT
            BibliographicRecordID
        FROM
            Polaris.Polaris.SysHoldRequests AS [shr] WITH (NOLOCK)
        WHERE
            shr.SysHoldStatusID = '3')
AND
    cir.Barcode NOT IN (
        SELECT
            DISTINCT(ItemBarcode)
        FROM
            Polaris.Polaris.SysHoldRequests AS [shr] WITH (NOLOCK)
        WHERE
            shr.SysHoldStatusID = '3'
        AND
            ItemBarcode IS NOT NULL)