# ccdw_fact_customer_list_snapshot

This table provides snapshots of customer list metrics over time.

| Column Alias                   | Data Type | Key    | Description                                                                                                                          | Index? |
| ------------------------------ | --------- | ------ | ------------------------------------------------------------------------------------------------------------------------------------ | ------ |
| `customer_list_record_id (PK)` | BIGINT    | **PK** | Unique identifier for a customer list snapshot record.                                                                               | No     |
| `ncustomer_list_id`            | VARCHAR   |        | Normalized customer list identifier.                                                                                                 | No     |
| `utc_record_timestamp`         | TIMESTAMP |        | UTC timestamp of the snapshot.                                                                                                       | No     |
| `utc_record_day_id`            | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_date`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_date.md) for the UTC record day.                    | No     |
| `utc_record_time_id`           | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_time`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_time.md) for the UTC record time.                   | No     |
| `utc_update_timestamp`         | TIMESTAMP |        | Last modified UTC timestamp of this record.                                                                                          | Yes    |
| `std_record_timestamp`         | TIMESTAMP |        | Timestamp of the snapshot, in standard time.                                                                                         | No     |
| `std_record_day_id`            | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_date`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_date.md) for the standard record day.               | No     |
| `std_record_time_id`           | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_time`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_time.md) for the standard record time.              | No     |
| `std_record_timezone_id`       | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_timezone`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_timezone.md) for the standard record time zone. | No     |
| `site_id`                      | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_site`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_site.md).                                           | No     |
| `num_customers`                | INTEGER   |        | Total number of registered customers at the time of snapshot.                                                                        | No     |