UNIT_PATH_METADATA_KEY

Business Definition

The column "UNIT_PATH_METADATA_KEY" in the table WELD_NORTH_PROD.WNE_DIM_MODEL.ASSIGNABLE_ACTIVITY_DIM represents a foreign key that links to the PATH_METADATA_DIM table, providing unit-level metadata specifically for EdgeEx data. Its business purpose is to facilitate the association of unit-level activities with their corresponding metadata, enabling users and analysts to understand the context and details of these activities. Users would utilize this column to join with the PATH_METADATA_DIM table to retrieve comprehensive metadata information for EdgeEx units, while it remains NULL for Armstrong/MPNG content.

Data Type

NUMBER

Nullable

Yes

Last Updated

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