ASSESSMENT_COMPLETED_ON_KEY

Business Definition

Surrogate date key representing when the student completed the assessment attempt, optimized for joins to date dimensions and partitioning. Use this key for calendar aggregations and reporting filters. Null indicates the attempt was not completed (for example, still in progress or expired).

Data Type

NUMBER(38,0)

Nullable

Yes

Last Updated

2026-01-08T03:23:35 by ASSESSMENT_FACT_ENRICHMENT