-- ============================================================================= -- Asset Management — tasks INSERT (pippa_task_manager.tasks) -- Single-statement; view_order auto-appends after MAX(view_order) for project_id=1 -- Schema-first: AST-SCHEMA-MIG owns all V1 CREATE TABLE migrations -- project_id=1, project_module_id=24, estimate_hours=3.00 each -- ============================================================================= -- If re-run fails on branch_name unique: delete prior Asset rows first, e.g. -- DELETE FROM tasks WHERE project_id = 1 AND branch_name LIKE '%asset%'; -- (or delete by the specific branch_name list) -- ============================================================================= INSERT INTO `tasks` ( `project_id`, `project_module_id`, `title`, `branch_name`, `view_order`, `type`, `description`, `estimate_hours`, `status`, `priority`, `due_date`, `qa_status`, `qa_comment`, `created_at`, `updated_at` ) SELECT 1, 24, v.title, v.branch_name, (SELECT COALESCE(MAX(t.view_order), 0) FROM `tasks` t WHERE t.project_id = 1) + v.ord AS view_order, v.type, v.description, 3.00, 'todo', v.priority, NULL, NULL, NULL, NOW(), NOW() FROM ( SELECT 1 AS ord, 'Phase 0 Plan Review & Sign-off' AS title, 'docs-asset-phase0-signoff' AS branch_name, 'Spike' AS type, '

Summary

As a product/tech owner, I want the Phase 0 plan formally signed so that implementation does not start on ambiguous scope.

Task serial

AST-1.0.1 — Phase 0 Plan Review & Sign-off · Spike

Depends on

—

Related tables / schema

No new tables. References plan §A–N and WBS 1.0.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

STOP gate

Plan accepted or change list published.

Task scope

Review ASSET_MANAGEMENT_IMPLEMENTATION_PLAN.md and ASSET_MANAGEMENT_WBS.md. Record sign-off in the plan header. Do not write application code.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 2 AS ord, 'Section N Decisions Log' AS title, 'docs-asset-section-n-decisions' AS branch_name, 'Spike' AS type, '

Summary

As a tech lead, I want every Section N ambiguity decided and written down so later phases do not invent rules.

Task serial

AST-1.0.2 — Section N Decisions Log · Spike

Depends on

AST-1.0.1

Related tables / schema

No new tables. Decision log in docs/asset-management/.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

STOP gate

All Phase 1 blockers decided (item master owner, location grain).

Task scope

Create/update DECISIONS.md with each decision, owner, date, and unblocked phase. Phase 1 blockers must be Done.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 3 AS ord, 'Phase STOP Gate Process' AS title, 'docs-asset-stop-gates' AS branch_name, 'Spike' AS type, '

Summary

As a tech lead, I want a repeatable STOP checklist per phase so work does not silently roll into the next phase.

Task serial

AST-1.0.3 — Phase STOP Gate Process · Spike

Depends on

AST-1.0.1

Related tables / schema

None.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Document STOP checklist template and attach to WBS. No code.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 4 AS ord, 'Release & Rollback Coordination' AS title, 'docs-asset-release-rollback' AS branch_name, 'Spike' AS type, '

Summary

As a release owner, I want rollback notes per phase so production enablement is reversible.

Task serial

AST-1.0.4 — Release & Rollback Coordination · Spike

Depends on

AST-1.0.1

Related tables / schema

References schema file; no DDL here.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Write release order and rollback per phase in docs. Coordinate with AST-1.12.0.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 5 AS ord, 'Full V1 Database Schema Lock (DDL Doc)' AS title, 'docs-asset-database-schema' AS branch_name, 'Spike' AS type, '

Summary

As the backend team, I want one locked DDL document for all V1 Asset tables so migrations do not invent columns.

Task serial

AST-SCHEMA-1 — Full V1 Database Schema Lock (DDL Doc) · Spike

Depends on

AST-1.0.2 (Phase 1 decisions)

Related tables / schema

All V1 tables listed in ASSET_MANAGEMENT_DATABASE_SCHEMA.md (see AST-SCHEMA-MIG for migrations).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Notes

Migrations are centralized in AST-SCHEMA-MIG. Feature cards must not ship domain CREATE TABLE migrations.

STOP gate

Schema DDL accepted.

Task scope

Review and lock ASSET_MANAGEMENT_DATABASE_SCHEMA.md. This card does NOT create Laravel migrations — that is AST-SCHEMA-MIG only.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 6 AS ord, 'Asset Module Skeleton — Backend' AS title, 'feature-asset-module-skeleton' AS branch_name, 'Backend' AS type, '

Summary

As a developer, I want the nwidart Asset module scaffolded so later stories and migrations have a home.

Task serial

AST-1.1.1 — Asset Module Skeleton — Backend · Feature

Depends on

AST-1.0.2, AST-SCHEMA-1

Related tables / schema

No domain tables in this card. Domain migrations = AST-SCHEMA-MIG.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

module:make Asset, enable in modules_statuses.json, RouteServiceProvider, empty ServiceProvider bindings, health route behind auth. Follow module-development-standard.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 7 AS ord, 'Asset V1 Full Schema Migrations — Backend' AS title, 'feature-asset-v1-schema-migrations' AS branch_name, 'Backend' AS type, '

Summary

As a backend developer, I want one migration set that creates all V1 Asset/Inventory tables so feature cards never invent schema.

Task serial

AST-SCHEMA-MIG — Asset V1 Full Schema Migrations — Backend · Feature

Depends on

AST-1.1.1, AST-SCHEMA-1

Related tables / schema

Creates ALL tables:

Out of scope for this card:

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Notes

After this card, feature BE cards use existing tables only (models/repos/services/APIs). No duplicate CREATE TABLE.

STOP gate

All V1 Asset tables exist in DB; rollback works; schema doc still matches.

Task scope

Implement Laravel migrations for every V1 Asset table listed in the schema doc. Register migrations via Asset module provider. Verify migrate + migrate:rollback. Eloquent models may be stubbed here or in feature cards — but CREATE TABLE belongs only here.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 8 AS ord, 'Asset Permissions Seed (actions.php)' AS title, 'feature-asset-permissions-seed' AS branch_name, 'Backend' AS type, '

Summary

As an admin, I want Asset module actions registered so RBAC can gate every Asset screen.

Task serial

AST-1.1.2 — Asset Permissions Seed (actions.php) · Feature

Depends on

AST-1.1.1

Related tables / schema

Uses platform actions / module_actions / permissions sync — no domain tables.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Add asset module section to backend/config/actions.php. Run sync. Feature test that permissions exist. No UI yet.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 9 AS ord, 'Asset Categories — Backend' AS title, 'feature-asset-categories-backend' AS branch_name, 'Backend' AS type, '

Summary

As an asset manager, I want category CRUD with a tree so items can be classified.

Task serial

AST-1.1.3 — Asset Categories — Backend · Feature

Depends on

AST-SCHEMA-MIG, AST-1.1.2

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: asset_categories (already migrated)
Columns

Unique: (company_id, code).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Model, repository+interface, service+interface, form requests, controller, resources, routes. Permissions asset.items.manage / view. Feature tests for unique, cycle, IDOR. Do not create migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 10 AS ord, 'Asset Units of Measure — Backend' AS title, 'feature-asset-units-backend' AS branch_name, 'Backend' AS type, '

Summary

As an asset manager, I want units of measure so quantity items have a consistent unit.

Task serial

AST-1.1.4 — Asset Units of Measure — Backend · Feature

Depends on

AST-SCHEMA-MIG

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: asset_units (already migrated)

Unique: (company_id, code).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Full Service-Repository CRUD API on existing table. Tests for uniqueness and company scope. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 11 AS ord, 'Asset Items + Tracking Mode — Backend' AS title, 'feature-asset-items-backend' AS branch_name, 'Backend' AS type, '

Summary

As an asset manager, I want an item master with SERIALIZED or QUANTITY tracking so the catalog drives both asset types.

Task serial

AST-1.1.5 — Asset Items + Tracking Mode — Backend · Feature

Depends on

AST-1.1.3, AST-1.1.4

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: asset_items (already migrated)

Unique: (company_id, code).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

CRUD API + validation on existing table. Enforce immutability in service. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 12 AS ord, 'Category Attributes — Backend' AS title, 'feature-asset-attributes-backend' AS branch_name, 'Backend' AS type, '

Summary

As an asset manager, I want category-specific custom attributes so laptops and vehicles do not share one flat column set.

Task serial

AST-1.1.6 — Category Attributes — Backend · Feature

Depends on

AST-1.1.3, AST-1.1.5

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Tables already migrated:

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

CRUD for definitions/options; set/get item attribute values. Validation service. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 13 AS ord, 'Asset Locations — Backend' AS title, 'feature-asset-locations-backend' AS branch_name, 'Backend' AS type, '

Summary

As an asset manager, I want floor/room/store locations under existing work locations so assets and stock have a physical place.

Task serial

AST-1.1.7 — Asset Locations — Backend · Feature

Depends on

AST-SCHEMA-MIG, AST-1.0.2 (location grain)

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: asset_locations (already migrated)

Unique: (company_id, code).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

CRUD API on existing table. Validate work_location belongs to company. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 14 AS ord, 'Asset Masters — Frontend' AS title, 'feature-asset-masters-frontend' AS branch_name, 'Frontend' AS type, '

Summary

As an asset manager, I want UI for categories, units, items, attributes, and locations so I can configure the catalog without API tools.

Task serial

AST-1.1.8 — Asset Masters — Frontend · Feature

Depends on

AST-1.1.2, AST-1.1.3, AST-1.1.4, AST-1.1.5, AST-1.1.6, AST-1.1.7

Related tables / schema

Consumes Phase 1 APIs. No new tables.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

frontend/src/modules/asset: nav, routes, list/form for category, unit, item, attributes, locations.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 15 AS ord, 'Phase 1 Tests + STOP' AS title, 'test-asset-phase1-stop' AS branch_name, 'QA' AS type, '

Summary

As a tech lead, I want Phase 1 proven and STOP signed so Phase 2 may start.

Task serial

AST-1.1.9 — Phase 1 Tests + STOP · QA

Depends on

AST-1.1.8, AST-SCHEMA-MIG

Related tables / schema

Phase 1 tables already from AST-SCHEMA-MIG; verify they exist and APIs work.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

STOP gate

Human confirms catalog, location grain, and AST-SCHEMA-MIG complete before feature work continues.

Task scope

Run/complete feature tests for Phase 1. Demo masters UI. Confirm all V1 tables migrated. Sign STOP on WBS 1.1.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 16 AS ord, 'Serialized Assets Registry — Backend' AS title, 'feature-asset-serialized-registry-backend' AS branch_name, 'Backend' AS type, '

Summary

As an asset custodian, I want individually identifiable assets with code, serial, cost, and location so I can manage physical instances.

Task serial

AST-1.2.1 — Serialized Assets Registry — Backend · Feature

Depends on

AST-1.1.9, AST-SCHEMA-MIG

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: serialized_assets (already migrated)

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

CRUD on existing table: create/update/view/list with filters. Cost fields gated by asset.finance.view. Activity log. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 17 AS ord, 'Serialized Asset Status Machine + Condition — Backend' AS title, 'feature-asset-status-machine-backend' AS branch_name, 'Backend' AS type, '

Summary

As a custodian, I want controlled status and condition transitions so assets do not jump into illegal states.

Task serial

AST-1.2.2 — Serialized Asset Status Machine + Condition — Backend · Feature

Depends on

AST-1.2.1

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Uses serialized_assets.status and condition columns (table already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

StatusTransition service + guards/endpoints. Tests for illegal jumps. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 18 AS ord, 'Serialized Asset Attribute Values — Backend' AS title, 'feature-asset-instance-attributes-backend' AS branch_name, 'Backend' AS type, '

Summary

As a custodian, I want instance-level attribute values so each laptop can store CPU/RAM etc.

Task serial

AST-1.2.3 — Serialized Asset Attribute Values — Backend · Feature

Depends on

AST-1.2.1, AST-1.1.6

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: serialized_asset_attribute_values (already migrated)

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Set/get values API. Validation. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 19 AS ord, 'Asset Tags Issue / Replace / Void — Backend' AS title, 'feature-asset-tags-backend' AS branch_name, 'Backend' AS type, '

Summary

As a custodian, I want QR/barcode tags with replace history so physical stickers resolve to the correct asset.

Task serial

AST-1.2.4 — Asset Tags Issue / Replace / Void — Backend · Feature

Depends on

AST-1.2.1

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Tables already migrated: asset_tags, asset_tag_events

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Issue/replace/void services + APIs. Permission asset.tags.issue. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 20 AS ord, 'QR Library Selection + Image Endpoint — Backend' AS title, 'feature-asset-qr-image-backend' AS branch_name, 'Backend' AS type, '

Summary

As a custodian, I want a QR image for a tag so I can print stickers.

Task serial

AST-1.2.5 — QR Library Selection + Image Endpoint — Backend · Feature

Depends on

AST-1.2.4

Related tables / schema

Uses asset_tags.token only (table already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Select library, composer dependency, GET image endpoint for active tag. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 21 AS ord, 'Label Print Single + Bulk — Backend/Frontend' AS title, 'feature-asset-label-print' AS branch_name, 'Fullstack' AS type, '

Summary

As a custodian, I want single and bulk label print so tagging drives are efficient.

Task serial

AST-1.2.6 — Label Print Single + Bulk — Backend/Frontend · Feature

Depends on

AST-1.2.5

Related tables / schema

Uses tags + serialized assets (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Print view/PDF or browser print for one and many assets.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 22 AS ord, 'Authenticated Scan Resolve — Backend' AS title, 'feature-asset-scan-resolve-backend' AS branch_name, 'Backend' AS type, '

Summary

As an authorized user, I want scanning a tag to return asset details filtered by my permissions.

Task serial

AST-1.2.7 — Authenticated Scan Resolve — Backend · Feature

Depends on

AST-1.2.4, AST-1.1.2

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Resolve via asset_tags.token → serialized_assets (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

GET scan endpoint + permission-aware Resource. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 23 AS ord, 'Serialized Assets List/Detail/Scan — Frontend' AS title, 'feature-asset-serialized-frontend' AS branch_name, 'Frontend' AS type, '

Summary

As a custodian, I want list, detail, and scan pages for serialized assets.

Task serial

AST-1.2.8 — Serialized Assets List/Detail/Scan — Frontend · Feature

Depends on

AST-1.2.1, AST-1.2.2, AST-1.2.3, AST-1.2.5, AST-1.2.7

Related tables / schema

Consumes 1.2 APIs. No new tables.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Asset list/filters, detail, scan page, print actions.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 24 AS ord, 'Phase 2 Tests + STOP' AS title, 'test-asset-phase2-stop' AS branch_name, 'QA' AS type, '

Summary

As a tech lead, I want Phase 2 STOP so Phase 3 feature work may proceed.

Task serial

AST-1.2.9 — Phase 2 Tests + STOP · QA

Depends on

AST-1.2.8

Related tables / schema

Phase 2 tables already from AST-SCHEMA-MIG.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

STOP gate

Confirm status list and serial mandatory/exceptions.

Task scope

Regression tests + demo create asset, print tag, scan. Sign STOP.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 25 AS ord, 'Inventory Transactions Ledger — Backend' AS title, 'feature-asset-inventory-transactions-backend' AS branch_name, 'Backend' AS type, '

Summary

As inventory, I want an append-only stock ledger so quantity changes are auditable.

Task serial

AST-1.3.1 — Inventory Transactions Ledger — Backend · Feature

Depends on

AST-1.1.9, AST-SCHEMA-MIG

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: inventory_transactions (already migrated)
Types include RECEIPT|ISSUE|TRANSFER_OUT|TRANSFER_IN|RETURN|ADJUSTMENT|DAMAGE|DISPOSAL|OPENING_BALANCE.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Model + repository insert-only methods on existing table. Pair with 1.3.2/1.3.4 for balance updates. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 26 AS ord, 'Inventory Balances Projection — Backend' AS title, 'feature-asset-inventory-balances-backend' AS branch_name, 'Backend' AS type, '

Summary

As inventory, I want a locked balance projection per item+location so stock queries are fast and safe.

Task serial

AST-1.3.2 — Inventory Balances Projection — Backend · Feature

Depends on

AST-1.3.1

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: inventory_balances (already migrated)

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Balance repository with lock helpers on existing table. Unit tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 27 AS ord, 'Asset Receipt Inbox — Backend' AS title, 'feature-asset-receipt-inbox-backend' AS branch_name, 'Backend' AS type, '

Summary

As the system, I want an idempotent receipt inbox so manual import and future GRN cannot double-post.

Task serial

AST-1.3.3 — Asset Receipt Inbox — Backend · Feature

Depends on

AST-1.3.1

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: asset_receipt_inbox (already migrated)

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Inbox repository on existing table for AssetReceiptService. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 28 AS ord, 'Inventory Ledger Service — Backend' AS title, 'feature-asset-ledger-service-backend' AS branch_name, 'Backend' AS type, '

Summary

As inventory, I want one service that posts receipt/issue/return/damage/disposal/opening movements correctly.

Task serial

AST-1.3.4 — Inventory Ledger Service — Backend · Feature

Depends on

AST-1.3.1, AST-1.3.2

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Writes inventory_transactions + updates inventory_balances (tables already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

InventoryLedgerServiceInterface + implementation. Activity log. Feature tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 29 AS ord, 'Inventory Location Transfer — Backend' AS title, 'feature-asset-inventory-transfer-backend' AS branch_name, 'Backend' AS type, '

Summary

As inventory, I want stock transfers between locations that cannot deadlock or go negative.

Task serial

AST-1.3.5 — Inventory Location Transfer — Backend · Feature

Depends on

AST-1.3.4

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Posts TRANSFER_OUT + TRANSFER_IN on existing ledger/balance tables.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Transfer API + service. Concurrency tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 30 AS ord, 'AssetReceiptService (Shared) — Backend' AS title, 'feature-asset-receipt-service-backend' AS branch_name, 'Backend' AS type, '

Summary

As the platform, I want one receipt application service for manual, import, and future GRN.

Task serial

AST-1.3.6 — AssetReceiptService (Shared) — Backend · Feature

Depends on

AST-1.3.3, AST-1.3.4, AST-1.2.1

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Uses inbox + serialized_assets OR ledger (all already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

AssetReceiptServiceInterface. Apply inbox line. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 31 AS ord, 'Manual Receipt — Backend + Frontend' AS title, 'feature-asset-manual-receipt' AS branch_name, 'Fullstack' AS type, '

Summary

As a custodian, I want to manually receive items into Asset/Inventory because Procurement/GRN does not exist yet.

Task serial

AST-1.3.7 — Manual Receipt — Backend + Frontend · Feature

Depends on

AST-1.3.6

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Creates inbox rows source_type=manual then applies via AssetReceiptService (tables already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

API + UI form. Show resulting asset codes or new balance. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 32 AS ord, 'Stock by Location — Frontend' AS title, 'feature-asset-stock-by-location-frontend' AS branch_name, 'Frontend' AS type, '

Summary

As inventory, I want to see on-hand quantity by item and location.

Task serial

AST-1.3.8 — Stock by Location — Frontend · Feature

Depends on

AST-1.3.2, AST-1.1.2

Related tables / schema

Reads inventory_balances (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

List/filter UI + API if list endpoint missing. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 33 AS ord, 'Phase 3 Tests (Concurrency) + STOP' AS title, 'test-asset-phase3-stop' AS branch_name, 'QA' AS type, '

Summary

As a tech lead, I want concurrency-safe stock proven before assignment/verification.

Task serial

AST-1.3.9 — Phase 3 Tests (Concurrency) + STOP · QA

Depends on

AST-1.3.5, AST-1.3.7, AST-1.3.8

Related tables / schema

Phase 3 tables already from AST-SCHEMA-MIG.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

STOP gate

Confirm negative stock policy and informational unit cost.

Task scope

Concurrency tests. Sign STOP.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 34 AS ord, 'Legacy Asset Data Analysis' AS title, 'spike-asset-legacy-analysis' AS branch_name, 'Spike' AS type, '

Summary

As a tech lead, I want a report of existing assets/employee_assets so the bridge cannot surprise us.

Task serial

AST-1.4.1 — Legacy Asset Data Analysis · Spike

Depends on

AST-1.0.2 (legacy decision), AST-1.2.9

Related tables / schema

Read-only: Employee assets, employee_assets.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

SQL/script + findings doc. Input to bridge.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 35 AS ord, 'Legacy Bridge Migration (One-way Copy)' AS title, 'feature-asset-legacy-bridge-migration' AS branch_name, 'Backend' AS type, '

Summary

As a tech lead, I want legacy assets copied into serialized_assets once so the new module becomes source of truth without dual registers.

Task serial

AST-1.4.2 — Legacy Bridge Migration (One-way Copy) · Feature

Depends on

AST-1.4.1, AST-1.2.1, AST-SCHEMA-MIG

Related tables / schema

Writes serialized_assets (legacy_asset_id). Optional ALTER employee_assets ADD serialized_asset_id — this is the ONLY allowed Employee table change in V1 Asset work.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Notes

Domain CREATE TABLE already done in AST-SCHEMA-MIG. This card is data copy + optional Employee ALTER only.

Task scope

Artisan command + dry-run. Optional nullable FK column on employee_assets only. Tests with fixtures.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 36 AS ord, 'Freeze Old Writer / Repoint Employee AssetTab' AS title, 'feature-asset-freeze-legacy-writer' AS branch_name, 'Backend' AS type, '

Summary

As HR/IT, I want the Employee Asset tab to stop creating legacy assets and use the new module so dual assignment cannot happen.

Task serial

AST-1.4.3 — Freeze Old Writer / Repoint Employee AssetTab · Feature

Depends on

AST-1.4.2, AST-1.4.4

Related tables / schema

May read serialized_assets via port; freeze EmployeeAssetService writes.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Feature-flag or hard switch; AssetTab calls Asset APIs. Same release as AST-1.4.4.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 37 AS ord, 'Asset Assignments — Backend' AS title, 'feature-asset-assignments-backend' AS branch_name, 'Backend' AS type, '

Summary

As a custodian, I want to assign a serialized asset to an employee or department with history preserved.

Task serial

AST-1.4.4 — Asset Assignments — Backend · Feature

Depends on

AST-1.2.9, AST-SCHEMA-MIG, AST-1.0.2 (legacy+proxy decisions)

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: serialized_asset_assignments (already migrated)

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Assign/return services + APIs on existing table. Permission asset.assets.assign. Tests. No CREATE TABLE migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 38 AS ord, 'Asset Handover Acknowledge/Reject/Proxy — Backend' AS title, 'feature-asset-handover-backend' AS branch_name, 'Backend' AS type, '

Summary

As an employee, I want to acknowledge receipt of an asset so custody is evidenced; as custodian I need proxy when the employee has no login.

Task serial

AST-1.4.5 — Asset Handover Acknowledge/Reject/Proxy — Backend · Feature

Depends on

AST-1.4.4

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: asset_handovers (already migrated)

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Handover APIs on existing table. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 39 AS ord, 'EmployeeDirectoryPort + EmployeeTimelinePort' AS title, 'feature-asset-employee-ports' AS branch_name, 'Backend' AS type, '

Summary

As the Asset module, I want ports to Employee so I never import Employee repositories directly.

Task serial

AST-1.4.6 — EmployeeDirectoryPort + EmployeeTimelinePort · Feature

Depends on

AST-1.4.4

Related tables / schema

No new Asset tables.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Integration contracts under Modules/Asset/Integration. Bind in provider. Tests with fake.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 40 AS ord, 'Employee Exit Outstanding Assets Report — Backend' AS title, 'feature-asset-exit-outstanding-report' AS branch_name, 'Backend' AS type, '

Summary

As HR, I want a list of outstanding assets for resigned/terminated employees so returns can be chased.

Task serial

AST-1.4.7 — Employee Exit Outstanding Assets Report — Backend · Feature

Depends on

AST-1.4.4, AST-1.4.6

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Reads assignments (already migrated) joined to employment status.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

API + Resource. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 41 AS ord, 'Employee Self Assets & Handovers — Backend' AS title, 'feature-asset-employee-self-view-backend' AS branch_name, 'Backend' AS type, '

Summary

As an employee, I want to see my assigned assets and pending handovers.

Task serial

AST-1.4.8 — Employee Self Assets & Handovers — Backend · Feature

Depends on

AST-1.4.5

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Filters assignments/handovers (already migrated) by authenticated employee.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Self endpoints. IDOR tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 42 AS ord, 'Assign / Return / Acknowledge — Frontend' AS title, 'feature-asset-assignment-frontend' AS branch_name, 'Frontend' AS type, '

Summary

As a custodian and employee, I want UI to assign, return, and acknowledge assets.

Task serial

AST-1.4.9 — Assign / Return / Acknowledge — Frontend · Feature

Depends on

AST-1.4.3, AST-1.4.5, AST-1.4.7, AST-1.4.8

Related tables / schema

Consumes 1.4 APIs.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Assign/return flows, handover UI, exit outstanding list.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 43 AS ord, 'Phase 4 Tests + STOP (Real Employee Check)' AS title, 'test-asset-phase4-stop' AS branch_name, 'QA' AS type, '

Summary

As a tech lead, I want one real employee’s legacy assignments appearing once and no dual writer.

Task serial

AST-1.4.10 — Phase 4 Tests + STOP (Real Employee Check) · QA

Depends on

AST-1.4.9

Related tables / schema

Assignments + handovers already migrated; bridge data verified.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

STOP gate

Real employee data check passed.

Task scope

Manual UAT + automated tests. Sign STOP.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 44 AS ord, 'Verification Sessions — Backend' AS title, 'feature-asset-verification-sessions-backend' AS branch_name, 'Backend' AS type, '

Summary

As an auditor, I want verification sessions that snapshot the expected set at start so later movements do not rewrite expectations.

Task serial

AST-1.5.1 — Verification Sessions — Backend · Feature

Depends on

AST-1.3.9, AST-SCHEMA-MIG

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: verification_sessions (already migrated)

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Create/start/cancel session APIs + snapshot builder on existing table. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 45 AS ord, 'Verification Lines + Results — Backend' AS title, 'feature-asset-verification-lines-backend' AS branch_name, 'Backend' AS type, '

Summary

As an auditor, I want lines that record found/missing/extra/wrong location/holder/damaged results.

Task serial

AST-1.5.2 — Verification Lines + Results — Backend · Feature

Depends on

AST-1.5.1

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: verification_lines (already migrated)

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Line update APIs. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 46 AS ord, 'Scan-to-Verify Flow — Backend' AS title, 'feature-asset-scan-to-verify-backend' AS branch_name, 'Backend' AS type, '

Summary

As an auditor, I want to scan a QR inside an open session to mark an asset found.

Task serial

AST-1.5.3 — Scan-to-Verify Flow — Backend · Feature

Depends on

AST-1.5.2, AST-1.2.7

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Uses tags + verification_lines (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Scan endpoint bound to session_id. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 47 AS ord, 'Quantity Stock Count + Variance — Backend' AS title, 'feature-asset-stock-count-backend' AS branch_name, 'Backend' AS type, '

Summary

As an auditor, I want to enter physical counts and see variance without changing the balance.

Task serial

AST-1.5.4 — Quantity Stock Count + Variance — Backend · Feature

Depends on

AST-1.5.2

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Quantity verification_lines (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Count entry API. Tests proving balances untouched. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 48 AS ord, 'Verification Complete & Review (Draft Adjustments Only)' AS title, 'feature-asset-verification-review-backend' AS branch_name, 'Backend' AS type, '

Summary

As a reviewer, I want to complete a session and create draft inventory adjustments without posting stock.

Task serial

AST-1.5.5 — Verification Complete & Review (Draft Adjustments Only) · Feature

Depends on

AST-1.5.3, AST-1.5.4

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

May write inventory_adjustments status=draft (table already migrated by AST-SCHEMA-MIG). Posting remains AST-1.6.4.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Notes

inventory_adjustments table already exists from AST-SCHEMA-MIG.

Task scope

Complete + review APIs. Create draft adjustment headers/lines without gateway submit. No CREATE TABLE.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 49 AS ord, 'Verification Session / Scan / Count — Frontend' AS title, 'feature-asset-verification-frontend' AS branch_name, 'Frontend' AS type, '

Summary

As an auditor, I want UI to run a verification session with scan and quantity count.

Task serial

AST-1.5.6 — Verification Session / Scan / Count — Frontend · Feature

Depends on

AST-1.5.5

Related tables / schema

Consumes 1.5 APIs.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Session list, start wizard, scan UI, quantity count UI, review screen.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 50 AS ord, 'Phase 5 Tests + STOP' AS title, 'test-asset-phase5-stop' AS branch_name, 'QA' AS type, '

Summary

As a tech lead, I want one scan session and one chair count demo with balances unchanged.

Task serial

AST-1.5.7 — Phase 5 Tests + STOP · QA

Depends on

AST-1.5.6

Related tables / schema

Verification tables already migrated.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

STOP gate

One scan session + one chair count accepted.

Task scope

UAT + tests. Sign STOP.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 51 AS ord, 'Asset Finance Events Outbox — Backend' AS title, 'feature-asset-finance-events-outbox' AS branch_name, 'Backend' AS type, '

Summary

As Finance (future), I want an outbox of acquisition/disposal/write_off intents without journals in Asset.

Task serial

AST-1.6.5 — Asset Finance Events Outbox — Backend · Feature

Depends on

AST-SCHEMA-MIG, AST-1.2.1

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: asset_finance_events (already migrated)

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Notes

Placed early so dispose/write-off/import can depend on it.

Task scope

Writer service used by disposal/write-off/receipt on existing table. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 52 AS ord, 'Asset Transfer Document + Approval Executor' AS title, 'feature-asset-transfer-approval' AS branch_name, 'Backend' AS type, '

Summary

As a custodian, I want asset transfers to go through ERPFlow approval before location/holder changes.

Task serial

AST-1.6.1 — Asset Transfer Document + Approval Executor · Feature

Depends on

AST-1.5.7, AST-1.4.10, AST-SCHEMA-MIG

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: asset_transfers (already migrated) + platform approval_requests.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Transfer document CRUD, gateway submit, TransferExecutor, register executor. Tests. No CREATE TABLE.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 53 AS ord, 'Asset Disposal Document + Approval Executor' AS title, 'feature-asset-disposal-approval' AS branch_name, 'Backend' AS type, '

Summary

As an asset manager, I want disposal requests approved before an asset becomes DISPOSED.

Task serial

AST-1.6.2 — Asset Disposal Document + Approval Executor · Feature

Depends on

AST-1.2.2, AST-1.6.5, AST-SCHEMA-MIG

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: asset_disposals (already migrated)

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Disposal document + DisposalExecutor. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 54 AS ord, 'Asset Write-off Document + Approval Executor' AS title, 'feature-asset-writeoff-approval' AS branch_name, 'Backend' AS type, '

Summary

As an asset manager, I want write-offs approved before WRITTEN_OFF status and finance outbox entry.

Task serial

AST-1.6.3 — Asset Write-off Document + Approval Executor · Feature

Depends on

AST-1.6.5, AST-SCHEMA-MIG

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: asset_write_offs (already migrated)

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

WriteOff document + executor. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 55 AS ord, 'Inventory Adjustment Document + Approval Executor' AS title, 'feature-asset-inventory-adjustment-approval' AS branch_name, 'Backend' AS type, '

Summary

As inventory, I want stock adjustments approved (when enabled) and posted only as ledger ADJUSTMENT rows.

Task serial

AST-1.6.4 — Inventory Adjustment Document + Approval Executor · Feature

Depends on

AST-1.5.5, AST-1.3.4, AST-SCHEMA-MIG

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Tables already migrated: inventory_adjustments, inventory_adjustment_lines

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Adjustment APIs through gateway to posted. AdjustmentExecutor. Tests. No CREATE TABLE.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 56 AS ord, 'Approval Module Actions + Executor Registration' AS title, 'feature-asset-approval-registration' AS branch_name, 'Backend' AS type, '

Summary

As an admin, I want Asset transfer/dispose/write-off/adjust-stock actions wired to the approval platform.

Task serial

AST-1.6.6 — Approval Module Actions + Executor Registration · Feature

Depends on

AST-1.6.1, AST-1.6.2, AST-1.6.3, AST-1.6.4

Related tables / schema

Platform approval_settings / module_actions.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

actions.php entries, provider registration, sync. Document how to attach workflows.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 57 AS ord, 'Asset Approval Requests — Frontend' AS title, 'feature-asset-approval-frontend' AS branch_name, 'Frontend' AS type, '

Summary

As a custodian, I want screens to request transfer/disposal/write-off/adjustment; as approver I use existing platform inbox.

Task serial

AST-1.6.7 — Asset Approval Requests — Frontend · Feature

Depends on

AST-1.6.6

Related tables / schema

Consumes document APIs; approvals via existing platform UI.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Request forms + document status pages.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 58 AS ord, 'Phase 6 Tests + STOP' AS title, 'test-asset-phase6-stop' AS branch_name, 'QA' AS type, '

Summary

As a tech lead, I want approval on/off, reject, stale, and double-dispose covered.

Task serial

AST-1.6.8 — Phase 6 Tests + STOP · QA

Depends on

AST-1.6.7

Related tables / schema

Phase 6 documents + outbox already migrated.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

STOP gate

Approver resolution confirmed; demos done.

Task scope

Automated tests + demo. Sign STOP.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 59 AS ord, 'Asset Service Providers — Backend' AS title, 'feature-asset-service-providers-backend' AS branch_name, 'Backend' AS type, '

Summary

As an asset manager, I want a minimal temporary provider list for warranties/AMC until a real vendor master exists.

Task serial

AST-1.7.1 — Asset Service Providers — Backend · Feature

Depends on

AST-1.0.2 (provider decision), AST-1.2.9, AST-SCHEMA-MIG

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: asset_service_providers (already migrated)

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

CRUD API on existing table. Permission contracts.manage. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 60 AS ord, 'Asset Warranties — Backend' AS title, 'feature-asset-warranties-backend' AS branch_name, 'Backend' AS type, '

Summary

As a custodian, I want warranty records with dates, provider, coverage, and optional file.

Task serial

AST-1.7.2 — Asset Warranties — Backend · Feature

Depends on

AST-1.7.1

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: asset_warranties (already migrated)

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

CRUD + file upload on existing table. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 61 AS ord, 'AMC Service Contracts + Covered Assets — Backend' AS title, 'feature-asset-service-contracts-backend' AS branch_name, 'Backend' AS type, '

Summary

As an asset manager, I want AMC/service contracts covering many assets without using Project contracts.

Task serial

AST-1.7.3 — AMC Service Contracts + Covered Assets — Backend · Feature

Depends on

AST-1.7.1, AST-1.2.1, AST-SCHEMA-MIG

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Tables already migrated: asset_service_contracts, asset_service_contract_assets

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Contract CRUD + attach/detach assets. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 62 AS ord, 'Service Contract Files — Backend' AS title, 'feature-asset-service-contract-files-backend' AS branch_name, 'Backend' AS type, '

Summary

As an asset manager, I want to attach documents to an AMC contract.

Task serial

AST-1.7.4 — Service Contract Files — Backend · Feature

Depends on

AST-1.7.3

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: asset_service_contract_files (already migrated)

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Upload/list/delete file APIs. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 63 AS ord, 'Warranty & AMC on Asset — Frontend' AS title, 'feature-asset-warranty-amc-frontend' AS branch_name, 'Frontend' AS type, '

Summary

As a custodian, I want warranty and AMC visible on the asset detail page.

Task serial

AST-1.7.5 — Warranty & AMC on Asset — Frontend · Feature

Depends on

AST-1.7.2, AST-1.7.3, AST-1.7.4

Related tables / schema

Consumes 1.7 APIs.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

UI sections on asset detail + provider/contract admin screens.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 64 AS ord, 'Phase 7 Tests + STOP' AS title, 'test-asset-phase7-stop' AS branch_name, 'QA' AS type, '

Summary

As a tech lead, I want overlapping warranty policy confirmed and contracts working.

Task serial

AST-1.7.6 — Phase 7 Tests + STOP · QA

Depends on

AST-1.7.5

Related tables / schema

Phase 7 tables already migrated.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

STOP gate

Overlapping coverage policy confirmed.

Task scope

Tests + STOP sign-off.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 65 AS ord, 'Opening Balance Import Template Design' AS title, 'docs-asset-import-template' AS branch_name, 'Spike' AS type, '

Summary

As an implementer, I want signed column templates for serialized, quantity, and optional warranty sheets.

Task serial

AST-1.8.1 — Opening Balance Import Template Design · Spike

Depends on

AST-1.3.9, AST-1.6.5

Related tables / schema

No tables. Spreadsheet columns map to existing schema.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

STOP gate

Template sign-off (also AST-1.8.8).

Task scope

Publish template xlsx + column dictionary. Human sign-off before production use.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 66 AS ord, 'Import Upload + Staging — Backend' AS title, 'feature-asset-import-staging-backend' AS branch_name, 'Backend' AS type, '

Summary

As an asset manager, I want to upload an opening file into staging batches/rows before anything is created.

Task serial

AST-1.8.2 — Import Upload + Staging — Backend · Feature

Depends on

AST-1.8.1, AST-SCHEMA-MIG

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Tables already migrated: asset_import_batches, asset_import_rows

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Upload API, batch/row repos on existing tables, Maatwebsite read. No CREATE TABLE.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 67 AS ord, 'Import Validation + Error Report — Backend' AS title, 'feature-asset-import-validation-backend' AS branch_name, 'Backend' AS type, '

Summary

As an asset manager, I want validation and an error report file so bad rows are fixed before confirm.

Task serial

AST-1.8.3 — Import Validation + Error Report — Backend · Feature

Depends on

AST-1.8.2

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Updates asset_import_rows / batches (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Validate action + Excel error export. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 68 AS ord, 'Import Confirm (All / Valid-only) + Queue — Backend' AS title, 'feature-asset-import-confirm-backend' AS branch_name, 'Backend' AS type, '

Summary

As an asset manager, I want an explicit confirm that creates assets/stock via AssetReceiptService without double posting.

Task serial

AST-1.8.4 — Import Confirm (All / Valid-only) + Queue — Backend · Feature

Depends on

AST-1.8.3, AST-1.3.6

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Confirm uses receipt inbox + domain tables (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Confirm API + job. Wire AssetReceiptService. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 69 AS ord, 'Acquisition Finance Events on Import Confirm' AS title, 'feature-asset-import-acquisition-events' AS branch_name, 'Backend' AS type, '

Summary

As Finance, I want acquisition outbox events created when opening assets with cost are confirmed.

Task serial

AST-1.8.5 — Acquisition Finance Events on Import Confirm · Feature

Depends on

AST-1.8.4, AST-1.6.5

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Writes asset_finance_events (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Hook in confirm path. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 70 AS ord, 'Import Reversal Script (Guarded)' AS title, 'feature-asset-import-reversal' AS branch_name, 'Backend' AS type, '

Summary

As a tech lead, I want a guarded reversal for a bad opening import that has not been assigned further.

Task serial

AST-1.8.6 — Import Reversal Script (Guarded) · Feature

Depends on

AST-1.8.4

Related tables / schema

Uses created_entity references on import rows; reversing ledger quantities.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Artisan command + safety checks + tests. No schema CREATE.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 71 AS ord, 'Opening Import Dry-run on Data Copy' AS title, 'ops-asset-import-dryrun' AS branch_name, 'Spike' AS type, '

Summary

As a release owner, I want a dry-run on a copy of real data before production import.

Task serial

AST-1.8.7 — Opening Import Dry-run on Data Copy · Spike

Depends on

AST-1.8.3

Related tables / schema

Uses staging only / disposable DB copy.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Run validate on copy data; attach results to STOP.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 72 AS ord, 'Phase 8 Tests + STOP (Template Sign-off)' AS title, 'test-asset-phase8-stop' AS branch_name, 'QA' AS type, '

Summary

As a tech lead, I want template signed and confirm path proven once.

Task serial

AST-1.8.8 — Phase 8 Tests + STOP (Template Sign-off) · QA

Depends on

AST-1.8.5, AST-1.8.7

Related tables / schema

Import tables already migrated.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

STOP gate

Template columns signed before any production file.

Task scope

Tests + template sign-off. Sign STOP.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 73 AS ord, 'Asset Service Events Thin Log — Backend' AS title, 'feature-asset-service-events-backend' AS branch_name, 'Backend' AS type, '

Summary

As a custodian, I want a thin maintenance history on an asset without building a CMMS.

Task serial

AST-1.9.1 — Asset Service Events Thin Log — Backend · Feature

Depends on

AST-1.7.6, AST-SCHEMA-MIG

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Table: asset_service_events (already migrated)

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Create/list APIs on existing table. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 74 AS ord, 'UNDER_MAINTENANCE Status Transitions — Backend' AS title, 'feature-asset-under-maintenance-status' AS branch_name, 'Backend' AS type, '

Summary

As a custodian, I want to mark an asset under maintenance and return it to AVAILABLE/ASSIGNED.

Task serial

AST-1.9.2 — UNDER_MAINTENANCE Status Transitions — Backend · Feature

Depends on

AST-1.2.2, AST-1.9.1

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

serialized_assets.status (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Extend status machine. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 75 AS ord, 'AssetContextPort for Future Maintenance' AS title, 'feature-asset-context-port' AS branch_name, 'Backend' AS type, '

Summary

As a future Maintenance module, I want a read port for asset status, warranty, and AMC.

Task serial

AST-1.9.3 — AssetContextPort for Future Maintenance · Feature

Depends on

AST-1.9.1, AST-1.7.2, AST-1.7.3

Related tables / schema

No new tables.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Interface + DTO + RealAssetContext + tests/fake.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 76 AS ord, 'Service History on Asset Page — Frontend' AS title, 'feature-asset-service-history-frontend' AS branch_name, 'Frontend' AS type, '

Summary

As a custodian, I want service history listed on the asset page.

Task serial

AST-1.9.4 — Service History on Asset Page — Frontend · Feature

Depends on

AST-1.9.1, AST-1.9.2

Related tables / schema

Consumes service events API.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

History panel + add event form.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 77 AS ord, 'Phase 9 Tests + STOP' AS title, 'test-asset-phase9-stop' AS branch_name, 'QA' AS type, '

Summary

As a tech lead, I want Phase 9 closed without CMMS scope creep.

Task serial

AST-1.9.5 — Phase 9 Tests + STOP · QA

Depends on

AST-1.9.4

Related tables / schema

service_events already migrated.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

STOP gate

History visible; port returns coverage; anti-scope held.

Task scope

Tests + STOP.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 78 AS ord, 'Finance Event Frozen Amount Rule' AS title, 'feature-asset-finance-frozen-amount' AS branch_name, 'Backend' AS type, '

Summary

As Finance, I want event amounts frozen at posting time so later asset cost edits do not rewrite history.

Task serial

AST-1.10.1 — Finance Event Frozen Amount Rule · Feature

Depends on

AST-1.6.5

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

asset_finance_events.amount immutable after insert (table already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Enforce in writer/repository. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 79 AS ord, 'AssetFinanceEventWriter Wiring' AS title, 'feature-asset-finance-event-writer' AS branch_name, 'Backend' AS type, '

Summary

As the Asset module, I want one writer used by receipt, disposal, and write-off paths.

Task serial

AST-1.10.2 — AssetFinanceEventWriter Wiring · Feature

Depends on

AST-1.10.1, AST-1.8.5, AST-1.6.2, AST-1.6.3

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

asset_finance_events (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Consolidate writer interface; ensure all three call sites use it. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 80 AS ord, 'Pending Finance Events Read API' AS title, 'feature-asset-finance-events-read-api' AS branch_name, 'Backend' AS type, '

Summary

As a finance reader, I want to list pending finance events without treating them as journals.

Task serial

AST-1.10.3 — Pending Finance Events Read API · Feature

Depends on

AST-1.10.2

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Reads asset_finance_events (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

List API + Resource. Permission asset.finance.view. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 81 AS ord, 'Cost Field Permission Enforcement' AS title, 'feature-asset-finance-view-permission' AS branch_name, 'Backend' AS type, '

Summary

As security, I want acquisition cost hidden from users without asset.finance.view.

Task serial

AST-1.10.4 — Cost Field Permission Enforcement · Feature

Depends on

AST-1.1.2, AST-1.2.7, AST-1.10.3

Related tables / schema

Affects Resources for serialized_assets and reports.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Resource transformers + FE gating audit. Tests. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 82 AS ord, 'Phase 10 Tests + STOP (Finance Sign-off)' AS title, 'test-asset-phase10-stop' AS branch_name, 'QA' AS type, '

Summary

As Finance owner, I confirm outbox is enough and depreciation is out of Asset.

Task serial

AST-1.10.5 — Phase 10 Tests + STOP (Finance Sign-off) · QA

Depends on

AST-1.10.4

Related tables / schema

finance_events already migrated.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

STOP gate

Finance confirms outbox sufficient.

Task scope

Sign-off note + tests. Sign STOP.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 83 AS ord, 'Asset Register Reports — Backend + Frontend' AS title, 'feature-asset-reports-register' AS branch_name, 'Fullstack' AS type, '

Summary

As a manager, I want asset register and by-employee / by-location / assignment history reports.

Task serial

AST-1.11.1 — Asset Register Reports — Backend + Frontend · Feature

Depends on

AST-1.4.10, AST-1.10.4

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

Read models from serialized_assets, assignments (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Report APIs + UI pages. No domain CREATE TABLE.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 84 AS ord, 'Verification Reports — Backend + Frontend' AS title, 'feature-asset-reports-verification' AS branch_name, 'Fullstack' AS type, '

Summary

As an auditor, I want verification results, missing, and wrong-location reports.

Task serial

AST-1.11.2 — Verification Reports — Backend + Frontend · Feature

Depends on

AST-1.5.7

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

verification_sessions/lines (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

APIs + UI. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 85 AS ord, 'Inventory Reports — Backend + Frontend' AS title, 'feature-asset-reports-inventory' AS branch_name, 'Fullstack' AS type, '

Summary

As inventory, I want on-hand, movement, variance, and adjustment history reports.

Task serial

AST-1.11.3 — Inventory Reports — Backend + Frontend · Feature

Depends on

AST-1.6.4, AST-1.3.9

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

balances, transactions, adjustments (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

APIs + UI. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 86 AS ord, 'Warranty/AMC Expiry + Acquisition Cost Lists' AS title, 'feature-asset-reports-expiry-cost' AS branch_name, 'Backend' AS type, '

Summary

As a manager, I want expiry lists and acquisition cost list as queries, not notifications.

Task serial

AST-1.11.4 — Warranty/AMC Expiry + Acquisition Cost Lists · Feature

Depends on

AST-1.7.6, AST-1.10.4

Related tables / schema

Tables already created by AST-SCHEMA-MIG. Do not add new migrations for these tables in this card. Models/repos only.

warranties, contracts, cost fields (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

APIs + UI. No migration.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 87 AS ord, 'Streaming Export for Asset Reports' AS title, 'feature-asset-reports-export' AS branch_name, 'Backend' AS type, '

Summary

As a manager, I want large report exports that do not OOM.

Task serial

AST-1.11.5 — Streaming Export for Asset Reports · Feature

Depends on

AST-1.11.1, AST-1.11.3

Related tables / schema

Read-only exports.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Export endpoints for key reports. Tests. No domain schema.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 88 AS ord, 'Index Tuning (Measured Only)' AS title, 'feature-asset-index-tuning' AS branch_name, 'Backend' AS type, '

Summary

As a developer, I want indexes only where EXPLAIN shows sequential scans on real queries.

Task serial

AST-1.11.6 — Index Tuning (Measured Only) · Feature

Depends on

AST-1.11.1, AST-1.11.3

Related tables / schema

Index migrations only (exception to AST-SCHEMA-MIG). Reason documented per index.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Notes

Allowed follow-up migrations: ADD INDEX only. No new tables.

Task scope

Measure report/list queries; add justified indexes only.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 89 AS ord, 'Security Pass (Cost Columns + Company Scope)' AS title, 'test-asset-security-pass' AS branch_name, 'QA' AS type, '

Summary

As security, I want IDOR and cost leakage tested across Asset APIs.

Task serial

AST-1.11.7 — Security Pass (Cost Columns + Company Scope) · QA

Depends on

AST-1.11.1, AST-1.10.4

Related tables / schema

All Asset APIs.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Test suite + checklist. Fix blockers found.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 90 AS ord, 'Concurrency Regression Suite' AS title, 'test-asset-concurrency-regression' AS branch_name, 'QA' AS type, '

Summary

As a tech lead, I want Phase 3 concurrency tests still green after later phases.

Task serial

AST-1.11.8 — Concurrency Regression Suite · QA

Depends on

AST-1.3.9, AST-1.4.10, AST-1.6.8

Related tables / schema

ledger/balances/assignments already migrated.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

CI suite card.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 91 AS ord, 'Phase 11 STOP — Report List Acceptance' AS title, 'test-asset-phase11-stop' AS branch_name, 'QA' AS type, '

Summary

As a product owner, I accept the V1 report list before further performance rewrites.

Task serial

AST-1.11.9 — Phase 11 STOP — Report List Acceptance · QA

Depends on

AST-1.11.5, AST-1.11.7, AST-1.11.8

Related tables / schema

Reports only.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

STOP gate

Report list accepted.

Task scope

Sign STOP on report list.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 92 AS ord, 'Feature Flags / Module Enable Order' AS title, 'docs-asset-enable-order' AS branch_name, 'Spike' AS type, '

Summary

As a release owner, I want a safe enable order for Asset in production.

Task serial

AST-1.12.0 — Feature Flags / Module Enable Order · Spike

Depends on

AST-1.0.4

Related tables / schema

modules_statuses + flags. Schema already migrated before enable.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Runbook in docs/asset-management.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 93 AS ord, 'Asset Module Documentation' AS title, 'docs-asset-module-guides' AS branch_name, 'Docs' AS type, '

Summary

As a developer/user, I want module and API docs for Asset.

Task serial

AST-1.12.1 — Asset Module Documentation · Docs

Depends on

AST-1.11.9

Related tables / schema

N/A.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

User guide outline + API notes. Update docs/README.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 94 AS ord, 'UAT per Phase' AS title, 'qa-asset-uat-tracker' AS branch_name, 'QA' AS type, '

Summary

As QA, I want a UAT tracker covering each phase STOP demo.

Task serial

AST-1.12.2 — UAT per Phase · QA

Depends on

AST-1.1.9 through AST-1.11.9 (rolling)

Related tables / schema

N/A.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Checklist + execution across environments.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 95 AS ord, 'Production Data Migration (Bridge + Opening Import)' AS title, 'ops-asset-production-migration' AS branch_name, 'Spike' AS type, '

Summary

As a release owner, I want production bridge and opening import executed with rollback plan.

Task serial

AST-1.12.3 — Production Data Migration (Bridge + Opening Import) · Spike

Depends on

AST-1.4.10, AST-1.8.8, AST-1.12.0

Related tables / schema

Uses bridge command + import confirm. Schema already from AST-SCHEMA-MIG.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Ops execution using AST-1.4.2 and AST-1.8.* runbooks.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 96 AS ord, 'Physical Label Printing & Tagging Drive' AS title, 'ops-asset-tagging-drive' AS branch_name, 'Spike' AS type, '

Summary

As operations, I want a physical tagging drive after labels print.

Task serial

AST-1.12.4 — Physical Label Printing & Tagging Drive · Spike

Depends on

AST-1.2.6, AST-1.12.3

Related tables / schema

Uses tags (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Ops checklist; not a code feature.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 97 AS ord, 'First Physical Verification Cycle' AS title, 'ops-asset-first-verification' AS branch_name, 'Spike' AS type, '

Summary

As operations, I want the first real verification cycle after tagging.

Task serial

AST-1.12.5 — First Physical Verification Cycle · Spike

Depends on

AST-1.12.4, AST-1.6.8

Related tables / schema

verification sessions (already migrated).

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Ops execution of Phase 5/6 flows on live data.

Definition of done

Architecture constraints

' AS description, 'high' AS priority UNION ALL SELECT 98 AS ord, 'User Training (Roles)' AS title, 'docs-asset-user-training' AS branch_name, 'Docs' AS type, '

Summary

As an org, I want training for manager, custodian, auditor, and employee roles.

Task serial

AST-1.12.6 — User Training (Roles) · Docs

Depends on

AST-1.12.1

Related tables / schema

N/A.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Task scope

Short training outlines / sessions.

Definition of done

Architecture constraints

' AS description, 'medium' AS priority UNION ALL SELECT 99 AS ord, 'Future Roadmap Tracker (Out of V1)' AS title, 'docs-asset-future-roadmap' AS branch_name, 'Spike' AS type, '

Summary

As a product owner, I want out-of-V1 items listed so they are not scheduled into V1 phases.

Task serial

AST-1.13 — Future Roadmap Tracker (Out of V1) · Spike

Depends on

AST-1.0.1

Related tables / schema

None for V1.

DDL reference: docs/asset-management/ASSET_MANAGEMENT_DATABASE_SCHEMA.md

Business rules

Notes

OUT OF V1

Task scope

Keep as backlog epic only. No implementation under V1.

Definition of done

Architecture constraints

' AS description, 'high' AS priority ) AS v ORDER BY v.ord; -- Total rows: 99 -- Sum estimate_hours: 297.00 (99 × 3.00)