Mappings

Every data point across projects

The dimensions, objects, and derivations the organization consolidates from every connection, how source values reconcile into them, and where each one comes from.

Master Consolidated View
Mapping Reconciliation / Labor costs

Labor costs

ADP pay and Sage job cost kept as actual and standard cost, with the burden rate and the timesheet tying pay to work orders.

5 approved3 need review
Configuration
Business object · reads 3 connections
Reconciles into
Labor CostsLABOR_COSTS
2 canonical values · 8 treatments
Match key
employee_idpay_period_endwork_order_id
Rows that share these values from different sources become one row.
Precedence
  1. 1ADP Workforce NowWins
  2. 2Sage 300 CRE
  3. 3AboutTime
When two sources disagree, the first one wins.
Canonical values
2 targets. Every approved treatment resolves to one of these.
  • ActualACTUAL
    Gross pay plus burden, allocated by timesheet
    5 values
  • StandardSTANDARD
    Sage job cost at the standard loaded rate
    2 values
Tell Eagle how to reconcile
Plain English. Eagle re-treats the matching rows and says what it did.
Instructions in effect
Nothing yet. Anything you say is applied to the table and kept for new source values.
    Select rows to preview how they combine into a canonical value. Click a source value to inspect or edit its treatment. Hover a confidence to see why.