Tag Archives: LIMTON TIS

Attendance Summary Report on LIMTON TIS

Here is quick SQL query that generates employee’s monthly attendance report on Limton TIS. Getting Department and Designation names was a bit tricky as they are not named as such. They are placed inside HRTCompanyLogicDetail table. select datename(dw,A.RDate) Day, C.EmployeeFirstName … Continue reading

Posted in Tutorials/Tips | Tagged | Leave a comment

Getting RAW Data in LIMTON TIS Time Management System

I had to pull raw data of an employee who hare marked his/her attendance more than 2 times (probably thinking to trick the system or otherwise), the regular table HRTAttendance show only In and Out time. In case of multiple … Continue reading

Posted in Tutorials/Tips | Tagged , , | Leave a comment