Action items should be in a table with pipe delimiters.

action_required should be true for this email.

actions_log.json must exist.

When the adapter raises, error is captured in the result.

users should get avatar_url column.

comments should get is_edited column.

users should get is_verified column.

comments should get parent_id column.

posts should get published_at column.

posts should get slug column.

There should be at least 3 added elements detected.

Each address must have the correct city.

Each address must have the correct state.

Each address must have the correct street.

Each address must have the correct zip.

addresses should have exactly 8 rows.

All address user_ids should reference existing users_new rows.

Analysis must address the vague performance requirements.

addresses table must exist after migration.

Analysis must address the vague timeline.

Analysis must address at least one vague quantity like 'large number' or 'reasonable period'.

Files older than 7 days must be marked for rotation.

Must contain an Agenda section with all 5 items.

At least 2 rounds of developer + reviewer logs must exist.

Review logs must contain substantive content, not just placeholders.

aggregated_results.json must exist.

Aggregation must cover Electronics, Clothing, and Books.

aggregation.json must exist.

Aggregation must have groups.

Aggregation revenue values must be approximately correct.

Each alert must have required fields.

All alert severities must be valid values.

alerts.json must exist.

Check that algorithm doesn't have obvious exponential patterns.

Spot-check: Alice Chen's address should be fully parsed.

Alice should be blocked.

Alice should have 2 completed items.

Alice Zhang Electronics revenue should be ~89.97 (3 * 29.99).

Alice's email must be updated to alice@newmail.com.

Alice should be late on 2026-03-10 and 2026-03-12.

Alice should have 2 late days.

Alice appears 3 times; latest signature should contain 'Security Team Lead'.

Alice's phone must be updated to 555-0101.

Alice punctuality_rate should be 0.60.

Alice total_hours should be approximately 41.75.

All 20 rules must be checked.

All returned salaries must be greater than 80000.

All expense amounts must be numbers, not strings.

All 8 applications must be in the output.

All 7 team members from CSV must be in the report.

All 6 dangerous files must be flagged.

All original data values must be present.

All 12 data entries must be present.

All deadlines should be valid dates in March 2026.

All directories must appear in the tree.