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.
- Healthcare Staff HRMS
- Data model
The tables behind Healthcare Staff HRMS
Healthcare Staff 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
Credential policy
Organizations and credential requirements define the organization-specific item to review.
Credential operations
Staff credential packets link the employee, organization, owner and requirement.
Evidence and review
CME activities, evidence documents, review decisions, follow up actions and state history retain the material, decision and subsequent work.
People foundation
Employees connect to Positions, Departments, Locations, learning, leave, time, payroll and performance records.
Every table, by feature
- Credential requirements4
- Staff credential packets5
- CME and evidence4
- Review and follow-up6
- Workforce records7
- Learning and leave8
- Shared and settings24
- Organizations
Healthcare organizations and facilities in scope.
- Credential requirements
License and credential definitions with policy reference and effective window.
Linked to Organizations - Staff credential packets
Credential packet for an eligible employee, carried through review to current status.
Linked to Employees, Organizations, People, Credential requirements - Employees
Central employee record for the clinical and support workforce.
Linked to Positions, Departments, Locations, Employees
- Staff credential packets
Credential packet for an eligible employee, carried through review to current status.
Linked to Employees, Organizations, People, Credential requirements - Employees
Central employee record for the clinical and support workforce.
Linked to Positions, Departments, Locations, Employees - Organizations
Healthcare organizations and facilities in scope.
- Credential requirements
License and credential definitions with policy reference and effective window.
Linked to Organizations - State history
Status transition audit trail for a credential packet.
Linked to People, Staff credential packets
- CME activities
Observation-level CME and license activity evidence for a credential packet.
Linked to Staff credential packets - Evidence documents
Primary-source documents attached to a credential packet.
Linked to Staff credential packets, People - Staff credential packets
Credential packet for an eligible employee, carried through review to current status.
Linked to Employees, Organizations, People, Credential requirements - Follow up actions
Actions assigned to close missing evidence or held conditions.
Linked to Staff credential packets, People
- Review decisions
Independent reviewer decision recorded against an exact source revision.
Linked to Staff credential packets, People - State history
Status transition audit trail for a credential packet.
Linked to People, Staff credential packets - Follow up actions
Actions assigned to close missing evidence or held conditions.
Linked to Staff credential packets, People - Staff credential packets
Credential packet for an eligible employee, carried through review to current status.
Linked to Employees, Organizations, People, Credential requirements - Evidence documents
Primary-source documents attached to a credential packet.
Linked to Staff credential packets, People - People
Named internal owners, reviewers and actors referenced across the domain records.
Linked to Organizations
- Employees
Central employee record for the clinical and support workforce.
Linked to Positions, Departments, Locations, Employees - Employment history
Lifecycle events: hire, promotion, transfer, comp change, manager change, leave and termination.
Linked to Employees, Positions - Positions
Seat-level org entries that an employee fills.
Linked to Job titles, Departments, Locations, Pay grades - Job titles
Canonical clinical and administrative job titles.
Linked to Pay grades - Departments
Clinical and administrative departments.
Linked to Departments, Employees - Locations
Facilities and remote work locations.
Linked to Tax jurisdictions - Staff credential packets
Credential packet for an eligible employee, carried through review to current status.
Linked to Employees, Organizations, People, Credential requirements
- Courses
Learning catalog of clinical and compliance content.
- Course enrollments
Employee enrollment in a course, the learning transaction record.
Linked to Courses, Employees - Training records
Durable record of completed training and certifications.
Linked to Employees, Courses - CME activities
Observation-level CME and license activity evidence for a credential packet.
Linked to Staff credential packets - Leave requests
Employee-submitted leave requests requiring manager approval.
Linked to Employees, Leave types - Leave balances
Current balance per employee per leave type, maintained by accrual.
Linked to Employees, Leave types - Leave types
Leave categories with country- and class-scoped accrual rules.
- Employees
Central employee record for the clinical and support workforce.
Linked to Positions, Departments, Locations, Employees
Keys and references
A packet points to its employee, organization, owner and credential definition. CME activities use their parent packet. Evidence documents, review decisions, follow-up actions and state history point back to that packet. Review decisions carry a source revision, which should be compared with the packet revision during review. Employee references connect the broader workforce records without turning a leave or payroll status into a credential conclusion.
Migration order
- Load organizations and named people who own and review credential work.
- Load departments, locations, job titles and positions, then employee records.
- Add credential requirements with organization and effective dates.
- Add staff credential packets with employee, organization, owner and definition references.
- Add CME activities, evidence documents, review decisions, state history and follow-up actions against their packets.
- Load learning, leave and other workforce records after their reference records are available.
Set up Healthcare Staff HRMS your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.