Use this cube to report on the use of activity codes throughout your visits. You can complete this information with fields from the following dimensions:
Activity codes, Branch, Branch rollback, Cancel Code, Client, Client Name, Employee, Employee Name, Facility, Funder, Service, Service Codes.
- Approval Status: of the visit'; approved, not approved, or rejected
- Account Type
- Visit ID
- Service Skill Type: category of skills on the service
- Service Skill Name: name of the skill on the service
- Service Label Name: invoice label on the service
- Service Label Value: invoice label value
- Visit Start Year
- Visit Start Month
- Visit Start Day
- Visit End Year
- Visit End Month
- Visit End Day
- Visit Start Time
- Visit End Time
- Visit Count
- Visit Approved Hours Sum: the total of approved hours for a given visit, irrespective of the bill-override or pay-override quantities or units.
- Visit Approved Hours Avg: the average of approved hours for a given visit, irrespective of the bill-override or pay-override quantities or units.
- Client Distinct Count
- Employee Distinct Count
- Visit Date MAX
- Visit Date MIN
- Visit Scheduled Hours Sum
- Visit Scheduled Hours Avg
- Override Bill Sum
- Override Pay Sum
Article is closed for comments.