Tracking FMLA
mrsbowden
167 Posts
I am trying to develope a tracking system for FMLA. The company I work for has always granted leave to those in need, but until NOW has never actually issued FMLA. Well I was the lucky person to put this into motion so to this point there is no record etc. of any person who was issued FMLA. Besides the paper work file I am keeping I would like a spread sheet or data base of some sort in order to quickly and easly keep track of those EE's dates etc. that have been issued FMLA or are currently on FMLA.
Is anyone will to share the type of information they track, how they track it etc. I was thinking of an Execl spreadsheet and maybe colorcoding for those who are currently out on FMLA. Any suggestions x:-/
Is anyone will to share the type of information they track, how they track it etc. I was thinking of an Execl spreadsheet and maybe colorcoding for those who are currently out on FMLA. Any suggestions x:-/
Comments
It works pretty well if you don't have very many to track.
She has set up all of our attendance recording, inlcuding FMLA on Access. We will start utilizing her program Jan. 1. To date, we have used hard copy calendars for exempt and non-exempt.
The calculation was set up to "subtract" each occurrance from the total. In other words, the total column was in a right hand column, and immediately to the left was the date in one column and then number of hours used on that date (or week) in the adjacent column. To the right of each entry then, was the current running total. Three columns total. "Date" "Time used" "running total"
If this is not clear and you'd like to call me, please let me know. I hope this helps. I liked the spreadsheet system and thought it worked well, but have recently been considering the software from JJKeller someone mentioned above. I currently have it in my possession for review.
Wendy