PayrollReportArchive
One file of the frozen report pack generated when a payroll run is marked Processed.
| Table | payroll_report_archive |
| Tenant-scoped | Yes — extends TenantOwned |
| Columns | 12 |
| Relationships | 0 |
| Source | backend/src/main/java/com/motorph/payroll/model/PayrollReportArchive.java |
Columns
| Field | Type | Column | Null | Notes |
|---|---|---|---|---|
archiveId | Integer | archive_id | — | primary key, generated |
payrollId | Integer | payroll_id | — | — |
reportCode | String | report_code | — | — |
format | String | format | — | — |
filename | String | filename | — | — |
content | byte[] | content | Yes | — |
sizeBytes | Integer | size_bytes | Yes | — |
sha256 | String | sha256 | Yes | — |
status | String | status | — | — |
error | String | error | Yes | — |
generatedBy | String | generated_by | Yes | — |
generatedAt | LocalDateTime | generated_at | — | — |
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.
Repository
PayrollReportArchiveRepository
Declared over PayrollReportArchive with id type Integer. Source: backend/src/main/java/com/motorph/payroll/repository/PayrollReportArchiveRepository.java
| Method | Returns | Notes |
|---|---|---|
findAllByPayrollIdOrderByReportCodeAscFormatAsc(Integer payrollId) | List<PayrollReportArchive> | derived |
findMetadataByPayrollId(@org.springframework.data.repository.query.Param("payrollId") Integer payrollId) | List<com.motorph.payroll.report.archive.PayrollReportArchiveDto> | explicit @Query |
findByPayrollIdAndReportCodeAndFormat(Integer payrollId, String reportCode, String format) | Optional<PayrollReportArchive> | derived |
findByArchiveIdAndPayrollId(Integer archiveId, Integer payrollId) | Optional<PayrollReportArchive> | derived |
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/.