HRIntelli - Magically Simplifying HR with AI
The HR management application will now include features to manage departments and employee benefits. Each department will have its own information and employees will be associated with a department. Additionally, employee benefits will be tracked.
Key Feature:
- Employee Management:
- Add new employees with their personal details, title, and compensation.
- Update employee details, including title changes, personal details, and compensation adjustments.
- Terminate employees and update their status.
- Department Management:
- Manage information about each department.
- Associate employees with departments.
- Performance Management:
- Track employee performance and status within the company.
- Managers can add performance feedback for employees who report to them.
- Employees can view their performance feedback and add personal feedback.
- Compensation Management:
- HR can update employee compensation and receive AI-driven recommendations.
- Track compensation history for each employee.
- Benefits Management:
- Track the benefits each employee receives.
- AI Integration:
- AI provides recommendations for compensation adjustments based on trends and employee performance.
- Co-pilot assistance for managers to generate personalized performance feedback.
- Reporting and Summarization:
- Summarize employee information, performance trends, and compensation data.
- Managers can view information about employees who report to them.
Postgres Schemas
1. departments
This table stores information about each department, including its name and description, and is linked to a specific tenant.
2. employees
This table stores detailed information about employees, including their title, department, compensation, status, hire date, and termination date. It ensures each employee is associated with a specific tenant and department.
3. performance
This table tracks performance feedback for employees, including feedback text, rating, and the manager who provided the feedback. It is linked to the employee and the manager providing the feedback. The vector embeddings are calculated for each performance of an employee. This helps HR and managers to search about the feedback and even retrieve employees with similar feedback and come up with a cohesive plan for improvement.
4. compensation_history
This table records changes in employee compensation, including the old and new compensation amounts, the date of change, and the reason for the change. It helps track the history of compensation adjustments.
5. employee_feedback
This table stores personal feedback provided by employees. It ensures feedback is linked to the specific employee who provided it. The embeddings on all the feedback of an employee helps to track similar patterns across feedbacks. This can help managers to understand which is the top priority improvement for the employee.
6. benefits
This table tracks the benefits each employee receives, including the name and description of the benefit. The embeddings are useful on the benefit types. This helps to summarize the long documents that explain benefits to the employees.
Full Script
This script includes all necessary tables for managing employees, performance, compensation history, feedback, departments, and benefits, following the multitenant rules with UUID types and primary and foreign keys defined appropriately.
Was this page helpful?