Inventory Model: Unit/Bed Current Availability Review

The Look outlined below contains a table outlining units/beds, associated programs and project types, and current availability. 

The steps below outline how to create this Look. 

1. Explore - Inventory Model
2. Fields
   Add the following fields to the Look: 

• • Dimensions
    • Inventory - Building Unit Configurations - Enable Beds (Yes / No) 
    • Inventory - Building Units - ID 
    • Inventory - Building Units  - Name 
    • Inventory - Buildings - ID 
    • Inventory - Buildings  - Name 
    • Inventory - Programs - Programs Served by the Unit - Program Name - Unit 
    • Inventory - Programs - Programs Served by the Unit - Project Type Code - Unit 
    • Inventory - Unit Configuration Beds - ID 
    • Inventory - Unit Configuration Beds - Name 
    • Unit Availability Status - Current Availability 

• • Measures
    • Inventory – Building Unit Configurations – Total Beds

3.   Filters

        Add the following fields as filters to the Look: 

• • Inventory - Unit Configuration History Configuration Status: is equal to Current Configuration 

Update the Row Limit as needed.