JobRequisition
The JobRequisition entity, mapped to the job_requisition table.
| Table | job_requisition |
| Tenant-scoped | Yes — extends TenantOwned |
| Columns | 7 |
| Relationships | 3 |
| Source | backend/src/main/java/com/motorph/payroll/model/JobRequisition.java |
Columns
| Field | Type | Column | Null | Notes |
|---|---|---|---|---|
requisitionId | Integer | requisition_id | — | primary key, generated |
numVacancies | Integer | num_vacancies | — | — |
estimatedCost | BigDecimal | estimated_cost | Yes | — |
status | String | status | — | — |
description | String | description | Yes | — |
createdAt | LocalDateTime | created_at | — | — |
isArchived | Boolean | is_archived | — | Archived rows are hidden from default listings but retained and restorable — distinct from the hard-delete endpoint, which removes the row outright. |
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 |
|---|---|---|---|---|
department | @ManyToOne | Department | department_id | Yes |
position | @ManyToOne | Position | position_id | Yes |
requestedBy | @ManyToOne | Employee | requested_by | Yes |
Referenced by
| Entity | Field | Kind |
|---|---|---|
| JobOpening | requisition | @ManyToOne |
| StaffingPlanItem | requisition | @ManyToOne |
Neighbourhood
Repository
JobRequisitionRepository
Declared over JobRequisition with id type Integer, with JpaSpecificationExecutor for dynamic filtering. Source: backend/src/main/java/com/motorph/payroll/repository/JobRequisitionRepository.java
| Method | Returns | Notes |
|---|---|---|
findWithDetailsByRequisitionId(Integer requisitionId) | Optional<JobRequisition> | derived |
Reached by
These controllers hold — directly or through a service they depend on — a repository over JobRequisition.
| Controller | Base path | Endpoints | Module |
|---|---|---|---|
| JobOpeningController | /api/job-openings | 6 | Recruitment |
| JobRequisitionController | /api/job-requisitions | 8 | Recruitment |
| PublicJobController | /api/public | 3 | Recruitment |
| ReportingController | /api/reports | 16 | Platform Misc |
| StaffingPlanController | /api/staffing-plans | 7 | Recruitment |
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/.