Onboarding & Offboarding Database Documentation
Summary
Onboarding and offboarding persistence spans eight runtime contexts. The source exposes 58 lifecycle-relevant object sets across those contexts, 19 authored migrations and seven current snapshots. Seven extracted services have design-time factories; the compatibility application uses a separate initializer rather than authored EF migrations.
Everything in this section is Draft. It describes source-confirmed logical models only. Physical database and schema names, connection information, SQL, migration commands, seed values, record identifiers and personal data are intentionally excluded.
Audience
Developers, QA and support engineers, data reviewers, implementation partners, solution architects, privacy reviewers and security reviewers.
Overview
This section explains the logical persistence model, ownership, integrity controls, evolution, testing evidence and verified gaps for the onboarding/offboarding lifecycle.
Confirmed inventory
| Measure | Confirmed value |
|---|---|
| Runtime persistence contexts | 8 |
| Lifecycle-relevant object sets documented | 58 |
| Authored migrations in extracted contexts | 19 |
| Current model snapshots | 7 |
| Design-time context factories | 7 |
| Compatibility authored migrations/snapshots | 0 / 0 |
The 58-object count is a documentation selection, not the total size of every service database. It includes lifecycle records, readiness projections, audit/history, notifications and delivery ledgers that participate in onboarding or offboarding.
Documentation map
- Overview, architecture, ownership, and context inventory
- Recruitment onboarding, offers, and candidate/joining
- Onboarding tasks, employee profile, organization assignment, and employment status
- Resignation/exit and exit history
- Payroll, attendance, leave, and asset clearance
- Notifications/outbox, audit/timeline, and compatibility storage
- Tenant isolation, mappings, keys, indexes, and conversions
- Query patterns, integrity, transactions, and concurrency
- Migrations, development seeding, retention, and testing
- Schema reference, limitations, and source map
Persistence landscape
Open governance questions
Production migration governance, rollback and restore ownership, retention, privacy erasure, reconciliation, performance baselines, concurrency policy and operational ownership require confirmation.
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/RecruitmentDbContext.csmicroservices/src/employee-service/Infrastructure/EmployeeDbContext.csData/AppDbContext.cs
Related Articles
See Also
Keywords
- Onboarding database
- Offboarding database
- Lifecycle persistence
Revision Information
- Status: Draft
- Last reviewed: 2026-07-20
- Review cycle: Quarterly