WithholdingTaxBracket
BIR TRAIN withholding tax bracket for one pay period's table.
| Table | withholding_tax_brackets |
| Tenant-scoped | No — global table |
| Columns | 7 |
| Relationships | 0 |
| Source | backend/src/main/java/com/motorph/payroll/model/WithholdingTaxBracket.java |
Not tenant-scoped
This entity does not extend TenantOwned, so its rows are shared across every tenant. TenantCoverageTest allows that only for tables deliberately declared global.
Columns
| Field | Type | Column | Null | Notes |
|---|---|---|---|---|
withholdingTaxBracketId | Integer | withholding_tax_bracket_id | — | primary key, generated |
payPeriod | TaxPayPeriod | pay_period | — | enum |
taxableIncomeFrom | BigDecimal | taxable_income_from | — | — |
taxableIncomeTo | BigDecimal | taxable_income_to | — | — |
baseTax | BigDecimal | base_tax | — | — |
rateOnExcess | BigDecimal | rate_on_excess | — | — |
effectiveDate | LocalDate | effective_date | — | — |
Repository
WithholdingTaxBracketRepository
Declared over WithholdingTaxBracket with id type Integer. Source: backend/src/main/java/com/motorph/payroll/repository/WithholdingTaxBracketRepository.java
| Method | Returns | Notes |
|---|---|---|
findAllByOrderByPayPeriodAscTaxableIncomeFromAsc() | List<WithholdingTaxBracket> | derived |
findAllByEffectiveDate(LocalDate effectiveDate) | List<WithholdingTaxBracket> | derived |
findBracketAsOf(@Param("income") BigDecimal income, @Param("asOf") LocalDate asOf, @Param("payPeriod") TaxPayPeriod payPeriod) | Optional<WithholdingTaxBracket> | explicit @Query |
findBracketInEarliestCohort(@Param("income") BigDecimal income, @Param("payPeriod") TaxPayPeriod payPeriod) | Optional<WithholdingTaxBracket> | explicit @Query |
findDistinctEffectiveDates() | List<LocalDate> | explicit @Query |
findDistinctEffectiveDates(@Param("payPeriod") TaxPayPeriod payPeriod) | List<LocalDate> | explicit @Query |
Reached by
These controllers hold — directly or through a service they depend on — a repository over WithholdingTaxBracket.
| Controller | Base path | Endpoints | Module |
|---|---|---|---|
| DemoDataController | /api/system-admin/demo-data | 3 | Billing & Platform |
| GovernmentFormsController | /api/government-forms | 8 | PH Statutory |
| PayrollController | /api/payroll | 8 | Payroll |
| PayrollSettingsController | /api/payroll-settings | 4 | Payroll |
| ReportingController | /api/reports | 16 | Platform Misc |
| WithholdingTaxBracketController | /api/withholding-tax-brackets | 8 | PH Statutory |
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/.