# Fact Tables

Fact tables contain the quantitative data or "facts" about business events, often linked to dimension tables by foreign keys.

| Fact Table Name                                                                                                                    | Description                                                                                                                                                                    | Indices                                                                                                                                                                                                                      |
| ---------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [ccdw_fact_customer_list_snapshot](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_fact_customer_list_snapshot.md)                     | Provides snapshots of customer list metrics over time.                                                                                                                         | None listed                                                                                                                                                                                                                  |
| [ccdw_fact_customer_registration](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_fact_customer_registration.md)                       | Records customer registration events.                                                                                                                                          | None listed                                                                                                                                                                                                                  |
| [ccdw_fact_inventory_record_snapshot](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_fact_inventory_record_snapshot.md)               | Captures daily snapshots of inventory levels. Data currently only represents data sourced from OCI.                                                                            | `inventory_record_id`, `utc_record_timestamp`, `utc_record_day_id`, `utc_record_time_id`, `location_id`, `location_group_id`, `sku_id`                                                                                       |
| [ccdw_fact_inventory_record_snapshot_hourly](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_fact_inventory_record_snapshot_hourly.md) | Captures hourly snapshots of inventory levels. Contains similar fields to the daily snapshot but at a finer granularity. Data currently only represents data sourced from OCI. | `inventory_record_id`, `utc_record_timestamp`, `utc_record_day_id`, `utc_record_time_id`, `location_id`, `location_group_id`, `sku_id`                                                                                       |
| [ccdw_fact_line_item](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_fact_line_item.md)                                               | Captures details of individual line items within orders. Each row represents a line item in an order.                                                                          | `line_item_id`, `order_id`, `sku_id`, `std_submit_day_id`, `site_id`, `business_channel_id`, `norder_id`, `locale_id`, `user_agent_id`, `customer_id`, `utc_submit_timestamp`, `utc_submit_day_id`                           |
| [ccdw_fact_order_payments](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_fact_order_payments.md)                                     | Records payment transactions for orders. Each row represents an order payment.                                                                                                 | `order_payment_id`, `site_id`, `business_channel_id`, `payment_method_id`, `std_submit_day_id`, `locale_id`, `user_agent_id`, `norder_id`, `customer_id`                                                                     |
| [ccdw_fact_promotion_activation](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_fact_promotion_activation.md)                         | Records instances where promotions are activated.                                                                                                                              | `promotion_activation_id`, `promotion_id`, `campaign_id`, `std_activation_day_id`, `activation_site_id`, `locale_id`, `user_agent_id`, `customer_id`, `utc_activation_timestamp`, `utc_activation_day_id`                    |
| [ccdw_fact_promotion_line_item](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_fact_promotion_line_item.md)                           | Records the application of promotions to individual line items. Each row represents a promotion line item in an order.                                                         | `promotion_line_item_id`, `promotion_id`, `sku_id`, `order_id`, `std_submit_day_id`, `site_id`, `business_channel_id`, `coupon_id`, `locale_id`, `user_agent_id`, `customer_id`, `utc_submit_timestamp`, `utc_submit_day_id` |
| [ccdw_fact_realtime_metric](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_fact_realtime_metric.md)                                   | Captures real time metrics.                                                                                                                                                    | `metric_id`, `metric_name,create_date`                                                                                                                                                                                       |
| [ccdw_fact_source_codes_activation](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_fact_source_codes_activation.md)                   | Records the activation of source codes.                                                                                                                                        | `source_code_activation_id`, `source_code_group_id`, `user_agent_id`, `customer_id`, `utc_activation_day_id`, `std_activation_day_id`, `activation_site_id`, `locale_id`                                                     |