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. Workday collects up to 36 periods of data and automatically purges
data older than 36 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.