Data Points
Snowflake Field Name | Tableau Data Source Field | Folder | Description |
Location Name | Location Name | Root | The lowest level of the hierarchy. This field is the specific bed/location name. |
Location ID | Location ID | Root | The ID associated with the Location Name |
Room Name | Room Name | Root | The name of the room that the location is in. A room can have multiple Location Names within it. |
Room ID | Room ID | Root | The ID associated with the Room Name |
Floor Name | Floor Name | Root | The floor of the building that the location is in. |
Floor ID | Floor ID | Root | The ID associated with the Floor Name |
Building Name | Building Name | Root | The name of the building on the campus |
Building ID | Building ID | Root | The ID associated with the Building Name |
Campus Name | Campus Name | Root | The name of the campus |
Campus ID | Campus ID | Root | The ID associated with the Campus Name |
Campus Street | Campus Street | Root | The street address of the campus |
Campus City | Campus City | Root | The city name of the campus |
Campus Zip | Campus Zip | Root | The zip code of the campus |
Customer Facility ID | Customer Facility ID | Root | The facility ID of the campus |
IQ Facility Name | IQ Facility Name | Root | The name assigned to the facility within Transfer IQ |
Enterprise Name | Enterprise Name | Root | The name of the enterprise |
Enterprise Levels 1-25 | Enterprise Levels 1-25 | Root | The enterprise hierarchy structure derived from Transfer IQ. This can include up to 25 levels. |
LastModDate | LastModDate | Root | System calculation that displays the most recent update to the application database in local time. This field is not intended for client reporting |
LastModDate_UTC | LastModDate_UTC | Root | System calculation that displays the most recent update to the application database in UTC. This field is not intended for client reporting |
Latest_LastModDate_UTC | Latest_LastModDate_UTC | Root | System calculation that displays the most recent update to the application database for any location in UTC. This field is not intended for client reporting |
TenantID | TenantID | Root | The unique identifier associated with the tenant. This field is not intended for client reporting. |
WarehouseAcquisitionDate_UTC | WarehouseAcquisitionDate_UTC | Root | The latest timestamp that a record is inserted in the Snowflake Data Warehouse in UTC format. |