[Tsheetx-developers] Absence management

[David T. <tom...@ho...>]

Hi to anyone listening.. I checked everything in that I have been working on last night. Different types of absences/leave can be entered on the absences pages. This is only monthly and to half-day granularity, that's how we have been using it. Public holidays can be entered, and appear on the calendar, but there is no user interface yet to manage these. There is an example SQL script to add public holidays. The new table timesheet_absences holds this info, with the impicit rule that an entry with a null user id applies to all users. The holiday calculation is working according to the new timesheet_allowances table. Again there is no user interface yet to manage this table. I tried to put the rule in that every user gets an initial allowance entry (of zero). Normally holiday allowance is added yearly, and this works. I use the earliest entry in this table as the user's "start date" i.e. when he joined the company/system. Glide-time is held in a similar way but is much more complicated to calculate. You need to calculate the worked-time (from the times entered), the required working-time (attendance) - you need to exclude public holidays and other things, and in our system you could compensate the time, or have it paid out. Compensation is an absence to record, and paying out hours should be represented by a negative entry in the glide-time allowance table. The glide-time calculation is messy and not well implemented, and on the monthly report the calculation is wrong. And it needs to be more flexible/configurable. But the basics are there. At least no one has to use this who doesn't want too, because it can be switched off (set ACL to none) on the config page. Cheers
_________________________________________________________________
Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy!
http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us