Cube: Claim Status History

This cube contains claim information based on its status history. It can be used to determine a claim's balance based on its status. Information from the following dimensions can be pulled:

Bill Item, Branch, Funder, Client, Client Name, Employee Update Name and Employee Update

Fields

• Claim ID
• Claim Status
• Claim Delay Reason Code
• Claim Procedure Code
• Claim Procedure Modifier
• Claim Quantity
• Claim Total Billed
• Claim Total Paid
• Claim Total Adjusted
• Claim Balance
• Claim Serviced at Year
• Claim Serviced at Month
• Claim Serviced at Day
• Claim Update Year
• Claim Update Month
• Claim Update Day
• Claim Update Time

Measures

• Client Distinct Count
• Claims Distinct Count