Skip to content

User Dim Latest

Table Overview

This table contains 26 columns.

Quick Navigation

Column Definitions

age

Business Definition

The AGE column represents the age of a user in the WNE_DIM_MODEL.USER_DIM_LATEST table, providing a demographic characteristic that can be used to analyze user behavior, preferences, and trends. Analysts can use this column to segment users by age group, enabling targeted marketing, product development, and customer support strategies.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

app_domain_key

Business Definition

The APP_DOMAIN_KEY column represents a unique identifier for a specific application domain, which is used to categorize and group related applications or services. It enables users and analysts to filter, aggregate, and analyze data by application domain, facilitating insights into application usage, performance, and trends.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

application_key

Business Definition

The APPLICATION_KEY column represents a unique identifier for a specific application or software used by a user, and its business purpose is to track and analyze user interactions with different applications. Analysts would use this column to segment user behavior and performance metrics by application, enabling them to identify trends and patterns in how users interact with different tools and systems.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:26:38.454000 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:39.366000 by MARKDOWN_IMPORT

ell_english_language_learner

Business Definition

The ELL_ENGLISH_LANGUAGE_LEARNER column indicates whether a student is classified as an English Language Learner (ELL), which is used to identify students who are non-native English speakers and may require additional language support. Analysts, educators can use this column to filter and analyze data for ELL students, track their progress, and inform instructional strategies to better support their language development and academic achievement.

Data Type

VARCHAR

Nullable

Yes

Last Updated

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

email

Business Definition

The EMAIL column in the USER_DIM_LATEST table represents the email address associated with a user in the Weld North Education platform. It is used to uniquely identify and contact users, and analysts can use it to link user data across different tables and systems, enabling analysis of user behavior and communication.

Data Type

VARCHAR

Nullable

Yes

Last Updated

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

external_id

Business Definition

EXTERNAL_ID 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 behavior from various sources, enabling a more comprehensive understanding of user interactions and experiences.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2025-12-10T02:26:41.996000 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:42.716000 by MARKDOWN_IMPORT

first_name

Business Definition

The FIRST_NAME column represents the first name of a user in the WNE_DIM_MODEL.USER_DIM_LATEST table. It is used to identify and personalize interactions with individual users, allowing analysts to filter and analyze data by specific users or groups of users, and to provide a more human-readable representation of user data in reports and visualizations.

Data Type

VARCHAR

Nullable

Yes

Last Updated

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

gender

Business Definition

The GENDER column represents the gender of a user in the USER_DIM_LATEST table, providing a demographic characteristic that can be used to analyze user behavior, preferences, and trends. Analysts can use this column to segment user data by gender, enabling insights into how different genders interact with the system, and informing product development and marketing strategies.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2025-12-10T02:26:44.223000 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 level. 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:45.152000 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 and support students with special needs, allowing educators and analysts to track their progress and make informed decisions about their education.

Data Type

VARCHAR

Nullable

Yes

Last Updated

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

is_deleted

Business Definition

The IS_DELETED column in the USER_DIM_LATEST table indicates whether a user's account has been deleted or is no longer active. Analysts can use this column to filter out inactive users from their analysis, ensuring that their reports and metrics only reflect current and active users.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

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

is_enabled

Business Definition

The IS_ENABLED column represents a flag indicating whether a user is currently enabled or active in the system. It is used by analysts to filter and report on active users, ensuring that only current and relevant user data is included in their analysis and decision-making processes.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-10T02:26:48.442000 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

VARCHAR

Nullable

Yes

Last Updated

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

last_login_date

Business Definition

LAST_LOGIN_DATE represents the most recent date a user last logged into the system, providing a timestamp for when a user was last active. This information is used to track user engagement and can be used by analysts to identify inactive users, monitor login trends, and inform customer support and retention strategies.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

last_name

Business Definition

LAST_NAME represents the surname 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 group data by user, enabling them to track user-specific information and trends.

Data Type

VARCHAR

Nullable

Yes

Last Updated

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

login_name

Business Definition

The LOGIN_NAME column represents a unique identifier for a user's login credentials, capturing the name used to access the system. It is used to track and analyze user activity, allowing analysts to identify and report on individual user behavior, such as login frequency and system usage patterns.

Data Type

VARCHAR

Nullable

Yes

Last Updated

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

source_created_on

Business Definition

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

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T02:26:52.445000 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, indicating the source of the user information. It is used to track and differentiate user data from various systems, allowing analysts to identify the original source of user data and perform analysis by system of origin.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:26:53.235000 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 was last updated, indicating when the latest information about a user was refreshed in the system. This column is used by analysts to track data freshness and identify when user information may need to be revalidated or updated, enabling them to maintain accurate and up-to-date user profiles.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

timezone

Business Definition

The TIMEZONE column represents the geographical region that a user is located in, which is used to determine the local time for scheduling and reporting purposes. Analysts and users can utilize this column to filter and analyze data by specific time zones, enabling them to better understand user behavior and trends across different regions.

Data Type

VARCHAR

Nullable

Yes

Last Updated

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

user_grade_level

Business Definition

The USER_GRADE_LEVEL column represents the current grade level of a user, providing a snapshot of their academic standing. It is used by analysts and educators to filter, segment, and analyze user data by grade level, enabling insights into user performance, progress, and trends across different grade levels.

Data Type

VARCHAR

Nullable

Yes

Last Updated

2025-12-10T02:26:57.761000 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 experiences and targeted analyses.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:26:58.463000 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_LATEST 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

Yes

Last Updated

2025-12-10T02:26:59.252000 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, and to perform analysis and reporting on user-level data, such as user demographics, engagement metrics, and model performance.

Data Type

VARCHAR

Nullable

Yes

Last Updated

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