Migration route

    PeopleSoftWorkday

    PeopleSoft to Workday Data Migration

    Migrate workers, job data, compensation from Oracle PeopleSoft to Workday HCM using a controlled process for extraction, mapping, transformation, validation, loading and reconciliation.

    Migration overview

    PeopleSoft to Workday is a cross-vendor HCM replacement between two systems that both model history properly — and model it differently. PeopleSoft keeps effective-dated, effective-sequenced rows; Workday reconstructs history through dated events processed by business processes.

    That difference is the migration. The work is not moving fields, it is replaying a PeopleSoft history as a sequence of Workday events that produce the same end state.

    Typical data scope

    Scope is agreed in discovery. On this route it usually covers:

    Workers

    Domain in scope for a typical PeopleSoft to Workday programme.

    Job data

    Domain in scope for a typical PeopleSoft to Workday programme.

    Compensation

    Domain in scope for a typical PeopleSoft to Workday programme.

    Absence

    Domain in scope for a typical PeopleSoft to Workday programme.

    Organisational structure

    Domain in scope for a typical PeopleSoft to Workday programme.

    Migration architecture

    One controlled pipeline, run as repeatable cycles.

    PeopleSoftDataMoveTransformation & validationWorkdayDataVault reconciliationDataLens

    Extracting from PeopleSoft

    What the source platform makes available, and the constraints that shape the extraction design.

    Effective-dated rows are the data modelPeopleSoft stores history as effective-dated, effective-sequenced rows. JOB in particular is a row per change, and the current record is whichever row is latest as at a date — not a flag. Extracting only current state throws away the history most HCM targets want.
    SetID and TableSet sharingReference data is scoped by SetID, so the same department or job code can mean different things in different business units. Flatten it and organisational structure silently merges.
    Translate valuesShort codes validate against the translate table rather than storing labels. Pulled with the transactions or the target inherits codes nobody can interpret.
    EMPLID, EMPL_RCD and concurrent jobsA worker is EMPLID plus employment record number. Someone with two concurrent jobs is two rows, and treating EMPLID as the unique key collapses them.
    Component interfaces vs direct SQLComponent interfaces apply PeopleSoft's own business rules and are slow at volume; direct SQL against the tables is fast and bypasses those rules. Migration extraction generally reads the tables, which means the rules have to be reimplemented in validation.
    Custom and bolt-on recordsA long-lived PeopleSoft estate carries customised records and bolt-ons holding data the business depends on. Profiling finds them; a standard object list does not.

    Source-to-target mapping

    A mapping workbook carries every field in scope from its PeopleSoft source through its transformation rule to the Workday target object and field. It is reviewed and approved with the business before the production migration, and applied identically in every cycle so a decision made once is not re-made under cutover pressure.

    Transformation challenges on this route

    The differences between PeopleSoft and Workday that create most of the work.

    History becomes a sequence of events

    A PeopleSoft JOB row is a fact. In Workday the equivalent is a staged event — a hire, a transfer, a job change — with its own effective date and business process. The migration converts rows into an ordered event stream.

    EMPLID plus EMPL_RCD to worker

    Concurrent jobs are separate PeopleSoft rows and must be expressed in Workday's own model for multiple positions rather than collapsed onto one worker.

    SetID-scoped reference data

    Departments, jobs and locations scoped by SetID can mean different things in different business units, and flattening them merges structure that should stay separate.

    Supervisory organisations, not departments

    Workday's organisational model is not a department tree. The PeopleSoft structure is re-expressed as supervisory organisations before any worker can be staged.

    Business process configuration gates the load

    A load that ignores the configured process either fails validation or leaves events awaiting approval, which looks like missing data.

    How Workday accepts the data

    Load order is part of the design, not an implementation detail.

    1. 1Foundation before workersSupervisory organisations, locations, job profiles, cost centres and compensation structures. Workday will not stage a worker into an organisation that does not exist.
    2. 2Choose EIB or Core Connector per objectEnterprise Interface Builder handles spreadsheet-shaped bulk loads against a web service; Core Connectors and Workday Studio cover the higher-volume and more complex integrations. Object volume and complexity decide which.
    3. 3Loads run as business processesThis is the difference that surprises teams coming from ERP. A Hire in Workday is a business process, not an insert. It has steps, conditions and approvals, and a load that ignores the process configuration either fails or leaves events sitting in flight.
    4. 4Staged hires and effective datingWorkers are commonly staged with a hire event and effective dates that reconstruct history, which means the load order follows the timeline as well as the dependency graph.
    5. 5Positions and supervisory hierarchyPosition management, where used, requires positions before workers; supervisory organisation assignment then rebuilds the reporting structure.
    6. 6Compensation after employmentCompensation plans and grades resolve against structures loaded earlier, so compensation is a later pass rather than a column on the worker load.
    7. 7Work the EIB error outputEach load returns per-row results. Failures are categorised against the business process or the validation that rejected them, corrected and reloaded.

    Treating a Workday load like an ERP insert is the single most common cause of a failed first cycle. Events, effective dating and the business process framework decide what a load actually does.

    Validation and reconciliation

    Validation before load

    Mandatory fields, referential integrity, format checks, business-rule validation and duplicate detection run on the prepared data, so problems surface as reportable exceptions rather than as failed loads in Workday.

    Reconciliation after load

    Source counts, transformed counts, rejected records and target counts, with control totals where the data supports them. Every discrepancy is categorised so the migration is approved on evidence rather than assertion.

    Migration cycles

    The pipeline is run end to end more than once before anything touches production. A typical structure is a first rehearsal that surfaces the bulk of mapping and data-quality corrections, a second that applies them and demonstrates production readiness, and the production cutover itself. How many cycles a programme needs depends on data quality and scope, which is established during discovery.

    1. 1Mock / PPR 1First full extract, transform, load, reconcile and exception analysis. Expect the largest correction list here.
    2. 2Mock / PPR 2Corrections applied, re-extract, re-run. Intended to closely replicate the production migration.
    3. 3Production cutoverFinal extract, data freeze, load, reconciliation, business validation and sign-off.

    Common risks on this route

    Event sequencing wrong

    Out-of-order events produce a worker whose current state is right and whose history is nonsense.

    Customised PeopleSoft records missed

    Bolt-ons hold data the business depends on and appear in no standard object list.

    Absence balances assumed

    Accrual balances are employee-visible on day one and are reconciled explicitly.

    Planning this migration?

    Tell us your source system, target platform, modules, data volumes and timeline. We can discuss the closest relevant migration experience and the recommended approach.