Skip to content

Org Dim Latest

Table Overview

This table contains 39 columns.

Quick Navigation

Column Definitions

account_manager

Business Definition

The "ACCOUNT_MANAGER" column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ORG_DIM_LATEST table represents the individual responsible for managing the account of a specific organization. Its business purpose is to identify the point of contact for account-related activities and communications. Users and analysts would use this information to direct inquiries, updates, and reports to the appropriate account manager.

Data Type

VARCHAR

Nullable

No

Last Updated

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

app_domain_key

Business Definition

A unique identifier representing the application domain within the organization. It is used to categorize and filter data based on specific business areas or functional domains, helping users and analysts to analyze and report on data relevant to particular segments of the organization.

Data Type

NUMBER

Nullable

No

Last Updated

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

application_key

Business Definition

APPLICATION_KEY is a unique identifier for each application within the organization, used to track and manage various applications across different systems. Users and analysts would use this key to link application-specific data and ensure accurate reporting and analysis.

Data Type

NUMBER

Nullable

No

Last Updated

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

edge_active_user

Business Definition

The EDGE_ACTIVE_USER column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ORG_DIM_LATEST table indicates whether a user is currently active within the EDGE system. It is used to filter and analyze active user data for operational and strategic decision-making.

Data Type

BOOLEAN

Nullable

No

Last Updated

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

external_id

Business Definition

EXTERNAL_ID is a unique identifier assigned to an organization by an external system, used to link and integrate data across different platforms. Users and analysts would use this column to match and consolidate organizational data from various sources for comprehensive analysis and reporting.

Data Type

VARCHAR

Nullable

No

Last Updated

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

external_sales_rep

Business Definition

The "EXTERNAL_SALES_REP" column represents the name or identifier of the sales representative responsible for external sales activities. Its business purpose is to track which sales representative is associated with each record, enabling users and analysts to evaluate performance and manage sales territories effectively.

Data Type

VARCHAR

Nullable

No

Last Updated

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

inside_ouside_sales

Business Definition

The "INSIDE_OUSIDE_SALES" column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ORG_DIM_LATEST table indicates whether a sale was made by an inside sales team or an outside sales team. This information is crucial for analyzing sales performance and strategies, helping users and analysts to understand the effectiveness of different sales channels within the organization.

Data Type

VARCHAR

Nullable

No

Last Updated

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

inside_sales_rep

Business Definition

The "INSIDE_SALES_REP" column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ORG_DIM_LATEST table represents the sales representative responsible for handling internal sales activities within the organization. Its business purpose is to track and manage the performance and responsibilities of the sales representative, and users/analysts would use it to identify which sales representative is associated with specific internal sales transactions or accounts.

Data Type

VARCHAR

Nullable

No

Last Updated

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

nces_account_id

Business Definition

The NCES_ACCOUNT_ID is a unique identifier assigned to educational institutions by the National Center for Education Statistics (NCES). It is used to track and analyze data related to specific schools or districts, enabling users and analysts to compare performance metrics and other educational statistics across different institutions.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_address

Business Definition

ORG_ADDRESS represents the physical address of an organization within the WELD_NORTH_PROD database. Its business purpose is to store the location information of various organizations, enabling users and analysts to identify and contact these entities for operational or analytical needs.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_alias

Business Definition

ORG_ALIAS represents an alternative name or abbreviation for an organization within the WELD_NORTH_PROD database. Its business purpose is to provide a recognizable shorthand or nickname for organizations, making it easier for users and analysts to identify and reference them in reports and analyses. Users would utilize this column to quickly locate and filter data related to specific organizations without needing to use their full, formal names.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_category

Business Definition

The ORG_CATEGORY column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ORG_DIM_LATEST table represents the category or type of an organization, such as a business, non-profit, or government entity. It is used to classify organizations for analytical purposes, helping users and analysts to filter and group data based on organizational categories for reporting and strategic decision-making.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_city

Business Definition

ORG_CITY represents the city where an organization is located, providing geographical context for business operations. Users and analysts would use this column to filter or group data by city for regional analysis and strategic planning.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_code

Business Definition

