Support Start and End Dates for Team and Team Lead Assignments
Ryan Pisuena
I should be able to:
- Assign a start date and end date for a user's Team and Team Lead assignments.
- Automatically update the end date of the previous assignment when a new one is scheduled.
- Retroactively add or modify assignments, allowing updates to start dates that are in the past.
- Track the historical changes to these fields over time for accurate performance analysis and reporting.
- Leverage a people_history table with the following schema for storing historical data: people_id, field_name, value, valid_from, valid_to