Skip to content

User Dim

Table Overview

This table contains 41 columns.

Quick Navigation

Column Definitions

age

Business Definition

The AGE column in the USER_DIM table represents the age of user, capturing the user's age at specific point in time. It is used by analysts to segment and analyze user behavior, preferences, and trends across different age groups, enabling insights into how age influences user interactions and decision-making.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:26:00.887000 by MARKDOWN_IMPORT

alternate_student_number

Business Definition

The ALTERNATE_STUDENT_NUMBER column represents a unique identifier for a student that is used in conjunction with their primary student number, allowing for the tracking of student data across different systems. It is used by analysts to match student records and ensure accurate reporting and analysis of student performance and progress.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:01.915000 by MARKDOWN_IMPORT

app_domain_key

Business Definition

The APP_DOMAIN_KEY column represents a unique identifier for a specific application domain within the WNE_DIM_MODEL.USER_DIM table. It is used to categorize and distinguish between different application domains, enabling users and analysts to filter, group, and analyze user data by specific domains, such as production, testing, or development environments.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:26:02.996000 by MARKDOWN_IMPORT

application_key

Business Definition

The APPLICATION_KEY column represents a unique identifier for a specific application or software used within the organization, and its business purpose is to enable tracking and analysis of user interactions with different applications. Users and analysts would use this column to filter, group, or join data by application, allowing them to gain insights into application usage patterns and user behavior.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:26:03.814000 by MARKDOWN_IMPORT

birth_date

Business Definition

The BIRTH_DATE column represents the date of birth of an individual user, providing a key demographic attribute for analysis and reporting. It is used to support age-based analysis, segmentation, and filtering in various business intelligence applications, enabling users to better understand user behavior and preferences across different age groups.

Data Type

DATE

Nullable

Yes

Last Updated

2025-12-10T02:26:04.767000 by MARKDOWN_IMPORT

data_source

Business Definition

The DATA_SOURCE column represents the origin of the user data, indicating whether it came from an internal system or an external source. It is used to track the source of user information, allowing analysts to identify potential data discrepancies or inconsistencies and to inform data quality initiatives.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:05.460000 by MARKDOWN_IMPORT

dw_created_by

Business Definition

The DW_CREATED_BY column represents the user who created the record in the USER_DIM table, capturing the origin of the data. It is used to track data lineage and accountability, allowing users and analysts to identify who created the record and when, which is useful for auditing and troubleshooting purposes.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:06.300000 by MARKDOWN_IMPORT

dw_created_on

Business Definition

The DW_CREATED_ON column represents the date and time when a user dimension record was created in the data warehouse. It is used to track when a user's information was first added to the system, allowing analysts to monitor user growth and trends over time.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T02:26:06.914000 by MARKDOWN_IMPORT

dw_effective_end_date

Business Definition

The DW_EFFECTIVE_END_DATE column represents the end date of a user's active period in the system, marking the point in time when the user's status or affiliation changed. This date is used by analysts to track user activity and changes over time, enabling them to filter and analyze data based on specific time periods or user statuses.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T02:26:07.772000 by MARKDOWN_IMPORT

dw_effective_start_date

Business Definition

The DW_EFFECTIVE_START_DATE column represents the date when a user's information became effective in the system, marking the beginning of a period during which the user's data is considered current. This date is used by analysts to track changes in user information over time and to ensure that reports and analytics reflect the most up-to-date user data.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T02:26:08.764000 by MARKDOWN_IMPORT

dw_is_active

Business Definition

DW_IS_ACTIVE is a flag indicating whether a user is currently active in the system. It is used by analysts to filter and report on active users, enabling them to focus on current user activity and exclude inactive users from their analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-10T02:26:09.588000 by MARKDOWN_IMPORT

dw_updated_by

Business Definition

The DW_UPDATED_BY column represents the user who last updated the user dimension record, providing a record of changes made to the data. This information is used for auditing and tracking purposes, allowing analysts to identify who made changes to the data and when, which is useful for troubleshooting and data quality control.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:10.303000 by MARKDOWN_IMPORT

dw_updated_on

Business Definition

The DW_UPDATED_ON column represents the date and time when a user's information was last updated in the USER_DIM table. It is used to track changes to user data over time, allowing analysts to identify when updates were made and analyze the impact of those changes on business outcomes.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T02:26:11.013000 by MARKDOWN_IMPORT

ell_english_language_learner

Business Definition

Flag indicating whether a student is identified as an English Language Learner (ELL). Used for compliance reporting and targeted instructional support identification.

