EMPLOYEES table and PERSONAL_DATA table

/*JOB and Person data snapshot reporting tables*/

PS_EMPLOYEES (HCM 8.8 / 9.1)

It stores all the current active jobs for all the employees.
Keys:
EMPLID
EMPL_RCD

This table is populated using an application engine process PER099.

Very useful table to avoid self-joining the JOB table to find out most effective dated/seq JOB record for employees.

Navigation in 9.1:
Set Up HRMS > System Administration > Database Processes > Refresh Employees Table



PERSONAL_DATA (HCM  9.1)
It stores all the current personal data information for all the employees.

Keys:
EMPLID


This table is populated using an application engine process PERS_REFRESH.


Navigation in 9.1:
Set Up HRMS > System Administration > Database Processes > Refresh Personal Data

This app engine in turn uses the following setup to refresh only the selective data based on
user inputs:
Set Up HRMS > System Administration > Database Processes > PERSONAL_DATA settings