Use this cube to report on visit and recurrence offers and responses: dates, status, and comments. You can complete your report with information from the following dimensions:
Branch, Branch rollback, Client, Client Cost Centre, Client Name, Employee, Employee Name, Funder, Service
Fields
Offer:
- Offer ID
- Offer Status: either closed or sent
- Offer Creation Year
- Offer Creation Month
- Offer Creation Day
- Offer Status Revision Year
- Offer Status Revision Month
- Offer Status Revision Day
- Offer Due Year
- Offer Due Month
- Offer Due Day
Response:
- Response ID
- Response Status: accepted, declined, or none
- Response Comment
- Response Active
- Response Revision Year
- Response Revision Month
- Response Revision Day
Recurrence information:
- Recurrence Start Year
- Recurrence Start Month
- Recurrence Start Day
Visit information:
- Visit ID
- Visit Start Year
- Visit Start Month
- Visit Start Day
- Visit End Year
- Visit End Month
- Visit End Day
- Visit Start Time
- Visit End Time
Measures
- Response Count: the number of responses received. If no response has been received, it will register a total of 0.
- Offer Count: the number of offers sent.
- Employee Distinct Count
Comments
0 comments
Article is closed for comments.