Open jessicahjwu opened 6 months ago
MIGRATION NOTES:
Code change + Migrate + Seeder
1) Deploy code change. 2) Run: php artisan migrate 3) Run: php artisan db:seed --class=DataFix_1269_Initialize_Position_Number_In_Conversation_Participants
Optional: Run all overnight processes.
Test validated Test Data:
Id Name Email Position Conversation date New Date 000910 Wilson,Shawna Shawna.Wilson@gov.bc.ca 00046401 2024-10-03 2023-12-14 000021 Zilke,Karen Karen.Zilke@gov.bc.ca 00019151 2023-11-11 2023-11-11 177102 Nadan,Devisha Devisha.Nadan@gov.bc.ca 00030521 2024-06-12 2024-06-12 181150 Lenarduzzi,Sophia Sophia.Lenarduzzi@gov.bc.ca 00003728 2024-01-11 2024-01-11 000164 Richmond,Dave Dave.Richmond@gov.bc.ca 00101602 Paused Manual
Scenario: User Margaret Burrows (EEID#128100) had her last PDP conversation signed off on Dec 29, 2023:
According to PeopleSoft, she started her new role as of Feb 12, 2024, and the PS entry was modified on Mar 15, 2024. Margaret's still receiving notifications that her next conversation due date is on April 29, which did not get recalculated after her new role started.
Business requirement: conversation due dates should be reset based on when the employee switched to a new role (new job start date plus four months).