Skip to content

Org Dim

Table Overview

This table contains 47 columns.

Quick Navigation

Column Definitions

account_manager

Business Definition

The ACCOUNT_MANAGER column represents the name of the account manager responsible for a specific customer account in the WNE_DIM_MODEL.ORG_DIM table. It is used by sales teams and analysts to identify the account manager associated with a particular customer, enabling them to track sales performance, manage customer relationships, and make informed business decisions.

Data Type

TEXT

Nullable

Yes

Last Updated

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

app_domain_key

Business Definition

The APP_DOMAIN_KEY column represents a unique identifier for a specific application domain within the organization, serving as a key to link related data across different tables. It is used by analysts to filter, group, and analyze data by application domain, enabling them to gain insights into domain-specific trends, performance, and metrics.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

application_key

Business Definition

The APPLICATION_KEY column represents a unique identifier for a specific application or software used in the organization, and its business purpose is to enable tracking and analysis of application usage and performance across different models and dimensions. Users and analysts would use this column to filter, group, and analyze data by specific applications, allowing them to gain insights into application-specific trends and patterns.

Data Type

NUMBER

Nullable

Yes

Last Updated

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

dw_created_by

Business Definition

The DW_CREATED_BY column represents the user who created the organizational dimension record in the data warehouse, capturing the origin of the data for auditing and tracking purposes. Analysts and users can utilize this column to identify the source of the data and investigate any discrepancies or issues related to data creation.

Data Type

TEXT

Nullable

Yes

Last Updated

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

dw_created_on

Business Definition

The DW_CREATED_ON column represents the date and time when a record was first inserted into the ORG_DIM table, serving as a timestamp for data creation. This column is used to track when organizational data was initially loaded into the data warehouse, allowing users and analysts to monitor data freshness and identify when changes to the data occurred.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

dw_effective_end_date

Business Definition

The DW_EFFECTIVE_END_DATE column represents the end date of a model's effective period, indicating when a model is no longer applicable or valid. This column is used to track the lifecycle of models and enable analysts to filter or analyze data based on specific time periods, ensuring that only relevant and current models are considered in their analysis.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

dw_effective_start_date

Business Definition

The DW_EFFECTIVE_START_DATE column represents the start date of a specific organizational structure or hierarchy within the company, indicating when a particular model or configuration became effective. This date is used by analysts to track changes in the organizational structure over time, enabling them to analyze historical data and trends in the context of the company's evolving hierarchy.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

dw_is_active

Business Definition

DW_IS_ACTIVE is a flag indicating whether a model is currently active or inactive in the organization. It is used by analysts to filter and report on active models, ensuring that only current and relevant data is considered in their analysis and decision-making processes.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

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

dw_updated_by

Business Definition

The DW_UPDATED_BY column represents the user who last updated the organizational dimension data, providing a record of who made changes to the data. This information is used by analysts and data stewards to track data lineage, identify the source of changes, and facilitate data governance and auditing.

Data Type

TEXT

Nullable

Yes

Last Updated

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

dw_updated_on

Business Definition

The DW_UPDATED_ON column represents the date and time when the data in the ORG_DIM table was last updated in the data warehouse. It is used by analysts to track when changes were made to the organizational dimension data, allowing them to monitor data freshness and identify when updates were made to the data.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

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

edge_active_user

Business Definition

The EDGE_ACTIVE_USER column represents a flag indicating whether a user is currently active in the EDGE system, with a value of 1 signifying an active user and 0 indicating an inactive user. This column is used by analysts to filter and segment data to focus on current users, enabling them to track engagement and usage patterns of active users in the EDGE system.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

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

external_id

Business Definition

The EXTERNAL_ID column represents a unique identifier for an organization, used to link the organization's data across different systems and platforms. It enables users and analysts to match and integrate data from various sources, facilitating a more comprehensive understanding of the organization's performance and trends.

Data Type

TEXT

Nullable

Yes

Last Updated

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

external_sales_rep

Business Definition

EXTERNAL_SALES_REP represents the external sales representative responsible for a specific model in the organization. It is used by users and analysts to identify the sales representative associated with a particular model, enabling them to track sales performance, analyze sales trends, and make informed business decisions.

Data Type

TEXT

Nullable

Yes

Last Updated

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

inside_ouside_sales

Business Definition

The INSIDE_OUTSIDE_SALES column represents a classification of sales transactions as either inside or outside sales, indicating whether the sale was made directly by a sales representative or through an external channel. This column is used to track and analyze sales performance by sales channel, enabling users and analysts to identify trends and opportunities for growth in different sales segments.

Data Type

TEXT

Nullable

Yes

Last Updated

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

inside_sales_rep

Business Definition

The INSIDE_SALES_REP column represents the inside sales representative responsible for a specific product or model, capturing the individual accountable for managing sales and customer relationships. This information is used by analysts and business users to track sales performance, identify trends, and inform sales strategies by attributing sales data to the corresponding inside sales representative.

Data Type

TEXT

Nullable

Yes

Last Updated

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

is_registration_uuid

Business Definition

