The tables behind Hospital + HRMS + Accounting

Central employee record that all workforce transactions reference.

Durable lifecycle events: hire, promotion, transfer, comp change, separation.

Organizational departments with cost center and department head.

Seat-level organization entries filled by employees.

Canonical job titles with family, level and pay grade.

Salary bands tied to job titles and positions.

Physical, remote and hybrid work locations with tax jurisdiction.

Learning catalog including mandatory compliance and clinical training.

Employee enrollment in a learning course.

Durable record of completed training and certifications.

Annual, mid-year and probation performance review cycles.

Subject-by-reviewer review within a performance cycle.

Employee goals tied to a performance cycle.

Approved positions opened to recruiting.

Seat-level organization entries filled by employees.

Candidate pool for open requisitions.

Candidate applications progressing through the hiring pipeline.

Scheduled interviews with scorecard rating and recommendation.

Offer letters with approval chain and signature state.

Central employee record that all workforce transactions reference.

Per-hire onboarding, transfer and offboarding task containers.

IT, HR, manager, compliance and training tasks inside a checklist.

Weekly timesheet header per employee.

Hours recorded against a day and cost center.

Employee leave requests requiring manager approval.

Accrued, taken and pending leave balance per employee and leave type.

Leave categories with accrual rules and documentation requirements.

Central employee record that all workforce transactions reference.

Scheduled payroll execution for a calendar and period.

Named pay schedules with frequency, cut-off and currency.

Scheduled payroll execution for a calendar and period.

Per-employee pay statement for a payroll run period.

Earning, deduction and tax lines on a pay statement.

Tax authority records driving withholding and filings.

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

Central employee record that all workforce transactions reference.

Weekly timesheet header per employee.

Staff service episodes recorded against an employee, department definition and owner.

Effective dated clinical and support department definitions used to classify service work.

Legal entities operating the hospital workforce and finance processes.

Central employee record that all workforce transactions reference.

Named operational actors who own, review and evidence hospital service work.

Observed or assigned charge items belonging to a hospital service episode.

Append-only episode status transitions with actor and operation key.

Supporting documents verified against a service episode.

Independent review outcomes recorded against an exact episode revision.

Assigned remediation and evidence follow-up for service episodes.

Observed or assigned charge items belonging to a hospital service episode.

Staff service episodes recorded against an employee, department definition and owner.

Supporting documents verified against a service episode.

Independent review outcomes recorded against an exact episode revision.

Assigned remediation and evidence follow-up for service episodes.

Append-only episode status transitions with actor and operation key.

External payroll and finance reconciliation of service episode values.

Named operational actors who own, review and evidence hospital service work.

Per-employee benefit plan enrollment with coverage tier and contributions.

Enrollable medical, dental, vision, retirement and life plans.

Individual engagement survey responses by department.

Engagement survey windows with minimum reporting group size.

Users