dimlocations

Dimension table delivering location details.

Table 1. dimlocations table
Column Description Example
TenantId

int

This field is for future use only, and is currently not defined.

 
LocationId

varchar

Displays the location id for the element/device. To get access points for a location, perform a join operation with the LocationId column of the dimlocationaccesspoints table.

l-3rd_floor_qa
LocationName

varchar

Displays where the element/device is being operated.

3rd Floor QA
SiteId

varchar

Displays the internal site id for the location.

s-mysitename
LastUpdateDate

timestamp

Displays the last update date of the location access point.

2018-01-01 19:16:25
DeletedFlag

tinyint

Displays 1 if deleted or else 0.

0