HR Attendance Automation
by Mainul Islam
1. Attendance Import Setup
1.1. Default Office start time
1.2. Default Office End Time
1.3. Form File
1.4. employee_id
1.5. date
1.6. time
1.7. datetime
1.8. event
1.9. From Database
1.10. Host
1.11. Pass
1.12. Port
1.13. Database Name
1.14. Table Name
1.15. employee_id
1.16. date
1.17. time
1.18. datetime
1.19. event
1.20. From API
1.21. employee_id
1.22. date
2. Fine Setup On Attendance
2.1. Inform user if late, absent or out from office before office close
2.2. Enable
2.3. Allow Late time (In minute)
2.4. Cut Salary (Check)
2.5. Max days to allow late time serialize in a month or not
2.6. allow max Days late
3. Data Store
3.1. name
3.2. Employee ID
3.3. date
3.4. entry time
3.5. Is Late
3.6. Late time
3.7. Event
3.8. After Insert
3.8.1. If late entry
3.8.2. if cut salary
4. Report
4.1. Attendance Sheet
4.1.1. Filters
4.1.1.1. Date
4.1.1.2. Month
4.1.1.3. Fiscal
4.1.1.4. Company(reqd)
4.1.1.5. Depantment
4.1.1.6. Employee
4.1.2. Data
4.1.2.1. Date
4.1.2.2. Employee ID
4.1.2.3. Employee Name
4.1.2.4. Department
4.1.2.5. Company
4.1.2.6. In Time
4.1.2.7. Out Time
4.1.2.8. Total Working hours
4.2. Punch (if data insert type Database or API)
4.2.1. Filters
4.2.1.1. Date
4.2.1.2. Month
4.2.1.3. Fical
4.2.1.4. Employee
4.2.2. Data
4.2.2.1. Date
4.2.2.2. Employee (If Employee not filtered)
4.2.2.3. Entry Time
4.2.2.4. Status ["In","Out"]