情境
A recruiting implementation needs to model how PeopleSoft HCM PS_JOB tables connect during hiring and assignment, from personal data through employment records to organizational job attributes.
這張圖裡有什麼
看懂背後的決策。
01
Used native erd with crowsfoot cardinality and FK columns to mirror PeopleSoft composite keys.
02
Added lookup tables for company, department, jobcode, location, and position to anchor PS_JOB assignment fields.
03
Included PS_EMPLOYMENT as the parent of PS_JOB based on shared emplid and empl_rcd keys.
Reuse this structure when documenting PeopleSoft HCM job data lineage for recruitment, onboarding, or HR data migration mapping.