Cube: Service recurrence

Use this cube to review your recurrences, such as the recurrence rules and start and end dates. You can also use fields form the following dimensions:

Branch, Branch rollback, Client, Client Name, Employee Name, Service, Service Codes.

Fields

• Service Recurrence ID

Recurrence rules:

• Service Recurrence Duration: length of the visits of the recurrence.
• Service Recurrence Frequency: "daily", "monthly", or "weekly"
• Service Recurrence Repeat Interval: for weekly or monthly recurrences, the repeat interval. for example, "2" for a rule of 'every 2 weeks".
• Service Recurrence Rule: for a weekly recurrence, the days of the week on which the visits take place.

Recurrence dates:

• Service Recurrence Start Day
• Service Recurrence Start Month
• Service Recurrence Start Time
• Service Recurrence Start Year
• Service Recurrence End Day
• Service Recurrence End Month
• Service Recurrence End Time
• Service Recurrence End Year
• Service Recurrence Scheduled Until Day: the scheduled until fields refer to the last visit created according to the mastering period configured in system settings.
• Service Recurrence Scheduled Until Month
• Service Recurrence Scheduled Until Year
• Recurrence Schedule Create Date: date recurrence rule was created.

Service labels:

• Service Label Name
• Service Label Value

Skills:

• Service Skill Name
• Service Skill Type

Facility:

• Facility ID
• Facility Name

Funder:

• Funder Code
• Funder Code Desc

Measures

• Client Distinct Count
• Employee Distinct Count
• Service Distinct Count
• Service Recurrence Count
• Service Recurrence Duration Sum