Cube: Intake

Use this cube to report on offers and referrals. You can add details to your report with information from the following dimensions:

Bill Item, Branch, Branch rollback, Client, Client Name, Employee Creation Name, Service. 

Cube Fields

• Intake ID
• Intake Reason
• Offer ID
• Intake Type: Offer or Referral
• Intake Status: Accepted, Posted, Processed, or Refused
• Intake Referral Source
• Intake Request Type
• Intake Response
• Intake Offer Refusal Reason
• Intake Service Type
• Intake Service Type Code
• Intake Service Referral Caseload
• Provider notification notes
• Provider instructions

Intake creation date:

• Intake Creation Year
• Intake Creation Month
• Intake Creation Day
• Intake Creation Month All
• Intake Creation Year-Week
• Intake Creation Week

Transmission date fields for offers and referrals:

• Offer Transmission Year
• Offer Transmission Month
• Offer Transmission Day
• Offer Transmission Month All
• Offer Transmission Year-Week
• Offer Transmission Week
• Offer Transmission Time
• Referral Transmission Year
• Referral Transmission Month
• Referral Transmission Day
• Referral Transmission Month All
• Referral Transmission Year-Week
• Referral Transmission Week
• Referral Transmission Time

Expiration date fields:

• Expiration Year
• Expiration Month
• Expiration Day
• Expiration Month All
• Expiration Year-Week
• Expiration Week
• Expiration Time

Processing date fields:

• Process Year
• Process Month
• Process Day
• Process Month All
• Process Year-Week
• Process Week
• Process Time

Measures

• Client Distinct Count
• Referral Posted Sum
• Referral Processed Sum
• Accepted Sum
• Expired Sum
• Refused Sum
• Intake Count