Data Item |
Type |
Details |
Item Source |
Approval Status |
Data Item |
This variable is pulled from the visit profile and specifies whether a visit has been approved |
Schedules->Workforce Management->Shift Approval |
Billitem Active |
Data Item |
Whether a Bill Code is active or not, "Active=true, Not Active =false" |
Accounting->Global Settings->Bill Codes |
Bill Item Code |
Data Item |
Bill Code |
Accounting->Global Settings->Bill Codes |
Bill Item Code Desc |
Data Item |
Bill Code description |
Accounting->Global Settings->Bill Codes |
Bill Item Gl Rev Code |
Data Item |
This represents the GL Revenue Code set up at the bill code level |
Accounting->Global Settings->Bill Codes |
Bill Item Gl Exp Code |
Data Item |
This represents the GL Asset Code set up at the Funder level |
Accounting->Global Settings->Funders |
Bill Item Unit Price |
Data Item |
The current Bill Code Rate. This variable will populate as "0" if the rate has never been altered. Use the variable "Bill Rate" in these cases. |
Accounting->Global Settings->Bill Codes->Rates |
Bill Item Creation Date |
Data Item |
Date the Bill Code was created |
Data Exploration |
Bill Item Revision Date |
Data Item |
Date the Bill Code was revised |
Data Exploration |
Bill Item Disabled Date |
Data Item |
Date the Bill Code was disabled |
Data Exploration |
Bill Item Internal |
Data Item |
Whether a Bill Code is Internal or External. This is used to track internal activities that you wouldn't necessary bill a client for, but would pay an employee. To use this, click the check box "Internal Code". |
Accounting->Global Settings->Bill Codes->Rates |
Bill Item Taxable |
Data Item |
Whether a Bill Code is taxable, "Taxable=true, Not Taxable =false" |
Accounting->Global Settings->Bill Codes |
Billitem Type |
Data Item |
Value varies from tenant to tenant |
Data Exploration |
Billitem Units |
Data Item |
A Bill Codes unit type (Hours or Visits). If an item has not Bill Code the value "Not Available" will be displayed. |
Accounting->Global Settings->Bill Codes->Rates |
Bill Rate |
Data Item |
The active rate for a Bill Code at the visit start date |
Accounting->Global Settings->Bill Codes |
Bill Rate Start Date |
Data Item |
The effective date of the Bill Code's rate applied to a visit |
Accounting->Global Settings->Bill Codes |
Cancel Code |
Data Item |
Code to denote a cancelled visit. Can take any cancel code value set in Cancel Codes within Accounting->Global Settings. |
Accounting->Global Settings->Cancel Codes |
Cancel Type |
Data Item |
This is the type of cancellation input to a visit if it is cancelled. There are three possible values "not cancelled", "on_hold", & "cancelled". |
Accounting->Global Settings->Cancel Codes |
Client Admission Year |
Data Item |
The year that the client's most recent service was entered into Alayacare |
Patient Profile->Services |
Client Admission Month |
Data Item |
The month that a client's most recent service was entered into Alayacare |
Patient Profile->Services |
Client Admission Day |
Data Item |
The day that a client's most recent service was entered into Alayacare |
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 when all client services were discharged |
Patient Profile->Services |
Client Discharged Month |
Data Item |
The month when all client services were 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->Demographics |
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 |
The referral source of a client |
Patient Profile->Services->Specific Service->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 |
Client Visit In A Facility |
Data Item |
If a client visit is provided in a facility this value will populate "true" |
Any schedule view |
Client Risk Name |
Data Item |
|
Patient Profile->Risk Assessment |
Client Risk Category |
Data Item |
|
Patient Profile->Risk Assessment |
Client Risk Severity |
Data Item |
|
Patient Profile->Risk Assessment |
Client Risk Creation Date |
Data Item |
|
Patient Profile->Risk Assessment |
Client Risk Revision Date |
Data Item |
|
Patient Profile->Risk Assessment |
Client Risk Employee Creation Firstname |
Data Item |
|
Patient Profile->Risk Assessment |
Client Risk Employee Creation Lastname |
Data Item |
|
Patient Profile->Risk Assessment |
Employee Company |
Data Item |
|
Patient Profile->Demographics |
Employee Creation State/Province |
Data Item |
The Province of the employee that created a visit |
Data Exploration |
Employee Creation City |
Data Item |
The city of the employee that created a visit |
Data Exploration |
Employee Creation Postal Code |
Data Item |
The Postal Code of the employee who created the visit |
Data Exploration |
Employee Creation Id |
Data Item |
The ID of the employee who created the visit |
Data Exploration |
Employee Creation Address 1 |
Data Item |
The Address 1 of the employee who created the visit |
Data Exploration |
Employee Creation Address 2 |
Data Item |
The Address 2 of the employee who created the visit |
Data Exploration |
Employee Creation Address 3 |
Data Item |
The Address 3 of the employee who created the visit |
Data Exploration |
Employee Creation Phone |
Data Item |
The phone number of the employee who created the visit |
Data Exploration |
Employee Creation Job Title |
Data Item |
The Job Title of the employee who created the visit |
Data Exploration |
Employee Creation Firstname |
Data Item |
The first name of the employee who created the visit |
Data Exploration |
Employee Creation Lastname |
Data Item |
The last name of the employee who created the visit |
Data Exploration |
Employee Creation Payroll Number |
Data Item |
The Payroll Number of the employee who created the visit |
Data Exploration |
Employee Creation Status |
Data Item |
The Status of the employee who created the visit |
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 |
|
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->Employment |
Employee SIN Number |
Data Item |
|
Employee Profile->Employment |
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 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 (also called Employment Type) |
Employee Profile->Employment |
Employee Current Caseload |
Data Item |
The current number of clients an employee is assigned to. |
Employee Profile->Clients->Caseload |
Employee Start Year |
Data Item |
|
Employee Profile->Demographics |
Employee Start Month |
Data Item |
|
Employee Profile->Demographics |
Employee Start Day |
Data Item |
|
Employee Profile->Demographics |
Employee Status |
Data Item |
An employee's status(active, terminated) at the date of a visit |
Employee Profile->Overview |
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 |
An ID tag in the employee list |
Employee Profile->Demographics |
Employee Update State/Province |
Data Item |
The State/Province of the most recent employee to update a visit |
Data Exploration |
Employee Update City |
Data Item |
The city of the most recent employee to update a visit |
Data Exploration |
Employee Update Postal Code |
Data Item |
The postal code of the most recent employee to update a visit |
Data Exploration |
Employee Update ID |
Data Item |
The ID of the most recent employee to update a visit |
Data Exploration |
Employee Update Address 1 |
Data Item |
The Address 1 of the most recent employee to update a visit |
Data Exploration |
Employee Update Address 2 |
Data Item |
The Address 2 of the most recent employee to update a visit |
Data Exploration |
Employee Update Address 3 |
Data Item |
The Address 3 of the most recent employee to update a visit |
Data Exploration |
Employee Update Phone |
Data Item |
The phone number of the most recent employee to update a visit |
Data Exploration |
Employee Update Job Title |
Data Item |
The job title of the most recent employee to update a visit |
Data Exploration |
Employee Update Firstname |
Data Item |
The first name of the most recent employee to update a visit |
Data Exploration |
Employee Update Lastname |
Data Item |
The last name of the most recent employee to update a visit |
Data Exploration |
Employee Update Payroll Number |
Data Item |
The payroll number of the most recent employee to update a visit |
Data Exploration |
Employee Update Status |
Data Item |
The status of of the most recent employee to update a visit |
Data Exploration |
Facility Name |
Data Item |
|
Patient Profile-> Schedule->Visit OR Patients->Facility List |
Facility Address |
Data Item |
|
|
Facility Creation Date |
Data Item |
The date a facility was created |
Data Exploration |
Facility Revision Date |
Data Item |
The date a facility was revised |
Data Exploration |
Facility Capacity |
Data Item |
The maximum capacity of a facility |
Patients->Facility List->View->Edit |
Funder Code |
Data Item |
|
Accounting->Global Settings->Funders |
Funder Code Desc |
Data Item |
|
Accounting->Global Settings->Funders |
Funder Creation Date |
Data Item |
The creation date of a funder |
Data Exploration |
Funder Revision Date |
Data Item |
The revision date of a funder |
Data Exploration |
Funder Holiday Multiplier |
Data Item |
The holiday multiplier of a funder |
Accounting->Global Settings->Funders |
Service Address 2 |
Data Item |
The second address line of a service |
Patient Profile->Services->Specific Service |
Service Address 3 |
Data Item |
The third address line of a service |
Patient Profile->Services->Specific Service |
Service Address State/Province |
Data Item |
The state/province of a service |
Patient Profile->Services->Specific Service |
Service Address City |
Data Item |
The city of a service |
Patient Profile->Services->Specific Service |
Service Address Postal Code |
Data Item |
The postal code of a service |
Patient Profile->Services->Specific Service |
Service Address ID |
Data Item |
The ID of a service address |
Patient Profile->Services->Specific Service |
Service Address Firstname |
Data Item |
The first name of a service address |
Patient Profile->Services->Specific Service |
Service Address Lastname |
Data Item |
The last name of a service address |
Patient Profile->Services->Specific Service |
Service Address Name |
Data Item |
The name of a service address |
Patient Profile->Services->Specific Service |
Service Address Phone |
Data Item |
The phone of a service address |
Patient Profile->Services->Specific Service |
Service Client Diagnosis |
Data Item |
This is the medical history of a client |
Patient Profile->Care Documentation->Care Plan |
Service Client Care Plan |
Data Item |
If a client has an active Care Plan populates "true" |
Patient Profile->Care Documentation->Care Plan |
Service Code |
Data Item |
|
Accounting->Global Settings->Service Codes |
Service Code Desc |
Data Item |
The description of a Service Code |
Accounting->Global Settings->Service Codes |
Service Code Paycode Coding Regular |
Data Item |
The non-overtime paycode associated with a Service Code |
Accounting->Global Settings->Service Codes |
Service Code Paycode Coding Overtime |
Data Item |
The overtime paycode associated with a Service Code |
Accounting->Global Settings->Service Codes |
Service Code Paycode Coding Holiday |
Data Item |
The holiday paycode associated with a Service Code |
Accounting->Global Settings->Service Codes |
Service Code Creation Date |
Data Item |
The date a Service Code was created |
Data Exploration |
Service Code Revision Date |
Data Item |
The date a Service Code was revised |
Data Exploration |
Service Code Late Start Hours |
Data Item |
The "Late Start" value specified for a service code. This will have downstream impact for shift approval. |
Accounting->Global Settings->Service Codes |
Service Code Duration |
Data Item |
The default duration of a service code |
Accounting->Global Settings->Service Codes |
Service Code Department Name |
Data Item |
The department that a service code is associated to |
Accounting->Global Settings->Service Codes |
Service Code Visits Overlap Type |
Data Item |
Whether a service code has the "visits can overlap" box checked |
Accounting->Global Settings->Service Codes |
Service Creation Date |
Data Item |
The date a service was created |
Data Exploration |
Service Revision Date |
Data Item |
The date that information about a service was updated |
Data Exploration |
Service Projected End Date |
Data Item |
The projected end date of a service |
Patient Profile->Services->Specific Service |
Service Original Start Date |
Data Item |
A CCAC date field |
Patient Profile->Services->Specific Service |
Service Required First Visit Date |
Data Item |
The date that a first visit for service MUST occur on. If Service Date Service Required BY is populated this will not have a value. |
Patient Profile->Services->Specific Service |
Service Date Service Required By |
Data Item |
The date that first visit for a service must occur BY. If Service Required First Visit Date is populated this will not have a value. |
Patient Profile->Services->Specific Service |
Service BRN |
Data Item |
A number assigned to services being funded by a CCAC |
Patient Profile->Services->Specific Service |
Service Pathway Description |
Data Item |
A description of the service pathway that comes in from some referrals from the CCAC |
Patient Profile->Services->Specific Service->Latest Referral Info |
Service ERL |
Data Item |
A services Emergency Response Level. It is an alphanumeric code that can be assigned to a service to categorize its risk level (codes determined by client). |
Patient Profile->Services->Specific Service |
Service Episode Number |
Data Item |
A variable that organizes services & clinical documentation |
Patient Profile->Services->Specific Service |
Service ID |
Data Item |
An Alayacare assigned number to identify a service |
Patient Profile->Services->Specific Service |
Service Main Address |
Data Item |
The address where a service is performed |
Patient Profile->Services->Specific Service |
Service Description |
Data Item |
A custom name given to a service to describe it |
Patient Profile->Services->Specific Service |
Service Payment Method Name |
Data Item |
The payment method selected at the service level. Values are set in Accounting & Global Settings. |
Patient Profile->Services->Specific Service->Accounting->Payment Method |
Service Payment Method Type |
Data Item |
The type of payment used for a service e.g. cash, credit card |
Patient Profile->Services->Specific Service->Accounting->Payment Method |
Service Start Date Year |
Data Item |
The year a service began |
Patient Profile->Services |
Service Start Date Month |
Data Item |
The month a service began |
Patient Profile->Services |
Service Start Date |
Data Item |
The specific calendar day a service started i.e. 2016-08-18 |
Patient Profile->Services |
Service Status Date |
Data Item |
The effective date of a Service Status |
Patient Profile->Services |
Service Status Reason |
Data Item |
The reason associated with a change in Service Status. Can create custom statuses to reflect organizational needs through Accounting & Global Settings. |
Accounting Global Settings->Service Status Reasons |
Visit By |
Data Item |
The location of a visit. "Visit By The Client" = the visit occurred occurred at the client's address, "Visit By Contact"= the visit occurred at the service address |
Data Exploration |
Visit Funded |
Data Item |
Whether the visit is covered by a funding block or not. Value can be either True or False. |
See the visit dialogue. |
Visit Completed |
Data Item |
Within any calendar view you can click a specific visit to see if it was completed |
Patient Profile->Scheduling |
Visit End Year |
Data Item |
Within any calendar view you can click a specific visit to see when it was completed |
Any scheduling view |
Visit End Month |
Data Item |
Within any calendar view you can click a specific visit to see when it was completed |
Any scheduling view |
Visit End Day |
Data Item |
Within any calendar view you can click a specific visit to see when it was completed |
Any scheduling view |
Visit End Time |
Data Item |
Within any calendar view you can click a specific visit to see when it was completed |
Any scheduling view |
Visit Funder Status |
Data Item |
Whether a Funder has deemed a visit Payable, Suspended, or Rejected. |
Accounting->Billing->Billing Cycle->Shifts |
Visit Holiday |
Data Item |
Whether a visit falls on a Holiday designated in Alayacare |
Data Exploration |
Visit ID |
Data Item |
Unique identifier for a visit |
Any scheduling view |
Visit In A Facility |
Data Item |
Visit In A Facility = the visit was in a facility, for a client or for a facility. Client Visit in A Facility = the visit was in a facility and for a client not for a facility |
Any scheduling view |
Visit Invoiced |
Data Item |
If a visit has been added to an invoice |
Data Exploration |
Visit Late Hours Range |
Data Item |
Visit punched lateness measured by hourly ranges |
Data Exploration |
Visit Sequence By Client |
Data Item |
The count of total visits to a client across all services |
Data Exploration |
Visit Sequence By Client And Service |
Data Item |
The count of total visits within a particular service to a client |
Data Exploration |
Visit Punched |
Data Item |
Whether a visit was punched in by an employee |
Any scheduling view |
Visit Start Year |
Data Item |
The year that a visit occured |
Any scheduling view |
Visit Start Quarter |
Data Item |
The quarter that a visit occured (Q1, Q2, Q3, Q4) |
Any scheduling view |
Visit Start Month |
Data Item |
The month that a visit occured |
Any scheduling view |
Visit Start Day |
Data Item |
The exact date that a visit occured, including month and year |
Any scheduling view |
Visit Start 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 visit start year, then visit start year. You can use this to see data from march for ALL years in the system |
Any scheduling view |
Visit Start Time |
Data Item |
The time of day a visit started |
Any scheduling view |
Visit Start Year- Week |
Data Item |
A year variable to be used together with "Visit Start Week" to determine the specific week that a visit occurred |
Any scheduling view |
Visit Start Week |
Data Item |
The year & week by number that a visit occured |
Any scheduling view |
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 |
Service Distinct Count |
Measure |
The number of distinct services that apply to the designated metrics |
Data Exploration |
Visit Approved Hours Avg |
Measure |
The average number of approved hours for visits related to a specified field |
Data Exploration |
Visit Approved Hours Sum |
Measure |
The total number of hours approved for visits related to specified field |
Data Exploration |
Visit Billed Hours Sum |
Measure |
The total number of hours billed for visits related to specified field(if the service code is billed by units, this value will populate 0) |
Data Exploration |
Visit Count |
Measure |
The total number of distinct visits over a selected time period, both complete & incomplete. |
Data Exploration |
Visit Count - Missed Class |
Measure |
Tenant specific value |
Data Exploration |
Visit Date MAX |
Measure |
This is the last visit date of a year |
Data Exploration |
Visit Date MIN |
Measure |
This is the first visit date of a year |
Data Exploration |
Visit Late Hours Avg(punch start - visit start - service code buffer) |
Measure |
Average time between punch and scheduled visit start |
Data Exploration |
Visit Late Hours Sum(punch start - visit start - service code buffer) |
Measure |
Sum of hours late for a visit(s) |
Data Exploration |
Visit Punched Hours Avg |
Measure |
Average time punched into a visit(s) |
Data Exploration |
Visit Punched Hours Sum |
Measure |
Total hours punched into a visit(s) |
Data Exploration |
Visit Scheduled Hours Avg |
Measure |
Average scheduled duration for a visit(s) |
Data Exploration |
Visit Scheduled Hours Sum |
Measure |
Total hours scheduled for a visit(s) |
Data Exploration |
Visit Scheduled minus Punched Duration Hours Sum |
Measure |
The difference between scheduled and punched duration for a visit(s) |
Data Exploration |