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 Details core 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.

Data Granularity

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

Supported Dataview/RDO Type

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

Columns


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	Number	No
Availability Pattern Request Approvers	Names of the users that have approved the availability pattern request	AVAILABILITY_PATTERN_REQUEST_APPROVERS	String	No
Availability Pattern Request Creation Date	Date and time at which the availability pattern request was submitted by an employee	AVAILABILITY_PATTERN_REQUEST_CREATE_DATETIME	DateTime	No
Availability Pattern Request Creator Full Name	Full name of the user who created the availability pattern request	AVAILABILITY_PATTERN_REQUEST_CREATOR_NAME	String	No
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	String	No
Availability Pattern Request End Date	Available pattern request end date	AVAILABILITY_PATTERN_REQUEST_ENDDATE	Date	No
Availability Pattern Request ID	System identifier of the availability pattern request	AVAILABILITY_PATTERN_REQUEST_ID	String	No
Availability Pattern Request Item Day Number	Day number of the segment of the requested availability pattern	AVAILABILITY_PATTERN_REQUEST_ITEM_DAY_NUMBER	Number	No
Availability Pattern Request Item Segment End Time	Availability pattern segment end time	AVAILABILITY_PATTERN_REQUEST_ITEM_SEGMENT_ENDTIME	DateTime	No
Availability Pattern Request Item Segment Start Time	Availability pattern segment start time	AVAILABILITY_PATTERN_REQUEST_ITEM_SEGMENT_STARTTIME	DateTime	No
Availability Pattern Request Item Segment Type	Availability pattern request segment type	AVAILABILITY_PATTERN_REQUEST_ITEM_SEGMENT_TYPE	String	No
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	String	No
Availability Pattern Request Pattern Cycle Weeks/Days	Availability pattern type value	AVAILABILITY_PATTERN_REQUEST_PATTERN_CYCLE_WEEKS_DAYS	String	No
Availability Pattern Request Start Date	Available pattern request start date	AVAILABILITY_PATTERN_REQUEST_STARTDATE	Date	No
Availability Pattern Request Status	Current status of the availability pattern request	AVAILABILITY_PATTERN_REQUEST_STATUS	String	No
Availability Pattern Request Subtype Description	Description of the request subtype associated with the availability pattern request	AVAILABILITY_PATTERN_REQUEST_SUBTYPE_DESC	String	No
Availability Pattern Request Subtype Name	Name of the request subtype associated with the availability pattern request	AVAILABILITY_PATTERN_REQUEST_SUBTYPE_NAME	String	No
Availability Pattern Request Subtype Symbol	Symbol of the request subtype associated with the availability pattern request	AVAILABILITY_PATTERN_REQUEST_SUBTYPE_SYMBOL	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