Employee Historical Change Tracking
- Michael Addison
This will be the structure of the data table for all users.
Important items to note:
Location_Code
EmployeeNumber unique to this person in PeopleSoft
Date_In_Job is the date that this Job_Title and Job_Code is effective from
Employment_Status_Code T is Terminated and A is Active
Original_Hire_Date is the first date the employee was hired into the company
To calculate length of time an active employee has worked, take the difference from Original_Hire_Date to today
To calculate length of time a terminated employee has worked, take the difference from Original_Hire_Date to the Terminated_Date (to be added 3/9/2022)
Able to determine the duration of time the user has been in the same Job_Title.
Benefit of this is it is a direct duplicate of the data being exported from PeopleSafe.
Company | Location | Location_Code | Org_Level_4_Code | Org_Level_2_Code | EmployeeNumber | LastName | FirstName | Middle_Name | Date_In_Job | Job_Title | Job_Code | Employment_Status_Code | IsSupervisor | Employee_Number_Supervisor | UserID | SecurityGroupName | Original_Hire_Date | Last_Hire_Date | PhoneNumber | Employee_Type | %%physloc%% | |
Eagle Materials | CPCMO | CPCMO |
| 110S0A | 1234 | Bob | George |
| 1-Dec-12 | Engineer | ENGIN1 | T | Y | 456 |
|
|
| 12/1/2012 0:00 | 12/1/2012 0:00 | 444 | Regular | 0xD8440--- |
Eagle Materials | CPCTU | CPCTU |
| 11000T | 1234 | Bob | George |
| 1-Jul-16 | Manager Mine | MINE3 | T | Y | 456 |
|
|
| 12/1/2012 0:00 | 12/1/2012 0:00 | 444 | Regular | 0xD8440--- |
Eagle Materials | EAGMT | EAGMT |
| 27000 | 1234 | Bob | George |
| 1-Oct-21 | Engineer Sr, Corp | ENGIN10 | T | Y | 678 |
|
|
| 12/1/2012 0:00 | 10/1/2021 0:00 | 444 | Regular | 0xD8440--- |
Eagle Materials | EAGMT | EAGMT | 9 | 900 | 1234 | Bob | George |
| 1-Jan-22 | Engineer Sr, Corp | ENGIN10 | A | Y | 678 |
|
|
| 12/1/2012 0:00 | 1/1/2022 0:00 | 444 | Regular | 0xD8440--- |