Audit Forecasting

The Audit Forecasting entity provides columns for use in a Dataview or report that return audit data for a given Forecasting entity type.

Data Granularity

Provides one row per category per time period (date or forecast week) per entity type.

Supported Dataview/RDO Type

Employee	Business Structure	Employee - Time Series	Business Structure - Time Series	Work Unit	Work Unit - Time Series

Columns


Changed Value	Changed value	FORAUDIT_CHANGED_VALUE	String	No
Client		FORAUDIT_DATASOURCE_CLIENT	String	No
Date	Date of the original transaction.	FORAUDIT_DATE	Date	No
Driver	Either the custom labor driver or the volume driver, depending upon the Entity Type.	FORAUDIT_DRIVER	String	No
Entity Type	Entity type. Either Volume Forecast, Volume Forecast Total, Volume Forecast Restore, Custom Labor Driver, Labor Forecast Headcount, Traffic Pattern, Labor Budget, Volume Budget, Adjustment Labor Driver	FORAUDIT_ENTITY_TYPE	Enum	No
Forecast Category	Forecast category	FORAUDIT_CHILD_CATEGORY	String	No
Functional Area	Functional area	FORAUDIT_DATASOURCE_FUNCTIONAL_AREA	String	No
Original Value	Original value	FORAUDIT_ORIGINAL_VALUE	String	No
Period Start Date and Time	Start date and time of the original transaction	FORAUDIT_START_DATE_TIME	DateTime	No
Period End Date and Time	End date and time of the original transaction	FORAUDIT_END_DATE_TIME	DateTime	No
Revision Date	Date and time at which the revision was made	FORAUDIT_REVISION_DATETIME	DateTime	No
Revision Type	Revision type. For example, Modify, Import, Create, or Delete	FORAUDIT_REVISION_TYPE	String	No
Revision User	Full name of the user who made the changes	FORAUDIT_REVISION_USER	String	No
Server	Server	FORAUDIT_DATASOURCE_SERVER	String	No
User Name	User name	FORAUDIT_DATASOURCE_USER_NAME	String	No

Core Entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category	Activity	Work Unit	Work Group	Procedure Code

Relationship

One-to-One	One-to-Many

On This Page