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 Employee Self-Service
- Data model
The tables behind HRMS with Employee Self-Service
HRMS with Employee Self-Service ships with 46 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
- 46
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Person and structure
The employee record links positions, departments, locations and managers to lifecycle history. Organization is recorded on service requests and service profiles; the employee has an entity value.
Self-service
Leave requests, leave balances, Timesheets, time entries and pay statements connect daily work to Employees.
Service review
Employee requests owns request documents, review decisions, evidence documents, follow up actions, external reconciliations and state history.
Pay and development
Payroll runs and benefit enrollments explain pay context; Goals, performance reviews, course enrollments and training records explain development.
Every table, by feature
- Employee records7
- Leave and time5
- Pay and benefits6
- Employee requests9
- Hiring and onboarding8
- Development7
- Shared and settings6
- Employees
The central person record. Every transaction in the suite ties back to Employees.
Linked to Positions, Departments, Locations, Employees - Departments
Organizational departments.
Linked to Departments, Employees - Positions
Seat-level org entries. A position is what an employee fills.
Linked to Job titles, Departments, Locations, Pay grades - Job titles
Canonical job titles.
Linked to Pay grades - Locations
Physical and remote locations where employees work.
Linked to Tax jurisdictions - Employment history
Every lifecycle event: hire, promotion, transfer, comp change, manager change, leave of absence, termination.
Linked to Employees, Positions - Organizations
Legal and business organizations that own employment relationships.
- Leave requests
Employee-submitted leave requests requiring manager approval.
Linked to Employees, Leave types - Leave balances
Current balance per employee per leave type, maintained by accrual.
Linked to Employees, Leave types - Leave types
Leave categories with country and class scoped accrual rules.
- Timesheets
Weekly timesheet header per employee.
Linked to Employees - Time entries
Hours against a day, project or cost center.
Linked to Timesheets
- Pay statements
Per-employee pay statement for a given run.
Linked to Payroll runs, Employees - Pay statement lines
Each earning, benefit deduction, tax and garnishment on a pay statement.
Linked to Pay statements, Tax jurisdictions - Payroll runs
A scheduled execution of payroll for a calendar and period.
Linked to Payroll calendars, Employees - Payroll calendars
Named pay schedules.
- Benefit enrollments
Per-employee enrollment in a benefit plan with coverage and contributions.
Linked to Employees, Benefit plans - Benefit plans
Enrollable benefit plans such as medical, dental, retirement and life.
- Employee requests
Employee self-service requests such as leave, expense and profile change.
Linked to Employees, Organizations, People, Employee profiles - Request documents
Observed or assigned detail items belonging to an employee request.
Linked to Employee requests - Review decisions
Independent review decisions recorded against an exact request revision.
Linked to Employee requests, People - Evidence documents
Supporting documents attached to a request and their verification state.
Linked to Employee requests, People - Follow up actions
Missing evidence and correction actions assigned to named people.
Linked to Employee requests, People - External reconciliations
External confirmation and reconciliation of request amounts.
Linked to Employee requests - State history
Status transition history for an employee request.
Linked to Employee requests, People - Employee profiles
Effective employee service profiles and their governing policy references.
Linked to Organizations - People
Named people used as owners, reviewers and assignees in HR service workflows.
Linked to Organizations
- Job requisitions
Approved positions opened to recruiting.
Linked to Positions, Job titles, Departments, Locations - Candidates
Person pool in the ATS.
Linked to Employees - Applications
A candidate applying to a requisition - the ATS pipeline record.
Linked to Candidates, Job requisitions, Employees - Interviews
Scheduled interviews against an application with scorecard capture.
Linked to Applications, Employees - Offers
Offer letter, approval chain and e-sign state.
Linked to Applications, Candidates, Positions, Employees - Onboarding checklists
The per-hire or per-separation container of tasks.
Linked to Employees - Onboarding tasks
Individual onboarding tasks that fan out to IT, Facilities, Payroll, Manager and the new hire.
Linked to Onboarding checklists, Employees, Payroll runs - Employees
The central person record. Every transaction in the suite ties back to Employees.
Linked to Positions, Departments, Locations, Employees
- Goals
Employee goals tied to a performance cycle.
Linked to Employees, Performance cycles - Performance cycles
Annual, mid-year and probation performance cycles.
- Performance reviews
Subject-by-reviewer review within a cycle.
Linked to Performance cycles, Employees - Courses
LMS catalog of learning content and certifications.
- Course enrollments
Employee enrollment in a course - the LMS transaction record.
Linked to Courses, Employees - Training records
The durable, audit-safe record of completed training and certifications.
Linked to Employees, Courses - Employees
The central person record. Every transaction in the suite ties back to Employees.
Linked to Positions, Departments, Locations, Employees
Keys and references
Keep the employee identifier stable across imported records. Preserve source request numbers, statement numbers, dates and status values. Review every reference to Employees and the related parent before migrating details. For request evidence, retain the source request and its revision so a reviewer can identify the exact decision being inspected.
Migration order
- Set structure. Load Organizations, Departments, Locations, job titles and Positions.
- Load people. Load Employees and confirm manager and position references.
- Set policy records. Load leave types, benefit plans, payroll calendars and employee profiles.
- Load activity. Bring in leave, time, pay, enrollment and request records with their original dates and statuses.
- Check detail. Reconcile lines, documents, decisions and history to each parent.
Set up HRMS with Employee Self-Service your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.