ASSESSMENT_ITEM_GRADED_ON_KEY

Business Definition

Surrogate date key in YYYYMMDD format representing when the item was graded, enabling efficient date dimension joins and filtering. Derived from ASSESSMENT_ITEM_GRADED_ON date portion. A value of 99999999 indicates grading date is unknown or the item has not been graded.

Data Type

NUMBER(8,0)

Nullable

No

Last Updated

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