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.
- Hospitality HRMS
- Data model
The tables behind Hospitality HRMS
Hospitality HRMS 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
- 7, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
People foundation
Employees link to positions, departments, locations, hiring, leave, time, pay and performance records.
Property operations
Property staff assignments links an employee, organization, property and owner to a service date. Service charge allocations hold line detail.
Review evidence
Review decisions, evidence documents, follow up actions and state history retain decisions, documents, actions and transitions.
Configuration
Organizations, hotel properties and People establish ownership and property context.
Every table, by feature
- Property staffing6
- Service charge review6
- Hiring and onboarding8
- Employee records7
- Time and leave6
- Payroll7
- Performance and learning7
- Shared and settings5
- Property staff assignments
Property staffing periods whose eligibility drives service charge allocation.
Linked to Employees, Organizations, People, Hotel properties - Hotel properties
Hotels, resorts and venues whose staff are rostered and charged.
Linked to Organizations - Organizations
Organizations that own hotel properties and workforce operations.
- Employees
The central person record every workforce transaction ties back to.
Linked to Positions, Departments, Locations, Employees - People
HR business partners, property owners and reviewers who operate the workforce records.
Linked to Organizations - State history
Every recorded status transition with actor and revision.
Linked to Property staff assignments, People
- Property staff assignments
Property staffing periods whose eligibility drives service charge allocation.
Linked to Employees, Organizations, People, Hotel properties - Service charge allocations
Line-level service charge allocations observed against a staffing period.
Linked to Property staff assignments - External reconciliations
External confirmation of service charge amounts against the source period.
Linked to Property staff assignments - Review decisions
Independent reviewer outcomes against an exact source revision.
Linked to Property staff assignments, People - Evidence documents
Supporting documents attached to a staffing period.
Linked to Property staff assignments, People - Follow up actions
Open exceptions and evidence gaps that must be resolved.
Linked to Property staff assignments, People
- Job requisitions
Approved openings that recruiting works against.
Linked to Positions, Job titles, Departments, Locations - Candidates
People applying for hospitality roles.
Linked to Employees - Applications
A candidate's application against a requisition.
Linked to Candidates, Job requisitions, Employees - Interviews
Interview events and scorecards.
Linked to Applications, Employees - Offers
Offers extended to candidates.
Linked to Applications, Candidates, Positions, Employees - Onboarding checklists
Per-hire or per-separation container of tasks.
Linked to Employees - Onboarding tasks
Individual onboarding tasks that fan out to IT, Payroll, HR and the manager.
Linked to Onboarding checklists, Employees - Positions
Seat-level org entries that employees fill.
Linked to Job titles, Departments, Locations, Pay grades
- Employees
The central person record every workforce transaction ties back to.
Linked to Positions, Departments, Locations, Employees - Employment history
Every lifecycle event: hire, promotion, transfer, comp change, termination.
Linked to Employees, Positions - Positions
Seat-level org entries that employees fill.
Linked to Job titles, Departments, Locations, Pay grades - Departments
Departments and outlets inside the operating organization.
Linked to Departments, Employees - Locations
Physical properties and work locations.
Linked to Tax jurisdictions - Pay grades
Salary bands tied to job titles and positions.
- Job titles
Canonical job titles used by positions and requisitions.
Linked to Pay grades
- Timesheets
Weekly timesheet header per employee.
Linked to Employees - Time entries
Hours against a day, outlet or cost center.
Linked to Timesheets - Leave requests
Employee-submitted leave requiring manager approval.
Linked to Employees, Leave types - Leave balances
Current balance per employee per leave type.
Linked to Employees, Leave types - Leave types
Leave categories with scoped accrual rules.
- Employees
The central person record every workforce transaction ties back to.
Linked to Positions, Departments, Locations, Employees
- Payroll calendars
Named pay schedules used by payroll runs.
- Payroll runs
A payroll cycle executed against a calendar.
Linked to Payroll calendars, Employees - Pay statements
Per-employee pay statement within a run.
Linked to Payroll runs, Employees - Pay statement lines
Earning, deduction and tax lines of a pay statement.
Linked to Pay statements, Tax jurisdictions - Tax filings
Statutory filings produced from payroll runs.
Linked to Tax jurisdictions, Payroll runs - Tax jurisdictions
Tax authorities driving withholding and filings.
- Employees
The central person record every workforce transaction ties back to.
Linked to Positions, Departments, Locations, Employees
- Performance cycles
Annual, mid-year and probation performance cycles.
- Goals
Individual goals tracked within a performance cycle.
Linked to Employees, Performance cycles - Performance reviews
Structured reviews within a performance cycle.
Linked to Performance cycles, Employees - Courses
Training courses available to the workforce.
- Course enrollments
Employee enrollment in a course.
Linked to Courses, Employees - Training records
Qualification and certification records with expiry.
Linked to Employees, Courses - Employees
The central person record every workforce transaction ties back to.
Linked to Positions, Departments, Locations, Employees
Keys and references
Use employee ID for employee identification and the assignment Number for property period discussion. The reference columns carry the actual links. A review decision stores source revision so the reviewer’s decision can be compared with the current assignment revision. The allocation line keeps source record id for source identity.
Migration order
- Load organizations, hotel properties, departments, locations, job titles and pay grades.
- Load employees and positions, then payroll calendars and leave types.
- Load assignments, hiring cases, time, leave and payroll cycles with their references.
- Load allocation detail, external reconciliations, evidence, review decisions and follow-ups after their source assignments.
- Compare imported identifiers, dates and amounts against a representative operating cycle.
Set up Hospitality HRMS your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.