Fine/fee schedule
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Question
Is there a report (or can it be created in SQL) of the fine/fee schedule for a sublibrary's items? The information needed would include:
material (ex. Textbook)
item status (ex. 53)
time limit (ex. 4 hour)
hourly fine (ex. $1.20 for every open hour)
daily fine (ex. $.50)
max fine (ex. $100.00)
replacement cost (ex. Varies or $399.00)
Answer
1. SQL operates against Oracle tables and this data is in the Aleph (u-tree) files, not in any Oracle table.
2. Though there may be a connection between the "material" and the item status, the z30_material does not enter into fine calculation.
3. These are the tab16 columns which do:
tab16 col.
----------
2 Item status
6 time limit (days)
9 time limit (hours)
11 daily fine*
23 max fine
*The hourly fine is obtained by dividing the daily fine by 24.
The replacement cost is in the xxx50 $data_tab tab18.eng and tab34. Article 000043054 ("How are Lost item charges calculated? **MASTER RECORD**") (see smart link below) describes how it is calculated.
A (locally-written) script might read tab16 and output the above columns to a spreadsheet, but that doesn't seem feasible for the replacement cost.
Additional Info / Related Articles
See also, Article "How are Lost item charges calculated? **MASTER RECORD**"
- Article last edited: 28-Feb-2016