Tracking Sql
🧑🏭 Product Requirement
| Target release | 12/22/2023 |
| Document owner | [email protected] |
| Developer | [email protected] |
| QA | [email protected] |
🎯 Objective
Tracking lại thông tin để check time clock / payroll
| Objective |
|---|
| e.g., Simplify the user experience |
🤔 Assumptions
Dùng hỗ trợ KH khi cần check time clock , tính payroll
🌟 Milestones
A. Employees: khi user có thay đổi thông tin chỉnh sửa những thông tin của NV như: + check table EmployeeEdited.sql lưu thông tin thay đổi khi: 1. Chỉ mới ghi log Change / update role/ tip pool/ OT 2. Deactive and Add new EE don’t add log B. Time Clock 1. Edit/ Update Clock in/ clock out/ Rest & Meal Rest Select * from TimeClockEdited;
Select * from TimeClockDeleted;
Select * from RestMealBreakEdited; Select * From EmployeeEdited order by UpdateDate desc;- chỉ lưu khi có update role, change giờ OT, giờ làm việc
–Updated Active export excel, csv trong Report UPDATE dbo.Configurations SET ConfigurationValue = ‘1’ WHERE ConfigurationName = ‘BOConfigValue.ExportReportExcelDocument’;
– Update inventory
🗒️ Requirements
| Requirement | User Story |
|---|
🎨 User interaction and design
Chỉ check bằng db
❓️ Open Questions
| Question | Answer |
|---|---|
| e.g., How might we make users more aware of this feature? | e.g., We’ll announce the feature with a blog post and a presentation |
⚠️ Out of Scope
Auto delete database tracking =< 25 months ago