Cube: Service

Use this cube to report on your clients' services.

Bill Item, Bill rate, Branch, Branch rollback, Client, Client Employee, Client Name, Contact Bill To, Employee, Employee Creation, Employee Creation Name, Employee Name, Employee Primary, Facility, Funder, Service Address, Service Codes, Service Cost Centre, Tag

Cube Fields

• Service Sequence By Client
• Activity Code Attached: false or true
• Facility Service: false or true
• Add To Associated Employees: false or true
• Service ID: the AlayaCare ID
• Visit By
• Service Description: the name of the service
• Service Status
• Service Status Reason
• Service instructions
• Service Episode Number
• Service Client Diagnosis
• Service Client Care Plan
• Service BRN
• Service Type Code
• Service Type Code Number
• Service Reason Code
• Service Reason Code Date
• Service Patient Available Date
• Service Notes
• Service Priority Rating
• Service Emergency Response Level
• Service Pathway Description
• Service Care Coordinator
• Service Preferred Language
• Service Workflow Status
• Service Assignment ID
• Service Delivery Type
• Service Medicaid Prior Authorization Number
• Pay Code Description

Payment method of the service:

• Service Payment Method Type
• Service Payment Method Name

Invoice labels of the service:

• Service Label Name
• Service Label Value

Skills on the service:

• Service Skill Type
• Service Skill Name

Service address:

• Treatment Firstname
• Treatment Lastname
• Treatment State/Province
• Treatment City
• Treatment Postal Code
• Treatment Phone
• Treatment Address
• Treatment Address 2
• Treatment Address 3

Referral information:

• Service Offer ID
• Service Referral Frequency Start Date
• Service Referral Frequency End Date
• Service Referral Frequency First Start Date
• Service Referral Frequency First End Date
• Service Referral Caseload

Service status historical:

• Service Status Historical Date From
• Service Status Historical Date To
• Service Status Historical
• Service Status Historical Status Days

Service dates:

• Service Start Year
• Service Start Month
• Service Start Day
• Service Effective Year: date of last status change
• Service Effective Month: date of last status change
• Service Effective Day: date of last status change
• Service Creation Year
• Service Creation Month
• Service Creation Day
• Service Creation Time
• Service Required First Visit Date
• Service Original Required First Visit Date
• Service Date Service Required By
• Service Original Date Service Required By
• Service Recertification Start Day
• Service Recertification Period
• First Visit Date - Service Creation Date (Days): difference between when the first visit of the service occurred and the creation date of the service.
• Projected End Year
• Projected End Month
• Projected End Day
• Status Year
• Status Month
• Status Day
• Status End Year
• Status End Month
• Status End Day
• Special Rate Start Year
• Special Rate Start Month
• Special Rate Start Day
• Visit First Year
• Visit First Month
• Visit First Day
• Visit Last Year
• Visit Last Month
• Visit Last Day
• Original Start Year
• Original Start Month
• Original Start Day

Client contact information:

• Client Contact Firstname
• Client Contact Lastname
• Client Contact Address
• Client Contact Address 2
• Client Contact City
• Client Contact State/Province
• Client Contact Postal Code
• Client Contact Country
• Client Contact Phone
• Client Contact Relationship
• Client Contact Type
• Client Contact Email
• Client Contact Status

Client admission and discharge dates:

• 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