Data & Screen Reference
A technical map of the module for administrators and support staff: the routes each page lives at, the fifteen database tables, the status vocabularies used across cases and their child items, and the controllers, cron jobs, seeder, and test command that make it run.
Routes
All routes are owned by the module and sit behind the offboarding URL prefix.
| URL | Page |
|---|---|
offboarding/checklist | Case list and workspace (default landing page). |
offboarding/checklist/view/{id} | A single offboarding case (the five-tab case page). |
offboarding/automation | Versioned workflow definitions, dry runs, run history. |
offboarding/setups | Templates, separation types, task catalog, sign-offs, SLA, connectors, settings. |
Database tables (15)
All tables are created by the module migration and tracked in migrations_offboarding.
| Table | Holds |
|---|---|
offboarding_cases | The parent case — one per departure. |
offboarding_case_tasks | Checklist tasks instantiated on a case. |
offboarding_case_assets | Assets endorsed to the leaver and their recorded outcome. |
offboarding_case_access_actions | Account/access actions and their verification state. |
offboarding_case_signoffs | Department sign-off requests and decisions. |
offboarding_case_events | The immutable case activity/audit log. |
offboarding_separation_types | System and tenant-defined separation types. |
offboarding_task_definitions | The reusable task catalog. |
offboarding_templates | Checklist template headers. |
offboarding_template_versions | Immutable published (and draft) template versions. |
offboarding_template_tasks | Tasks belonging to a template version. |
offboarding_signoff_definitions | Sign-off gate definitions and resolvers. |
offboarding_connectors | Integration connector configuration (secrets encrypted). |
offboarding_automation_runs | Each automation/workflow execution. |
offboarding_automation_attempts | Per-run attempts (for retries and history). |
Status vocabularies
Case status
draft scheduled in progress on hold blocked ready for clearance completed exception closed cancelled
Task status
pending ready in progress completed blocked failed skipped cancelled
Asset outcome
returned transferred lost damaged waived
Access action status
planned scheduled awaiting verification completed failed cancelled
Sign-off status
pending requested approved rejected
Controllers
| Controller | Serves |
|---|---|
Offboarding | The Checklist — case list, case page, and case actions. |
Offboarding_automation | The Automation page — versions, dry runs, run history. |
Offboarding_setups | The Setups page — templates, types, catalog, sign-offs, SLA, connectors, settings. |
Cron jobs
| Slug | Schedule | Role |
|---|---|---|
offboarding_scheduler | Every 10 minutes (*/10 * * * *) | Releases due work and progresses case state. |
offboarding_reminders | Hourly (0 * * * *) | Sends reminders and raises escalations. |
Both jobs require a ticking Advanced Cron runtime (server cron calling php erpat cron:tick,
or a manual tick).
Seeder
The demo seeder loads reversible sample data.
php erpat db:seed OffboardingDemo # load sample data
php erpat db:seed OffboardingDemo --remove # soft-delete the sample dataTests
The module ships its own PHPUnit suite (run only by the module test runner, not the core suite).
php erpat module:test Offboarding