Locations Extent (System.Identity Module)
[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]
Contains details about specific physical locations.
Fields
The following table lists the fields in the Locations extent.
| Column | Type | Required | Description |
|---|---|---|---|
Folder |
yes |
The Modeling Services Folder associated with the Location. |
|
Id |
Integer64 |
yes |
The unique identifier of the Location. |
KindId |
The unique identifier of a Kind that describes additional information about the Location. |
||
TenantId |
yes |
||
ParentLocationId |
The unique identifier for the parent Location for the Location in a Location hierarchy. For example, a city location could have a parent location of a country. |
||
Name |
Text(256) |
The name of the Location. |
|
DisplayName |
Text(256) |
The display name of the Location. |
|
MetropolitanRegion |
Text(128) |
The metropolitan region of the Location. |
|
Neighborhood |
Text(128) |
The neighborhood name of the Location. |
|
Street |
Text(256) |
The street value of the Location. |
|
City |
Text(256) |
The city of the Location. |
|
PostalCode |
Text(64) |
The postal code of the Location. |
|
StateOrProvince |
Text(64) |
The state or province of the Location. |
|
Country |
Text(128) |
The country of the Location. |
|
AnchorPointLat |
The latitude value of the Location. |
||
CountryCode |
Text(6) |
The country code of the Location. |
|
AnchorPointLong |
The longitude value of the Location. |
||
MailStop |
Text(256) |
The mail stop of the Location. |
|
TimeZone |
Integer16 |
The time zone of the Location. |
|
AnchorPointVertical |
|||
DescriptiveInformation |
Text(2048) |
Additional information about the Location. |
Remarks
To work with this extent in the SQL Server Modeling Services, see Locations Table (System.Identity Schema).