SssContributionRate
The SssContributionRate entity, mapped to the sss_contribution_rates table.
| Table | sss_contribution_rates |
| Tenant-scoped | No — global table |
| Columns | 11 |
| Relationships | 0 |
| Source | backend/src/main/java/com/motorph/payroll/model/SssContributionRate.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 |
|---|---|---|---|---|
contributionRateId | Integer | contribution_rate_id | — | primary key, generated |
salaryBracketFrom | BigDecimal | salary_bracket_from | — | — |
salaryBracketTo | BigDecimal | salary_bracket_to | — | — |
mscRegular | BigDecimal | msc_regular | — | — |
mscMpf | BigDecimal | msc_mpf | — | — |
regularEmployerShare | BigDecimal | regular_employer_share | — | — |
regularEmployeeShare | BigDecimal | regular_employee_share | — | — |
ecEmployerShare | BigDecimal | ec_employer_share | — | — |
mpfEmployerShare | BigDecimal | mpf_employer_share | — | — |
mpfEmployeeShare | BigDecimal | mpf_employee_share | — | — |
effectiveDate | LocalDate | effective_date | — | — |
Repository
SssContributionRateRepository
Declared over SssContributionRate with id type Integer. Source: backend/src/main/java/com/motorph/payroll/repository/SssContributionRateRepository.java
| Method | Returns | Notes |
|---|---|---|
findAllByOrderBySalaryBracketFromAsc() | List<SssContributionRate> | derived |
findAllByEffectiveDate(LocalDate effectiveDate) | List<SssContributionRate> | derived |
findBracketsAsOf(@Param("salary") BigDecimal salary, @Param("asOf") LocalDate asOf) | List<SssContributionRate> | explicit @Query |
findBracketAsOf(BigDecimal salary, LocalDate asOf) | Optional<SssContributionRate> | derived |
findBracketsInEarliestCohort(@Param("salary") BigDecimal salary) | List<SssContributionRate> | explicit @Query |
findBracketInEarliestCohort(BigDecimal salary) | Optional<SssContributionRate> | derived |
findDistinctEffectiveDates() | List<LocalDate> | explicit @Query |
Reached by
These controllers hold — directly or through a service they depend on — a repository over SssContributionRate.
| 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 |
| SssContributionRateController | /api/sss-contribution-rates | 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/.