I wrote something like this for a company in Trinidad recently.
It was used to interface to their Peoplesoft databases of employees and keep
track of changes in employee department as well as to track absences.
An absence tracking system is quite simple to do..basic database stuff,
sticking records in and hten generating a series of looping queries to get
results on reports by absence type, aggregates of absence types etc. etc.
However, with the BP system it was a bit more challenging since there was
the need to synchronise with the Peoplesoft tables to determine which
employees had joined/changed department, and also there was the issue of
department heads editing historical records (Stored in an empinfo history
table)and current records (stored in an empinfo current table) over time.
Finally we settled that admins alone could edit any records. There are still
problems with this edit facility it seems, and I'll have to look into it
when I come off vacation. Longest damn 'simple/quick' project I've worked on
:(
-Gel
> ----- Original Message -----
> From: "Melissa Fraher" <[EMAIL PROTECTED]>
>
> > Does anyone know of a CF application which tracks employee attendance
> > and vacations?
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
