How to Identify Employees with Missing Profile ID Using SQL Query

1) Look to see if and when we migrated this employee’s profile to Fusion via this SQL.  It is the FT_PROF_MIGR_DATE field.  CEHHR088 picked him up on Sept 30th.

select * from ps_ceh_ft_emplid where emplid = '00507532'

2) Find the Talent Zip file created on this date (Sept. 30) and look in the F_PROFILE_VO.DAT file to see if he is on there.  He is:

--E00553118|Mike Santay|||FE30F6FBA849FA4DE04376A01790770E|00553118|A|P|3D37D655386D7940E053D13ED30AE4A8||3D37D655386D7940E053D13ED30AE4A8

3) Log into Fusion and pull the Profile load up for this day.  Look at errors.  Oops, no load found for this date.  Next Profile load I see is Oct 7, and that was the file generated Oct 7.

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.