Skip to content

DW_EFFECTIVE_END_DATE

Business Definition

Represents the end date of the current version of a record. Set to '2999-12-31' for active records and updated to the current timestamp when a new version is created. Defines the period during which the record is considered valid.

Data Type

TIMESTAMP_NTZ

Nullable

No

Last Updated

2025-12-10T02:24:27.450000 by MARKDOWN_IMPORT