Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI 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