Page History

...

Here is a screenshot of the local_core.circsnapshot4 table in the LDP. 

Testing LDP Results

Use this query to make sure the circ_snapshot4 table in the local_core schema is getting updated daily at 8am.

select 
sm.extract_date::timestamp,
count (sm.loan_id) as count_of_loans

from local_core.circ_snapshot4 as sm
group by sm.extract_date::timestamp
order by sm.extract_date::timestamp desc

Circ Snapshot for Metadb

The circsnapshot for Metadb uses the table that was originally created in LDP to store additional updates to demographics information needed for certain circulation queries. This table was exported from the LDP and imported into the local_shared schema in Metadb. In the data import process, column data types were set to match the data types in the equivalent LDP table. 

...