We have Micros 3700 ver 4.7 in 6 restaurants. We use Hot Schedules to do employee communication and scheduling. Hot Schedules will import the employee schedules into our Micros DB. This allows time and attendance to work. Here is my problem: The schedule data never goes away. This becomes an issue when an employee is termed and we would like to reuse the number. I am looking for a script that would purge the schedule data older than 12 months. I am not sure which table needs to be purged.
Can anybody help?
Thanks.
Can anybody help?
Thanks.