Do Not Send Cube

Data Item	Data Type	Details	Item Source
Block Type	Data Item	Binary data field, either "employee blocked by the client" OR "client blocked by the employee"	Patient Profile->Coordination->Do Not Send, Employee Profile->Clients->Do Not Send
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 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> Other
Client State/Province	Data Item		Patient Profile->Demographics> Address
Client City	Data Item		Patient Profile->Demographics>Address
Client Postal Code	Data Item		Patient Profile->Demographics>Address
Client Group Name	Data Item		Patient Profile->Demographics
Client Health Card Number	Data Item		Patient Profile->Demographics
Client Health Card Version	Data Item	Applicable for agencies servicing clients with a health card number that versions	Patient Profile->Demographics
Client ID	Data Item	ID assigned by AlayaCare software	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 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
Do Not Send Creation Year	Data Item	Year the Do Not Send was set; if multiple Do Not Sends have been set then multiple values will present	Data Exploration
Do Not Send Creation Month	Data Item	Month the Do Not Send was set; if multiple Do Not Sends have been set then multiple values will present	Data Exploration
Do Not Send Creation Day	Data Item	Day the Do Not Send was set; if multiple Do Not Sends have been set then multiple values will present	Data Exploration
Do Not Send Reason	Data Item	Free text entry reason for setting the Do Not Send	Patient Profile>Coordination>Do Not Send Employee Profile > Clients > Do Not Send
Employee Company	Data Item		Employee Profile->Demographics
Employee Creation State/Province	Data Item	The State/Province of the employee who created the Do Not Send value	Data Exploration
Employee Creation City	Data Item	The City of the employee who created the Do Not Send value	Data Exploration
Employee Creation Postal Code	Data Item	The Postal Code of the employee who created the Do Not Send value	Data Exploration
Employee Creation Id	Data Item	The ID of the employee who created the Do Not Send value	Data Exploration
Employee Creation Address 1	Data Item	The Address 1 of the employee who created the Do Not Send value	Data Exploration
Employee Creation Address 2	Data Item	The Address 2 of the employee who created the Do Not Send value	Data Exploration
Employee Creation Address 3	Data Item	The Address 3 of the employee who created the Do Not Send value	Data Exploration
Employee Creation Phone	Data Item	The Phone of the employee who created the Do Not Send value	Data Exploration
Employee Creation Job Title	Data Item	The Job Title of the employee who created the Do Not Send value	Data Exploration
Employee Creation Firstname	Data Item	The first name of the employee who created the Do Not Send value	Data Exploration
Employee Creation Lastname	Data Item	The last name of the employee who created the Do Not Send value	Data Exploration
Employee Creation Payroll Number	Data Item	The Payroll Number of the employee who created the Do Not Send value	Data Exploration
Employee Creation Status	Data Item	The Status of the employee who created the Do Not Send value	Data Exploration
Employee Current Status	Data Item	Employee Current Status denotes whether an employee is currently working, and able to be scheduled for visits.	Employee Profile->Overview
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	Current Province/State registered to the Employee	Employee Profile->Demographics > Address
Employee City	Data Item	Current City  registered to the Employee	Employee Profile->Demographics > Address
Employee Postal Code	Data Item	Current Postal Code registered to the Employee	Employee Profile->Demographics > Address
Employee Group Name	Data Item	Group(s) assigned to an Employee	Employee Profile->Demographics
Employee ID	Data Item		Employee Profile->Demographics
Employee Payroll Number	Data Item	Payroll Number set	Employee Profile->Employment>Employment Settings
Employee Sin Number	Data Item	SIN set	Employee Profile->Employment>Employment Settings
Employee Address 1	Data Item	Street Number and Name (use for Google Maps routing)	Employee Profile->Demographics>Address
Employee Address 2	Data Item	Additional information including appartment/suite number	Employee Profile->Demographics>Address
Employee Address 3	Data Item	Additional information including appartment/suite number	Employee Profile->Demographics>Address
Employee Phone	Data Item	Primary Phone number field set; data displays as it is entered	Employee Profile->Demographics
Employee Creation Date	Data Item	This specifies the date the employee profile was created	Data Exploration
Employee Revision Date	Data Item	This specifies the date the employee profile was revised	Data Exploration
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->Employment
Employee Max Weekly Capacity	Data Item	The maximum number of hours an employee can work in a single week.	Employee Profile->Employment
Employee Min Daily Capacity	Data Item	The minimum number of hours an employee must work in a single day.	Employee Profile->Employment
Employee Min Weekly Capacity	Data Item	The minimum number of hours an employee must work in a single week.	Employee Profile->Employment
Employee Max Caseload	Data Item	The maximum number of clients that an employee can be assigned at one time.	Employee Profile->Employment
Employee Position Type	Data Item	Employee Position Types are used to determine if an employee is eligible for holiday pay.	Employee Profile->Employment
Employee Current Caseload	Data Item	The current number of clients an employee is assigned to.	Employee Profile->Clients->Caseload
Employee Personal Email	Data Item		Employee Profile > Demographics
Employee Termination Year	Data Item	Year an Employees status was set to "Terminated"	Employee Profile->Demographics->Other Fields->Termination Date
Employee Termination Month	Data Item	Month an Employees status was set to "Terminated"	Employee Profile->Demographics->Other Fields->Termination Date
Employee Termination Day	Data Item	Date Employee status was set to "Terminated"	Employee Profile->Demographics->Other Fields->Termination Date
Employee UID	Data Item	External ID set for an Employee; usually ID field leveraged for legacy system ID assigned to Employees.	Data Exploration
Client Distinct Count	Measure	The number of distinct clients that apply to the designated metrics	Data Exploration
Do Not Send Count	Measure	Count of Do Not Send profiles assigned/set	Data Exploration
Employee Distinct Count	Measure	The number of distinct employees that apply to the designated metrics	Data Exploration