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
Comments
0 comments
Article is closed for comments.