Employee Profile Storage

Summary

EmployeeProfile is an Attendance-local projection of employee attributes needed for availability, calculation fallback, and display. It is not employee master data.

Audience

• Backend developers, architects, QA engineers, and integration owners

Reference Content

Stored projection

The externally supplied employee/labor reference is the primary key and is not database-generated. The row includes tenant, active state, joining date, Attendance mode, standard-hour and threshold categories, optional shift display/timing fields, selected organizational/display fields, and update time.

The tenant/active index supports availability reads, and the global filter applies tenant context. The service’s upsert operation inserts a missing profile or updates the current projection conceptually.

No database foreign key or cross-database join to Employee Service exists. Automated event synchronization is Transitional / Requires confirmation; current source confirms an upsert service and notes future event synchronization. Data freshness and deletion propagation are therefore integration concerns.

Source References

• microservices/src/attendance-service/Domain/Attendance/EmployeeProfile.cs
• microservices/src/attendance-service/Infrastructure/AttendanceDbContext.cs
• microservices/src/attendance-service/Application/Services/EmployeeProfileService.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