PayrollSettings
Single-row table of configurable payroll computation parameters.
| Table | payroll_settings |
| Tenant-scoped | Yes — extends TenantOwned |
| Columns | 71 |
| Relationships | 0 |
| Source | backend/src/main/java/com/motorph/payroll/model/PayrollSettings.java |
Columns
| Field | Type | Column | Null | Notes |
|---|---|---|---|---|
payrollSettingsId | Integer | payroll_settings_id | — | primary key, generated |
workingDaysPerMonth | BigDecimal | working_days_per_month | — | — |
hoursPerDay | BigDecimal | hours_per_day | — | — |
overtimeMultiplier | BigDecimal | overtime_multiplier | — | — |
nightDiffMultiplier | BigDecimal | night_diff_multiplier | — | — |
thirteenthMonthNonTaxableCap | BigDecimal | thirteenth_month_non_taxable_cap | — | — |
regularHolidayMultiplier | BigDecimal | regular_holiday_multiplier | — | — |
specialDayMultiplier | BigDecimal | special_day_multiplier | — | — |
restDayMultiplier | BigDecimal | rest_day_multiplier | — | — |
specialDayRestDayMultiplier | BigDecimal | special_day_rest_day_multiplier | — | — |
regularHolidayRestDayMultiplier | BigDecimal | regular_holiday_rest_day_multiplier | — | — |
premiumDayOvertimeMultiplier | BigDecimal | premium_day_overtime_multiplier | — | — |
nightDiffEnabledHours | Boolean | night_diff_enabled_hours | — | — |
nightShiftStart | LocalTime | night_shift_start | — | — |
nightShiftEnd | LocalTime | night_shift_end | — | — |
defaultRestDay | Set<DayOfWeek> | default_rest_day | — | converted by RestDaysConverter |
philhealthPremiumFloor | BigDecimal | philhealth_premium_floor | — | — |
philhealthPremiumCeiling | BigDecimal | philhealth_premium_ceiling | — | — |
pagibigContributionCap | BigDecimal | pagibig_contribution_cap | — | — |
pagibigEmployerCap | BigDecimal | pagibig_employer_cap | — | — |
formDisclaimerText | String | form_disclaimer_text | — | — |
taxAdviceNotice | String | tax_advice_notice | — | — |
payFrequency | PayFrequency | pay_frequency | — | enum |
firstCutoffStartDay | Integer | first_cutoff_start_day | — | — |
firstCutoffEndDay | Integer | first_cutoff_end_day | — | — |
secondCutoffStartDay | Integer | second_cutoff_start_day | — | — |
secondCutoffEndDay | Integer | second_cutoff_end_day | — | — |
payDateFirstCutoff | Integer | pay_date_first_cutoff | — | — |
payDateSecondCutoff | Integer | pay_date_second_cutoff | — | — |
payPeriodAnchorDate | LocalDate | pay_period_anchor_date | Yes | — |
payDateLagDays | Integer | pay_date_lag_days | — | — |
defaultRoundingMode | PayrollRoundingMode | default_rounding_mode | — | enum |
workStartTime | LocalTime | work_start_time | — | — |
lateGracePeriodMinutes | Integer | late_grace_period_minutes | — | — |
minimumOvertimeIncrementMinutes | Integer | minimum_overtime_increment_minutes | — | — |
breakDeductionPolicy | BreakDeductionPolicy | break_deduction_policy | — | enum |
standardUnpaidBreakDurationMinutes | Integer | standard_unpaid_break_duration_minutes | — | — |
lateDeductionPolicy | LateDeductionPolicy | late_deduction_policy | — | enum |
absentDeductionPolicy | AbsentDeductionPolicy | absent_deduction_policy | — | enum |
timesheetPayPolicy | TimesheetPayPolicy | timesheet_pay_policy | — | enum |
contributionDeductionSchedule | ContributionSchedule | contribution_deduction_schedule | — | enum |
customDeductionsEnabled | Boolean | custom_deductions_enabled | — | — |
yearEndTaxAdjustmentEnabled | Boolean | year_end_tax_adjustment_enabled | — | — |
recognitionAwardsEnabled | Boolean | recognition_awards_enabled | — | — |
currentStatutoryYear | Integer | current_statutory_year | — | — |
taxTableVersion | String | tax_table_version | Yes | — |
sssTableVersion | String | sss_table_version | Yes | — |
philhealthTableVersion | String | philhealth_table_version | Yes | — |
pagibigTableVersion | String | pagibig_table_version | Yes | — |
holidayEligibilityPolicy | HolidayEligibilityPolicy | holiday_eligibility_policy | — | enum |
payUnworkedRegularHoliday | Boolean | pay_unworked_regular_holidays | — | — |
payUnworkedSpecialHoliday | Boolean | pay_unworked_special_holiday | — | — |
payHolidayIfAbsentPreviousDay | Boolean | pay_holiday_if_absent_previous_day | — | — |
payHolidayIfOnLeave | Boolean | pay_holiday_if_on_leave | — | — |
allowOvertimeDuringLeave | Boolean | allow_overtime_during_leave | — | — |
allowOvertimeDuringHoliday | Boolean | allow_overtime_during_holiday | — | — |
allowOvertimeDuringSuspension | Boolean | allow_overtime_during_suspension | — | — |
holidayLeaveInteractionPolicy | HolidayLeaveInteractionPolicy | holiday_leave_interaction_policy | — | enum |
currencyCode | String | currency_code | — | — |
showEmployerContribution | Boolean | show_employer_contribution | — | — |
showLeaveBalance | Boolean | show_leave_balance | — | — |
showYearToDate | Boolean | show_year_to_date | — | — |
showTaxBreakdown | Boolean | show_tax_breakdown | — | — |
companyLogo | String | company_logo | Yes | — |
version | Integer | version | — | — |
isLocked | Boolean | is_locked | — | — |
approvedBy | String | approved_by | Yes | — |
effectiveDate | LocalDateTime | effective_date | Yes | — |
createdDate | LocalDateTime | created_date | Yes | — |
lastModifiedBy | String | last_modified_by | Yes | — |
lastModifiedDate | LocalDateTime | last_modified_date | 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.
Referenced by
| Entity | Field | Kind |
|---|---|---|
| PayrollSettingsChange | payrollSettings | @ManyToOne |
Neighbourhood
Repository
PayrollSettingsRepository
Declared over PayrollSettings with id type Integer. Source: backend/src/main/java/com/motorph/payroll/repository/PayrollSettingsRepository.java
| Method | Returns | Notes |
|---|---|---|
findFirstByOrderByPayrollSettingsIdAsc() | Optional<PayrollSettings> | derived |
Reached by
These controllers hold — directly or through a service they depend on — a repository over PayrollSettings.
| Controller | Base path | Endpoints | Module |
|---|---|---|---|
| BonusController | /api/bonuses | 6 | Payroll |
| CertificateTemplateController | /api/certificate-templates | 8 | HR |
| DemoDataController | /api/system-admin/demo-data | 3 | Billing & Platform |
| GovernmentFormsController | /api/government-forms | 8 | PH Statutory |
| LeaveRequestController | /api/leave-requests | 7 | HR |
| PayrollController | /api/payroll | 8 | Payroll |
| PayrollSettingsChangesController | /api/payroll-settings-changes | 1 | Payroll |
| PayrollSettingsController | /api/payroll-settings | 4 | Payroll |
| PublicSignupController | /api/public/signup | 2 | Billing & Platform |
| RecognitionAwardController | /api/recognition-awards | 7 | HR |
| ReportingController | /api/reports | 16 | Platform Misc |
| TenantAdminController | /api/admin/tenants | 7 | Billing & Platform |
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/.