ASSESSMENT_ITEM_STARTED_ON_KEY

Business Definition

Surrogate date key in YYYYMMDD format representing when the item was started, enabling efficient date dimension joins and partition pruning. Derived from ASSESSMENT_ITEM_STARTED_ON date portion. A value of 99999999 indicates the start date is unknown or null.

Data Type

NUMBER(8,0)

Nullable

No

Last Updated

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