---
schema_version: "1"
id: 8251e0c21aa470fa2742c385ddd8bc24c0ab0f4103cd6982a04e03ce58d63112
title: ccdw_aggr_registration
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/commerce-cloud/b2c-commerce/guides/jdbc/jdbc_ccdw_aggr_registration.md
canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_registration.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 3971ee00ac7326893eaaae1f362da7e380ba87b204b8bfaf725baaae4ad1f0d0
products:
  - Composable Storefront
  - Salesforce APIs
---
# ccdw_aggr_registration

This table summarizes customer registration activity.

| Column Alias        | Data Type | Key    | Description                                                                  | Index? |
| ------------------- | --------- | ------ | ---------------------------------------------------------------------------- | ------ |
| `registration_date` | DATE      |        | Date of customer registration.                                               | Yes    |
| `site_id`           | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_site`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_site.md).                     | Yes    |
| `locale_code`       | VARCHAR   |        | Locale code from [`ccdw_dim_locale`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_locale.md).               | Yes    |
| `device_class_code` | VARCHAR   |        | Device class code from [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md). | Yes    |
| `num_registrations` | INTEGER   |        | Total number of customer registrations.                                      | No     |

<!-- **Indices**: `registration_date, site_id,locale_code, device_class_code` -->