Cube: APR

This cube contains information on APRs. You can use it to report on the creation, submission, and progress of APRs. In addition to report details and dates, the first visit dates are also available, as well as fields from the following dimensions: 

Branch, Branch rollback, Client, Client Name, Employee, Employee Creation, Employee Creation Name, Employee Name, Employee Update, Employee Update Name, Funder, Service, Service Change Type.

Fields

Report details:

• Report Name
• Report ID
• Report Status
• Report Type
• Report Urgent
• Report Response

Report dates - submission, creation, revision: 

• Report Submission Date - First Visit Date (in days)
• Report Submission Date - Last Visit Date (in days)
• Report Submission Date - Service Discharge Date (in days)
• Report Creation Year
• Report Creation Month
• Report Creation Day
• Report Revision Year
• Report Revision Month
• Report Revision Day
• Report Submission Year
• Report Submission Month
• Report Submission Day

First Visit Date and Time:

• First Visit Start Year
• First Visit Start Month
• First Visit Start Day
• First Visit Start Time

Measures

• First Visit Date And Report Submission
• Last Visit Date And Report Submission
• Service Discharge Date And Report Submission
• Report Count