Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

UPDATE folio_circulation.loan__t__ 
SET user_id = NULL
WHERE __current = FALSE
AND user_id IS NOT NULL
;

...

Historical Request data to be purged

-request data is not attached to fines, fees, or loans

...

-need to update requester id value to NULL on request rows that are not current or request status is Closed for both historic and current rowscurrent 

-need to determine whether or not BD and ILL requests need to be considered differently

...