IS_LOWEST_CHILD

Business Definition

The IS_LOWEST_CHILD column is a boolean flag indicating whether the child organization in a given row is a leaf organization (has no children itself) in the organizational hierarchy. A value of TRUE indicates that the child_org_key organization is at the bottom level of the hierarchy with no subordinate organizations (typically a Classroom or final operational unit). This flag is used to identify terminal organizations for rollup calculations and to distinguish between intermediate and leaf nodes in the organizational tree.

Data Type

BOOLEAN

Nullable

No

Last Updated

2025-01-23 by MANUAL_ENTRY