---
schema_version: "1"
id: a4c660034c935f99352acee2abec411bd15f1d39eed17ea228e06c88d76a36b4
title: ccdw_fact_customer_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_fact_customer_registration.md
canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_fact_customer_registration.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 3892698046717d294de3b0d394a92e3f2c993b3274929488204fb7082eefb379
products:
  - Composable Storefront
  - Salesforce APIs
---
# ccdw_fact_customer_registration

This table records customer registration events.

| Column Alias                   | Data Type | Key    | Description                                                                                                                                                            | Index? |
| ------------------------------ | --------- | ------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------ |
| `registration_id (PK)`         | BIGINT    | **PK** | Unique identifier for a customer registration.                                                                                                                         | No     |
| `utc_registration_timestamp`   | TIMESTAMP |        | UTC timestamp of the registration.                                                                                                                                     | No     |
| `utc_registration_day_id`      | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_date`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_date.md) for the UTC registration day.                                                                                  | No     |
| `utc_registration_time_id`     | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_time`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_time.md) for the UTC registration time.                                                                                 | No     |
| `utc_update_timestamp`         | TIMESTAMP |        | Last modified UTC timestamp of this record.                                                                                                                            | Yes    |
| `std_registration_timestamp`   | TIMESTAMP |        | Timestamp of the registration, in standard time.                                                                                                                       | No     |
| `std_registration_day_id`      | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_date`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_date.md) for the standard registration day.                                                                             | No     |
| `std_registration_time_id`     | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_time`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_time.md) for the standard registration time.                                                                            | No     |
| `std_registration_timezone_id` | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_timezone`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_timezone.md) for the standard registration time zone.                                                               | No     |
| `registration_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) where the registration occurred.                                                                               | No     |
| `visitor_id`                   | VARCHAR   |        | Unique identifier for a visitor session. This ID persists across sessions and is associated with an anonymous tracking cookie (for example, dwanonymous).              | No     |
| `customer_id`                  | BIGINT    | **FK** | Foreign key to [`ccdw_dim_customer`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_customer.md). For unregistered buyers, this value is `1` and can't distinguish one unregistered buyer from another. | No     |
| `locale_id`                    | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_locale`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_locale.md).                                                                                                           | No     |
| `user_agent_id`                | INTEGER   | **FK** | Foreign key to [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md).                                                                                                   | No     |