Because each library can use any number of third-party report generators, this section lists only the tables and their columns from which report generators (or library-created programs) can extract notice information. You can print your customized notices and send them through your local postal service or you can send notices by email.
The notice table stores information about the borrower (such as the borrower number) and summary information from all the blocks on the notice. It also stores information about the borrower location (such as the library name and address).
Column |
Contains This Information |
Whether the message “Address Correction Requested” is included in the notice (1=Yes). Note: If you are in the United States, SirsiDynix can customize the text in this message depending on the contract your library has with the United States Postal Service. |
|
Balance due (if any). |
|
Balance due (formatted). Use this column instead of the balance column for third-party report programs, since it is already formatted with dollar signs, decimal points, and so forth. |
|
System-assigned number of the batch that contains the notice. |
|
System-assigned number of the borrower record for the borrower who receives the notice. |
|
Notice that the line represents (first, second, and so forth). |
|
Number of the invoice. |
|
Code for the location to which the borrower belongs. |
|
Date that the notice was created in Horizon. |
|
Total amount owed (if any). |
|
The total amount owed (formatted). Use this column instead of the total_amount column for third-party report programs, since it is already formatted with dollar signs, decimal points, and so forth. |
The notice_batch table contains information about each batch of notices that you create in Circulation Reports.
Column |
Contains This Information |
System-assigned number that identifies the batch that contains the notice. |
|
Message or note about the notice batch. |
|
Number of e‑mailed notices contained in the batch. |
|
Date the batch was last used to create notices. |
|
Time the batch was last used to create notices. |
|
Number of printed notices contained in the batch. |
|
Whether the notice was sent by email. |
|
Number of times the batch has been used to create notices. |
|
Type of notice. |
The notice_content table stores more detailed information about individual unresolved blocks on a borrower’s record.
Column |
Contains This Information |
Amount owed for the item (if any). |
|
Amount owed (formatted). Use this column instead of the amount column for third-party report programs, since it is already formatted with dollar signs, decimal points, and so forth. |
|
Name of the item’s author. |
|
System-assigned number of the batch in which the notice is contained. |
|
Block code for which the notice is created. |
|
Description of the block for which the notice is created. |
|
Number of the block in the borrower’s record. |
|
Call number of the title for which the notice is created. |
|
Notes or a message about the notice or block. |
|
Notice that the line represents (first, second, and so forth). This number is used with batch# to link each line in this table to a particular notice in the notice table. |
|
Copy of the title for which the notice is created. |
|
Applicable date. (For example, an overdue notice would have an overdue date.) This field is null where dates do not apply (such as with fines). |
|
Date a hold expires. |
|
Groups items by block type. (For example, overdues would be listed together, fees would be listed together, and so forth.) |
|
Barcode of the item for which the notice is created. |
|
Location code of the item to which the notice applies. Note: You can use only one location in each report (either item_location or pickup_location). |
|
Message included on the notice (for example, “The following items are overdue:”). This message comes from the Default Language field on the block table. (For more information, see Setting Up Blocks.) |
|
Identifies the hold’s pickup location, if the notice is for a hold. Note: You can use only one location in each report (either pickup_location or item_location). |
|
Price of the item for which the notice is created. |
|
The title of the item for which the notice is created. |
© 1998-2017 Sirsi Corporation