ORG_CODE represents the unique identifier for an organization within the Weld North production system. Its business purpose is to categorize and track different organizations, enabling users and analysts to filter and analyze data specific to each organization.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_country

Business Definition

The ORG_COUNTRY column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ORG_DIM_LATEST table represents the country where an organization is located. Its business purpose is to provide geographical context for organizational data, enabling users and analysts to filter and analyze information based on the country of operation.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_customer_id

Business Definition

ORG_CUSTER_ID is a unique identifier for each customer organization within the Weld North production system. It is used to track and manage customer-specific data, enabling users and analysts to filter and analyze information pertinent to individual organizations.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_customer_internal_id

Business Definition

ORG_CUSTER_INTERNAL_ID is a unique identifier assigned to each customer within the organization. It serves to track and manage customer information across various systems and is used by analysts to link customer data for comprehensive analysis and reporting.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_district

Business Definition

The ORG_DISTRICT column represents the district to which an organization belongs within the WELD_NORTH_PROD database. Its business purpose is to categorize organizations by their geographical or administrative districts, aiding users and analysts in filtering and aggregating data based on district-level information for regional analysis and reporting.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_id

Business Definition

ORG_ID represents the unique identifier for an organization within the WELD_NORTH_PROD database. Its business purpose is to distinguish between different organizations, enabling users and analysts to filter and aggregate data specific to each organization for reporting and analysis.

Data Type

NUMBER

Nullable

No

Last Updated

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

org_import_id

Business Definition

ORG_IMPORT_ID is a unique identifier assigned to an organization during the data import process. It serves to track and reference the organization within the WELD_NORTH_PROD database, enabling users and analysts to link and analyze data related to specific organizations across different datasets.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_key

Business Definition

ORG_KEY is a unique identifier for an organization within the WELD_NORTH_PROD database. It is used to track and reference specific organizations across various tables and reports, enabling users and analysts to filter and analyze data specific to each organization.

Data Type

NUMBER

Nullable

No

Last Updated

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

org_state

Business Definition

ORG_STATE represents the state in which an organization is located, providing geographical context for business operations. Users and analysts would use this column to filter or aggregate data based on the organization's state, enabling regional analysis and strategic planning.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_status

Business Definition

ORG_STATUS represents the current operational status of an organization within the Weld North production environment. Its business purpose is to indicate whether an organization is active, inactive, or in another defined state. Users and analysts would use this column to filter or segment data based on the operational status of organizations, aiding in various analyses such as performance tracking and resource allocation.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_territory

Business Definition

The ORG_TERRITORY column represents the geographical region or territory associated with an organization. Its business purpose is to categorize organizations based on their location, aiding users and analysts in performing regional analysis and segmentation for strategic planning and market evaluation.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_timezone_key

Business Definition

ORG_TIMEZONE_KEY represents the unique identifier for the timezone associated with an organization. Its business purpose is to standardize and track the timezone information for various organizational entities, enabling users and analysts to accurately interpret and report time-sensitive data based on the organization's local time.

Data Type

NUMBER

Nullable

No

Last Updated

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

org_title

Business Definition

ORG_TITLE represents the official title of an organization within the Weld North production system. Its business purpose is to provide a clear and consistent name for each organization, facilitating easy identification and categorization. Users and analysts would use this column to filter, sort, and analyze data based on specific organizational titles, enabling them to gain insights into organizational performance and activities.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_type

Business Definition

ORG_TYPE represents the type of organization, such as a company, non-profit, or government agency, within the WELD_NORTH_PROD.WNE_DIM_MODEL.ORG_DIM_LATEST table. It is used by users and analysts to categorize and filter organizations based on their type for various reporting and analytical purposes.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_uuid

Business Definition

ORG_UUID is a unique identifier for an organization within the WELD_NORTH_PROD database. It is used to distinguish and track specific organizations for reporting and analysis purposes, enabling users and analysts to filter and aggregate data by organization.

Data Type

VARCHAR

Nullable

No

Last Updated

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

org_zipcode

Business Definition

