Skip to content

User Org Dim

Table Overview

This table contains 21 columns.

Quick Navigation

Column Definitions

app_domain_key

Business Definition

The APP_DOMAIN_KEY column in the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table represents the application domain context for membership events, serving to categorize and organize these events by their respective application domains. Users and analysts would use this column to filter and analyze membership data based on specific application domains, providing insights into how different domains are utilized within the organization.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

application_key

Business Definition

The APPLICATION_KEY column in the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table represents a unique identifier for the specific application where a user's membership exists. Its business purpose is to link user memberships to their respective applications, allowing users and analysts to understand which applications users are associated with. This information is crucial for analyzing user engagement and application usage across different platforms.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

dw_created_by

Business Definition

The column "DW_CREATED_BY" in the table WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM represents the Snowflake user who created the record. Its business purpose is to track the originator of each entry, providing accountability and traceability. Users and analysts would use this column to identify who created specific records, which is useful for auditing and understanding data lineage.

Data Type

TEXT

Nullable

Yes

Last Updated

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

dw_created_on

Business Definition

DW_CREATED_ON represents the timestamp when a record was first inserted into the data warehouse. Its business purpose is to track the creation time of user organization data, allowing users and analysts to understand when specific records were added to the system. This information is useful for auditing, tracking data freshness, and analyzing trends over time.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

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

dw_effective_start_date

Business Definition

DW_EFFECTIVE_START_DATE represents the date and time when a record in the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table becomes active and valid. It is used to track changes over time in a slowly changing dimension, allowing users and analysts to understand the historical context of data and perform accurate time-based analysis.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

dw_is_active

Business Definition

The column "DW_IS_ACTIVE" in the table WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM indicates whether a record is currently active or has been superseded. Its business purpose is to help users and analysts distinguish between current and historical data, enabling them to focus on the most relevant information for their analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

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

dw_updated_by

Business Definition

The column "DW_UPDATED_BY" in the table WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM represents the user who last updated the record in the data warehouse. Its business purpose is to track changes made to the data, providing accountability and traceability. Users and analysts would use this column to identify who made the most recent modification, which is useful for auditing and understanding the history of data changes.

Data Type

TEXT

Nullable

Yes

Last Updated

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

dw_updated_on

Business Definition

DW_UPDATED_ON represents the timestamp of the last update to a record in the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table. Its business purpose is to track when changes were made to user organization data, allowing users and analysts to understand the recency and frequency of updates for auditing and data freshness analysis.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

is_deleted

Business Definition

The IS_DELETED column in the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table indicates whether a user's membership has been deleted, serving as a flag for membership status. Users and analysts can utilize this column to filter out deleted memberships or to analyze trends in membership cancellations.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

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

is_enabled

Business Definition

The IS_ENABLED column in the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table indicates whether a user's membership is active or enabled. It is set to TRUE when the event action is 'Created' or 'Modified', and FALSE otherwise, helping users and analysts determine the current status of a user's membership within the organization.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

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

org_id

Business Definition

ORG_ID represents the unique identifier for an organization within the system, serving as a key reference for organizational data. Users and analysts utilize this column to link and analyze data related to specific organizations, facilitating tasks such as tracking organizational performance and managing organizational hierarchies.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

org_key

Business Definition

ORG_KEY represents the unique identifier for an organization within the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table. It serves to link user data to the corresponding organization in the ORG_DIM dimension table, enabling users and analysts to understand the organizational context of user activities. If an organization is not found, the value defaults to -1.

Data Type

NUMBER

Nullable

No

Last Updated

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

org_uuid

Business Definition

ORG_UUID represents the unique identifier for an organization, sourced from the GROUP_MEMBERSHIP_LOG.ORG_ID field. Its business purpose is to track and identify specific organizations within the system, allowing users and analysts to filter and analyze data based on organizational affiliations.

Data Type

TEXT

Nullable

Yes

Last Updated

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

role

Business Definition

The "ROLE" column in the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table represents the role of a user within the organization, such as Student, Teacher, or Admin. This information is crucial for understanding the user's responsibilities and permissions, and analysts can use it to segment data based on different roles for targeted analysis and reporting.

Data Type

TEXT

Nullable

Yes

Last Updated

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

source_created_on

Business Definition

The SOURCE_CREATED_ON column in the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table represents the timestamp when a user's membership was created in the source system. This information is crucial for understanding the history and timing of user memberships, allowing users and analysts to track and analyze membership creation trends over time.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

source_updated_on

Business Definition

The SOURCE_UPDATED_ON column in the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table represents the timestamp when the membership was last modified in the source system. It is used to track the most recent update to a user's group membership, providing valuable insights into the history and changes in organizational structure. Analysts can use this information to understand the dynamics of user group memberships over time, which is crucial for auditing and reporting purposes.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

user_id

Business Definition

The USER_ID column in the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table represents a unique identifier for users, sourced from upstream systems. It is used to track and identify individual users within the organization, enabling users and analysts to link user-specific data across different datasets for comprehensive analysis and reporting.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

user_key

Business Definition

The USER_KEY column in the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table represents a unique identifier for users, serving as a foreign key to the USER_DIM dimension table. It is used to link user-specific information across different tables, enabling users and analysts to track and analyze user activities and relationships within the organization. If a user is not found in the USER_DIM table, the USER_KEY defaults to -1.

Data Type

NUMBER

Nullable

No

Last Updated

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

user_org_key

Business Definition

The USER_ORG_KEY column in the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table represents a unique identifier for each user-organization membership relationship. It serves as a surrogate primary key, enabling users and analysts to distinguish and track individual user-org associations within the dataset.

Data Type

NUMBER

Nullable

No

Last Updated

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

user_uuid

Business Definition

The USER_UUID column in the WELD_NORTH_PROD.WNE_DIM_MODEL.USER_ORG_DIM table represents the unique identifier for a user member, sourced from the GROUP_MEMBERSHIP_LOG.MEMBER_ID field. Its business purpose is to uniquely identify users across different events, allowing users and analysts to track and analyze individual user activities and memberships.

Data Type

TEXT

Nullable

Yes

Last Updated

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