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.
- Pharmaceuticals HRMS
- Data model
The tables behind Pharmaceuticals HRMS
Pharmaceuticals HRMS ships with 45 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
- 45
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Workforce records
Employees link to position, department, location, manager and payroll calendar; employment history preserves dated changes.
Recruiting and onboarding
Requisitions link to positions, applications to requisitions and candidates, and start tasks to an employee checklist.
Leave and time
Leave requests and balances link to employees and leave types; daily time entries sit under weekly timesheets.
Payroll and tax
Runs link to calendars, statements to runs and employees, statement lines to statements, and filings to jurisdictions.
Performance and learning
Goals and reviews link to employees and cycles; enrollments and training records link employees to courses.
GMP qualification
Assignments link employees, organizations, people owners and controlled modules; evidence, decisions, history and actions link back to the assignment.
Every table, by feature
- Workforce records8
- Recruiting and onboarding9
- Leave and time6
- Payroll and tax8
- Performance and learning7
- GMP qualification10
- Shared and settings5
- 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, manager change, leave of absence, termination.
Linked to Employees, Positions - Departments
Organizational departments with cost centers and accountable heads.
Linked to Departments, Employees - Positions
Seat-level org entries that employees fill.
Linked to Job titles, Departments, Locations, Pay grades - Job titles
Canonical job titles in the pharmaceutical workforce.
- Locations
Physical and remote locations where employees work.
Linked to Tax jurisdictions - Pay grades
Salary bands tied to job titles and positions.
- Payroll calendars
Named pay schedules driving payroll runs.
- Job requisitions
Approved positions opened to recruiting.
Linked to Positions, Job titles, Departments, Locations - Applications
A candidate applying to a requisition: the recruitment pipeline record.
Linked to Candidates, Job requisitions, Employees - Candidates
Person pool in the applicant tracking system.
Linked to Employees - Interviews
Scheduled interviews against an application with scorecard capture.
Linked to Applications, Employees - Offers
Offer letter, approval chain and signature state.
Linked to Applications, Candidates, Positions, Employees - Onboarding checklists
Per-hire or per-separation container of onboarding tasks.
Linked to Employees - Onboarding tasks
Individual onboarding tasks fanned out to IT, Facilities, Payroll, Manager and the new hire.
Linked to Onboarding checklists, Employees - Employees
The central person record every workforce transaction ties back to.
Linked to Positions, Departments, Locations, Employees - Positions
Seat-level org entries that employees fill.
Linked to Job titles, Departments, Locations, Pay grades
- Leave types
Leave categories with country- and class-scoped accrual rules.
- Leave balances
Current 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
The central person record every workforce transaction ties back to.
Linked to Positions, Departments, Locations, Employees
- Payroll calendars
Named pay schedules driving payroll runs.
- 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
Each earning, benefit deduction, tax and garnishment 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.
- Timesheets
Weekly timesheet header per employee.
Linked to Employees - 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.
- Performance reviews
Subject-by-reviewer review within a cycle.
Linked to Performance cycles, Employees - Goals
Employee goals tied to a performance cycle.
Linked to Employees, Performance cycles - Courses
Learning catalog of GxP courses and certifications.
- Course enrollments
Employee enrollment in a course: the learning 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 workforce transaction ties back to.
Linked to Positions, Departments, Locations, Employees
- Controlled training modules
Versioned controlled GMP training modules and their policy references.
Linked to Organizations - Pharma staff assignments
Assignment of an eligible employee to a controlled GMP training module, tracked through qualification.
Linked to Employees, Organizations, People, Controlled training modules - GMP training records
Observation-level GMP training line evidence for a staff assignment.
Linked to Pharma staff assignments - Evidence documents
Source evidence documents supporting a staff assignment.
Linked to Pharma staff assignments, People - Review decisions
Independent review decision recorded against an exact staff assignment revision.
Linked to Pharma staff assignments, People - State history
Status transition history for a staff assignment.
Linked to Pharma staff assignments, People - Follow up actions
Remediation or missing-evidence actions raised from training review.
Linked to Pharma staff assignments, People - People
Internal owners, reviewers and actors named on GxP training work.
Linked to Organizations - Organizations
Legal and operational organizations in the GxP workforce scope.
- Employees
The central person record every workforce transaction ties back to.
Linked to Positions, Departments, Locations, Employees
Keys and references
Use the employee identifier to reconcile people before importing their transactions. A requisition number, run number and assignment number identify separate work items. Preserve the reference to the source record when migrating an application, pay statement, training line or review decision. The controlled assignment revision is important because the reviewer decision names the version that was inspected.
Migration order
- Establish organizations, people owners, departments, locations, job titles, positions and payroll calendars.
- Import employees and dated employment history.
- Add requisitions, candidates, applications, offers and onboarding work.
- Add leave, time, pay and tax records for a representative period.
- Add cycles, courses and employee learning records.
- Add controlled modules, staff assignments, evidence, decisions and follow-up actions.
Set up Pharmaceuticals HRMS your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.