シナリオ
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.