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.
- Talent Suite
- Data model
The tables behind Talent Suite
Talent Suite ships with 37 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
- 37
- Features
- 7, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
People
Employees connect Positions, Departments, Locations and dated employment history.
Recruiting
Job requisitions connect Applications, Candidates, Interviews and Offers.
Operating time
Leave requests connect leave types and leave balances; Timesheets carry time entries.
Pay and benefits
Payroll runs connect pay statements and their pay statement lines; benefit enrollments connect employees and plans.
Development
Performance cycles connect Goals and performance reviews; Courses connect enrollments and training records.
Engagement
Engagement surveys connect consented engagement responses by department.
Every table, by feature
- People records7
- Recruiting6
- Onboarding4
- Time and leave6
- Payroll and benefits8
- Performance4
- Learning and engagement5
- Shared and settings2
- Employees
Central person record for every worker in the organization.
Linked to Positions, Departments, Locations, Employees - Positions
Seat-level org entries that an Employee fills.
Linked to Job titles, Departments, Locations, Pay grades - Job titles
Canonical job titles.
Linked to Pay grades - Departments
Organizational departments.
Linked to Departments, Employees - Locations
Physical and remote work locations.
Linked to Tax jurisdictions - Employment history
Every employee lifecycle event.
Linked to Employees, Positions - Pay grades
Salary bands tied to Job Titles and Positions.
- Job requisitions
Approved positions opened to recruiting.
Linked to Positions, Job titles, Departments, Locations - Applications
A candidate applying to a requisition.
Linked to Candidates, Job requisitions, Employees - Candidates
Person pool in the applicant tracking system.
Linked to Employees - Interviews
Scheduled interviews with scorecard capture.
Linked to Applications, Employees - Offers
Offer letter, approval chain and e-sign state.
Linked to Applications, Candidates, Positions, Employees - Positions
Seat-level org entries that an Employee fills.
Linked to Job titles, Departments, Locations, Pay grades
- Onboarding checklists
Per-hire or per-separation container of tasks.
Linked to Employees - Onboarding tasks
Individual onboarding tasks by function.
Linked to Employees, Onboarding checklists, Payroll runs - Employees
Central person record for every worker in the organization.
Linked to Positions, Departments, Locations, Employees - Employment history
Every employee lifecycle event.
Linked to Employees, Positions
- Leave types
Leave categories with country- and class-scoped accrual rules.
- Leave balances
Current balance per employee per leave type.
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 in the organization.
Linked to Positions, Departments, Locations, Employees
- Payroll calendars
Named pay schedules.
- 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 run.
Linked to Payroll runs, Employees - Pay statement lines
Earnings, deductions, taxes and garnishments on a pay statement.
Linked to Tax jurisdictions, Pay statements - Benefit plans
Enrollable benefit plans.
- Benefit enrollments
Per-employee enrollment in a benefit plan.
Linked to Employees, Benefit plans - Tax filings
Payroll tax filings produced from a run.
Linked to Tax jurisdictions, Payroll runs - Tax jurisdictions
Tax authority records driving withholding and filings.
- 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 cycle.
Linked to Performance cycles, Employees - Employees
Central person record for every worker in the organization.
Linked to Positions, Departments, Locations, Employees
- Courses
Learning catalog of content and certifications.
- Course enrollments
Employee enrollment in a course.
Linked to Courses, Employees - Training records
Durable audit-safe record of completed training and certifications.
Linked to Employees, Courses - Engagement surveys
Employee engagement survey campaigns.
- Engagement responses
Consented engagement survey responses.
Linked to Engagement surveys, Departments
Keys and references
Keep the employee identity stable across lifecycle events. Follow the reference from an offer to its application and position, and from a statement to its run and employee. Use effective dates for history and plan eligibility. A saved list is a view over its source table; it does not create another business record.
Migration order
- Foundation. Load Departments, Locations, job titles, pay grades, Positions and payroll calendars.
- People. Load Employees with references, then employment history.
- Operating records. Load recruiting, leave, time, benefit and payroll records after their parent records.
- Development. Load cycles, goals, reviews, courses and training records with employee links.
- Check links. Reconcile a real hire, leave period and pay run before expanding the import.
Set up Talent Suite your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.