3789534 - People Intelligence: Users missing from CoreWorkforceData and CrossWorkforceData when Hire Event Reason is not mapped in Manage Analytic Data Product

• Users (or a subset of users) are present in the local table (SuccessFactors datasource tables such as assignment and jobDetail) but are completely absent from derived data products — specifically CoreWorkforceData and CrossWorkforceData.

  Typical observations:

  • Querying the local table assignment table by userId returns results.
  • Querying the gold coreworkforcedata or crossworkforcedata delta tables for the same user returns no rows.
  • Affected users often share a specific assignmentClass (e.g., GA — Global Assignment) or a specific eventReason on their hire row.

• SAP SuccessFactors HCM Suite
  • People Intelligence in Business Data Cloud (BDC)

crossworkforcedata, cross‑workforce, databricks, delta sharing, missing users, user ids, people intelligence, business data cloud, manage analytics data products, manage derived data products, global assignment, event reason, termination reason, start of global employment, filtered records, Workforce Composition Insights, People Intelligence, crossworkforcedata, missing user IDs, employee data continuity, termination event reason, end of global assignment, workforce analytics, employee lifecycle data, production data discrepancy, missing workforce records, user synchronization, data refresh, employment records, workforce composition data model,People Intelligence, PI , KBA , LOD-SF-PI , People Intelligence in Business Data Cloud (BDC) , Problem