DW_IS_ACTIVE

Business Definition

Flag indicating whether this is the currently active version of the item record ('Y' for active, 'N' for historical). Most queries filter on DW_IS_ACTIVE = 'Y' to retrieve current state. Historical versions are retained for audit and trend analysis.

Data Type

VARCHAR(1)

Nullable

Yes

Last Updated

2026-01-13T04:05:42 by LEARNOSITY_ITEMS_DIM_ANALYSIS