Individual skill

atlas-commerce-ops-scorecard

Solve Atlas Commerce Operations analytical scorecard, reconciliation, and data-correction requests against the authenticated workplace SQL service. Use when a task gives a business request JSON + an answer-template JSON and asks you to compute fulfillment, refund, carrier-quality, warehouse-productivity, or support-health metrics from the Atlas Operations database. Covers cohort scoping, snapshot-vs-event-history authority, raw/canonical fields, minor-unit money + FX, the controlled correction transaction, and the support active-time clock.

experiments/claude_code_glm_5_2_max/reports/skills/task_group_022/reflect-3/reflect-3_attempt_02/SKILL.md

Read pinned source

Source commit 5082a777379156a048881e94940d640702e5e09a

What was checked

Matches the observed repository HEAD
Yes
Scanner rules are current
Yes
Repository scan complete
No
Skill scan complete
No
Observed behavior
Instructions only
Last checked
Nov 6, 2026

These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.

Install this skill

Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.

An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.

Repository context

Repository stars (not skill ratings)
121
Repository last updated
Oct 29, 2026
License
Apache-2.0

Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.

Files and excerpt

File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.

Browse files
Read excerpt

# Atlas Commerce Operations Scorecard & Reconciliation

## When to use

A request provides a **business request object** (scope, definitions, rules) and an **answer template JSON** (a schema with required fields, units, rounding, and ordering). The job is to compute the requested metrics from the Atlas Commerce Operations database and write one JSON object that conforms to the template *exactly* (no extra fields, no commentary). Requests are analytical (read-only) unless an approved data correction is explicitly requested.

## Environment

- Authenticated HTTP service (base URL and bearer token are given per environment in the access doc).
- `GET /api/schema` — table DDL.
- `GET /api/data-dictionary` — column descriptions and conventions.
- `GET /api/correction-audit` — public audit rows for applied corrections.
- `POST /api/sql` — read-only `SELECT`/`WITH` queries. Body `{"sql": "...", "params": [...]}`.
- `POST /api/sql/transaction` — controlled multi-statement transaction (only when a correction is requested). Body `{"statements": [{"sql","params"}], "expected_total_changes": N}`.