Workforce Planning & Recruitment
Streamline your hiring pipeline with tools designed for educational institutions. Manage vacancies, track applicants, and automate the onboarding of new faculty and staff.
- Job Posting & Applicant Tracking
- Automated Compliance Checklists
- Digital Contract Generation
- Staff Onboarding Workflows
-- HR & Workforce Schema v4.2
CREATE TABLE staff_contracts (
id UUID PRIMARY KEY,
staff_id UUID REFERENCES employees(id),
contract_type VARCHAR(50),
salary_grade_id UUID REFERENCES salary_grades(id),
start_date DATE NOT NULL,
end_date DATE,
is_active BOOLEAN DEFAULT TRUE,
audit_trail JSONB
);
CREATE TABLE performance_reviews (
id UUID PRIMARY KEY,
staff_id UUID REFERENCES employees(id),
reviewer_id UUID REFERENCES employees(id),
rating INTEGER CHECK (rating BETWEEN 1 AND 5),
review_period_id UUID REFERENCES academic_periods(id)
);
Module: hr_workforce_part1.sql
Performance & CPD Tracking
Foster professional growth with 360° performance appraisals and Continuous Professional Development (CPD) tracking aligned to institutional goals.
- Objective-Based Appraisals
- CPD Credits & Certification Log
- Disciplinary & Grievance Cases
- Succession Planning Dashboards
-- HR & Workforce Schema v4.2
CREATE TABLE staff_contracts (
id UUID PRIMARY KEY,
staff_id UUID REFERENCES employees(id),
contract_type VARCHAR(50),
salary_grade_id UUID REFERENCES salary_grades(id),
start_date DATE NOT NULL,
end_date DATE,
is_active BOOLEAN DEFAULT TRUE,
audit_trail JSONB
);
CREATE TABLE performance_reviews (
id UUID PRIMARY KEY,
staff_id UUID REFERENCES employees(id),
reviewer_id UUID REFERENCES employees(id),
rating INTEGER CHECK (rating BETWEEN 1 AND 5),
review_period_id UUID REFERENCES academic_periods(id)
);
Module: hr_workforce_part1.sql
Unified Staff Records & Leave
A single source of truth for all employee data. Manage leave requests, attendance, and welfare benefits with self-service portals for every staff member.
- Digital Employee Files
- Self-Service Leave Management
- Staff Welfare & Benefits Hub
- Workforce Analytics & Turnover
-- HR & Workforce Schema v4.2
CREATE TABLE staff_contracts (
id UUID PRIMARY KEY,
staff_id UUID REFERENCES employees(id),
contract_type VARCHAR(50),
salary_grade_id UUID REFERENCES salary_grades(id),
start_date DATE NOT NULL,
end_date DATE,
is_active BOOLEAN DEFAULT TRUE,
audit_trail JSONB
);
CREATE TABLE performance_reviews (
id UUID PRIMARY KEY,
staff_id UUID REFERENCES employees(id),
reviewer_id UUID REFERENCES employees(id),
rating INTEGER CHECK (rating BETWEEN 1 AND 5),
review_period_id UUID REFERENCES academic_periods(id)
);
Module: hr_workforce_part1.sql
Module Link: Finance
Data Sync Active
Automated Tax Computation
Regional tax rules applied per staff contract.
Statutory Deductions
Pensions, social security, and health insurance.
Direct Bank Exports
One-click generation of bank payment files.