Synchronize Policies Report

The Synchronize Policies (Syncpolicy) report updates tables (Oracle or ODBC, depending on the type of system) for policies that display in WorkFlows so the policy names display correctly.

This report is used only in libraries that use Oracle or Microsoft SQL Server databases.

The Synchronize Policies report contains the Basic Tab: Reports.

Policies are contained in Oracle tables on Oracle systems and in ODBC tables on Microsoft SQL Server systems. Each time policy definitions are created or modified in WorkFlows, the corresponding policy tables are not updated automatically. The Synchronize Policies report updates the policy tables so that when SQL (or MSSQL) statements that output a policy number are used, WorkFlows can refer to the policy table and display the correct policy name instead of the internal policy number.

The frequency with which your library system should run this report depends on the method your library system uses to cycle services on the system and how often this occurs. If your library system calls the auto_haltrun script to cycle services every day, then there is no need to schedule this report to run regularly. However, other reports that cycle services (such as the Add, Delete, Update Text report) do not update policy tables as part of the system cycle. If your daily system cycle job does not call the auto_haltrun script to cycle services, or your library does not cycle services daily, you should schedule the Synchronize Policies report to run daily.

You can also run this report any time significant policy changes are made; however, if you choose to do this, be sure that you run the report outside of peak hours of library service, as running this report makes library services temporarily unavailable to staff and patrons.