Cube: Service Historical

Use this cube to explore changes to your services over time, like the progression of status changes, or changes to service dates. You have also access to the following dimensions:

Bill Item, Bill rate, Branch, Branch rollback, Client, Client Employee, Client Name, Contact Bill To, Employee, Employee Name, Employee Primary, Facility, Funder, Service Address, Service Codes.

Fields

• Service Sequence By Client
• Facility Service: "true" if the service was created for the facility rather than a client, "false" if not
• First Visit Date - Service Creation Date (Days)
• Service ID: AlayaCare ID of the service
• Service Description: the name of the service

Special Rates (client profile>Accounting>Custom Bill rates):

• Special Rate Start Year
• Special Rate Start Month
• Special Rate Start Day

Service dates:

• Original Start Year
• Original Start Month
• Original Start Day
• Service Start Year
• Service Start Month
• Service Start Day
• Service Effective Year
• Service Effective Month
• Service Effective Day
• Service Creation Year
• Service Creation Month
• Service Creation Day
• Projected End Year
• Projected End Month
• Projected End Day

Visits:

• Visit By
• Visit First Year
• Visit First Month
• Visit First Day
• Visit Last Year
• Visit Last Month
• Visit Last Day

Status:

• Status Year
• Status Month
• Status Day
• Status End Year
• Status End Month
• Status End Day
• Service Status
• Service Status Reason
• Service Status Historical Date From - Year
• Service Status Historical Date From - Month
• Service Status Historical Date From - Day
• Service Status Historical Date To - Year
• Service Status Historical Date To - Month
• Service Status Historical Date To - Day

Client admission and discharge:

• Client Admission Year
• Client Admission Month
• Client Admission Day
• Client Admission Time
• Client Discharge Year
• Client Discharge Month
• Client Discharge Day
• Client Discharged Time

Measures

• Length Of Stay Sum
• Length Of Stay Avg
• Client Distinct Count
• Service Count
• Service Date MIN
• Visit Count
• Average Number Of Visits