ORG_ZIPCODE represents the postal code of the organization's location. Its business purpose is to provide geographical information for organizational analysis and reporting. Users and analysts would use this column to filter or aggregate data based on geographic regions, enabling them to understand trends and patterns related to specific areas.

Data Type

VARCHAR

Nullable

No

Last Updated

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

parent_org_uuid

Business Definition

PARENT_ORG_UUID is a unique identifier for the parent organization within the WELD_NORTH_PROD.WNE_DIM_MODEL.ORG_DIM_LATEST table. It is used to track and link related organizations within a hierarchical structure, enabling users and analysts to understand organizational relationships and perform hierarchical analysis.

Data Type

VARCHAR

Nullable

No

Last Updated

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

product_group_key

Business Definition

PRODUCT_GROUP_KEY is a unique identifier that represents a specific group of products within the organization. Its business purpose is to categorize and manage products effectively, allowing users and analysts to filter and analyze data based on these product groups for strategic decision-making.

Data Type

NUMBER

Nullable

No

Last Updated

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

professional_development_specialist

Business Definition

The "PROFESSIONAL_DEVELOPMENT_SPECIALIST" column represents the individual responsible for overseeing professional development activities within an organization. Its business purpose is to track and manage the specialists who facilitate training and development programs. Users and analysts would use this column to identify key personnel involved in professional development initiatives and to analyze the effectiveness of these programs.

Data Type

VARCHAR

Nullable

No

Last Updated

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

source_created_by

Business Definition

The "SOURCE_CREATED_BY" column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ORG_DIM_LATEST table represents the individual or system that originally created the record. Its business purpose is to track the source of data entry for auditing and accountability. Users and analysts would use this column to trace the origin of data entries, ensuring data integrity and facilitating troubleshooting.

Data Type

VARCHAR

Nullable

No

Last Updated

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

source_created_on

Business Definition

The "SOURCE_CREATED_ON" column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ORG_DIM_LATEST table represents the date and time when the record was originally created in the source system. Its business purpose is to track the creation timestamp of organizational data, allowing users and analysts to understand the chronology of data entries and perform time-based analyses.

Data Type

TIMESTAMP_NTZ

Nullable

No

Last Updated

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

source_system_id

Business Definition

SOURCE_SYSTEM_ID is a unique identifier that indicates the original system from which the data in the WELD_NORTH_PROD.WNE_DIM_MODEL.ORG_DIM_LATEST table was sourced. It is used by users and analysts to trace the origin of the data, ensuring data lineage and facilitating troubleshooting and reconciliation processes.

Data Type

NUMBER

Nullable

No

Last Updated

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

source_updated_by

Business Definition

The "SOURCE_UPDATED_BY" column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ORG_DIM_LATEST table represents the individual or system that last updated the record. Its business purpose is to track changes and maintain accountability for updates. Users and analysts would use this column to identify who made the most recent modification to the data, aiding in auditing and troubleshooting.

Data Type

VARCHAR

Nullable

No

Last Updated

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

source_updated_on

Business Definition

The "SOURCE_UPDATED_ON" column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ORG_DIM_LATEST table represents the date and time when the source data for the organization dimension was last updated. Its business purpose is to track the freshness of the data, allowing users and analysts to understand the recency of the information and ensure they are working with the most current data available.

Data Type

TIMESTAMP_NTZ

Nullable

No

Last Updated

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

strategic_project_manager

Business Definition

The "STRATEGIC_PROJECT_MANAGER" column represents the individual responsible for overseeing and managing strategic projects within the organization. Its business purpose is to identify the key personnel accountable for the success and delivery of these projects. Users and analysts would use this information to track project progress, allocate resources, and ensure effective communication with the appropriate project manager.

Data Type

VARCHAR

Nullable

No

Last Updated

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

type

Business Definition

The "TYPE" column in the WELD_NORTH_PROD.WNE_DIM_MODEL.ORG_DIM_LATEST table represents the category or classification of an organization. Its business purpose is to differentiate between various types of organizations within the dataset. Users and analysts would use this column to filter and analyze data based on specific organizational types, enabling more targeted and relevant insights.

Data Type

VARCHAR

Nullable

No

Last Updated

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