Space / Space Planning / Space Planner / Space & Portfolio Planning Console
Real Property / Advanced Forecasting / Advanced Portfolio Forecasting / Space & Portfolio Planning Console
Concept: Groups Table and the Space & Portfolio Planning Console
The Groups table works behind the scenes in the Space & Portfolio Planning Console; it stores the allocations with which you experiment on stack plans This topic documents how the system generates records in the Groups table and the values for key fields.
To examine the Groups table:
- Review the Allocation Events tab of the Space & Portfolio Planning Console. This tab lists allocations organized by Group Name.
- Users with the Smart Client can examine the Groups table and the generated records. In Smart Client, choose the Views tab at the bottom of the screen. Choose to add the GP (Groups) table to your view. Since the Groups table is used for both a space inventory at the group level and portfolio scenarios, you may wish to turn on the portfolio-related fields such as Allocation Event, Event Date, Group Name, Portfolio Scenario, and so on, and turn off the space inventory-related fields such as Group Area and Chargeable Cost.
Allocations are created in the Groups table when:
- you add space requirements to a portfolio scenario.
- you add existing space to a portfolio scenario
- you create unavailable space in the stack plan
- you create new allocations in the stack plan
- you sync, if working with functional groups
- you create a portfolio scenario
The sections below describe the various types of allocations stored in the Groups table, organized by Group Name.
Note: The Groups table is also used by the Space Inventory application to store departmental areas located on one floor. See Group Inventory Process.
Unallocated
When you start a portfolio scenario, the system creates Unallocated groups, with 2500 square feet assigned to each of five floors in the UNALLOC building. The system creates the UNALLOC virtual building whose purpose is to hold organizational groups that are not yet associated with any building or floor. When working with the stack plan, you can drag allocations that the system places on the UNALLOC stack plan to the stack plans for buildings in your inventory; you can also drag allocations from a floor's stack to the UNALLOC stack plan to use as a holding place; .
Field in GP Table | Value |
---|---|
Allocation Type | Usable Area Owned |
Event Name | Add Space from Inventory |
Group Name | Unallocated |
Area Feet (area_manual) |
defaults to 2500 |
Other Unavailable Space
When you Add New Space to a Scenario or Add Unavailable Area to the Stack Plan and specify that the space as unavailable, the system creates the Other Unavailable Area record in the Groups table.
Field in GP Table | Value |
---|---|
Allocation Type | Unavailable Area |
Event Name | value that you enter |
Group Name | Other Unavailable Space |
Area Feet (area_manual) |
value that you enter |
Allocated Area
When you add space requirements to a portfolio scenario or add existing space to a portfolio scenario, the system runs the AbRPLMGroupSpaceAllocation-PortfolioForecastingService
workflow rule to create the allocations for each organization in the inventory.
From the organizational unit (business unit, division, department, functional group) at which you specify space requirements, the system runs the workflow rule to create the corresponding allocations in the stack plan and colors them according to the AutoCAD Highlight Pattern field for the department. You can edit the generated color if you wish. See Edit an Allocation on a Stack Plan.
In the Groups table, the system creates the allocations and completes these key fields:
Field in GP Table | Value |
---|---|
Allocation Type | Allocated Area |
Event Name | Add space from inventory |
Group Name | This is the name of the business unit, division, department, or functional group represented by this allocation. |
Area Feet (area_manual) |
the sum of all areas for this organization on this floor |
The system also creates Allocated Area records when you do the following on a stack plan:
- create new allocations. See Adding New Allocations to the Stack Plan.
- split allocations. See Splitting an Allocation.
Owned Floor
When you add space requirements to a portfolio scenario or add existing space to a portfolio scenario, the AbRPLMGroupSpaceAllocation-PortfolioForecastingService
workflow rule creates the Owned Floor record if the building is owned. This reflects the amount of area available for allocations on the stack
The system creates Group records that represent Usable Area of floors that do not contain leases (that is, there area no records for that floor in the Suites table). The system sums the areas of the rooms where Super Category = Usable, and where the category space is used in calculations (rmcat.used in_calcs = ’all_totals’
). The system does not rely on the value fl.area_usable
because users might have made changes to the rooms since running the Update Area Totals workflow rule, and because fl.area_usuable
includes Remaining Area.
Field in GP Table | Value |
---|---|
Allocation Type | Usable Area – Owned |
Event Name | Add space from inventory |
Group Name | Owned Floor |
Area Feet (area_manual) |
|
Lease Information
It the building is leased, the workflow rules creates the Lease Information record.
Field in GP Table | Value |
---|---|
Allocation Type | Usable Area – Leased |
Event Name | Add space from inventory |
Group Name | Lease Information |
Area Feet (area_manual) |
If the Lease Area Method = Suite, then If the Lease Area Method = Group, then If the Lease Area Method = Room – Composite or Room – All Room, then s |
To show the date span of the lease, the system completes the Start Date and End Date fields. The Start Date of the lease group cannot occur before the Portfolio Start Date (portfolio_scenario.date_start
). If the lease has a start date that occurs before the Portfolio Start Date, then the lease group start date will be the same as the Portfolio Scenario Start Date. The lease start date can be later than the Portfolio Scenario Start Date.
Unavailable - Vertical Penetration Area
The workflow rule creates an allocation and corresponding stack element for each floor's vertical penetration.
Field in GP Table | Value |
---|---|
Allocation Type | Unavailable - Vertical Penetration Area |
Event Name | Add space from inventory |
Group Name | Unavailable - Vertical Penetration Area |
Area Feet (area_manual) |
|
Unavailable - Service Area
The workflow rule creates an allocation and corresponding stack element for each floor's service area
Field in GP Table | Value |
---|---|
Allocation Type | Unavailable - Service Area |
Event Name | Add space from inventory |
Group Name | Unavailable - Service Area |
Area Feet (area_manual) |
|
Unavailable - Remaining Area
Unavailable - Remaining Area represents the sum of a floor's Usable Rooms, Vertical Penetration, and Service Areas subtracted from Gross Area. It applies only for floors that are owned; this is not created for floors that contain leases. For more information, see Concept: Remaining Area and Usable Area Calculations
Field in GP Table | Value |
---|---|
Allocation Type | Unavailable - Remaining Area |
Event Name | Add space from inventory |
Group Name | Unavailable - Remaining Area |
Area Feet (area_manual) |
|