ITEM_KEY

Business Definition

Surrogate key uniquely identifying each item record in the dimension, generated from the LEARNOSITY_ITEMS_DIM_ITEM_KEY sequence. This key enables efficient joins to fact tables and supports SCD Type 2 tracking by providing stable references across historical versions. The -1 value represents unknown or unmatched items in dimensional queries.

Data Type

NUMBER(38,0)

Nullable

No

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS