Categories
- All Categories
- Oracle Analytics Learning Hub
- 29 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 237 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
HR Analytics: Person Number vs Employee Number
Judith Ullman
Rank 3 - Community Apprentice
It seems that Person Number in W_HR_PERSON_D should be one number for each person who is in the system for any reason, and Employee Number in W_EMPLOYEE_D would be one number per person designated as an employee. However, each employee should have an Assignment Number (at least for us PeopleSoft users). When I list Person Number, Employee Number, and Assignment Number, I get people who have Person Number and Assignment Number but not an Employee Number ("Unspecified").
It is ambiguous enough that I cannot tell if our data are messed up, or I don't have the correct definition of these columns. Can anyone help?
0