Lo scenario
A PeopleSoft HCM analyst needs to document the PS_JOB compensation and payroll data model to support HR reporting and integrations.
Cosa contiene questo disegno
Leggi le decisioni che ne stanno alla base.
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.