We currently have the Employee History set up to run the refresh on a daily basis within our system. We need to find the associated tables within the data base for reporting purposes.
We are logging data from the following business classes: Employee (including LPS User defined fields), EmployeeAddress, EmployeeAllowance, EmployeeCompetencyAndSkill, EmployeeContact (including LPS User defined fields), EmployeeCredential, EmployeeEmergencyContact, EmployeeOtherPayRate, WorkAssignment (including LPS User defined fields).
The only table that we currently have found is EMPLOYEETRANSACTIONHISTORY this table does not store all of the information that is viewable from the Employee History online view. Does anyone know what the other table names are that would store the history data from the above tables?
