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.
- Multi-country HRMS
- Data model
The tables behind Multi-country HRMS
Multi-country HRMS 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
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
People & organization
Employees connect Positions, Departments, Locations, pay grades and payroll calendars; employment history preserves dated changes.
Hiring & offers
Job requisitions open position demand; Applications connect Candidates to requisitions; Interviews and Offers carry the decisions.
Leave & time
Leave requests link Employees and leave types; leave balances carry dated amounts; Timesheets group time entries.
Payroll & tax
Payroll runs belong to payroll calendars, pay statements belong to runs, and pay statement lines describe amounts. Tax filings link runs and tax jurisdictions.
Benefits & learning
Benefit enrollments link benefit plans and Employees. Course enrollments and training records link Employees and Courses.
Performance & transitions
Performance reviews and Goals link people to performance cycles; onboarding tasks belong to onboarding checklists.
Every table, by feature
- People & organization9
- Hiring & offers9
- Leave & time7
- Payroll & tax8
- Benefits & learning7
- Performance & transitions8
- Shared and settings2
- 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 - Departments
Organizational departments with parent hierarchy and cost centers.
Linked to Departments, Employees - Locations
Physical and remote locations where employees work.
Linked to Tax jurisdictions - Positions
Seat-level org entries that an Employee fills.
Linked to Job titles, Departments, Locations, Pay grades - Job titles
Canonical job titles with job family, level and exempt status.
Linked to Pay grades - Pay grades
Salary bands tied to job titles and positions.
- Payroll calendars
Named pay schedules per legal entity, country and currency.
- Tax jurisdictions
Tax-authority records driving withholding and filings.
- Job requisitions
Approved positions opened to recruiting.
Linked to Positions, Job titles, Departments, Locations - Positions
Seat-level org entries that an Employee fills.
Linked to Job titles, Departments, Locations, Pay grades - Job titles
Canonical job titles with job family, level and exempt status.
Linked to Pay grades - Pay grades
Salary bands tied to job titles and 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 - Interviews
Scheduled interviews against an application with scorecards.
Linked to Applications, Employees - Offers
Offer letter, approval chain and e-signature state.
Linked to Applications, Candidates, Positions, Employees - Employees
Central person record for every worker; all suite transactions tie back to Employees.
Linked to Positions, Departments, Locations, Employees
- Leave types
Leave categories with country- and class-scoped accrual rules.
- 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 - Timesheets
Weekly timesheet header per employee.
Linked to Employees - Time entries
Hours against a day, project or cost center.
Linked to Timesheets - Employees
Central person record for every worker; all suite transactions tie back to Employees.
Linked to Positions, Departments, Locations, Employees - Payroll runs
A scheduled execution of payroll for a calendar and period.
Linked to Payroll calendars, Employees
- Payroll calendars
Named pay schedules per legal entity, country and currency.
- 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 - Tax jurisdictions
Tax-authority records driving withholding and filings.
- Tax filings
Payroll tax filings produced from a run and remitted to an authority.
Linked to Tax jurisdictions, Payroll runs - Exchange rates
Read-only effective exchange rates for this app.
- Employees
Central person record for every worker; all suite transactions tie back to Employees.
Linked to Positions, Departments, Locations, Employees
- Benefit plans
Enrollable benefit plans such as medical, dental, retirement and life.
- Benefit enrollments
Per-employee enrollment in a benefit plan with dependents and dates.
Linked to Employees, Benefit plans - Courses
Learning catalog of courses and certifications.
- Course enrollments
Employee enrollment in a course; the learning transaction record.
Linked to Courses, Employees - Training records
Durable, audit-safe record of completed training and certifications.
Linked to Employees, Courses - Employees
Central person record for every worker; all suite transactions tie back to Employees.
Linked to Positions, Departments, Locations, Employees - Pay statements
Per-employee pay statement for a given payroll run.
Linked to Payroll runs, Employees
- Performance cycles
Annual, mid-year and probation performance cycles.
- Goals
Employee goals tied to a performance cycle.
Linked to Employees, Performance cycles - Performance reviews
Subject-by-reviewer review within a performance cycle.
Linked to Performance cycles, Employees - Employment history
Every lifecycle event: hire, promotion, transfer, comp change, manager change, leave of absence, termination.
Linked to Employees, Positions - 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 - Positions
Seat-level org entries that an Employee fills.
Linked to Job titles, Departments, Locations, Pay grades
Keys and references
Keep the employee identifier stable through hiring, time, pay and reviews. Requisition, offer, run and statement numbers support operational lookup; their references determine which records belong together. Country, entity, currency and effective dates should be checked on each record where they appear. Exchange rates carry a separate effective date for comparison across currencies.
Migration order
- Organization. Load Departments, Locations, job titles, pay grades, Positions and tax jurisdictions.
- Schedules and rules. Load payroll calendars, leave types, benefit plans, Courses and performance cycles.
- People. Load Employees with valid position, department, location, manager and calendar references; then reconcile employment history.
- Transactions. Load open requisitions, applications, offers, leave balances and requests, benefits, time, reviews and learning records.
- Pay evidence. Reconcile payroll runs, pay statements, pay statement lines and tax filings by period and jurisdiction before using them for a new cycle.
Set up Multi-country HRMS your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.