Geography Name References

The geography name references view object contains the mapping between location elements and Master Reference geography elements based on Geography Name Matching.

Data Store Key : CrmAnalyticsAM.CrmExtractAM.HzBiccExtractAM.GeoNameReferenceExtractPVO

Primary Keys : GeoNameReferenceId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
CreatedBy	The user who created the record.
CreationDate	The date and time of creating the record.
GeoNameReferenceId	The unique name reference identifier.
GeographyId	The unique identifier for geography that's mapped to a location component for each geography type.
GeographyType	Indicates the geography type of the geography that's mapped to the location component.
LastUpdateDate	The date and time of last update of the record.
LastUpdateLogin	The login of the user who last updated the record.
LastUpdatedBy	The user who last updated the record.
LevelNumber	The level number for a location identifier in a hierarchy.
LocEffectiveEndDate	The effective end date of location.
LocEffectiveStartDate	The effective start date of location.
LocationId	The unique identifier for the location.
LocationTableName	The address table name. Example values: HZ_LOCATIONS, PER_ADDRESSES_F and MKL_LM_LEADS.
UserLastUpdateDate	The date and time when the geography name reference record was last updated. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database such as a different mobile database or the server.