Cube: Claims

This cube contains information on claims created for electronic billing. You can use it to report on current and past status changes, claim details, and visits within the claims. Additionally, you can draw information from the following dimensions: Bill Item, Bill Rate, Branch, Client, Client Name, Client Contact, Employee, Employee Name, Funder, Service, Service Codes..

Claim general information:

• Claim Internal Number: internal only
• Claim ID
• Claim Is Preparing: if a claim is in status prepared
• Claim Is Open: value is true if open, false if closed.
• Claim Is Marked for Submission: true" if marked, "false" if not.
• Claim Invoice Number: legacy field.
• Claim Used Bank: if the claim has bank applied, the field value will be yes. Otherwise, its value will be no
• Claim Sent Year/Month/Day
• Claim Units
• Delay Code
• Denial Reason
• Client Cost Centre Description
• Client Cost Centre Number

Banked time:

• Banking Balance
• Banking Turned ON: value is true if yes, false if no.

Claim current status information, including date of update:

• Claim Current Status
• Claim Current Status Year
• Claim Current Status Month 
• Claim Current Status Day 
• Claim Status Message

Visit information:

• Visit ID
• Visit Tag ID: backend ID for a visit tag
• Visit Approval Status
• Visit Hours Approved
• Visit Scheduled Duration
• Visit Punched Duration

Service date for claim:

• Claim Serviced At Year
• Claim Serviced At Month
• Claim Serviced At Day

Visit start and end:

• Visit Start Date Year
• Visit Start Date Month
• Visit Start Date Day
• Visit End Date Year
• Visit End Date Month
• Visit End Date Day
• Visit Start Time
• Visit End Time

Visit punch distance:

• Visit Punch Start Year
• Visit Punch Start Month
• Visit Punch Start Day
• Visit Punch Start Time
• Visit Punch End Year
• Visit Punch End Month
• Visit Punch End Day
• Visit Punch End Time

Claims posting:

• Claims Posting Year
• Claims Posting Month
• Claims Posting Day
• Resubmission Status

Measures

• Claims Balance Amount
• Claims Distinct Count
• Claims Due Amount
• Claims Paid Amount
• Claims Visit Qty
• Claim Bank Sum: value of the bank applied to the claim
• Clients Distinct Count
• Employee Distinct Count
• Invoice Item Qty Sum