DEPTH_FROM_PARENT

Business Definition

The DEPTH_FROM_PARENT column represents the number of hierarchical levels between the parent and child organization, calculated as the distance in the organizational tree. A value of 0 indicates the same organization, 1 indicates an immediate parent-child relationship, 2 indicates a grandparent-child relationship, and so on. This column is critical for hierarchical analytics, allowing analysts to aggregate metrics at specific levels of the organizational structure and perform multi-level rollup calculations.

Data Type

NUMBER

Nullable

No

Last Updated

2025-01-23 by MANUAL_ENTRY