Task Cube

Data Item	Data Type	Details	Item Source
Client Admission Year	Data Item	The year that the client's most recent service is entered into Alayacare	Patient Profile->Services
Client Admission Month	Data Item		Patient Profile->Services
Client Admission Day	Data Item		Patient Profile->Services
Client Admission Time	Data Item	The time that a service status was entered.	Patient Profile->Services->Specific Service->Status History
Client Age	Data Item	This calculates the patient's age based on the birth date entered in their profile.	Patient Profile->Demographics
Client Age Range	Data Item	This specifies what age range the patient falls within. Options are: 0-17, 18-64, 65-89 and 90+.	Patient Profile->Demographics
Client Birthday	Data Item		Patient Profile->Demographics
Client Current Status	Data Item	The current status of a client (Active, On Hold, Discharged). If a client has at least one active service they are Active.	Patient Profile
Client Discharged Year	Data Item	The year that a client's most recent service was discharged	Patient Profile->Services
Client DIscharged Month	Data Item	The month that a client's most recent service was discharged	Patient Profile->Services
Client Discharged Day	Data Item	This is the day that a clients most recent service was discharged	Patient Profile->Services
Client ERL	Data Item	A client's Emergency Response Level(codes determined by client)	Patient Profile - > Emergency Response Level
Client Gender	Data Item		Patient Profile->Demographics
Client State/Province	Data Item		Patient Profile->Demographics
Client City	Data Item		Patient Profile->Demographics
Client Postal Code	Data Item		Patient Profile->Demographics
Client Group Name	Data Item		Patient Profile->Demographics
Client Health Card Number	Data Item		Patient Profile->Demographics
Client Health Card Version	Data Item		Patient Profile->Demographics
Client ID	Data Item		Patient Profile->Demographics
Client Address 1(2)	Data Item		Patient Profile->Demographics
Client Address 2	Data Item		Patient Profile->Demographics
Client Address 3	Data Item		Patient Profile->Demographics
Client Phone	Data Item		Patient Profile->Demographics
Client Email	Data Item		Patient Profile->Demographics
Client Referral Source	Data Item		Patient Profile->Services->Specific Service
Client Revision Date	Data Item	Date and time of last edit to client demographic tab	Data Exploration
Client BRN	Data Item		Patient Profile->Services
Client Initial Inquiry	Data Item	Tenant Specific Value	Tenant Specific Value
Client Lastname	Data Item		Patient Profile->Demographics
Client Firstname	Data Item		Patient Profile->Demographics
Client Nationality	Data Item		Patient Profile->Demographics
Client Referred By	Data Item		Patient Profile->Services->Referrals
Client Status	Data Item	The status(Active, On Hold, Discharged) of a Client at a specific date. This variable is different than "Client Current Status" as it will show you the historic status of a client at a time in the past based on the date filters or other variables used.	Patient Profile->Overview
Client UID	Data Item	Client's external ID for use by Agency (or ID generated by AlayaCare)	Patient Profile->Demographics->Other Fields
Due Month All	Data Item	This field is used to see data for a month across ALL years. E.g. If you want march from all years, use this. If you want JUST march 2000, first use task due year, then task due month. You can use this to see data from march for ALL years in the system	Data Exploration
Due Year-Week	Data Item	A year variable to be used together with "Due Week" to determine the specific week that a task is due	Data Exploration
Due Week	Data Item	The year & week that a task is due	Data Exploration
Employee Company	Data Item		Employee Profile->Demographics
Employee Creation State/Province	Data Item	The Province of the employee that created a task	Data Exploration
Employee Creation City	Data Item	The city of the employee that created a task	Data Exploration
Employee Creation Postal Code	Data Item	The postal code of the employee that created a task	Data Exploration
Employee Creation ID	Data Item	The ID of the employee that created a task	Data Exploration
Employee Creation Address 1	Data Item	The address 1 of the employee that created a task	Data Exploration
Employee Creation Address 2	Data Item	The address 2 of the employee that created a task	Data Exploration
Employee Creation Address 3	Data Item	The address 3 of the employee that created a task	Data Exploration
Employee Creation Phone	Data Item	The phone of the employee that created a task	Data Exploration
Employee Creation Job Title	Data Item	The job title of the employee that created a task	Data Exploration
Employee Creation Firstname	Data Item	The first name of the employee that created a task	Data Exploration
Employee Creation Lastname	Data Item	The last name of the employee that created a task	Data Exploration
Employee Creation Payroll Number	Data Item	The payroll number of the employee that created a task	Data Exploration
Employee Creation Status	Data Item	The status of the employee that created a task	Data Exploration
Employee Department Name	Data Item	The name(s) of the department(s) an employee is assigned to	Employee Profile->Demographics
Employee Gender	Data Item		Employee Profile->Demographics
Employee State/Province	Data Item		Employee Profile->Demographics
Employee City	Data Item		Employee Profile->Demographics
Employee Postal Code	Data Item		Employee Profile->Demographics
Employee Group name	Data Item		Employee Profile->Demographics
Employee ID	Data Item		Employee Profile->Demographics
Employee Payroll Number	Data Item		Employee Profile->Demographics
Employee SIN Number	Data Item		Employee Profile->Demographics
Employee Address 1	Data Item		Employee Profile->Demographics
Employee Address 2	Data Item		Employee Profile->Demographics
Employee Address 3	Data Item		Employee Profile->Demographics
Employee Phone	Data Item		Employee Profile->Demographics
Employee Creation Date	Data Item	This specifies the date an employee profile was created	Data Exploration
Employee Revision Date	Data Item	This specifies the date and time an employee profile was revised	Data Exploration
Employee Personal Email	Data Item		Employee Profile->Demographics
Employee Job Title	Data Item		Employee Profile->Demographics
Employee Lastname	Data Item		Employee Profile->Demographics
Employee Firstname	Data Item		Employee Profile->Demographics
Employee Max Daily Capacity	Data Item	The maximum number of hours an employee can work in a single day.	Employee Profile->Demographics
Employee Max Weekly Capacity	Data Item	The maximum number of hours an employee can work in a single week.	Employee Profile->Employment->Employment Settings
Employee Min Daily Capacity	Data Item	The minimum number of hours an employee must work in a single day.	Employee Profile->Employment->Employment Settings
Employee Min Weekly Capacity	Data Item	The minimum number of hours an employee must work in a single week.	Employee Profile->Employment->Employment Settings
Employee Max Caseload	Data Item	The maximum number of clients that an employee can be assigned at one time.	Employee Profile->Employment->Employment Settings
Employee Position Type	Data Item	Employee Position Types are used to determine if an employee is eligible for holiday pay.	Employee Profile->Employment->Employment Settings
Employee Current Caseload	Data Item	The current number of clients an employee is assigned to.	Employee Profile->Clients->Caseload
Employee Status	Data Item		Employee Profile->Overview
Employee UID	Data Item		Employee Profile->Demographics
Employee Update State/Province	Data Item	The State/Province of the Employee who updated a task	Data Exploration
Employee Update City	Data Item	The City of the Employee who updated a task	Data Exploration
Employee Update Postal Code	Data Item	The Postal Code of the Employee who updated a task	Data Exploration
Employee Update ID	Data Item	The ID of the Employee who updated a task	Data Exploration
Employee Update Address 1	Data Item	The Address 1 of the Employee who updated a task	Data Exploration
Employee Update Address 2	Data Item	The Address 2 of the Employee who updated a task	Data Exploration
Employee Update Address 3	Data Item	The Address 3 of the Employee who updated a task	Data Exploration
Employee Update Phone	Data Item	The Phone of the Employee who updated a task	Data Exploration
Employee Update Job Title	Data Item	The Job Title of the Employee who updated a task	Data Exploration
Employee Update Firstname	Data Item	The Firstname of the Employee who updated a task	Data Exploration
Employee Update Lastname	Data Item	The Lastname of the Employee who updated a task	Data Exploration
Employee Update Payroll Number	Data Item	The Payroll Number of the Employee who updated a task	Data Exploration
Employee Update Status	Data Item	The Status of the Employee who updated a task	Data Exploration
Client Distinct Count	Measure	The number of distinct clients that apply to the designated metrics	Data Exploration
Employee Distinct Count	Measure	The number of distinct employees that apply to the designated metrics	Data Exploration
Task Count	Measure		Data Exploration
Task Creation Year	Data Item		Dashboard->Tasks
Task Creation Month	Data Item		Dashboard->Tasks
Task Creation Day	Data Item		Dashboard->Tasks
Task Creation Month All	Data Item	This field is used to see data for a month across ALL years. E.g. If you want march from all years, use this. If you want JUST march 2000, first use task creation year, then task creation month. You can use this to see data from march for ALL years in the system	Data Exploration
Task Creation Time	Data Item		Dashboard->Tasks
Task Creation Year-Week	Data Item	A year variable to be used together with "Task Creation Week" to determine the specific week that a task was created	Data Exploration
Task Creation Week	Data Item	The year & week that a task was created	Data Exploration
Task Due Year	Data Item		Dashboard->Tasks
Task Due Month	Data Item		Dashboard->Tasks
Task Due Day	Data Item		Dashboard->Tasks
Task ID	Data Item	A number assigned sequentially to tasks created	Dashboard->Tasks
Task Description	Data Item	A Tasks title	Dashboard->Tasks
Task Details	Data Item	A field to allow further information about a Task to be written	Dashboard->Tasks
Task Overdue	Data Item	Specifies whether a Task has not been completed before its due date	Dashboard->Tasks
Task Priority	Data Item	A task can be given a priority to categorize its importance	Dashboard->Tasks
Task Status	Data Item	Whether a task is complete or not	Dashboard->Tasks
Task Update Year	Data Item	The year a Task was updated	Data Exploration
Task Update Month	Data Item	The month a Task was updated	Data Exploration
Task Update Day	Data Item	The day a Task was updated	Data Exploration
Task Update Month All	Data Item	This field is used to see data for a month across ALL years. E.g. If you want march from all years, use this. If you want JUST march 2000, first use task update year, then task update month. You can use this to see data from march for ALL years in the system	Data Exploration
Task Update Year-Week	Data Item	A year variable to be used together with "Task Update Week" to determine the specific week that a task was updated	Data Exploration
Task Update Week	Data Item	The year & week that a task was updated	Data Exploration