Contractors HRMS

Features

Industries

Reference

More

Start now
  1. Contractors HRMS
  2. Data model
Reference

The tables behind Contractors HRMS

Contractors 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

Assignment core

Contractor engagements ties Organizations, Employees, People and contractor profiles to a dated scope and agreed rate.

Compliance and evidence

Contractor compliance items and evidence documents point to the source assignment.

Review and remediation

Review decisions, state history and follow up actions retain decisions, transitions and assigned work.

Worker context

Employees link to Timesheets, which contain time entries.

Every table, by feature

Engagement workspace

4 tablesAbout this feature
  • Contractor engagements

    The contractor assignment record: rate, scope, compliance state and lifecycle

    Linked to Organizations, Employees, People, Contractor profiles
  • Organizations

    Legal entities and vendor organizations in the contractor workforce

  • Employees

    The central worker record every HR transaction ties back to

    Linked to Positions, Departments, Locations, Employees
  • People

    Internal staff who own and review contractor engagements

    Linked to Organizations

Profiles and rate terms

3 tablesAbout this feature
  • Contractor profiles

    Rate cards and policy definitions applied to contractor engagements

    Linked to Organizations
  • Organizations

    Legal entities and vendor organizations in the contractor workforce

  • Contractor engagements

    The contractor assignment record: rate, scope, compliance state and lifecycle

    Linked to Organizations, Employees, People, Contractor profiles

Compliance review

3 tablesAbout this feature
  • Contractor compliance items

    Line-level compliance observations against a contractor engagement

    Linked to Contractor engagements
  • Evidence documents

    Supporting documents held against a contractor engagement

    Linked to Contractor engagements, People
  • Contractor engagements

    The contractor assignment record: rate, scope, compliance state and lifecycle

    Linked to Organizations, Employees, People, Contractor profiles

Independent decisions

3 tablesAbout this feature
  • Review decisions

    Independent review verdicts recorded against an engagement revision

    Linked to Contractor engagements, People
  • Contractor engagements

    The contractor assignment record: rate, scope, compliance state and lifecycle

    Linked to Organizations, Employees, People, Contractor profiles
  • State history

    Append-only status transition log for contractor engagements

    Linked to Contractor engagements, People

Follow-up actions

3 tablesAbout this feature
  • Follow up actions

    Remediation work assigned when evidence or compliance is missing

    Linked to Contractor engagements, People
  • Contractor engagements

    The contractor assignment record: rate, scope, compliance state and lifecycle

    Linked to Organizations, Employees, People, Contractor profiles
  • People

    Internal staff who own and review contractor engagements

    Linked to Organizations

Worker time and records

4 tablesAbout this feature
  • Employees

    The central worker record every HR transaction ties back to

    Linked to Positions, Departments, Locations, Employees
  • Timesheets

    Weekly timesheet header per employee

    Linked to Employees
  • Time entries

    Hours recorded against a day, project or cost center

    Linked to Timesheets
  • Contractor engagements

    The contractor assignment record: rate, scope, compliance state and lifecycle

    Linked to Organizations, Employees, People, Contractor profiles

Shared and settings

33 tables
  • Applications

    A candidate applying to a requisition; the ATS pipeline record

    Linked to Candidates, Job requisitions, Employees
  • Benefit enrollments

    Per-employee enrollment in a benefit plan with dependents and dates

    Linked to Employees, Benefit plans
  • Benefit plans

    Enrollable benefit plans: medical, dental, retirement, life

  • Candidates

    Candidate pool in the applicant tracking system

    Linked to Employees
  • Course enrollments

    Employee enrollment in a course; the learning transaction record

    Linked to Courses, Employees
  • Courses

    Learning catalog of courses and certifications

  • Departments

    Organizational departments used for grouping and reporting

    Linked to Departments, Employees
  • Employment history

    Lifecycle events: hire, promotion, transfer, comp change, termination

    Linked to Employees, Positions
  • Engagement responses

    Individual survey responses with consent basis and free comment

    Linked to Engagement surveys, Departments
  • Engagement surveys

    Employee engagement survey campaigns

  • Goals

    Employee goals tied to a performance cycle

    Linked to Employees, Performance cycles
  • Interviews

    Scheduled interviews against an application with scorecard capture

    Linked to Applications, Employees
  • Job requisitions

    Approved positions opened to recruiting

    Linked to Positions, Job titles, Departments, Locations
  • Job titles

    Canonical job titles with family, level and exemption status

    Linked to Pay grades
  • Leave balances

    Current balance per employee per leave type, maintained by accrual

    Linked to Employees, Leave types
  • Leave requests

    Employee leave requests requiring manager approval

    Linked to Employees, Leave types
  • Leave types

    Leave categories with accrual rules and caps

  • Locations

    Physical, field and remote work locations

    Linked to Tax jurisdictions
  • Offers

    Offer letter, approval chain and e-sign state

    Linked to Applications, Candidates, Positions, Employees
  • Onboarding checklists

    Per-hire or per-separation container of onboarding tasks

    Linked to Employees
  • Onboarding tasks

    Individual tasks fanned out to IT, Facilities, Payroll, Manager and HR

    Linked to Onboarding checklists, Employees
  • Pay grades

    Salary bands tied to job titles and positions

  • Pay statement lines

    Each earning, deduction, tax and employer cost on a pay statement

    Linked to Pay statements, Tax jurisdictions
  • Pay statements

    Per-employee pay statement for a given payroll run

    Linked to Payroll runs, Employees
  • Payroll calendars

    Named pay schedules driving payroll runs and cutoffs

  • Payroll runs

    A scheduled execution of payroll for a calendar and period

    Linked to Payroll calendars, Employees
  • Performance cycles

    Annual, mid-year and probation review cycles

  • Performance reviews

    Subject-by-reviewer review within a performance cycle

    Linked to Performance cycles, Employees
  • Positions

    Seat-level org entries that employees fill

    Linked to Job titles, Departments, Locations, Pay grades
  • Tax filings

    Payroll tax filings produced from a run and remitted to an authority

    Linked to Tax jurisdictions, Payroll runs
  • Tax jurisdictions

    Tax authorities driving withholding and filings

  • Training records

    Durable audit-safe record of completed training and certifications

    Linked to Employees, Courses
  • Users

    Users

    Linked to Users

Keys and references

Contractor engagements is the source for compliance items, evidence documents, decisions, history and actions. Its Organization, Employee, Owner and Definition references identify who and what the engagement concerns. Review decisions carries source revision so a verdict can be read against the version considered. Timesheets belongs to Employees; time entries belongs to a weekly sheet.

Migration order

  1. Load Organizations, People and contractor profiles.
  2. Load Employees and their organizational references.
  3. Load contractor engagements with worker, organization, owner and profile references.
  4. Load contractor compliance items and evidence documents against each engagement.
  5. Load review decisions, state history and follow up actions with their source references.
  6. Load Timesheets and time entries for the relevant employees.

Set up Contractors HRMS your way.

Start free, then use Proto to change fields, steps and approvals before your team goes live.

Start now Download Proto

How to get started