Skills
.Work. You
Rest

workday-roster-validator

Community

Validate Workday changes vs downstream rosters

Data & Analytics#normalization#reconciliation#roster#data-quality#excel-report#workday#hr-data
Authorjac007x
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Validates whether Workday Worker Change History proposed values have propagated into downstream ARS/PowerBI rosters. It joins on WIN (Associate ID), normalizes field values, and flags mismatches while producing an auditable three-sheet Excel reconciliation report.

Core Features & Use Cases

  • Cross-row field-level reconciliation: aggregates all proposed values per associate, normalizes them, and compares to the live roster.
  • Location and code normalization: handles Workday location formats, job codes with country prefixes, and manager/name variants to reduce spurious diffs.
  • Automated reporting: outputs a three-sheet Excel reconciliation with Summary, Reconciliation Detail, and Action Required sections for easy review.
  • Use Case: run after a Workday batch to verify propagation to downstream systems and escalate discrepancies.

Quick Start

Run reconcile.py with your Workday change report and ARS roster to generate a reconciliation Excel file.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: workday-roster-validator
Download link: https://github.com/jac007x/CheatCodes-Skill-Library/archive/main.zip#workday-roster-validator

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.