The IS_REGISTRATION_UUID column represents a unique identifier for a registration event in the WNE_DIM_MODEL.ORG_DIM table, allowing users to track and analyze registration activities across different models and organizations, and is used to link registration data with other relevant information for reporting and analytics purposes.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-10T02:25:00.932000 by MARKDOWN_IMPORT

nces_account_id

Business Definition

The NCES_ACCOUNT_ID column represents a unique identifier for a school or district account in the National Center for Education Statistics (NCES) database. It is used to link the organization's demographic and assessment data, enabling users to analyze and compare performance across different schools and districts.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:01.709000 by MARKDOWN_IMPORT

org_address

Business Definition

The ORG_ADDRESS column represents the physical location of an organization, providing a mailing address or street address where the organization is situated. It is used by users and analysts to identify and filter organizations by their geographical location, facilitating tasks such as territory management, customer segmentation, and market analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:02.372000 by MARKDOWN_IMPORT

org_alias

Business Definition

ORG_ALIAS represents an alternate name or abbreviation for an organization, providing a secondary identifier to support data matching and integration across different systems. It enables users and analysts to link and analyze data from various sources, ensuring consistency and accuracy in organizational data representation.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:03.200000 by MARKDOWN_IMPORT

org_category

Business Definition

ORG_CATEGORY represents the type of organization a model is associated with, such as a school, district, or state. It is used by analysts and users to filter, group, and analyze model data by organizational type, enabling them to understand performance and trends at different levels of the organization.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:04.106000 by MARKDOWN_IMPORT

org_city

Business Definition

The ORG_CITY column represents the city where an organization is located, providing a geographical context for the organization's operations. It is used by analysts to filter, group, and analyze data by city, enabling them to identify trends, patterns, and insights related to specific geographic regions.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:04.694000 by MARKDOWN_IMPORT

org_code

Business Definition

ORG_CODE represents a unique identifier for an organization within the company, serving as a key to link various data entities and facilitate analysis across different departments and business units. Analysts and users can utilize this column to filter, group, and aggregate data by organization, enabling them to gain insights into performance, trends, and metrics at the organizational level.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:05.314000 by MARKDOWN_IMPORT

org_country

Business Definition

The ORG_COUNTRY column represents the country where an organization is located, providing a geographical context for analysis and reporting. It enables users and analysts to filter, group, and aggregate data by country, facilitating insights into regional trends, performance, and market dynamics.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:06.198000 by MARKDOWN_IMPORT

org_customer_id

Business Definition

ORG_CUSTOMER_ID represents a unique identifier for a customer organization in the WNE_DIM_MODEL.ORG_DIM table, allowing users and analysts to link customer data across different tables and systems, and track customer-specific information and performance metrics.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:07.376000 by MARKDOWN_IMPORT

org_customer_internal_id

Business Definition

ORG_CUSTOMER_INTERNAL_ID represents a unique identifier assigned to a customer within the organization, allowing for the tracking and management of customer-specific data across different systems and platforms. This identifier is used by analysts and business users to link customer information, analyze customer behavior, and inform business decisions.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:08.143000 by MARKDOWN_IMPORT

org_district

Business Definition

ORG_DISTRICT represents the organizational district to which a well belongs, providing a way to categorize and group wells by geographic or administrative regions. Analysts and users can utilize this column to filter, aggregate, and analyze well data by district, enabling them to gain insights into regional trends, patterns, and performance metrics.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:08.858000 by MARKDOWN_IMPORT

org_id

Business Definition

ORG_ID represents a unique identifier for an organization within the company, serving as a key to link various data entities and facilitate analysis across different business dimensions. It enables users and analysts to filter, group, and aggregate data by organization, allowing for insights into performance, trends, and metrics at the organizational level.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:25:09.565000 by MARKDOWN_IMPORT

org_import_id

Business Definition

ORG_IMPORT_ID represents a unique identifier for an organization's import data, allowing users to track and manage the organization's data imports. It is used by analysts to link the organization's data to its corresponding import history, facilitating data validation, troubleshooting, and auditing.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:10.406000 by MARKDOWN_IMPORT

org_key

Business Definition

The ORG_KEY column represents a unique identifier for an organization within the company, serving as a key to link organizational data across different systems and reports. It is used by analysts and business users to filter, group, and analyze data by specific organizations, enabling them to gain insights into organizational performance and make informed decisions.

Data Type

NUMBER

Nullable

No

Last Updated

2025-12-10T02:25:11.203000 by MARKDOWN_IMPORT

org_state

Business Definition

The ORG_STATE column represents the state in which an organization is located, providing a geographical identifier for the organization. It is used to filter, group, and analyze data by state, enabling users and analysts to understand regional trends, compare performance across different states, and make informed decisions at the state level.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:11.980000 by MARKDOWN_IMPORT

org_status

Business Definition

ORG_STATUS represents the current operational status of an organization, indicating whether it is active, inactive, or in another state. Analysts and users can utilize this column to filter or segment data by the organization's status, enabling them to focus on active organizations or identify inactive ones that may require attention.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:13.040000 by MARKDOWN_IMPORT

