ASSESSMENT_ITEM_COMPLETED_ON_KEY

Business Definition

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

Data Type

NUMBER(8,0)

Nullable

No

Last Updated

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