Advance and Recovery Storage
Source-backed advance and recovery storage for the HR Suit Payroll Service.
Source-backed advance and recovery storage for the HR Suit Payroll Service.
Source-backed persistence mapping and child ownership for the appraisal aggregate.
Source-backed asset clearance storage for HR Suit onboarding and offboarding.
Source-backed account of the transitional ETL that copies monolith asset records into the Asset Service while preserving compatibility identity.
Source-backed statement of the Asset Service's concurrency posture — no concurrency token or locking, only lifecycle re-checks, callback idempotency, and unique indexes, which reduce but do not guarantee safety.
Source-backed map of Asset integrity controls across domain invariants, application checks, database constraints, and unenforced expectations, with a classification matrix.
Consolidated source-backed persistence limitations and areas requiring confirmation for Asset Management.
Source-backed overview of asset persistence technology, ownership, and verified model totals.
Source-backed inventory of existing asset persistence test evidence and a separated catalog of recommended future database coverage.
Source-backed description of AssetDbContext and a verified inventory of its seven object sets, their CLR types, persistence purpose, classification, tenant scope, and keys.
Source-backed account of the Development-only asset seeder: its trigger, environment restriction, idempotency marker, and seeded categories.
Source-backed EF Core mappings for every persisted Asset entity — tables, keys, required properties, enum conversions, owned values, indexes, generated values, jsonb columns, and ignored members.
Source-backed inventory of every Asset non-primary-key index and database constraint, with uniqueness, composition, tenant participation, and missing expected constraints.
Source-backed inventory of Asset primary keys, unique keys, enforced foreign-key relationships, and identifier-only cross-service references that are not database relationships.
Source-backed verified logical catalog of asset persisted objects without physical deployment details.
Source-backed database and persistence documentation for HR Suit Asset Management.
Source-backed account of the Asset Service migration history, model snapshot, rollback method, and startup migration behavior.
Source-backed data-ownership map for the Asset bounded context: what the Asset Service owns outright versus what it only references across service boundaries.
Source-backed flow of how Asset write and read operations reach PostgreSQL: endpoints, commands, repository and unit of work, DbContext, aggregate, evidence writers, outbox staging, and external calls kept outside the transaction.
Verified mapping from persistence concern to authoritative asset-service source paths.
Source-backed inventory of Asset EF Core read patterns — tenant filtering, includes, ordering, capped reads, in-memory processing, and the indexing and pagination gaps they expose.
Source-backed account of deletion, retention, and cleanup behavior across every Asset Service persisted object.
Source-backed persistence of the canonical Asset aggregate, its columns, owned values, lifecycle state, and integrity gaps.
Source-backed tenant isolation for Asset persistence — EF global query filters, explicit backfill predicates, header/claim trust, and the absence of database-enforced isolation.
Source-backed description of the Asset single-transaction save model, what commits together, where external HTTP calls sit relative to the transaction, and failure behavior.
Source-backed inventory of the four persisted Asset value objects — their scalar columns, validation, equality semantics, query and index implications, and the non-persisted computed members.
Source-backed persistence of the append-only asset assignment-history child rows, their key, columns, indexes, and immutability.
Transitional monolith coexistence, Time Office backfill, validation, resume, and cutover boundaries.
Database-enforced and application-enforced Attendance integrity and transaction boundaries.
Source-backed guide to Attendance Service data ownership, persistence, tenancy, migrations, integrity, and testing.
Architecture and responsibilities of Attendance Service PostgreSQL and EF Core persistence.
Ownership boundaries among Attendance, Time Office, Employee, Payroll, Leave, and legacy persistence.
Verified inventory of Attendance contexts, objects, relationships, indexes, filters, migrations, and compatibility components.
Confirmed global query filters, scoped identifiers, and operational exceptions in Attendance persistence.
Safe test strategy for Attendance repositories, migrations, tenancy, transactions, and backfill.
Source-backed Attendance indexes, lookup patterns, no-tracking reads, and pagination gaps.
Verified Attendance migration sequence, startup application, model snapshot, and development seeding.
Transactional outbox persistence, relay state, and delivery boundary for Attendance integration events.
Policy and policy-rule persistence, constraints, assignment gaps, and foundation status.
Attendance policy and rule persistence, ownership, relationships, and constraints.
Source-backed attendance projection storage for the HR Suit Payroll Service.
Persistence model, ordering, tenancy, and current limitations of Attendance punches.
Source-backed attendance readiness storage for HR Suit onboarding and offboarding.
Confirmed persistence model and integrity boundaries for daily Attendance records.
Persistence and integrity boundaries for Attendance reopen requests.
Source-backed persistence of the asset audit-log and timeline evidence tables, their columns, tenant filtering, and save-boundary participation.
Attendance audit and timeline persistence, actor context, ordering, and semantic boundaries.
Source-backed audit and timeline storage for HR Suit onboarding and offboarding.
Source-backed audit and timeline storage for the HR Suit Payroll Service.
Source-backed technical audit and business timeline persistence and transaction participation.
Source-backed candidate and joining storage for HR Suit onboarding and offboarding.
Source-backed legacy-shaped persistence adapter, transition context, upsert behavior, resume markers, and parity checks.
Source-backed behavior of the CompatId compatibility identity on the Asset aggregate — runtime identity generation, backfill verbatim insertion, uniqueness, and lookup.
Source-backed compatibility persistence for HR Suit onboarding and offboarding.
Legacy-to-canonical persistence mapping, backfill identity, and cutover boundaries.
Verified duplicate protection, missing concurrency tokens, overlap races, and failure modes.
Source-backed concurrency and idempotency for HR Suit onboarding and offboarding.
Source-backed data integrity for HR Suit onboarding and offboarding.
Source-backed local savechanges atomicity, multi-save workflows, external boundaries, and enforcement limits.
Source-backed database limitations for HR Suit onboarding and offboarding.
Verified Workforce Scheduling database limitations grouped by required review area.
Source-backed database overview for HR Suit onboarding and offboarding.
Persistence ownership, bounded contexts, systems of record, and maturity.
Source-backed database source map for HR Suit onboarding and offboarding.
Traceability map from Workforce Scheduling database topics to verified source files.
Query filters, tenant fields, bypasses, and administrative access across scheduling contexts.
Verified migration, mapping, repository, backfill, parity, and missing database test coverage.
Source-backed database testing guide for HR Suit onboarding and offboarding.
Authoritative inventory of every verified DbContext relevant to Workforce Scheduling.
Source-backed dbcontexts and object sets for HR Suit onboarding and offboarding.
Source-backed development seeding for HR Suit onboarding and offboarding.
Verified development-only scheduling and calendar seed behavior.
Source-backed persistence of asset document-reference child rows that point at externally-owned Document Service content without storing bytes.
Stored assignment ranges and effective-policy lookup behavior.
Source-confirmed Employee Service persistence ownership, schema, tenancy, migrations, integrity, and compatibility boundaries.
Source-confirmed persistence, repositories, search, tenant context, audit, outbox, and background-processing behavior.
Attendance-local employee read-model persistence and its Employee Service boundary.
Source-backed employee profile storage for HR Suit onboarding and offboarding.
Source-backed employment and status storage for HR Suit onboarding and offboarding.
Source-backed entity mappings for HR Suit onboarding and offboarding.
Verified fluent mappings for scheduling and calendar entities.
Verified scheduling relationships, scalar references, and delete behavior.
Source-backed exit approval and history storage for HR Suit onboarding and offboarding.
Source-backed expense projection storage for the HR Suit Payroll Service.
Source-backed appraisalgoal child persistence, ownership, indexing, and integrity boundaries.
Source-backed Helpdesk persistence, mappings, tenant isolation, migrations, transactions, concurrency, seeding and database testing documentation.
Verified EF Core ownership, mapping, indexes and outbox unit of work.
Verified Leave and legacy holiday persistence and absence from canonical scheduling.
Source-backed indexes and constraints for HR Suit onboarding and offboarding.
Verified logical indexes and uniqueness constraints without physical database identifiers.
Source-backed verified indexes and source-confirmed read, report, history, compatibility, and outbox access patterns.
Source-backed keys and relationships for HR Suit onboarding and offboarding.
Verified Leave balance persistence, uniqueness, and lifecycle behavior.
Source-backed guide to Leave Service persistence, tenancy, migrations, integrity, and testing.
Architecture and responsibility of Leave Service persistence.
Verified Leave policy persistence and stored-versus-enforced behavior.
Source-backed leave projection storage for the HR Suit Payroll Service.
Source-backed leave readiness storage for HR Suit onboarding and offboarding.
Verified persistence model and lifecycle role of Leave requests.
Verified Leave type persistence and constraints.
Source-backed lifecycle persistence object reference for HR Suit onboarding and offboarding.
Authoritative logical inventory of verified Workforce Scheduling persistence entities.
Verified migration counts, model snapshots, design-time factories, and startup behavior.
Source-backed migration sequence, model snapshot, design-time support, and development-only seed behavior.
Source-backed migrations and snapshots for HR Suit onboarding and offboarding.
Source-backed notification and outbox storage for HR Suit onboarding and offboarding.
Source-backed persistence of the NotificationAuditLog table — the append-only stage trail, its 13 stages and its unbounded growth.
Verified absence of concurrency control in Notification persistence and the specific race windows the unique indexes do and do not close.
Source-backed Notification persistence documentation covering the NotificationDb schema, entities, mappings, indexes, query patterns, transactions, migrations and seeding.
Source-backed overview of Notification persistence: the owned database, schema, table count, index count and current maturity.
Source-backed persistence of the NotificationDeliveryAttempts table — the append-only per-attempt record and its truncation behavior.
Source-backed persistence of the ProcessedIntegrationEvents table — the idempotency ledger, its unique constraint and its check-then-write race window.
Source-backed persistence of the NotificationMessages table — columns, indexes, lifecycle and the absence of referential constraints.
Verified persistence model of the Notification Service and the absence of a repository abstraction.
Source-backed persistence of the NotificationPreferences table — the opt-out model, wildcard rows and the absence of any write path.
Source-backed persistence of the NotificationRecipients table — the upsert-merge directory keyed by tenant, type and external reference.
Source-backed persistence of retry state in Notification — attempt counters, attempt rows and the absence of a retry queue or dead-letter table.
Verified absence of a statistics table in Notification and the computed count queries that serve statistics instead.
Source-backed persistence of the NotificationTemplates table — versioning, the global-default convention and the uniqueness constraint.
Source-backed save boundaries in Notification — the many-small-saves pattern, the absence of explicit transactions and its partial-failure consequences.
Source-backed offer storage for HR Suit onboarding and offboarding.
Source-backed onboarding & offboarding database documentation for HR Suit onboarding and offboarding.
Source-backed onboarding task storage for HR Suit onboarding and offboarding.
Source-backed organization assignment storage for HR Suit onboarding and offboarding.
Source-backed persistence of the transactional outbox table, its columns, save-boundary participation, and the polling relay that drains it.
Source-backed transactional outbox persistence, polling, uniqueness, and relay boundary.
Source-backed payroll compatibility and transition storage for the HR Suit Payroll Service.
Source-backed payroll data integrity and transactions for the HR Suit Payroll Service.
Source-backed payroll database documentation for the HR Suit Payroll Service.
Source-backed payroll database overview for the HR Suit Payroll Service.
Source-backed payroll database ownership and boundaries for the HR Suit Payroll Service.
Source-backed payroll database testing guide for the HR Suit Payroll Service.
Source-backed payroll detail storage for the HR Suit Payroll Service.
Source-backed payroll indexing and query patterns for the HR Suit Payroll Service.
Source-backed payroll migrations and seeding for the HR Suit Payroll Service.
Source-backed payroll outbox storage for the HR Suit Payroll Service.
Source-backed payroll period storage for the HR Suit Payroll Service.
Source-backed payroll persistence object reference for the HR Suit Payroll Service.
Source-backed payroll readiness storage for HR Suit onboarding and offboarding.
Source-backed payroll run storage for the HR Suit Payroll Service.
Approved Attendance period snapshot persistence and Payroll consumption boundary.
Source-backed payroll tenant isolation for the HR Suit Payroll Service.
Source-backed payroll workforce storage for the HR Suit Payroll Service.
Source-backed payslip storage for the HR Suit Payroll Service.
Source-backed database documentation for HR Suit Performance.
Source-backed source-backed overview of performance persistence ownership and verified model totals.
Source-backed existing persistence test evidence and clearly separated recommended coverage.
Source-backed verified logical catalog of performance persisted objects without physical deployment details.
Source-backed global filters, child filtering, privileged context, and transition-tool exceptions.
Source-backed persistence architecture for HR Suit onboarding and offboarding.
Repository, unit-of-work, context, and compatibility persistence structure.
Source-backed persistence ownership and boundaries for HR Suit onboarding and offboarding.
Source-backed runtime, design-time, compatibility, and transition persistence boundaries.
Source-backed persistence of the processed-event idempotency ledger, modeled for future inbound consumption but unused at runtime today.
Source-backed processedintegrationevent ledger mapping and current absence of a local consumer.
Source-backed query patterns for HR Suit onboarding and offboarding.
Verified repository and resolver query patterns for scheduling persistence.
Source-backed owned storage for rating, weightage, cycleperiod, and reviewerref value objects.
Source-backed recruitment application storage for HR Suit Recruitment.
Source-backed recruitment audit and timeline storage for HR Suit Recruitment.
Source-backed recruitment candidate storage for HR Suit Recruitment.
Source-backed recruitment data integrity and transactions for HR Suit Recruitment.
Source-backed recruitment database compatibility and transition for HR Suit Recruitment.
Source-backed recruitment database documentation for HR Suit Recruitment.
Source-backed recruitment database overview for HR Suit Recruitment.
Source-backed recruitment database ownership and boundaries for HR Suit Recruitment.
Source-backed recruitment database tenant isolation for HR Suit Recruitment.
Source-backed recruitment database testing guide for HR Suit Recruitment.
Source-backed recruitment document reference storage for HR Suit Recruitment.
Source-backed recruitment indexing and query patterns for HR Suit Recruitment.
Source-backed recruitment interview feedback storage for HR Suit Recruitment.
Source-backed recruitment interview storage for HR Suit Recruitment.
Source-backed recruitment job opening storage for HR Suit Recruitment.
Source-backed recruitment migrations and seeding for HR Suit Recruitment.
Source-backed recruitment offer storage for HR Suit Recruitment.
Source-backed recruitment onboarding storage for HR Suit onboarding and offboarding.
Source-backed recruitment onboarding storage for HR Suit Recruitment.
Source-backed recruitment outbox storage for HR Suit Recruitment.
Source-backed recruitment persistence object reference for HR Suit Recruitment.
Source-backed recruitment processed event storage for HR Suit Recruitment.
Source-backed recruitment requisition storage for HR Suit Recruitment.
Repository ports, tenant-filtered data access, unit-of-work behavior, audit, timeline, and outbox persistence.
Source-backed resignation and exit storage for HR Suit onboarding and offboarding.
Source-backed retention and cleanup for HR Suit onboarding and offboarding.
Verified lifecycle retention and absence of cleanup jobs for scheduling data.
Source-backed persistence mapping for the reviewcycle aggregate and its logical appraisal association.
Source-backed appraisalreview child persistence and stage-history behavior.
Source-backed salary component storage for the HR Suit Payroll Service.
Effective-dated employee Shift assignment persistence and application-enforced overlap rules.
Effective-dated employee assignment persistence and query support.
Confirmed Shift persistence, compatibility identity, lifecycle, and assignment relationship.
Canonical and legacy shift persistence, lifecycle, indexes, and audit behavior.
Source-backed tenant isolation for HR Suit onboarding and offboarding.
Relationship model for shifts, weekly offs, policies, rules, and employee shift assignments.
Source-backed transactions and save boundaries for HR Suit onboarding and offboarding.
Verified save boundaries, implicit transaction scope, and partial-failure risks.
Verified enum, numeric, temporal, JSON, and compatibility value handling.
Source-backed value conversions and owned values for HR Suit onboarding and offboarding.
Tenant weekly-off representation, uniqueness, lifecycle, and relationship boundaries.
Canonical, Leave-owned, and legacy weekly-off persistence.
Verified append-only WorkflowAction persistence.
Verified audit-log and timeline persistence behavior.
Verified WorkflowCondition mapping and lifecycle.
Verified duplicate guards, unique constraints and absent optimistic concurrency.
Source-backed Workflow persistence, schema, mappings, tenancy, migrations, transactions, seeding and testing documentation.
Grouped verified Workflow persistence limitations.
Verified migration inventory, snapshot, factory and Development startup behavior.
Verified Workflow persistence ownership and maturity.
Verified repository, worklist, diagnostic and outbox query patterns.
Verified absence of Workflow cleanup, archival and retention behavior.
Authoritative one-row-per-entity Workflow schema inventory.
Verified repository-relative source map for Workflow database documentation.
Verified global query filters, administrative bypass and storage gaps.
Verified smoke coverage and missing database-specific tests.
Authoritative inventory of verified Workflow DbContext behavior.
Verified WorkflowDefinition mapping, constraints, tenancy and lifecycle.
Verified Development-only Workflow seed behavior.
Authoritative summary of verified fluent mappings.
Verified aggregate foreign keys and unmodeled reference boundaries.
Verified primary, unique, foreign-key and query-support indexes.
Verified WorkflowInstance persistence, indexes and lifecycle.
Verified transactional outbox mapping, relay queries and status saves.
Verified aggregate persistence lifecycle and save boundaries.
Verified idempotency-ledger schema and inactive consumer boundary.
Source-backed persistence of the workflow-instance reference on the Asset aggregate and the identifier-only boundary with the Workflow Service.
Source-backed persisted workflow correlation on appraisal and its external ownership boundary.
Verified WorkflowStep field mapping and stage-order index.
Verified WorkflowTask assignment, decision and worklist persistence.
Verified command, outbox, relay and seeding save boundaries.
Verified enum, structured JSON and timestamp compatibility mappings.
Verified WorkflowVersion persistence and ownership.
Source-backed database documentation for workforce scheduling persistence, mappings, isolation, migrations, compatibility, and testing.