**Source URL:** https://limited.veevavault.dev/vql/query-targets/hierarchy-relationship.md

# Hierarchy Relationship

Use the `hierarchy_node_sysr` relationship to see the ordering of hierarchical objects. This relationship is available on hierarchy-enabled Vault objects, such as `edl_template__v`, `edl__v`, `submission_metadata__v`, and `visual_hierarchy__v`.

The `hierarchy_node_sysr` relationship cannot be queried directly and is only available as a
subquery. It is a one-to-one inbound relationship.

Access to hierarchy node data depends on the user’s permissions on the parent hierarchical record.

## Queryable Fields {#queryable-fields}

| Field Name | Description |
| --- | --- |
| `node_id_sys` | The ID of the hierarchy node (distinct from the record ID). |
| `order_sys` | The numerical position of the node among its siblings. |
| `parent_node_id_sys` | The ID of the parent hierarchy node (`null` for root nodes). |
| `last_modified_date_sys` | The date the hierarchy node was last modified. |

## Query Example {#query-example}

```
SELECT uuid__v,
  (SELECT order__sys from hierarchy_node__sysr) 
FROM edl_template__v
WHERE root_content_plan_template__v.uuid__v = '47c296ch'

```


---

**Previous:** [Groups](/vql/query-targets/groups)  
**Next:** [Jobs](/vql/query-targets/jobs)