Skip to main content

Dealer

Overview​

The Dealer data product serves as a valuable resource providing access to curated data about a franchise that enters into sales and service agreements with General Motors to market, sell, and service GM Products. This data is collected from various source systems, ensuring that it is comprehensive and relevant. By leveraging this carefully gathered information, analytic teams can derive insights and make informed decisions that drive their strategies and operations forward.

Below is an example of available Data Product/s with link to Confluence page:

SUBPRODUCTDESCRIPTION
Dealer IdentityA franchise that enters into sales and service agreements with General Motors to market, sell, and service GM Products.  This was previously known as Dealer360.
This includes dealers, upfitters, auction houses, and other entities that partner with GM after production before or part of the sale.

Key Benefits​

  • A master repository of all GM dealers.

  • Cross-reference tables enabling dealer chaining and relationship mapping.

  • Business Function Unit (BFU) codes linked to Business Associate Codes (BACs), defining dealer capabilities and authorizations.

  • Area of Primary Responsibility (APR) assignments for geographic and operational alignment.

  • Daily hours of operation for sales, service, and parts departments.

  • Classification of dealers by GM’s vehicle marketing divisions

Getting Access and Data Catalog:​

All requests to access GM data must be reviewed and approved by GM’s privacy team via the Privacy Impact Assessment (PIA) tool. GM’s PIA tool helps to identify, assess, and mitigate privacy risks associated with a particular product or service—especially when it collects, uses, stores, or shares personal data. If a PIA has not been approved for your use case, you can submit one using the link: epia.gm.com.

SUBPRODUCTGLENDA PROFILEATLAN
Dealer IdentityDirect Query Access - HDL - Dealer_PROD - Silver_Dealer_Identity_GMNA - ReaderDealer Identity

Note :

  • To gain access to confluence pages: Navigate to Service Now , Search for 'Confluence (CONF) Access' , Under the ‘What do you need access to? Search by group or space name’ question select Data Engineering (Viewer)

  • To request access to data: Go to http://myaccess.gm.com/ . Under Manage Access -> Manage My Access , submit a request with Glenda profile information provided above.

Cross-reference tables enabling dealer chaining and relationship mapping

  • identify dealers that take on business of dealerships that have closed:
select * from dealer_prod.silver_dealer_identity_gmna.dealer_old_new_xref
  • identify the sales hierarchy of a dealer:
select * from dealer_prod.silver_dealer_identity_gmna.fs_dlr_sales_hier

Business Function Unit (BFU) codes linked to Business Associate Codes (BACs), defining dealer capabilities and authorizations

select business_function_use_cd, business_function_use_desc, count(distinct business_associate_cd) from
dealer_prod.silver_dealer_identity_gmna.business_associate_function_use
where status = 'A' --limiting to active associations
group by 1,2

How many dealers have the same Area of Primary Responsibility (APR) assignments for geographic and operational alignment.

select zip_5_cd, count(distinct(business_associate_cd))
from dealer_prod.silver_dealer_identity_gmna.dealer_area_primary_responsibility
group by 1

Daily hours of operation for sales, service, and parts departments

select zip_5_cd, count(distinct(business_associate_cd))
from dealer_prod.silver_dealer_identity_gmna.dealer_area_primary_responsibility
group by 1

Classification of dealers by GM’s vehicle marketing divisions

select marketing_organization_type_desc, count(distinct(business_associate_cd))
from dealer_prod.silver_dealer_identity_gmna.business_associate_marketing_organization_type_hierarchy
group by 1

Who's Using this Data?​

  • many groups

Training & Learning Resources​

Need Help? Connect with us​

Support Channels​

Have an update? Send us your feedback via Slack at: #feedback-data-gm-com​

Last updated: October 16, 2025 Document version: 1.0