A Listing of Day End Processes

Day End Processing runs several processes. You can customize which processes run during Day End. The Day End Process table lists this information about each process:

The name of each Day End process.
The name of each Day End menu option.
The name of each Day End program.
A description of each Day End process.

You can use the information in this section as you perform Day End tasks. (For more information on performing Day End tasks, see Adding or Removing a Process from the Day End Schedule and Running Day End.)

These Day End processes are listed in the order they run by default:

Process

Menu Option

Program Name

Description

Set Overdues

OverDue

deoverdu.exe

Changes items that remain checked out, with due dates that have passed, to the status of “Overdue.”

Purge Circ History

CircHis

decirchi.exe

Deletes old circulation information about the previous borrower of an item. (You specify the number of days that must elapse before circulation information is purged in the itype table. For more information, see “Defining Item Circulation Types [ITYPEs]” in the “Preparing Horizon to work with Item Records” section of the Circulation Setup Guide.)

Expire Holds

ExpHold

deexphol.exe

Resets the status for “Items Being Held” to “Checked In” when the hold expiration date is reached and generates a notice to inform the borrower.

Generate Day End SMS Notices

DeSMS

DeSMS.exe

Generates all SMS notices for pre-overdues, overdues, and holds available for pickup when SMS has been enabled and a borrower has requested the specific notice type.

This feature can be configured to have the notices count as a notice sent, or the borrower can receive SMS messages as well as telephone, email, or printed notices in addition to the SMS notice

For additional information about SMS and day end processing, see the SMS Messaging Administration Guide.

Generate Notices

Notices

denotice.exe

Generates all notices with parameters that have been reached; you can then print the notices from various processes. (For example, if notices are set to be sent every seven days after the first notice, Horizon generates notices for blocks that have had an initial notices generated seven days prior to the current date.)

Purge Requests

PurgReq

dereque.exe

Deletes items with a request expiration date that has passed without the request being filled from the request queue. (At this time, Day End also generates a notice to inform the borrower that the request has expired.)

Purge Burbs

PurgNot

deburb.exe

Moves obsolete blocks to the burb history file.

Purge Words

Word

deword.exe

Deletes keywords from the keyword index that no longer have any references.

Purge New Bibs

NewBib

denewbib.exe

Clears out the New Titles list in staff searching. (You specify the number of days that a title must remain in the list before this process clears in the matham view.) (For more information, see System-Wide Settings.)

Purge Burb History

BurbHis

deburbhi.exe

Deletes past blocks after a specified amount of time. (You set this time [days] for each block type in the block view. For more information, see “Setting Up or Editing a Block Type” in the Circulation Setup Guide.)

Purge Deleted Items

PurgIte

deitems.exe

Removes from the database any items that library staff have deleted. (Note that the items are removed from the indexes at the time of the original delete.)

Purge Deleted Bibs

PurgBib

debibs.exe

Removes from the database all bibs that library staff have deleted. (Note that bibs are removed from the indexes at the time of the original delete.)

Age Item Status

AgeItem

deitmstt.exe

Changes the status of items to the next specified status after a given amount of time. (For example, items with a status of “Lost” change to a status of “Missing” after the number of days have elapsed specified in the location view.)

PO Complete

DePoCmp

depocomp.exe

Rolls a PO over to a status of “Complete.”

Acquisitions Claims

DeAcqCl

deacqclm.exe

Generates claims for items ordered through Acquisitions.

Serials Claims

DeSerCl

deserclm.exe

Generates claims for serial issues that have not arrived. (Horizon assigns a “Claim” status to issues according to claims parameters set up in the issue’s copy record.) (If you want to force a claim on an issue, you must change the status of an issue to “Claim” before you run this Day End process.)

Purge Expired Advance Bookings

PurgABK

deadbook.exe

Deletes bookings that have expired.

Purge PO Line Item Histories

PurgPoL

depolihi.exe

Purges PO line activity (such as ordered, received, and so forth) when the date set in the po_activity_type view has passed. (This process also sets the days of retention for the specific activity type.)

Update Reserve Room ICT Activity

DeRbrAc

derbract.exe

Changes the active status of reserved items from active to inactive and vice versa when the activation and reactivation dates in the ICT record passes.

Update Locations Summary

Upd49b

deupd049.exe

