ccdw_fact_inventory_record_snapshot_hourly

This table captures hourly snapshots of inventory levels. It contains similar fields to the daily snapshot but at a finer granularity. This table currently only represents data sourced from OCI.

Column Alias	Data Type	Key	Description	Index?
`inventory_record_id (PK)`	BIGINT	PK	Unique identifier for an inventory record snapshot.	Yes
`utc_record_timestamp`	TIMESTAMP		UTC timestamp of the inventory record snapshot.	Yes
`utc_record_day_id`	SMALLINT	FK	Foreign key to `ccdw_dim_date` for the UTC record day.	Yes
`utc_record_time_id`	SMALLINT	FK	Foreign key to `ccdw_dim_time` for the UTC record time.	Yes
`utc_update_timestamp`	TIMESTAMP		Last modified UTC timestamp of this record.	Yes
`location_id`	INTEGER	FK	Foreign key to `ccdw_dim_location`.	Yes
`location_group_id`	INTEGER	FK	Foreign key to `ccdw_dim_location_group`.	Yes
`sku_id`	INTEGER	FK	Foreign key to `ccdw_dim_product` for the SKU.	Yes
`available_to_fulfill_alloc`	INTEGER		Allocated quantity available to fulfill orders.	No
`available_to_order_alloc`	INTEGER		Allocated quantity available to be ordered.	No
`on_hand_alloc`	INTEGER		Allocated quantity currently on hand.	No
`reserved_alloc`	INTEGER		Allocated quantity that is reserved.	No
`soft_reserved_alloc`	INTEGER		Allocated quantity that is soft reserved.	No
`safety_stock_count_alloc`	INTEGER		Allocated quantity for safety stock.	No
`available_to_fulfill`	INTEGER		Total quantity available to fulfill orders.	No
`available_to_order`	INTEGER		Total quantity available to be ordered.	No
`on_hand`	INTEGER		Total quantity currently on hand.	No
`reserved`	INTEGER		Total quantity that is reserved.	No
`soft_reserved`	INTEGER		Total quantity that is soft reserved.	No
`safety_stock_count`	INTEGER		Total quantity for safety stock.	No
`total_futures_quantity`	INTEGER		Total quantity of future inventory.	No