Data Type

VARCHAR

Nullable

No

Last Updated

2025-12-10T02:26:11.870000 by MARKDOWN_IMPORT

email

Business Definition

The EMAIL column represents the email address associated with a user in WNE_DIM_MODEL. It is used to uniquely identify and contact users, and analysts can use it to link user data across different systems or to send targeted communications.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:13.124000 by MARKDOWN_IMPORT

external_id

Business Definition

The EXTERNAL_ID column represents a unique identifier for a user in an external system, allowing for integration and matching of user data across different platforms. It is used by analysts to link user information and activity from external sources to the user's profile in the WNE_DIM_MODEL, enabling a more comprehensive understanding of user behavior and performance.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:14 by MARKDOWN_IMPORT

first_login_date

Business Definition

The FIRST_LOGIN_DATE column represents the date when a user first logged into the system, providing a timestamp for when a user initially accessed the platform. This information is used to track user adoption and engagement, allowing analysts to analyze user behavior and identify trends in user activity over time.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T02:26:15.089000 by MARKDOWN_IMPORT

first_name

Business Definition

The FIRST_NAME column in the USER_DIM table represents the first name of a user in the system, providing a way to identify and personalize interactions with individual users. It is used by analysts and users to filter, sort, and display user data in reports and analytics, enabling them to better understand user behavior and tailor their analysis to specific individuals or groups.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:16.046000 by MARKDOWN_IMPORT

gender

Business Definition

The GENDER column in the USER_DIM table represents the gender of a user in the system, which is used to provide demographic information and support analysis of user behavior and trends by gender. Analysts can use this column to filter or segment data by gender, enabling insights into how different genders interact with the system or respond to various features and initiatives.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:17.115000 by MARKDOWN_IMPORT

grade_level_id

Business Definition

The GRADE_LEVEL_ID column represents a unique identifier for a student's grade level, which is used to categorize students into distinct groups based on their academic year or age. It enables users and analysts to filter, analyze, and report on student data by grade level, facilitating insights into student performance and progress across different grade levels.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:26:17.832000 by MARKDOWN_IMPORT

iep_individualized_educational_plan

Business Definition

IEP_INDIVIDUALIZED_EDUCATIONAL_PLAN indicates whether a student has an Individualized Education Program (IEP) in place, which is a customized plan developed for students with special needs to ensure they receive an appropriate education. This column is used to identify students with IEPs and analyze their academic performance and progress in relation to their peers, enabling educators and administrators to make informed decisions about support services and accommodations.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:18.635000 by MARKDOWN_IMPORT

is_deleted

Business Definition

The IS_DELETED column in the USER_DIM table indicates whether a user account has been deleted or is still active. It is used to filter out deleted user accounts from analysis and reporting, ensuring that only current and relevant user data is considered.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-10T02:26:19.330000 by MARKDOWN_IMPORT

is_enabled

Business Definition

The IS_ENABLED column in the USER_DIM table represents a flag indicating whether a user account is currently active and allowed to access the system. It is used by analysts to filter out inactive users when analyzing user activity, behavior, and performance metrics, ensuring that only relevant and up-to-date data is considered in their reports and insights.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-10T02:26:20.157000 by MARKDOWN_IMPORT

is_synced

Business Definition

The IS_SYNCED column in the USER_DIM table indicates whether a user's data has been successfully synchronized with the production environment. It is used by analysts to identify users whose data is up-to-date and ready for reporting and analysis, allowing them to filter out users with incomplete or outdated information.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-10T02:26:20.996000 by MARKDOWN_IMPORT

language

Business Definition

The LANGUAGE column represents the language in which a user interacts with the system, indicating their preferred language for communication and content display. It is used by analysts to segment user behavior and preferences by language, enabling the creation of targeted content and support services that cater to diverse user populations.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:21.855000 by MARKDOWN_IMPORT

last_login_date

Business Definition

LAST_LOGIN_DATE represents the date a user last logged into the system, providing a timestamp for the most recent user activity. This column is used to track user engagement and can be used by analysts to identify inactive users, monitor user adoption, and inform product development and support decisions.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T02:26:22.594000 by MARKDOWN_IMPORT

last_name

Business Definition

The LAST_NAME column in the USER_DIM table represents the last name of a user in the system, providing a way to identify and distinguish between individuals. It is used by analysts and users to filter, sort, and analyze data by user, enabling them to track user-specific trends, behaviors, and performance metrics.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:23.529000 by MARKDOWN_IMPORT

login_name

Business Definition

The LOGIN_NAME column represents a unique identifier for a user in the system, capturing the username used to access the application. It is used to track and analyze user activity, enabling analysts to identify specific user behavior, preferences, and performance metrics, and to inform business decisions related to user engagement and experience.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:24.280000 by MARKDOWN_IMPORT

product_group_key

Business Definition

The PRODUCT_GROUP_KEY column represents a unique identifier for a group of related products in the WNE_DIM_MODEL.USER_DIM table. It is used by analysts to categorize and analyze user behavior and product interactions at a higher level, enabling them to identify trends and patterns across similar products.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:26:24.976000 by MARKDOWN_IMPORT

site

Business Definition

The SITE column represents a unique identifier for a specific production site or facility within the organization, and its business purpose is to enable tracking and analysis of production data by site. Users and analysts would use this column to filter, group, and compare production metrics across different sites, facilitating site-level performance evaluation and optimization.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:25.685000 by MARKDOWN_IMPORT

source

Business Definition

The SOURCE column represents the origin of the user data, indicating whether the user information was obtained from an internal system or an external source. It is used to track the provenance of user data and help analysts understand the reliability and potential biases of the information, enabling them to make informed decisions when analyzing user behavior and trends.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:26.815000 by MARKDOWN_IMPORT

source_created_on

Business Definition

The SOURCE_CREATED_ON column represents the date and time when a user's information was initially created in the source system. It is used to track the origin and history of user data, allowing analysts to understand when user information was first established and how it has evolved over time.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T02:26:27.887000 by MARKDOWN_IMPORT

source_system_id

Business Definition

The SOURCE_SYSTEM_ID column represents a unique identifier for the system from which user data originated, allowing analysts to track the source of user information and distinguish between users from different systems. This identifier is used to link user data from various systems, enabling a comprehensive view of user interactions and behavior across different platforms.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:26:28.642000 by MARKDOWN_IMPORT

source_updated_on

Business Definition

The SOURCE_UPDATED_ON column represents the date and time when the source data for a user dimension record was last updated. It is used to track when changes were made to user information, allowing analysts to monitor data freshness and identify potential discrepancies or updates that may impact reporting or analytics.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T02:26:29.922000 by MARKDOWN_IMPORT

sso_id

Business Definition

The SSO_ID column represents a unique identifier for a user's single sign-on account, which is used to authenticate and authorize access to various systems and applications. It is used by analysts to link user activity and behavior across different platforms and tools, enabling them to track user engagement and performance metrics.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:30.738000 by MARKDOWN_IMPORT

student_number

Business Definition

The STUDENT_NUMBER column represents a unique identifier for a student in the school's database, used to track and link their academic records and assessment data across different systems. It enables users and analysts to match student information and assessment scores from various sources, facilitating a comprehensive view of student performance and progress.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:31.468000 by MARKDOWN_IMPORT

timezone

Business Definition

The TIMEZONE column represents the geographical region's standard time offset from Coordinated Universal Time (UTC) associated with a user's location. It is used to ensure accurate timestamping and scheduling of events, allowing analysts to account for regional time differences when analyzing user activity and behavior.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:32.485000 by MARKDOWN_IMPORT

user_grade_level

Business Definition

The USER_GRADE_LEVEL column represents the grade level of a user in the system, indicating the educational level or year of study they are currently in. This information is used to provide context for user performance and progress, allowing analysts to filter and analyze data by grade level to identify trends and patterns in user behavior and outcomes.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:33.228000 by MARKDOWN_IMPORT

user_id

Business Definition

The USER_ID column represents a unique identifier for a user in the system, serving as a key to link user information across different tables and datasets. It is used by analysts to track user behavior, preferences, and interactions, enabling them to create personalized models and make data-driven decisions.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:26:33.892000 by MARKDOWN_IMPORT

user_key

Business Definition

The USER_KEY column represents a unique identifier for a user in the WNE_DIM_MODEL.USER_DIM table, serving as a primary key to distinguish individual users. It is used by analysts to link user information across different tables and systems, enabling the tracking of user activity, behavior, and performance metrics.

Data Type

NUMBER

Nullable

No

Last Updated

2025-12-10T02:26:34.765000 by MARKDOWN_IMPORT

user_uuid

Business Definition

The USER_UUID column represents a unique identifier for a user in the system, serving as a key to link user information across different tables and datasets. It enables analysts to track user behavior, preferences, and interactions, allowing for a more comprehensive understanding of user engagement and experience.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:26:35.757000 by MARKDOWN_IMPORT