Skip to main content

SssContributionRate

The SssContributionRate entity, mapped to the sss_contribution_rates table.

Tablesss_contribution_rates
Tenant-scopedNo — global table
Columns12
Relationships0
Sourcebackend/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​

FieldTypeColumnNullNotes
contributionRateIdIntegercontribution_rate_id—primary key, generated
salaryBracketFromBigDecimalsalary_bracket_from——
salaryBracketToBigDecimalsalary_bracket_to——
mscRegularBigDecimalmsc_regular——
mscMpfBigDecimalmsc_mpf——
regularEmployerShareBigDecimalregular_employer_share——
regularEmployeeShareBigDecimalregular_employee_share——
ecEmployerShareBigDecimalec_employer_share——
mpfEmployerShareBigDecimalmpf_employer_share——
mpfEmployeeShareBigDecimalmpf_employee_share——
effectiveDateLocalDateeffective_date——
cohortIdIntegercohort_idYesAssigned by the V142 trigger from (family, effective_date[, pay_period]); read-only here.

Repository​

SssContributionRateRepository​

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

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

ControllerBase pathEndpointsModule
DemoDataController/api/system-admin/demo-data3Billing & Platform
PayrollController/api/payroll10Payroll
PayrollOnboardingController/api/onboarding/payroll1Payroll
PayrollSettingsController/api/payroll-settings6Payroll
PublicPayrollSimulatorController/api/public/payroll-simulator3Payroll
SssContributionRateController/api/sss-contribution-rates8PH 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/.