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.

Employee Dataview Business Structure Dataview
X  

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

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
Employee Organization Day Organizational Job Paycode Labor Category Activity
X            
One-to-One One-to-Many
  X