In the old process, if the "Last Day Worked" variable was blank, within the app I think it defaults to a filler of todays date regardless of what state an employee is in, i.e., everyone that had a blank has 2023-02-28 in their record when looking in the app. When exporting the data, these actually appear as "Invalid date". In the new process, it looks like it is defaulting blank dates to 1900-01-01, which both appears in the app and in the exported data.
This might merit further conversation, possibly with the PSA as well, but maybe we want to consider handling blanks differently (perhaps, it's a calculation of one day before effective date if blank?)
In the old process, if the "Last Day Worked" variable was blank, within the app I think it defaults to a filler of todays date regardless of what state an employee is in, i.e., everyone that had a blank has 2023-02-28 in their record when looking in the app. When exporting the data, these actually appear as "Invalid date". In the new process, it looks like it is defaulting blank dates to 1900-01-01, which both appears in the app and in the exported data.
This might merit further conversation, possibly with the PSA as well, but maybe we want to consider handling blanks differently (perhaps, it's a calculation of one day before effective date if blank?)