Evaluations

Views for employee evaluations (performance conversations) and their individual answers/scores.

These views cover the employee evaluation system in Maecos. Evaluations represent structured performance conversations between employees and team leaders, with scored answers and status tracking through a submission workflow.

---

reporting.evaluations

Employee evaluation records with status, deadlines, and overall score.

Evaluations follow a two-step workflow: the employee submits a self-assessment first (submitted_by_employee_at), then the team leader completes and finalizes the evaluation (submitted_by_team_leader_at, finalized_at).

Field	Type	Description
evaluation_id	uuid	Unique identifier
employee_id	uuid	The evaluated employee
team_id	uuid	Team context for the evaluation
team_leader_id	uuid	The evaluating team leader
conversation_date	date	Scheduled conversation date
employee_deadline	date	Deadline for employee self-assessment
closing_deadline	date	Deadline for final closing
status	text	Current evaluation status
decline_reason	text	Reason if the evaluation was declined
exemption_reason	text	Reason if the employee was exempted
score	numeric	Overall numeric score
submitted_by_employee_at	timestamp	When the employee submitted
submitted_by_team_leader_at	timestamp	When the team leader submitted
reopened_at	timestamp	When the evaluation was reopened (if applicable)
conclusion	text	Final conclusion text
created_at	timestamp	When the evaluation was created
created_by	uuid	User who created the evaluation
updated_at	timestamp	Last modification timestamp
updated_by	uuid	User who last modified the evaluation
deleted_at	timestamp	Soft delete timestamp
deleted_by	uuid	User who deleted the evaluation
finalized_at	timestamp	When the evaluation was finalized

Joins: Join employee_id and team_leader_id with users.user_id. Join with lms_teams on team_id. Join with evaluation_answers on evaluation_id for individual answers.

---

reporting.evaluation_answers

Individual answers within an evaluation. Each row is one question-answer pair.

Field	Type	Description
evaluation_answer_id	uuid	Unique identifier
evaluation_id	uuid	Parent evaluation
answered_by	uuid	User who provided the answer
question	text	The question text
answer	text	The answer text
score	numeric	Numeric score for this answer
answer_type	text	Type of answer (e.g., Comment, Score)
created_at	timestamp	When the answer was created
created_by	uuid	User who created the answer
updated_at	timestamp	Last modification timestamp
updated_by	uuid	User who last modified the answer
deleted_at	timestamp	Soft delete timestamp
deleted_by	uuid	User who deleted the answer

---

Example queries

Evaluation completion status by team

SELECT
    t.name AS team,
    COUNT(*) AS total_evaluations,
    COUNT(e.finalized_at) AS finalized,
    COUNT(*) FILTER (WHERE e.status = 'open') AS still_open
FROM reporting.evaluations e
JOIN reporting.lms_teams t USING (team_id)
WHERE e.deleted_at IS NULL
GROUP BY t.name
ORDER BY still_open DESC;

Average evaluation scores by team

SELECT
    t.name AS team,
    ROUND(AVG(e.score), 2) AS avg_score,
    COUNT(*) AS evaluations
FROM reporting.evaluations e
JOIN reporting.lms_teams t USING (team_id)
WHERE e.deleted_at IS NULL
    AND e.score IS NOT NULL
GROUP BY t.name
ORDER BY avg_score DESC;