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 | Provides snapshots of customer list metrics over time. | None listed |
| ccdw_fact_customer_registration | Records customer registration events. | None listed |
| ccdw_fact_inventory_record_snapshot | 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 | 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 | 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 | 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 | 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 | 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 | Captures real time metrics. | metric_id, metric_name,create_date |
| ccdw_fact_source_codes_activation | 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 |