Availability Pattern Request Detail

The Availability Pattern Request Detail entity makes data available to Dataviews and Report Data Objects that allow managers to review the availability pattern change requests made by employees. This allows manager to better understand the number of requests, the employees making those requests, and the status of those requests. With this information, managers can better ensure that availability pattern requests are being approved or rejected in a timely manner, which employees are regularly requesting availability pattern changes, and which are not.

The Availability Pattern Request Detail entity must have a relationship to the Employee Detailscore entity. This will allow the administrator who creates a Dataview or Report Data Object to include any of the data columns in the Employee Details entity with the data columns from the Availability Pattern Request Detail entity.

Supported Dataview types

Employee Dataview	Business Structure Dataview
X

Data granularity

Provides one row per employee per availability pattern request segment item.

Columns

Label	Description	Key
Availability Pattern Request Amount of Days/Weeks	Number of Days/Weeks in the cycle of the requested availability pattern	AVAILABILITY_PATTERN_REQUEST_AMOUNT_DAYS_WEEKS
Availability Pattern Request Approvers	Names of the users that have approved the availability pattern request	AVAILABILITY_PATTERN_REQUEST_APPROVERS
Availability Pattern Request Creation Date	Date and time at which the availability pattern request was submitted by an employee	AVAILABILITY_PATTERN_REQUEST_CREATE_DATETIME
Availability Pattern Request Creator Full Name	Full name of the user who created the availability pattern request	AVAILABILITY_PATTERN_REQUEST_CREATOR_NAME
Availability Pattern Request Employee Comments	List of the comments and associated nots applied to a request by a user identified as an employee	AVAILABILITY_PATTERN_REQUEST_EMP_COMMENTS_NOTES
Availability Pattern Request End Date	Available pattern request end date	AVAILABILITY_PATTERN_REQUEST_ENDDATE
Availability Pattern Request ID	System identifier of the availability pattern request	AVAILABILITY_PATTERN_REQUEST_ID
Availability Pattern Request Item Day Number	Day number of the segment of the requested availability pattern.	AVAILABILITY_PATTERN_REQUEST_ITEM_DAY_NUMBER
Availability Pattern Request Item Segment End Time	Availability pattern segment end time	AVAILABILITY_PATTERN_REQUEST_ITEM_SEGMENT_ENDTIME
Availability Pattern Request Item Segment Start Time	Availability pattern segment start time	AVAILABILITY_PATTERN_REQUEST_ITEM_SEGMENT_STARTTIME
Availability Pattern Request Item Segment Type	Availability pattern request segment type	AVAILABILITY_PATTERN_REQUEST_ITEM_SEGMENT_TYPE
Availability Pattern Request Manager Comments	List of the comments and associated nots applied to a request by a user identified as a manager	AVAILABILITY_PATTERN_REQUEST_MGR_COMMENTS_NOTES
Availability Pattern Request Pattern Cycle Weeks/Days	Availability pattern type value	AVAILABILITY_PATTERN_REQUEST_PATTERN_CYCLE_WEEKS_DAYS
Availability Pattern Request Start Date	Available pattern request start date	AVAILABILITY_PATTERN_REQUEST_STARTDATE
Availability Pattern Request Status	Current status of the availability pattern request	AVAILABILITY_PATTERN_REQUEST_STATUS
Availability Pattern Request Subtype Description	Description of the request subtype associated with the availability pattern request	AVAILABILITY_PATTERN_REQUEST_SUBTYPE_DESC
Availability Pattern Request Subtype Name	Name of the request subtype associated with the availability pattern request	AVAILABILITY_PATTERN_REQUEST_SUBTYPE_NAME
Availability Pattern Request Subtype Symbol	Symbol of the request subtype associated with the availability pattern request	AVAILABILITY_PATTERN_REQUEST_SUBTYPE_SYMBOL

Related entities

Employee Details

Core entity

Employee	Organization	Day	Organizational Job	Paycode	Labor Category
X

Relationship

One-to-One	One-to-Many
	X