Update Table: UserEmploymentHistory

[Neecolaa]

Overview

We need to update the UserEmploymentHistory table model to change a field to a foreign key

Details

• The initial model issue: Create Table: user_employment_history #81
• Discussion leading to this change is here: PD: 2026 PM/DB Lead #593 (comment)

Action Items

• Update existing Django model

• In the files indicated by Resource 1.01, Change the following items in the code

Current Name in code	Updated Name	Updated Type (may already be this type)	FK Table	FK Table Issue(s)
title	modern_job_title	int (UUID)	ModernJobTitle	#62

• Write a test for the new relationships this model will have with other models (e.g., creating a user and assigning them a set of permissions on a project) if any.

• Update API end point

• Update API unit tests

• generate a schema table description (see resources 1.04), post it in a comment below, and add a link to it in the Update Schema dependency issue

• Document the endpoint in ReDocs (see resources 1.05)

FK status

• Create Table: modern_job_title #62

After PR has been approved

Resources

• 1.01 Code locations
  • 1.01.01 /app/core/models.py
  • 1.01.02 /app/core/admin.py
  • 1.01.03 /app/core/api/serializers.py
  • 1.01.04 /app/core/api/views.py
• 1.02 People Depot Resources wiki page for links
  • ERD
  • Table and Field Definitions
  • API Endpoint
• 1.03 Spreadsheet: PD: Table and field explanations, Current Field Permissions tab
• 1.04 Instructions for how to generate a schema table description
• 1.05 Instructions for how to Document End point step 3