Dimension table is populating employees together with new applicants
988724Feb 2 2013 — edited Feb 2 2013Issue: w_employee_d dimension table is populating names of applicants & employees instead of full time employees only- when queried against. This is affecting reports’ results in the workforce profile subject area. Desired solution is to figure out the reason for this and to clean up this data.
Example: Samuel Deleon is the Director of IT and instead of his name appearing under the job description, Carol Myrick (who applied for a job a while ago) – her name appears instead. We need this correctly represented.