RecognitionAward
One recognition award earned by one employee in one Processed payroll run.
| Table | recognition_award |
| Tenant-scoped | Yes — extends TenantOwned |
| Columns | 8 |
| Relationships | 2 |
| Source | backend/src/main/java/com/motorph/payroll/model/RecognitionAward.java |
Columns
| Field | Type | Column | Null | Notes |
|---|---|---|---|---|
recognitionAwardId | Integer | recognition_award_id | — | primary key, generated |
category | RecognitionCategory | category | — | enum |
awardRank | Integer | award_rank | Yes | 1..3 for ranked categories; null for the threshold award (Perfect Attendance). |
metricValue | BigDecimal | metric_value | — | The number the award was decided on, in the category's own unit: late minutes for MOST_PUNCTUAL, hours for OVERTIME_CHAMPION and TOP_HOURS, days present for PERFECT_ATTENDANCE. |
awardNumber | String | award_number | — | — |
employeeName | String | employee_name | — | — |
generatedBy | String | generated_by | Yes | — |
generatedAt | LocalDateTime | generated_at | — | — |
Plus tenant_id, inherited from TenantOwned. Hibernate stamps it on insert and adds where tenant_id = ? to every query, so it is never written or read by application code.
Relationships
| Field | Kind | Target | Join column | Required |
|---|---|---|---|---|
payroll | @ManyToOne | Payroll | payroll_id | Yes |
employee | @ManyToOne | Employee | employee_id | Yes |
Neighbourhood
Repository
RecognitionAwardRepository
Declared over RecognitionAward with id type Integer. Source: backend/src/main/java/com/motorph/payroll/repository/RecognitionAwardRepository.java
| Method | Returns | Notes |
|---|---|---|
findAllByPayroll_PayrollIdOrderByCategoryAscAwardRankAscEmployeeNameAsc(Integer payrollId) | List<RecognitionAward> | derived |
findAllByEmployee_EmployeeNumberOrderByGeneratedAtDesc(Integer employeeNumber) | List<RecognitionAward> | derived |
deleteAllByPayroll_PayrollId(Integer payrollId) | void | derived |
existsByPayroll_PayrollId(Integer payrollId) | boolean | derived |
Reached by
These controllers hold — directly or through a service they depend on — a repository over RecognitionAward.
| Controller | Base path | Endpoints | Module |
|---|---|---|---|
| RecognitionAwardController | /api/recognition-awards | 7 | HR |
Generated page
This page is rebuilt from the source on every docs build by docs-site/scripts/gen-code-wiki.mjs. Editing it has no effect — change the code, or, if what you want to say is prose, write it in docs/.