Cube: Funding Block

Report on funding block quantities, dates, and frequency. You can also add fields from the following dimensions:

Bill Item, Branch, Branch rollback, Cancel Code, Client, Client Employee, Client Name, Employee Primary, Funder, Service, Service Codes.

Cube Fields

Fields describing the funding block:

• Funding Block ID: each funding block, including the master, has an individual ID
• Funding Block Units: visits or hours
• Funding Block Frequency: custom, monthly, total, or weekly
• Funder Type
• Claim Type

The service label:

• Service Label Name
• Service Label Value

Funding block dates - start, end, expiry, creation, revision:

• Funding Block Start Year
• Funding Block Start Month
• Funding Block Start Day
• Funding Block End Year
• Funding Block End Month
• Funding Block End Day: End refers to the end date of the individual funding block.
• Funding Block Expiry Year
• Funding Block Expiry Month
• Funding Block Expiry Day: expiry refers to the end date of the mast funding block.
• Funding Block Creation Year
• Funding Block Creation Month
• Funding Block Creation Day
• Funding Block Revision Year
• Funding Block Revision Month
• Funding Block Revision Day
• Funding Block Master: true for master funding blocks, false if not. 

Measures

• Funding Block Count: the total of separate funding blocks
• Funding Block Quantity Sum: the sum of all the funding block quantities
• Visit Scheduled Hours Sum
• Visit Count