org_territory

Business Definition

ORG_TERRITORY represents the geographic territory to which an organization belongs, providing a way to categorize and analyze data by region. It is used by analysts to filter, group, and report on data by territory, enabling them to understand regional trends, performance, and market dynamics.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:14.422000 by MARKDOWN_IMPORT

org_timezone_key

Business Definition

ORG_TIMEZONE_KEY represents a unique identifier for a specific time zone, allowing users to associate a location with its corresponding time zone. It is used to accurately track and analyze data across different regions, enabling analysts to account for time zone differences when examining data from various locations.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:25:15.127000 by MARKDOWN_IMPORT

org_title

Business Definition

ORG_TITLE represents the title of an organization within the company, providing a way to categorize and identify different departments or teams. It is used by analysts and users to filter, group, and analyze data by specific organizational units, enabling them to gain insights into performance and trends at the departmental level.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:15.832000 by MARKDOWN_IMPORT

org_type

Business Definition

The ORG_TYPE column represents the type of organization associated with a well, such as a company or government agency, and is used to categorize and analyze wells by the type of organization that operates them, enabling users to filter and group data by organization type for reporting and business intelligence purposes.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:16.676000 by MARKDOWN_IMPORT

org_uuid

Business Definition

The ORG_UUID column represents a unique identifier for an organization within the WNE_DIM_MODEL.ORG_DIM table, serving as a key to link organizational data across different tables and systems, enabling users and analysts to accurately identify and analyze data at the organizational level.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:17.272000 by MARKDOWN_IMPORT

org_zipcode

Business Definition

The ORG_ZIPCODE column represents the postal zip code associated with an organization's physical location. It is used to identify and analyze geographic trends, patterns, and correlations in data related to the organization, such as customer demographics, sales performance, or market research.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:18.043000 by MARKDOWN_IMPORT

parent_org_uuid

Business Definition

The PARENT_ORG_UUID column represents a unique identifier for the parent organization of a given entity, providing a way to establish hierarchical relationships between organizations. It is used to support analysis and reporting at the parent organization level, enabling users to roll up data and perform aggregations across multiple child organizations.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:19.361000 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.ORG_DIM table. It is used by analysts to categorize and analyze products by their respective groups, enabling them to track sales trends, product performance, and other key business metrics at a group level.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:25:20.222000 by MARKDOWN_IMPORT

professional_development_specialist

Business Definition

The PROFESSIONAL_DEVELOPMENT_SPECIALIST column represents the name of the professional development specialist assigned to a school or district, indicating the individual responsible for providing support and guidance on instructional strategies and best practices. This information is used by analysts and educators to identify the specialist associated with a particular school or district, facilitating communication and collaboration on professional development initiatives.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:20.860000 by MARKDOWN_IMPORT

source_created_by

Business Definition

The SOURCE_CREATED_BY column represents the user or system that created the source data for the organizational dimension, providing a record of the origin of the data. This information is used by analysts to track data lineage, identify potential data quality issues, and understand the source of organizational data used in reporting and analytics.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:21.974000 by MARKDOWN_IMPORT

source_created_on

Business Definition

The SOURCE_CREATED_ON column represents the date and time when a model was created in the source system, providing a timestamp for when the model was first introduced. This information is used by analysts to track the history and evolution of models over time, enabling them to understand how models have changed and when new models were introduced.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T02:25:22.733000 by MARKDOWN_IMPORT

source_system_id

Business Definition

The SOURCE_SYSTEM_ID column represents a unique identifier for the source system that provided the data for a specific organizational entity, such as a school or district. It is used to track the origin of the data and enable users to analyze and report on data from different source systems, allowing them to understand the data's context and provenance.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-10T02:25:23.446000 by MARKDOWN_IMPORT

source_updated_by

Business Definition

The SOURCE_UPDATED_BY column represents the user or system that last updated the source data for a specific organizational dimension record. It is used to track changes and updates to the organizational structure, allowing users and analysts to identify who made changes and when, which is essential for auditing and troubleshooting purposes.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:24.396000 by MARKDOWN_IMPORT

source_updated_on

Business Definition

The SOURCE_UPDATED_ON column represents the date and time when the source data for a specific organizational dimension was last updated. It is used to track changes to organizational data over time, allowing users and analysts to identify when updates were made and analyze the impact of those changes on their reporting and analytics.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-10T02:25:25.312000 by MARKDOWN_IMPORT

strategic_project_manager

Business Definition

The STRATEGIC_PROJECT_MANAGER column represents the name of the strategic project manager responsible for overseeing a specific project or initiative within the organization. This information is used by analysts and stakeholders to track project ownership and accountability, and to facilitate communication and collaboration between teams and departments.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:26.075000 by MARKDOWN_IMPORT

type

Business Definition

The TYPE column in the WNE_DIM_MODEL.ORG_DIM table represents the type of organization or entity, such as a school, district, or state, and is used to categorize and filter data by the level of organization, enabling users and analysts to analyze and report on data at different levels of granularity.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-10T02:25:26.926000 by MARKDOWN_IMPORT