Workforce schedule exceptions across systems: a map of WFM, telephony, ticketing and HR records and the keys that join them

Short answer

Reconstructing a workforce schedule exception takes four links: a shared clock (interval start against ticket and contact timestamps), a shared queue or skill name, a ticket number in each override note that points to the cause, and an approver recorded on the schedule change. Add a kept version of the forecast and schedule in force at the time, and one exception can be rebuilt across the WFM platform, telephony, ticketing, HR and payroll. Missing any link turns a decision into a guess.

Visual briefFull-size diagram
Five system nodes, WFM platform, telephony, ticketing, HR and payroll, and team chat, arranged around one joined case; keys labeled interval and queue, contact ID and queue, employee ID and ticket number travel along the links to join it, with a weaker timestamp-only link from team chat.
Illustrative map. Each key is the field that has to survive an export for one exception to be rebuilt.

This map is part of the workforce schedule exceptions guide, which covers the renewal inventory. It answers a narrower question: where each record lives and how they join.

Five systems, one exception day

A schedule exception rarely lives in one tool. The plan is in the WFM platform. The demand that broke it is in the telephony or contact platform. The cause is in ticketing. The money and hours are in HR and payroll. And in many operations, the approval itself happened in team chat or email.

Each system counts differently. WFM counts by interval and queue; telephony counts by contact; ticketing counts by ticket and tag; payroll counts by employee and pay period. The joins are therefore not one shared ID but a combination: time plus queue plus a ticket reference plus an employee identifier.

The system map

SystemRecordLinking keyOwner
WFM platformPublished forecast and intraday reforecast versionsQueue or workstream name, interval start, publish timeWFM team
WFM platformSchedule change requests and overridesInterval, queue, reason code, approver, ticket number in the noteWorkforce director
WFM platformAdherence and service level by intervalInterval, queue, published schedule versionCustomer operations
Telephony or contact platformContact records with queue and timestampsContact ID, initial contact ID, queue, timestampTelephony administrator
Ticketing systemIncident and release tickets, tagsTicket number, created timestamp, tagProduct and support
HR and payrollOvertime approvals and adjusted time cardsEmployee ID, date, approverHR
Team chat or emailInformal approvals and contextTimestamp, channel, ticket number if quotedVaries; often nobody

Two rows do the hardest work. The override row carries the reason and the approver, which are what make the record a decision. The contact record row supplies the actual demand: in Amazon Connect, for example, a transferred call creates a new contact record that points to the previous one and to the initial contact, so demand can be counted once per customer rather than once per leg.

Where each linking key breaks

Every key above has a known failure mode, and most of them happen quietly during renewals and reorganizations.

  • Time. Interval start in WFM, created timestamps elsewhere. Time zones and daylight saving shifts move one side by an hour. Ask which zone each system stores.
  • Queue. Queues get renamed, merged and split. Zendesk documents that historical WFM report data reflects the configuration active when it was recorded, so a renamed workstream appears as a break in history rather than a correction.
  • Schedule. Zendesk also documents that WFM schedules do not sync automatically with Zendesk schedules or business hours. Two systems can each hold a "schedule" that disagrees.
  • Plan version. Adherence is calculated against the published schedule (Amazon Connect documents this). If only the latest version survives, old adherence figures lose their reference point.
  • Reason. An override note that says "spike" with no ticket number cannot be joined to its cause.
  • Authority. Approvals given in chat never reach the schedule change record.

The same issue shows up in manufacturing, where a production schedule change log needs its reason codes and versions kept for the same reasons.

One joined case: the 10:20 override (Illustrative)

Fictional and invented for this page. The 410-person support operation from the worked firmware release case cancels a training block for 14 agents at 10:20 after a release at 10:05. Here is what a fully joined record of that single decision looks like, field by field.

LinkSystemField value (Illustrative)
CauseTicketingIncident ticket opened 10:11, tag "firmware", linked to release ticket
Plan beforeWFMForecast version published 06:00: 125 calls for the 10:30 interval, voice queue
Plan afterWFMReforecast version published 10:18: 340 calls for the same interval
DecisionWFMSchedule change 10:20: training block canceled for 14 agents, reason code "volume event", note cites the incident ticket
AuthorityWFMApproved by the workforce manager at 10:21
DemandTelephony365 contacts offered in the 10:30 interval on the voice queue, counted by initial contact
HoursHR and payrollNo overtime; training hours recoded as phone time on 14 time cards
OutcomeWFMService level 31% at 10:30, 44% at 11:00 after a second action

