CHILD_ORG_KEY

Business Definition

The CHILD_ORG_KEY column represents the unique key of the child organization in a hierarchical parent-child relationship. This is a foreign key that links to the ORG_DIM table and represents the descendant organization at any level in the hierarchy (could be immediate child or deeper descendant). It is used in hierarchical queries to trace organizational descendants and enable drilling down from higher organizational levels to lower levels in reporting and analysis.

Data Type

NUMBER

Nullable

No

Last Updated

2025-01-23 by MANUAL_ENTRY