# Planning Dimension Node Hierarchy DMO

Defines the parent-child relationships between dimension nodes in the dimension hierarchy.

## Object Properties

**Object API Name:** `PlanningDimensionNodeHierarchy_std__dlm`\
**Category:** Unassigned\
**Availability:** Available in 262 and later versions\
**Primary Key Field:** Id

## Relationships

- **ParentNodeId** has a FOREIGNKEY relationship with the [Planning Dimension Node DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-planningdimensionnodedmo-dmo.md) `Id` field.
- **ChildNodeId** has a FOREIGNKEY relationship with the [Planning Dimension Node DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-planningdimensionnodedmo-dmo.md) `Id` field.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [ChildNodeId](#childnodeid)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [EndDate](#enddate)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_ChildNodeId](#kq_childnodeid)
- [KQ_Id](#kq_id)
- [KQ_ParentNodeId](#kq_parentnodeid)
- [ParentNodeId](#parentnodeid)
- [StartDate](#startdate)
- [StructureType](#structuretype)
- [UsageType](#usagetype)

### cdp_sys_record_currency

- **Field API Name:** `cdp_sys_record_currency__c`
- **Data Type:** TEXT
- **Description:** System-generated metadata field that stores a 3-letter ISO currency code.

### ChildNodeId

- **Field API Name:** `ChildNodeId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceId

- **Field API Name:** `DataSourceId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceObjectId

- **Field API Name:** `DataSourceObjectId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### EndDate

- **Field API Name:** `EndDate__c`
- **Data Type:** DATEONLY
- **Description:** Date and time when the record or activity ended.

### Id

- **Field API Name:** `Id__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### InternalOrganizationId

- **Field API Name:** `InternalOrganizationId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### KQ_ChildNodeId

- **Field API Name:** `KQ_ChildNodeId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ChildNodeId

### KQ_Id

- **Field API Name:** `KQ_Id__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for Id

### KQ_ParentNodeId

- **Field API Name:** `KQ_ParentNodeId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ParentNodeId

### ParentNodeId

- **Field API Name:** `ParentNodeId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### StartDate

- **Field API Name:** `StartDate__c`
- **Data Type:** DATEONLY
- **Description:** Date and time when the record or activity began.

### StructureType

- **Field API Name:** `StructureType__c`
- **Data Type:** TEXT
- **Description:** Alphanumeric string representing the structure type.

### UsageType

- **Field API Name:** `UsageType__c`
- **Data Type:** TEXT
- **Description:** Alphanumeric string representing the usage type.