Cube: Availability

This cube contains information on scheduled availabilities, time off, and unavailabilities. You can use it to track total paid or unpaid vacation time or absences, or your employees' patterns of availability or unavailability to inform staffing requirements.

Along with general information on the configuration of the availability, including start and end dates, you can also pull the start and end dates and times for individual occurrences of recurring availabilities and fields from the following dimensions: 

Employee, Employee Name, Service Codes.

Fields

General information on the availability/unavailability/time off type:

• Availability Type: availability, time off, or unavailability 
• Availability Frequency: daily or weekly 
• Availability Days List: contains the days of the week when a weekly frequency is specified for an availability/unavailability. The days are indicated in format MO, TU, WE, TH, FR, SA, SU and comma-separated in a single row/column for each availability/unavailability.
• Availability Interval: value of the Repeat every field when the frequency daily or weekly is set.
• Availability Disabled
• Time Off Types
• Availability Description

Start and end date for the availability/unavailability/time off type:

• Availability Start Date Year
• Availability Start Date Month
• Availability Start Date Day
• Availability End Date Year
• Availability End Date Month
• Availability End Date Day
• Availability Start Time
• Availability End Time

Start and end date for an occurrence of a recurring availability/unavailability/time off type:

• Event Start Date Year
• Event Start Date Month
• Event Start Date Day
• Event End Date Year
• Event End Date Month
• Event End Date Day
• Event Start Time
• Event End Time

Measures

Availability Duration sum
Availability Duration Paid sum
Availability Days sum
Employee Distinct Count