Skip to main content

Queries

Audience​

Developers, QA engineers, support engineers, security engineers, solution architects, and implementation partners.

Reference Content​

This page records source-verified technical behavior and boundaries for the workforce-scheduling capability.

Summary​

Queries return shifts, weekly-off rules, attendance policies, assignments, effective-policy diagnostics, audit records, and timeline records. Shift and policy lists can include inactive rows. Assignment reads can be filtered to one employee and join shift names in application memory.

Projection behavior​

Domain times are rendered in a culture-independent format. Scheduled hours are derived from the shift window. Policy rules are ordered by sequence. Effective-policy output includes provenance so callers can see whether shift, default policy, or profile fallback values won.

Query boundaries​

Reads use tenant-filtered repository queryables. Audit and timeline queries apply optional entity filters and bounded result sizes. No roster calendar, coverage view, team schedule, availability, rotation, or reporting projection was found.

Performance note​

Batch effective-policy resolution preloads profiles, assignments, and shifts, while ordinary query methods can perform separate reads. Production cardinality and query-plan evidence were not available.

Source References​

  • microservices/src/attendance-service/Application/Services/ShiftPolicyQueries.cs
  • microservices/src/attendance-service/Application/TimeOffice/ShiftPolicyMappings.cs

See Also​

Keywords​

  • Workforce scheduling
  • Shift policy
  • Attendance integration

Revision Information​

  • Status: Draft
  • Last reviewed: 2026-07-20
  • Next review: 2026-10-20