JobOffer
The JobOffer entity, mapped to the job_offer table.
| Table | job_offer |
| Tenant-scoped | Yes — extends TenantOwned |
| Columns | 24 |
| Relationships | 3 |
| Source | backend/src/main/java/com/motorph/payroll/model/JobOffer.java |
Columns
| Field | Type | Column | Null | Notes |
|---|---|---|---|---|
offerId | Integer | offer_id | — | primary key, generated |
offeredSalary | BigDecimal | offered_salary | Yes | — |
startDate | LocalDate | start_date | Yes | — |
offerDate | LocalDate | offer_date | Yes | — |
expiryDate | LocalDate | expiry_date | Yes | — |
status | String | status | — | — |
notes | String | notes | Yes | — |
employmentType | String | employment_type | Yes | — |
workArrangement | String | work_arrangement | Yes | — |
probationEndDate | LocalDate | probation_end_date | Yes | — |
riceSubsidy | BigDecimal | rice_subsidy | Yes | — |
phoneAllowance | BigDecimal | phone_allowance | Yes | — |
clothingAllowance | BigDecimal | clothing_allowance | Yes | — |
grossSemiMonthlyRate | BigDecimal | gross_semi_monthly_rate | Yes | — |
hourlyRate | BigDecimal | hourly_rate | Yes | — |
sssNumber | String | sss_number | Yes | — |
sssVerified | boolean | sss_verified | — | — |
philhealthNumber | String | philhealth_number | Yes | — |
philhealthVerified | boolean | philhealth_verified | — | — |
pagibigNumber | String | pagibig_number | Yes | — |
pagibigVerified | boolean | pagibig_verified | — | — |
tinNumber | String | tin_number | Yes | — |
tinVerified | boolean | tin_verified | — | — |
acceptedAt | LocalDateTime | accepted_at | Yes | — |
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 |
|---|---|---|---|---|
applicant | @ManyToOne | JobApplicant | applicant_id | Yes |
position | @ManyToOne | Position | position_id | Yes |
createdBy | @ManyToOne | Employee | created_by | Yes |
Neighbourhood
Repository
JobOfferRepository
Declared over JobOffer with id type Integer, with JpaSpecificationExecutor for dynamic filtering. Source: backend/src/main/java/com/motorph/payroll/repository/JobOfferRepository.java
| Method | Returns | Notes |
|---|---|---|
findWithDetailsByOfferId(Integer offerId) | Optional<JobOffer> | derived |
countByStatus(String status) | long | derived |
findAllByStatusAndAcceptedAtIsNotNull(String status) | List<JobOffer> | derived |
Reached by
These controllers hold — directly or through a service they depend on — a repository over JobOffer.
| Controller | Base path | Endpoints | Module |
|---|---|---|---|
| JobOfferController | /api/job-offers | 6 | Recruitment |
| ReportingController | /api/reports | 16 | Platform Misc |
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/.