Menu
Keep payroll as an external feed by staging workforce snapshots in StoreOps and loading reporting summaries through nightly SQL procedures and a DataSet-backed repository seam.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Squad branching model: main-only workflow with feature branches
{what this skill teaches agents}
Wire legacy .NET Framework service hosts through Enterprise Library-flavored appSettings so Unity, service location, exception policies, logging, and database aliases all hang off one configuration seam.
Build internal order-management Web Forms pages with ObjectDataSource, GridView, DetailsView, and ViewState-heavy filter handling.
Build a believable mid-2000s .NET data layer around connection catalogs, stored-procedure wrappers, DataSets, and repository facades.
Anchor store-ops workbench screens in separate StoreOps tables for order state, status snapshots, workforce alerts, and zone bulletins, with dispatch tickets linked back to orders.
| name | legacy-workforce-reporting-seam |
| description | Keep payroll as an external feed by staging workforce snapshots in StoreOps and loading reporting summaries through nightly SQL procedures and a DataSet-backed repository seam. |
| domain | services |
| confidence | high |
| source | earned |
Use this when the sample needs believable labor analytics without turning a store operations app into a fake HR suite. It fits legacy .NET stacks where SQLCMD deployment scripts, batch ETL, and repository wrappers should expose brittle seams instead of hiding them.
StoreOps tables with names that sound like nightly feed artifacts.Reporting tables from those StoreOps snapshots via numbered migration procedures so deployment order and ETL behavior stay obvious.DataSet-returning gateway, then map rows inside a repository so the batch layer does not hard-code report values.data\sqlserver\before\StoreOps\02-schema.sqldata\sqlserver\before\Reporting\04-service-procedures.sqlsrc\before\Fabrikam.EnterprisePizza.Data\Repositories\Reporting\WorkforceReportRepository.cssrc\before\Fabrikam.EnterprisePizza.Reporting.Batch\Program.cs