Read down the right-hand column. Every row shares the same interval and queue, and the cause, decision and authority rows share the ticket number. That is what "fully joined" means. Remove the ticket reference from the note and the decision loses its reason; overwrite the 06:00 forecast and the gap that triggered it disappears.

Testing the map with the WFM manager, at metadata level

A partner can test each link in one conversation without seeing any record. Ask, and write down yes, partly or no:

  1. Which time zone does each system store, and has it changed?
  2. Have queues or workstreams been renamed or merged, and when?
  3. Do override notes cite a ticket number, and since which year?
  4. Is the approver recorded on schedule changes, or only in chat or email?
  5. Are earlier forecast and schedule versions kept, or replaced?
  6. How many years does each system hold, and which ones change at the next renewal?

The answers go into the referral brief template. Never ask for exports, screenshots or logins. Contact center advisors may also find the telephony side covered in call transfer recovery, and closures or sales of a center in call center closing and selling a call center business.

Qualification and unknowns. The company needs 50+ full-time employees at peak (contractors excluded), a documented operating history, rights to license the records and an authorized contact. Companies in the U.S., Canada and the EU qualify, as do companies in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia when at least 90% of the data is in English. Whether the joins hold in practice, what employee data must be removed, buyer interest and any offer stay unknown until SourceX reviews the opportunity. Partners sign the Channel Partner Agreement before submitting introductions; the first valid introduction within the 90-day window is credited when the company submits a verified application. More record types are on the industries hub.

Next step

Refer a company. Earn up to $100,000. Default reward: 25% of Actual Supplier Payout, capped at $100,000 cumulatively per referred company. Eligibility and payment conditions apply, and a signed Schedule A or addendum can differ. A lead, meeting or signature alone does not trigger payment.

If the WFM manager answers yes to most of the six questions and the history spans several years, register as a partner, check the company against who qualifies and read the program terms before you introduce the workforce director.

  1. Step 1Share your linkSend your personal link to a company you know.
  2. Step 2Company appliesThe company applies itself at /apply.
  3. Step 3Company signs and is paidThe company signs, delivers its data and is paid by SourceX under its agreement.
  4. Step 4You get your rewardYour 25% of the actual supplier payout. A reward becomes payable after SourceX has paid the referred company under its signed agreement and the payout conditions in the program terms are met, including finance approval and your tax and payment details.

Common questions

Does the company need a data warehouse for these joins to work?

No. Many operations never joined these systems at all. What matters is whether the keys exist in each system, so the joins could be made during a review. A warehouse that already joins them is a bonus, not a requirement.

Should a partner ask for a sample export to test the map?

No. Ask whether each field exists and how far back it goes. Exports, screenshots and logins stay inside the company; SourceX's review tests the joins under the company's own controls.

What if overrides were approved in team chat?

Note the years when that was the practice. Chat approvals can sometimes be tied back to schedule changes by time and queue, but it is weaker evidence, and whether chat history can be used at all is a question for counsel.

Sources

  1. refer.sourcex.si/terms
  2. support.zendesk.com/hc/en-us/articles/6514633060634-Getting-star…
  3. support.zendesk.com/hc/en-us/articles/8920679615258-Zendesk-WFM-…
  4. docs.aws.amazon.com/connect/latest/adminguide/ctr-data-model.html
  5. docs.aws.amazon.com/connect/latest/adminguide/schedule-adherence…

Free resources

Know a company with valuable proprietary data?

Become a referral partner, get your link and introduce the company’s CEO (in an owner-run company, usually the owner). Referral partners can join from most countries. We can't work with partners in countries or regions under U.S. sanctions or on U.S. restricted-party lists. The companies you introduce should be based in the U.S., Canada and the EU, or in the UK, Australia, New Zealand, India, Singapore, South Africa, Latin America, the UAE and Saudi Arabia with at least 90% of their data in English.

Refer a company →

I own a business

Explore licensing your company's data directly to SourceX for AI training and evaluation. Start a short assessment; no uploads needed.

Start an assessment