Skip to main content

After Sales Business Catalog

Overview​

Suite of data hubs supporting Customer Care and Aftersales business functions including Supply Chain, Warehousing, Logistics, Sales, Service and Battery Lifecycle. Extensively used by data analysts to produce various KPIs to support Aftersales and Battery Lifecycle Business Operations.

Key Benefits​

This data supports analytics to support complete business model for Aftersales Order-to-Cash, Request-to-Pay, Issue-to-Resolution and Battery Remanufacturing and Recycling

  • Customer Care Aftersales Decision Analytics (CCADA):

    • The CCA Decision Analytics suite consists of a large data warehouse and multiple front ends that serves various CCA functional areas.

    • Daily Sales Report (SRT): Provides CCA daily sales reporting through web interface (used by internal GM and Field reps)

    • PASE: Web application that collects and measures existing metrics on dealer performance and calculates dealer incentives.

    • Risk Analysis: Used by Supply Chain management to support the workflow of creating part disposition analysis requests, analyzing and assigning part disposition recommendations, and tracking the part disposition action plans.

    • SMARTWEB: Web App that allows CCA users to write SQL statements and pull data from the data warehouse.

  • Aftersales Transactional Data Store (ATDS):

    • Sources and consolidates data from various CCA global data sources

    • Serves as Operational Data Store (ODS) to support downstream CCA and Supply Chain applications

    • Supports operational reporting with near real-time data needs

    • Supports Aftersales Gateway services

  • End User Computing (EUC):

    • Data mart is used by GM Customer Care and Aftersales (CC&A) as an end-user computing system for customers to generate AD-Hoc queries for a variety of reports.

    • Primarily serves USCA Mainframe data refreshed daily

  • Inventory Tracking & Control (ITC):

    • Collection of inventory and sales-related data stored in a centralized repository and readily accessible to the entire CCA enterprise.

    • Inventory Transactions (loaded daily) - An Inventory Transaction describes the historical movement of SPO-owned inventory.

    • Inventory Balances (loaded twice a month) - Inventory Balances represent balance quantities for SPO-owned inventory. The data is divided into various inventory subsets. All values represent unit quantities

    • Materials & Returns (loaded monthly) - Sales and Returns information is fed from Invoicing and contains records where part number is included

  • Business Process Support Planning Center (BPSPC/BPS):

    • Consolidated data from RIM, EUC, Mainframe supporting Aftersales Supply Chain Business function

    • Supports data for the reduction of back-order and increase in System-Fill.

  • Aftersales Engineering Vault:

    • Primary data repository for aftersales vehicle information, encompassing both as-built configurations and as-maintained changes throughout the vehicle's lifecycle.

    • Primary data repository for aftersales battery information

    • Primary data source for Aftersales Services Gateway APIs consumed by aftersales enterprise applications

    • Consolidated data from GPDHUB, GSPAS, GEPICS, Flexnet, SAVI, US external partners (ATC, LabelMaster, SNT, Honda), and regional external partners

    • Supports business operations for remanufacturing and recycling of EV batteries in the US and other regions

    • Supports business operations for vehicle service management, electronic key code management, service authoring, Part Traceability

Getting Access​

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.

How to Get Access to Aftersales Data

  • Access Instructions:

    • Oracle access is requested through Galileo per ASMS.

    • Databricks access through Glenda Roles (catalog a204571-ccawdp-prod):

Databricks SchemaGlenda Role
aev_178705_abt204571-NA-CCA Databricks Readers Secure ABT
aev_178705_ime204571-NA-CCA Databricks Readers Secure IME
aev_178705_rpt204571-NA-CCA Databricks Readers Secure RPT
aev_178705_savi204571-NA-CCA Databricks Readers Secure SAVI
atds_otc204571-NA-CCA Databricks Readers Secure ATDS_OTC
dbo204571-NA-CCA Databricks Readers Secure ABT EUC
mlmexicodw204571-NA-CCA Databricks Readers Secure ABT EUC
mlsa204571-NA-CCA Databricks Readers Secure ABT EUC
iam_sales204571-NA-CCA Databricks Readers Secure IAM_SALES
  • Access Levels: Reader, Enhanced (for data engineers/analysts)

Explore the Data Catalog​

Browse available After Sales data:

  • What are the open backorders for a give part number/dealer?

  • What are the replacement parts for a given part number?

  • What is the supersession chain for a given part number?

  • What are the current inventory levels for a given part/warehouse?

  • Who is the prime supplier for a given part?

  • What are contracts for a given supplier?

Sample Query​

- Sample query - COMING SOON

Who's Using this Data?​

Reports and Dashboards​

  • COMING SOON

Training & Learning Resources​

Status: COMING SOON

API Documentation and Tutorials​

Need Help? Connect with us​

Support Channels​

  • Primary Channel for Data: #help-data
  • Primary Contact for access related questions - Galileo Access Request (per ASMS)

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

Last updated: August 18, 2025 Document version: 1.0