New Overdue Notices Report
| • | Pipe-delimited Output |
The New Overdue Notices (Noverdue) report creates daily overdue notices, notices for very recently overdue items, or items that became overdue during the specified date range. This report differs from other overdue notice reports because a range of overdue dates can be selected on the report’s Charge Notice tab so that each type of overdue notice (first notice, second notice, and so on) can be generated based on the number of days overdue.
The New Overdue Notices (Noverdue) report will not allow the selection of material that is not yet overdue. If there is a need to select material that is due in the future and not yet overdue, the Overdue Notice (Overdue) report should be used.
This report contains the following tabs.
| • | Basic Tab: Reports |
| • | Charge Notice Tab |
| • | Charge Selection Tab |
| • | Copy Accountability Selection Tab |
| • | Item Selection Tab |
| • | Produce Mailing Labels Tab |
| • | Sorting Tab |
| • | User Accountability Selection Tab |
| • | User Selection Tab |
| • | User Status Selection Tab |
| • | Print Separate Reports for Each Library Tab |
On the Charge Notice tab, each Message field has a corresponding Date field. You may use the Date Range gadget in each Date field to select a range of dates during which items became overdue. When you select a range of dates for the Date fields, the report will determine the type of overdue notice to produce based on the number of days overdue for the selected overdue charges.
If you use the default date selection, you must run this report on a daily basis, including weekends. The default date is no later than zero days before the report is run (that is, today).
The report results can be sorted by user ID, group ID, user name, or ZIP code. User ID is the default sort. Address labels may also be printed.
When sorting the overdue notices by ZIP code, you now have the option of dropping the initial sort by library. This option creates batches of overdue notices in ZIP code order, which some libraries use to save on batch mailing costs. If you select sort by ZIP code on the Sorting tab, the Presort by Library check box will appear. Clear the Presort by Library check box, and the notices will be sorted by ZIP code only.
If you choose not to sort by ZIP code, the report sorts by Library first, then by User Name, User ID, or Group ID.
When the library address is included in a notice, the address is drawn from the user record with a user ID which matches the User ID attribute of the appropriate Library policy.
If Generate Pipe Delimited Output is selected on the Charge Notice tab, the report creates a pipe-delimited file and places it in the /Rptprint directory with the naming convention of yyyymmdd_internalrptname.pipe. The report log lists the pipe-delimited report file name. This pipe-delimited file can be opened using a third-party application, such as a spreadsheet application.
Sorting selections made within the report are not applied to pipe-delimited files. For example, if you sort the report by ZIP code, the ZIP code sort is not applied to the contents of the pipe-delimited file
The entries listed in the Brief Entries attribute of the User Address Format wizards are used to supply information for the address fields in the pipe-delimited file. The City/State field (if it is used) is evaluated as one field, not as two separate fields for the city and the state. The report will check user records for the fields listed in the Brief Entries attribute and print only the populated fields in the pipe-delimited output.
Pipe-delimited Key File
The pipe-delimited key file defines each field of the pipe-delimited file for a particular notice.
The following pipe-delimited key file defines the fields for an overdue item notice.
|date|Library Name|street|line|city, state|zip|user ID
|User name|street|line|city,state|zip|group id|
salutation|notice text|call number|item ID|title|author|
due date|price|accrued fine|closing text|
For example, this is a pipe-delimited key file for an overdue item notice, and the notice output that is produced from the file.
|Friday, May 12, 2006|Rockerfeller Public Library|123 Main St.|
|Huntsville, AL|35801|ID: 6580|Mary Patron|1234 Fair Oaks Lane||St Louis, MO|63134|Group ID:|Dear Mary Patron,|”1ST OVERDUE NOTICE” The following Library materials are overdue. Please return them as soon as possible. Thank you. |PS1305 .A2 B53 1985|924-1001|Adventures of Huckleberry Finn : Tom Sawyer’s comrade / Mark Twain ; edited by Walter Blair and Victor Fischer.|Twain, Mark, 1835-1910.|5/5/2006,23:59|$25.00|$0.70|BY SIGNING, I ACKNOWLEDGE THAT I HAVE RECEIVED THE ABOVE MATERIAL AND THAT THE ABOVE INFORMATION IS ACCURATE. PATRON’S SIGNATURE:________________________________________OFFICE:_____________ DATE:_______________________
|Friday, May 12, 2006
Rockerfeller Public Library
123 Main St.St Louis, MO
55555
ID: 6580
Mary Patron
1234 Fair Oaks Lane
St Louis, MO
55555
Group ID:
Dear Mary Patron,
”1ST OVERDUE NOTICE”
The following Library materials are overdue. Please return themas soon as possible.
Thank you.
1 call number:PS1305 .A2 B53 1985 ID:924-1001
Adventures of Huckleberry Finn : Tom Sawyer’s comrade / Mark Twain ;
edited by Walter Blair and Victor Fischer.
Twain, Mark, 1835-1910.
due:5/5/2006,23:59 price:$25.00 accrued fine to date:$0.70
BY SIGNING, I ACKNOWLEDGE THAT I HAVE RECEIVED THE ABOVEMATERIAL AND THAT THE ABOVE INFORMATION IS ACCURATE.
PATRON’S SIGNATURE:______________________________________ OFFICE:_____________
DATE:_______________________
Related topics