情境
A PeopleSoft HCM analyst needs to document the PS_JOB compensation and payroll data model to support HR reporting and integrations.
這張圖裡有什麼
看懂背後的決策。
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.