Le scénario
A PeopleSoft HCM analyst needs to document the PS_JOB compensation and payroll data model to support HR reporting and integrations.
Ce que contient ce dessin
Comprenez les décisions qui le sous-tendent.
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.