Time Office Storage

Summary

Time Office persistence comprises shifts, weekly-off rules, Attendance policies and owned policy rules, plus effective-dated employee shift assignments.

Audience

• Backend developers, Time Office implementers, QA engineers, and architects

Relationships

Only policy-to-rule is an EF relationship and database foreign key, with cascade delete. Assignment-to-shift is intentionally a logical identifier without navigation or foreign key. Weekly-off rules are tenant/day settings and have no modeled shift or policy relationship. Employee-specific policy assignment is Not implemented in this model.

Source References

• microservices/src/attendance-service/Domain/TimeOffice/Shift.cs
• microservices/src/attendance-service/Domain/TimeOffice/WeeklyOffRule.cs
• microservices/src/attendance-service/Domain/TimeOffice/AttendancePolicy.cs
• microservices/src/attendance-service/Domain/TimeOffice/EmployeeShiftAssignment.cs
• microservices/src/attendance-service/Infrastructure/AttendanceDbContext.cs

Related Articles

• Attendance database
• Attendance technical documentation
• Attendance API documentation

See Also

• Attendance business documentation
• Attendance overview

Keywords

• Attendance persistence
• EF Core
• PostgreSQL

Revision Information

• Status: Draft
• Last reviewed: 2026-07-15
• Review cycle: Quarterly