Query Patterns
Audience
Developers, QA and support engineers, data reviewers, implementation partners, solution architects, privacy reviewers and security reviewers.
Reference Content
Summary
Observed queries are tenant-scoped lists/lookups, active-onboarding lookup, status/readiness projection lookup, timeline ordering, clearance checks and delivery queue polling.
Pattern catalog
| Pattern | Supporting model |
|---|---|
| Candidate/onboarding status lists | Tenant/status indexes |
| Offer/candidate/onboarding lookup | Business and compatibility identifiers |
| Employee organization/status lists | Tenant/department and tenant/status indexes |
| Lifecycle chronology | Tenant/time audit and timeline indexes |
| Consumer duplicate check | Unique processed-event identity |
| Outbox relay polling | Delivery status/time index |
| Asset clearance | Assignment state queried by employee reference |
| Exit history | Request/subject chronology in compatibility context |
Query boundary
Safety concern
Any explicit global-filter bypass must add equivalent tenant or bounded-public-flow controls. The active onboarding lookup is a confirmed gap. Direct database querying is not a documented application interface.
Performance
Pagination, plan quality, slow-query thresholds and production cardinality are not established by source inspection and require measurement.
Requires confirmation
Unless explicitly confirmed above, production migration governance, rollback, reconciliation, retention, privacy, performance, concurrency and operational ownership require confirmation.
Source References
microservices/src/recruitment-service/Infrastructure/Persistence.csmicroservices/src/asset-service/Application/Queries/AssetQueries.cs
Related Articles
See Also
Keywords
- Onboarding database
- Offboarding database
- Lifecycle persistence
Revision Information
- Status: Draft
- Last reviewed: 2026-07-20
- Review cycle: Quarterly