FACAH Quick Start Guide Summary
Overview
Supporting blended facilities reporting and analysis, the Facilities Activity Hub (FacAH) is a central repository for UC San Diego enterprise system data as it relates to all facilities activity across relevant systems.
This hub contains data from current and future facilities systems, including space, personnel assignments and department allocation information. Allocation pattern analysis, space planning and forecast reporting, multi-department analysis and person assigned spaces data is available using the Cognos and Tableau visualization tools. Blending the facilities data from FacAH with other Activity Hubs is supported in Cognos.
Other Resources
Have a field name but not sure what view to look in? Search the Activity Hub Field List.
Data is loaded each night. To see when the data completed being loaded by UCSD into FACAH see this report: Tableau > Public > AH Data Load Status Report.
Space Management Resources: https://rmp.ucsd.edu/fsim/esm.html#Tririga-Training-and-Resources
FACAH Basics
What is a space?
A space can mean a variety of things at UCSD: room, hallway, sections of a room like cubes or desks, closet, restroom.
Spaces are organized into a location hierarchy along the lines of Campus > Neighborhood > Building > Floor > Space > Allocations
Allocations refers to a space’s relationship with departments and clusters. A Space can have multiple allocations to different departments and clusters at the same time.
Additionally, a space can have different types of assigned occupants. Not all spaces have occupants.
Note: Buildings in planning or development do not have spaces and are not included in FACAH.
Allocated vs Assigned
Allocated refers to a space’s relationship with departments and clusters.
Assignments refer to people / headcount within a space.
Occupancy
Occupancy is the count of persons assigned to a space. Those people may or may not work in that space every day of the week. Therefore, the number of assigned people in a space may exceed the number of seats within a space.
| Example 1 | Example 2 | Example 3 |
|
|---|---|---|---|---|
Space Occupant Count | 4 | 3 | 6 |
|
Space Total Capacity | 6 | 6 | 6 |
|
Space Workpoint Capacity | 4 | 4 | 4 |
|
Space Sq Ft | 100 | 100 | 100 |
|
Space Occupant Sq Ft = Space Sq Ft / Space Occupant Count | .25 | .3333 | .16666 | Will change with assignments, could change daily |
Find the FACAH View you need
Use Case | Recommended View | Recommended Folder / Fields |
|---|---|---|
I want to see all of the secondary locations of a person | FACAH-SpaceAllocationDetail-View |
|
I want to see 1 row per person | FACAH-PersonLocation-View |
|
What is in a FACAH View?
View Name / Cognos Package Name / Tableau Data Source Name | Contents | Security |
|---|---|---|
FACAH-PersonLocation-View | Space assignments per Person + Employee Activity Hub (EAH) person information 1 row per person Only 1 secondary location will be displayed Pre-joined with EAH-Workforce-View on Current Primary Position for the Employee | FACAH Core |
FACAH-Spaces-View | Information about the space, including details of all location hierarchy levels related to that space 1 row per space Includes assigned + unassigned, allocated + unallocated spaces | FACAH Core |
FACAH-SpaceAllocationDetails-View | FACAH-PersonLocation-View + FACAH-Spaces-View + Department Allocations + Cluster Allocations Multiple levels of detail included *warning - this is an advanced view, do not start here if you are new to space data, double check your totals | FACAH Core |