Leadership
Source data is brought into the model through incremental updates. You can contact your administrator for times and frequencies of updates.
When multiple records for the same Effective date are specified for an employee or employee’s work assignment, the record with the most recent Update Stamp for the same Effective date is used.
For example, if an employee originally has a Start Date of 6/3/2020 effective 6/3/2020, but then changes the Start Date to 6/10/2020, if the effective date 6/3/2020 is used when updating the Start Date field the only Start Date tracked is 6/10/2020. If an Effective date of 6/10/2020 is specified for the new Start Date, the Employee have two Start Dates, 6/3/2020 and 6/10/2020.
Some Employee fields such as Birthdate, Gender, Ethnicity and Name are not tracked historically and always show the most recently specified value.
| Fact table | Description |
|---|---|
| Work Assignment History |
Tracks the changes to work assignments and the effective date of the change. These are changes that involve a From and To value on a specific date such as changing a job code on an effective date. The key source table for this data is Work Assignment History. The analyze by dates are Effective From and Effective To. |
| Work Assignment Snapshot |
Provides a snapshot of the state of each employee’s work assignment. The snapshot is calculated as of the last date of each month they are employed. This includes measures that are not tied to an effective date but require analysis over periods of time such as age, Length of Service (LOS), and Time in Job . The key source tables for this data is Work Assignment History and the Employee table. Data reflects the last date of each month Snapshot_Month. During the current month, the data reflects the data as of the processing date. |