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.

Data Granularity

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

Supported Dataview/RDO Type

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

Columns


Hours of Operation Date	Date of the hours of operation	HOURS_OF_OPERATION_DATE	Date	No
Hours of Operation End Time	The end time of the hours of operation	HOURS_OF_OPERATION_END_TIME	DateTime	No
Hours of Operation Is Closed	Indicates whether the hours of operation are marked as closed	HOURS_OF_OPERATION_IS_CLOSED	Boolean	No
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	Boolean	No
Hours of Operation Location (Path)	Full business structure path of the locations that are associated with the hours of operation	HOURS_OF_OPERATION_LOCATION	String	No
Hours of Operation Start Time	The start time of the hours of operation	HOURS_OF_OPERATION_START_TIME	DateTime	No

Additional Info

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.

Note: Joining of Report Data Objects in BIRT Studio is not supported.

Core Entity

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

Relationship

One-to-One	One-to-Many