EMPLOYEES table is a current employee information table. This is primarily used in interfacing with third party systems or in business rep...
EMPLOYEES table is a current employee information table. This is primarily used in interfacing with third party systems or in business reporting as well in conjunction with EMPLOYMENT which is now a view. EMPLOYEES table is populated by running a delivered process called Employee refres, the job name is PERS099. This process will populate EMPLOYEES table by first truncating the whole table and then re inserting the data. This table will only store information for active employees in the system and it will have only one row corresponding to each employee’s most recent personal and job details.