Hours of Operation

Use the Hours of Operation entity in Dataviews and reports to allow managers to view a store's hours of operation. This can enable them to view store operations against scheduled hours, for example, to ensure that they have enough people scheduled throughout the day, particularly at opening and closing times. In addition, because the hours of operation can change during periods of unusual activity, it is useful for managers to have this information on their daily reports to alert them to such changes.

Supported Dataview types

Employee Dataview	Business Structure Dataview
	X

Data granularity

Provides one row per location, per date, per hours of operation item in the selected date range

Columns

Label	Description	Key
Hours of Operation Date	Date of the hours of operation.	HOURS_OF_OPERATION_DATE
Hours of Operation End Time	The end time of the hours of operation	HOURS_OF_OPERATION_END_TIME
Hours of Operation Is Closed	Indicates whether the hours of operation are marked as closed.	HOURS_OF_OPERATION_IS_CLOSED
Hours of Operation Is Override	Indicates whether the hours of operation are an override to the regular hours of operation.	HOURS_OF_OPERATION_IS_OVERRIDE
Hours of Operation Location (Path)	Full business structure path of the locations that are associated with the hours of operation.	HOURS_OF_OPERATION_LOCATION
Hours of Operation Start Time	The start time of the hours of operation	HOURS_OF_OPERATION_START_TIME

Additional information

For custom reports, it may be sufficient to build separate Business Structure Report Data Objects each with a location type for the specific business structure node where hours of operation are needed. Multiple report data objects could then be joined to create the custom report. This would avoid the need to create a business structure Dataview with a location type of Job and have all locations returned as a separate row.

Core entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category	Activity
			X

Relationship

One-to-One	One-to-Many
	X