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 Time |
Data Item |
The time 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 |