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
Comments
0 comments
Article is closed for comments.