DW_EFFECTIVE_END_DATE

Business Definition

DW_EFFECTIVE_END_DATE represents the date until which a user organization record is considered active in the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table. Its business purpose is to track the end of the validity period for each record, facilitating slowly changing dimension Type 2 tracking. Users and analysts would use this column to determine the duration for which a specific user organization was active or to identify when a record was superseded by a new one.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T02:27:04.971000 by MARKDOWN_IMPORT