Skip to main content

PagibigContributionRate

The PagibigContributionRate entity, mapped to the pagibig_contribution_rates table.

Tablepagibig_contribution_rates
Tenant-scopedNo — global table
Columns7
Relationships0
Sourcebackend/src/main/java/com/motorph/payroll/model/PagibigContributionRate.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​

FieldTypeColumnNullNotes
contributionRateIdIntegercontribution_rate_id—primary key, generated
salaryBracketFromBigDecimalsalary_bracket_from——
salaryBracketToBigDecimalsalary_bracket_to——
employeeShareBigDecimalemployee_share——
employerShareBigDecimalemployer_share——
effectiveDateLocalDateeffective_date——
cohortIdIntegercohort_idYesAssigned by the V142 trigger from (family, effective_date[, pay_period]); read-only here.

Repository​

PagibigContributionRateRepository​

Declared over PagibigContributionRate with id type Integer. Source: backend/src/main/java/com/motorph/payroll/repository/PagibigContributionRateRepository.java

MethodReturnsNotes
findAllByOrderBySalaryBracketFromAsc()List<PagibigContributionRate>derived
findAllByEffectiveDate(LocalDate effectiveDate)List<PagibigContributionRate>derived
findBracketsAsOf(@Param("salary") BigDecimal salary, @Param("asOf") LocalDate asOf)List<PagibigContributionRate>explicit @Query
findBracketAsOf(BigDecimal salary, LocalDate asOf)Optional<PagibigContributionRate>derived
findBracketsInEarliestCohort(@Param("salary") BigDecimal salary)List<PagibigContributionRate>explicit @Query
findBracketInEarliestCohort(BigDecimal salary)Optional<PagibigContributionRate>derived
findDistinctEffectiveDates()List<LocalDate>explicit @Query
findHighestBracketsAsOf(@Param("asOf") LocalDate asOf)List<PagibigContributionRate>explicit @Query
findHighestBracketAsOf(LocalDate asOf)Optional<PagibigContributionRate>derived
findHighestBracketsInEarliestCohort()List<PagibigContributionRate>explicit @Query
findHighestBracketInEarliestCohort()Optional<PagibigContributionRate>derived

Reached by​

These controllers hold — directly or through a service they depend on — a repository over PagibigContributionRate.

ControllerBase pathEndpointsModule
DemoDataController/api/system-admin/demo-data3Billing & Platform
PagibigContributionRateController/api/pagibig-contribution-rates8PH Statutory
PayrollController/api/payroll10Payroll
PayrollOnboardingController/api/onboarding/payroll1Payroll
PayrollSettingsController/api/payroll-settings6Payroll
PublicPayrollSimulatorController/api/public/payroll-simulator3Payroll

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/.