The scenario
A PeopleSoft HCM analyst needs to document the PS_JOB compensation and payroll data model to support HR reporting and integrations.
What is in this drawing
Read the decisions behind it.
01
Central PS_JOB entity with effective-dated composite key (EMPLID, EMPL_RCD, EFFDT, EFFSEQ)
02
Included PS_PERSONAL_DATA and PS_EMPLOYMENT parent tables for employee hierarchy
03
Linked PS_JOB to core reference tables (DEPT, JOBCODE, LOCATION, COMPANY, PAYGROUP, SALARY_PLAN, POSITION) via crowsfoot relationships
When documenting or extending PeopleSoft HCM job, compensation, or payroll reporting data models.
More like this