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
Comments
0 comments
Article is closed for comments.