Concept: Trended Workers Report Data Source
The
Trended Workers
report data source (RDS) is an indexed, Workday-delivered RDS that captures headcount data and workforce activity. You can create custom dashboards and reports or use Workday-delivered standard reports to view staffing events in your organization. You can't create nBox or search reports with the RDS.The RDS reduces the effort required to gain insights into your data by enabling you to gather accurate and current workforce data more efficiently. You don't need to export your data to Microsoft Excel or external applications to perform complex data analysis. This keeps your data more secure.
Workday updates the RDS weekly for nonproduction tenants (Implementation and Sandbox), and either nightly or every Monday for production tenants depending on your retroactive period selection. Based on your configuration on the
Maintain Trended Workers
task, Workday collects between 12 to 72 months of data and automatically purges data older than 72 periods from the RDS.Activity Data, Snapshot Data, and Calculated Metrics
The RDS contains report fields that collect worker data over time and includes activity data, snapshot data, and calculated metrics. You can distinguish between activity and snapshot data by using the
Record Type
field in reports.When processing events that occur on the last day of the period, Workday processes all activity data first, then captures the snapshot data. Workday also snapshots the results at the end of the period and takes into account retroactive changes up to 6 periods, which could impact your data.
Activity data includes these types of events, captured based on the
Effective Date
of the event:
- Addition or deletion of additional jobs.
- Hires.
- International assignments.
- Organization changes.
- Promotions.
- Staffing changes.
- Terminations.
- Transfers.
Workday tracks the
Effective Date
of the event as the Record Date
.Snapshot data includes worker data captured as of the last second of the last day of each period, such as:
- Biographical data.
- Compensation data.
- Headcount.
- Worker data.
Workday captures snapshot data on the first day of a new period but sets the
Record Date
as the last day of the period. Example: Workday captures snapshot data on 2018-09-01T12:01, but the Record Date
is 2018-09-30.Calculated metrics are a combination of activity and snapshot data. You can:
- Aggregate calculated metrics as drillable report fields in your trending report.
- Average, sum, or build additional calculations to determine rolling averages, spans of control, or turnovers.