GovernmentFiling
One government-form filing (e.g.
| Table | government_filing |
| Tenant-scoped | Yes — extends TenantOwned |
| Columns | 19 |
| Relationships | 1 |
| Source | backend/src/main/java/com/motorph/payroll/model/GovernmentFiling.java |
Columns
| Field | Type | Column | Null | Notes |
|---|---|---|---|---|
governmentFilingId | Integer | government_filing_id | — | primary key, generated |
formType | String | form_type | — | — |
periodYear | Integer | period_year | — | — |
periodMonth | Integer | period_month | Yes | — |
referenceNumber | String | reference_number | Yes | — |
amountPaid | BigDecimal | amount_paid | Yes | — |
filedDate | LocalDate | filed_date | Yes | — |
paidDate | LocalDate | paid_date | Yes | The day the money left. |
paymentMethod | String | payment_method | Yes | BANK_TRANSFER, CASH, CHECK, E_WALLET or OTHER (PaymentMethods). |
status | String | status | — | Active or Voided. |
voidedAt | LocalDateTime | voided_at | Yes | — |
voidedBy | String | voided_by | Yes | — |
voidReason | String | void_reason | Yes | — |
remarks | String | remarks | Yes | — |
receiptFilename | String | receipt_filename | Yes | — |
receiptContentType | String | receipt_content_type | Yes | — |
receiptData | byte[] | receipt_data | Yes | — |
uploadedBy | String | uploaded_by | Yes | — |
createdDate | LocalDateTime | created_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.
Relationships
| Field | Kind | Target | Join column | Required |
|---|---|---|---|---|
paidFromAccount | @ManyToOne | com.motorph.payroll.accounting.model.Account | paid_from_account_id | — |
Repository
GovernmentFilingRepository
Declared over GovernmentFiling with id type Integer. Source: backend/src/main/java/com/motorph/payroll/repository/GovernmentFilingRepository.java
| Method | Returns | Notes |
|---|---|---|
findAllMetadataByPeriodYear(@Param("year") int year) | List<GovernmentFilingDto> | explicit @Query |
findAllMetadataByPeriodYearIncludingVoided(@Param("year") int year) | List<GovernmentFilingDto> | explicit @Query |
lockById(@Param("id") Integer id) | java.util.Optional<com.motorph.payroll.model.GovernmentFiling> | explicit @Query |
sumAmountPaid(@Param("formType") String formType, @Param("year") int year, @Param("month") int month) | BigDecimal | explicit @Query |
Reached by
These controllers hold — directly or through a service they depend on — a repository over GovernmentFiling.
| Controller | Base path | Endpoints | Module |
|---|---|---|---|
| GovernmentFilingController | /api/government-filings | 5 | PH Statutory |
| GovernmentFormsController | /api/government-forms | 16 | 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/.