ASSESSMENT_ITEM_KEY

Business Definition

Composite surrogate key uniquely identifying each assessment item response record, constructed from assessment_id concatenated with item_id. This key serves as the unique constraint for incremental loads and enables efficient deduplication across event sources. Use this column as the primary key for joins and to ensure referential integrity with downstream aggregations.

Data Type

VARCHAR

Nullable

No

Last Updated

2026-01-20T04:47:38 by ASSESSMENT_ITEM_FACT_ANALYSIS