Updates summary of locations that have copies of a particular bib. (This option and appropriate staff searching configurations are useful only if your database includes several location options which are physically far apart. Updating holding locations lets bib-level displays show where copies of a title are without having to display the Copies list.)

Day End Notice Fine

DeNoFin

denofin.exe

Creates fines for every notice generated, regardless of the number of items on the notice.

Pending MARC Send Output

PMSOut

depmsout.exe

Puts into a file all changes in bib and holdings records that have occurred since the last time PMSOut was run. (This process is necessary only for those libraries that have two or more servers and need their bib and circulation databases synchronized.)

Day End Stat Processing

DeStats

destat.exe

Gathers daily statistics on various library activities such as checkouts, then, if flagged to do so, generates reports for these statistics. Day End collects and groups reports of circulation activities by:

ITYPEs
BTYPEs
ISTATs
BSTATs

Also extracts and compiles Extended Statistics information, if the feature has been activated. For more information, see Extended Statistics.

Day End Stat Processing Monthly

DeStatM

destat.exe

Gathers statistics on a monthly basis. (This version of Stat Processing takes longer to run than the daily Day End Stat process.) DeStatM does this:

Gathers monthly snap shot statistics, such as item stats and borrower stats.
Removes obsolete statistics, such as retention days.
Collapses statistics, such as a past year’s daily circulation statistics into a year’s statistics.
Prints daily and monthly reports.

Update Current Address for Borrowers

MBAupd

deboradr.exe

Updates the borrower address table to reflect the borrower’s current address. If a borrower has a temporary address, Horizon updates to that address. When the date range specified for a current temporary address expires, or if there is no temporary address, Horizon updates the table to the mailing address. If the borrower does not have a mailing address, Horizon updates to the permanent address.

Day End Item and Borrower Counts

DeCount

DeCounts.exe

Updates the changes made to item and borrower related tables. (Horizon keeps a count of changes made to item and borrower tables, such as changes to item statuses, collections, btypes, phone types, and so forth.) The DeCounts.exe Day End process updates and records these changes.

Generate Telephone Messaging Notices

DeTcNtc

DETcNoti.exe

Deletes old telephone notices according to the parameter set in the day_to_keep_history column in the telecirc_control view, and generates telephone notices for overdues, holds, and fines for borrowers.

Generate Claims for Serials Binding

DeBindC

DeBindCl.exe

Processes all shipped lots that have not been received.

Statements Completed

DeSTCmp

DeSTComp.exe

Marks Acquisitions statements as complete when the statement is approved and you run Day End.

Day End Debt Collection Update

DeDebtU

rundc.bat

/d /g1 u e

Queries the database for borrowers you have currently submitted for collections, looks for continued activity for those borrowers, and updates any amounts as a result of continued activity. In addition, it creates a report of these borrowers.

Day End Debt Collection New

DeDebtN

rundc.bat

/w /g1 n e

Queries the database for borrowers who meet debt collection criteria that Horizon has not yet submitted for collections, creates a report of these new borrowers, and adds the borrowers to the list of current borrowers submitted for collections.

Day End Create and Output Notices

DeNtcCr

DeNtcCreate.exe

Creates overdue, pre-overdue, and hold notices and sends them automatically based on each borrower's notification configuration.

Day End Clean Up Increment Tables

DeIncCl

DeIncCl.exe

Cleans up the database tables that support the Increment Inventory Number, Call Number Prefixes, and CSA Call Number Prefixes features, if any of them have been enabled. This process removes temporary numbers that can be reused and updates the starting number for each prefix to one number greater than the current number.

Day End Run Stored Procedures

DeSp

DeRunSp.exe

/n /a

Runs a specified custom stored procedure in the Horizon database. Type the name of the stored procedure to run following the /n switch; type any arguments to pass to the stored procedure following the /a switch. For example:

/nsample_proc /a1234

Note: This process only runs stored procedures that perform database insertions or updates; this process does not run selection procedures.

Day End Family Group

DeFamGp

DeFamilyGroup.exe

Removes all family groups from the database that have one or fewer members.

Day End Automatic Renewal Items

AutoRNu

DeAutoRenewal.exe

Renews any items that are due on the current date that can be renewed (according to the renewal settings configured for the location) and that have not exceeded the maximum times an item can be automatically renewed (see Setting Auto-Renewal Options).

 


© 1998-2017 Sirsi Corporation