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 Internal Job Board
- Data model
The tables behind HRMS with Internal Job Board
HRMS with Internal Job Board 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 and structure
Employees refers to Positions, Departments, Locations, pay grades and a manager in Employees. Employment history preserves dated events.
Recruiting
Job requisitions points to the receiving position and hiring owners. Candidates can point to an employee referrer. Applications links a candidate to a requisition; Interviews and Offers extend the case.
Operating records
Leave requests, Timesheets, payroll runs, performance reviews and course enrollments carry the employee or period context needed for their work.
Every table, by feature
- People and positions7
- Internal recruiting7
- Interviews and offers7
- Onboarding and leave6
- Time and payroll9
- Performance and learning7
- Shared and settings4
- Employees
Central person record for every worker; all HRMS with Internal Job Board 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 - Positions
Seat-level org entries that an Employee fills.
Linked to Job titles, Departments, Locations, Pay grades - Departments
Organizational departments with parent hierarchy and cost centers.
Linked to Departments, Employees - Job titles
Canonical job titles with job family, level and exempt status.
Linked to Pay grades - Locations
Physical and remote locations where employees work.
Linked to Tax jurisdictions - Pay grades
Salary bands tied to job titles and positions.
- 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 - Departments
Organizational departments with parent hierarchy and cost centers.
Linked to Departments, Employees - 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 - Employees
Central person record for every worker; all HRMS with Internal Job Board transactions tie back to Employees.
Linked to Positions, Departments, Locations, 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 - Candidates
Person pool in the applicant tracking system.
Linked to Employees - 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 - Pay grades
Salary bands tied to job titles and 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 HRMS with Internal Job Board transactions tie back to Employees.
Linked to Positions, Departments, Locations, Employees - Leave requests
Employee-submitted leave requests requiring manager approval.
Linked to Employees, Leave types - Leave balances
Current leave 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 - 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 filings
Payroll tax filings produced from a run and remitted to an authority.
Linked to Tax jurisdictions, Payroll runs - Tax jurisdictions
Tax-authority records driving withholding and filings.
- Exchange rates
Read-only effective exchange rates for this app.
- 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 - 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 HRMS with Internal Job Board transactions tie back to Employees.
Linked to Positions, Departments, Locations, Employees
Keys and references
Use the record identifiers and numbered business keys consistently during migration. Keep references to the existing employee, candidate, position and requisition records rather than duplicating people or seats. Confirm date and currency context for payroll, leave and offers. A saved list is a view on its source table; it does not create another copy of the underlying record.
Migration order
- Organization. Load departments, locations, pay grades, job titles and positions.
- People. Load employees and dated employment history, then validate managers and position references.
- Policy. Load leave types, benefit plans, pay calendars, courses and review cycles.
- Activity. Load requisitions, candidates, applications, interviews and offers with their references intact.
- Operating records. Load leave, time, payroll, performance, onboarding and training records after their parent records exist.
- Reconcile. Review counts, reference links, dates and status values with the responsible team.
Set up HRMS with Internal Job Board your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.