Skip to main content

PayrollReportArchive

One file of the frozen report pack generated when a payroll run is marked Processed.

Tablepayroll_report_archive
Tenant-scopedYes — extends TenantOwned
Columns12
Relationships0
Sourcebackend/src/main/java/com/motorph/payroll/model/PayrollReportArchive.java

Columns​

FieldTypeColumnNullNotes
archiveIdIntegerarchive_id—primary key, generated
payrollIdIntegerpayroll_id——
reportCodeStringreport_code——
formatStringformat——
filenameStringfilename——
contentbyte[]contentYes—
sizeBytesIntegersize_bytesYes—
sha256Stringsha256Yes—
statusStringstatus——
errorStringerrorYes—
generatedByStringgenerated_byYes—
generatedAtLocalDateTimegenerated_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

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