Versions Compared

Old Version 21

changes.mady.by.user Sharon Helen Markus

Saved on

compared with

New Version 22

changes.mady.by.user Sharon Helen Markus

Saved on

Key

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

...

The daily_update_circ_demographics_metadb task is set up to execute the update_circsnapshot4.sql query daily at 7am, 11am, 2pm, 5pm, and 9pm. The update_circ_snapshot4_metadb.sql query (in the LOCAL_AUTOMATED folder in DBeaver) runs the following code on Metadb using the z_slm5 user account, which uses the INSERT function to get the new checkouts and add them to the sm_local_shared.circsnapshot4 table daily automatically. The sm_local_shared.circsnapshot4 table is used in circulation queries to generate reports that need the PII data that is removed everyday from circulation data in the FOLIO system.

...