These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- HRMS with Exit Management
- Data model
The tables behind HRMS with Exit Management
HRMS with Exit Management ships with 36 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 36
- Features
- 7, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Employee context
Employees links to Departments, Positions, Locations and payroll calendars.
Departure
Employment history keeps effective events; onboarding checklists contains onboarding tasks.
Final pay
Payroll runs contains pay statements, which contain pay statement lines.
Related decisions
Benefit enrollments, leave balances and leave requests support departure review.
Hiring context
Candidates, Applications, job requisitions and Offers preserve recruiting links.
Every table, by feature
- Employee records5
- Exit checklists3
- Assigned tasks3
- Employment history3
- Final pay6
- Benefits and leave5
- Recruiting and rehire6
- Shared and settings17
- Employees
Central person record for every worker; all suite transactions tie back to Employees.
Linked to Positions, Departments, Locations, Employees - Departments
Organizational departments with parent hierarchy and cost centers.
Linked to Departments, Employees - Positions
Seat-level org entries that an Employee fills.
Linked to Job titles, Departments, Locations, Pay grades - Employment history
Every lifecycle event: hire, promotion, transfer, comp change, manager change, leave of absence, termination.
Linked to Employees, Positions - Payroll calendars
Named pay schedules per legal entity, country and currency.
- Onboarding checklists
Per-hire or per-separation container of onboarding and offboarding tasks.
Linked to Employees - Onboarding tasks
Individual tasks that fan out to IT, Facilities, Payroll, HR, Manager and the new hire.
Linked to Onboarding checklists, Employees - Employees
Central person record for every worker; all suite transactions tie back to Employees.
Linked to Positions, Departments, Locations, Employees
- Onboarding tasks
Individual tasks that fan out to IT, Facilities, Payroll, HR, Manager and the new hire.
Linked to Onboarding checklists, Employees - Onboarding checklists
Per-hire or per-separation container of onboarding and offboarding tasks.
Linked to Employees - Employees
Central person record for every worker; all suite transactions tie back to Employees.
Linked to Positions, Departments, Locations, Employees
- Employment history
Every lifecycle event: hire, promotion, transfer, comp change, manager change, leave of absence, termination.
Linked to Employees, Positions - Employees
Central person record for every worker; all suite transactions tie back to Employees.
Linked to Positions, Departments, Locations, Employees - Positions
Seat-level org entries that an Employee fills.
Linked to Job titles, Departments, Locations, Pay grades
- Payroll runs
A scheduled execution of payroll for a calendar and period.
Linked to Payroll calendars, Employees - Pay statements
Per-employee pay statement for a given payroll run.
Linked to Payroll runs, Employees - Pay statement lines
Earnings, benefit deductions, taxes and garnishments on a pay statement.
Linked to Pay statements, Tax jurisdictions - Payroll calendars
Named pay schedules per legal entity, country and currency.
- Timesheets
Weekly timesheet header per employee.
Linked to Employees - Benefit enrollments
Per-employee enrollment in a benefit plan with dependents and dates.
Linked to Employees, Benefit plans
- Benefit enrollments
Per-employee enrollment in a benefit plan with dependents and dates.
Linked to Employees, Benefit plans - Benefit plans
Enrollable benefit plans such as medical, dental, retirement and life.
- Leave balances
Current leave balance per employee per leave type, maintained by accrual.
Linked to Employees, Leave types - Leave requests
Employee-submitted leave requests requiring manager approval.
Linked to Employees, Leave types - Employees
Central person record for every worker; all suite transactions tie back to Employees.
Linked to Positions, Departments, Locations, Employees
- Employees
Central person record for every worker; all suite transactions tie back to Employees.
Linked to Positions, Departments, Locations, Employees - Employment history
Every lifecycle event: hire, promotion, transfer, comp change, manager change, leave of absence, termination.
Linked to Employees, Positions - Candidates
Person pool in the applicant tracking system.
Linked to Employees - Applications
A candidate applying to a requisition; the recruiting pipeline record.
Linked to Candidates, Job requisitions, Employees - Job requisitions
Approved positions opened to recruiting.
Linked to Positions, Job titles, Departments, Locations - Offers
Offer letter, approval chain and e-signature state.
Linked to Applications, Candidates, Positions, Employees
Keys and references
Employees is the person anchor. Onboarding checklists.Employee identifies the departure subject; onboarding tasks.onboarding checklists identifies the parent work. Employment history.Employee links the dated event. Pay statements.Employee identifies the person and pay statements.Run identifies the payroll run. Benefit enrollments.Employee and leave balances.Employee connect the related review records.
Migration order
- Organization. Set up Departments, Locations, job titles, pay grades and payroll calendars.
- People. Import Employees with the correct manager, department and payroll calendar references.
- History. Bring across dated employment history events before treating current status as the complete story.
- Exit work. Import onboarding checklists and then linked onboarding tasks with their real owners and outcomes.
- Pay and entitlements. Link benefit enrollments, leave balances, payroll runs, pay statements and pay statement lines by their existing references.
Set up HRMS with Exit Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.