The tables behind HRMS with Workforce Analytics

Periodic dated workforce observation for one organization unit: the analytics grain.

Observed or assigned workforce measurement lines belonging to a workforce snapshot.

The central person record. Every transaction in the suite ties back to Employees.

Every lifecycle event: hire, promotion, transfer, comp change, manager change, leave-of-absence, termination.

Effective-dated organizational definitions used as the reporting grain for workforce snapshots.

Legal entities and operating organizations in the workforce analytics scope.

Observed or assigned workforce measurement lines belonging to a workforce snapshot.

Periodic dated workforce observation for one organization unit: the analytics grain.

The central person record. Every transaction in the suite ties back to Employees.

Every lifecycle event: hire, promotion, transfer, comp change, manager change, leave-of-absence, termination.

Comparison of expected workforce/HR cost against externally confirmed values.

Approved positions opened to recruiting.

Independent reviewer decision recorded against an exact workforce snapshot revision.

Supporting document retained for a workforce snapshot.

Comparison of expected workforce/HR cost against externally confirmed values.

Remediation task raised from a review finding or missing evidence.

Append-only audit trail of workforce snapshot status transitions.

Periodic dated workforce observation for one organization unit: the analytics grain.

Named HR and business users (owners, reviewers, approvers) referenced by workforce records.

The central person record. Every transaction in the suite ties back to Employees.

Every lifecycle event: hire, promotion, transfer, comp change, manager change, leave-of-absence, termination.

Seat-level org entries. A Position is what an Employee fills.

Organizational departments (Engineering, Sales, People, Finance, etc.).

Physical and remote locations where employees work.

Canonical job titles (Software Engineer II, Senior Recruiter).

Effective-dated organizational definitions used as the reporting grain for workforce snapshots.

Periodic dated workforce observation for one organization unit: the analytics grain.

Seat-level org entries. A Position is what an Employee fills.

Approved positions opened to recruiting.

Person pool in the ATS - may apply to multiple requisitions.

A candidate applying to a requisition - the ATS pipeline record.

Scheduled interviews against an application with scorecard capture.

Offer letter, approval chain, and e-sign state.

The central person record. Every transaction in the suite ties back to Employees.

Every lifecycle event: hire, promotion, transfer, comp change, manager change, leave-of-absence, termination.

Employee-submitted leave requests requiring manager approval.

Current balance per employee per leave type, maintained by accrual.

Leave categories with embedded country- and class-scoped accrual rules.

Weekly timesheet header per employee.

Hours against a day, project, or cost center.

Employee goals tied to a performance cycle.

Annual / mid-year / probation performance cycles.

Subject-by-reviewer review within a performance cycle.

LMS catalog of learning content and certifications.

Employee enrollment in a course - the LMS transaction record.

The durable, audit-safe record of completed training and certifications.

A scheduled execution of payroll for a calendar and period.

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

Enrollable benefit plans (medical, dental, 401k, PF, pension, life).

Individual survey response. Reported only in groups at or above the survey minimum group size.

Consent-aware engagement surveys with a minimum reporting group size.

Read-only effective exchange rates for this app.

The per-hire (or per-separation) container of onboarding tasks.

Individual tasks that fan out to IT, Facilities, Payroll, Manager, and the new hire.

Salary bands tied to Job Titles and Positions.

Each earning, benefit deduction, tax, and garnishment on a pay statement.

Per-employee pay statement for a given run.

Named pay schedules (Bi-weekly US, Monthly IN, Semi-monthly SG).

Payroll tax filings produced from a run, remitted to an authority.

Tax-authority records driving withholding and filings.

Users