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