Cube: Employee

Use this cube to report on your employee profiles. Additionally, you can use fields from the following dimensions:

Branch, Branch rollback, Employee, Employee Special rates, Employee Cost Centre.

Cube Fields

• Has Skills

Employee general information (from Employee Profile>Demographics):

• Employee Lastname
• Employee Firstname
• Employee Full Name
  Employee UID 2: form context field
• Employee Group Name
• Employee Department Name
• Employee Department Active: legacy field
• Employee Role Name
• Employee Role Code: backend field
• Employee Role Permission: ACLs enabled for the role

 Facilities to which the employee is associated:

• Employee Facility Name
• Employee Facility Address
• Employee Facility Description

 Clients to whom the employee is associated:

• Associated Client Firstname
• Associated Client Lastname
• Associated Client Status
• Association Status
• Client Contact Alayacare ID

Availability, unavailability, time off types:

• Employee Rule Type: availability, unavailability, or timeoff type
• Employee Rule Description
• Employee Rule Duration: difference between start and end date
• Employee Rule Starting Date
• Employee Rule End Date
• Employee Rule Date Difference
• Employee Rule: description of frequency
• Employee Rule Time Off Type: for general availability or unavailability, otherwise Timeoff Type name

Employee contact information (in Employee Profile>Overview):

• Employee Contact UID
• Employee Contact Salutation
• Employee Contact Firstname
• Employee Contact Lastname
• Employee Contact Relationship
• Employee Contact Type
• Employee Contact Communication Method
• Employee Contact Address
• Employee Contact Address Suite
• Employee Contact City
• Employee Contact State/Province
• Employee Contact Postal Code
• Employee Contact Country
• Employee Contact Main Phone
• Employee Contact Other Phone
• Employee Contact Personal Phone
• Employee Contact Email
• Employee Contact Fax
• Employee Contact Website
• Employee Contact Emergency Response Level
• Employee Contact Title
• Employee Contact Gender
• Employee Contact Birthday
• Employee Contact Remarks

Dates - Creation, Revision, Start, Termination:

• Employee Creation Year
• Employee Creation Month
• Employee Creation Day
• Employee Revision Year
• Employee Revision Month
• Employee Revision Day
• Employee Start Year
• Employee Start Month
• Employee Start Day
• Employee Termination Year
• Employee Termination Month
• Employee Termination Day

Measures

• Employee Current Assignment Load Sum
• Employee Count