Org Level 1 to 5

This query subject describes an organization as a flat structure with four levels of an organization structure hierarchy.

Org Level 1 to 5 Properties

Property

Description

Org Node Name L1

Organization structure Level 1 Node name.

Org Node Name L2

Organization structure Level 2 Node name.

Org Node Name L3

Organization structure Level 3 Node name.

Org Node Name L4

Organization structure Level 4 Node name.

Org Node Name L5

Organization structure Level 5 Node name. (Usage is defined for this level node.)

Org Type Name

Organization name.

Org Node ID L1

The organization node ID on Level 1.

Org Node ID L2

The org. node ID on Level 2.

Org Node ID L3

The org. node ID that is referenced from the Usage query subject.

Org Node ID L4

The organization node ID that is referenced from the Usage query subject.

Org Node ID L5

The organization node ID that is referenced from the Usage query subject.

Start Date L2-1

The Effective start date (inclusive) of the hierarchy relationship between L2 node and L1 node.

End Date L2-1

The Effective end date (exclusive) of the hierarchy relationship between L2 node and L1 node.

Time ID Start L2-1

Reference to the Effective start date (inclusive) of the hierarchy relationship between L2 node and L1 node.

Time ID End L2-1

Reference to the Effective end date (exclusive) of the hierarchy relationship between L2 node and L1 node.

Start Date L3-2

The Effective start date (inclusive) of the hierarchy relationship between L3 node and L2 node.

End Date L3-2

The Effective end date (exclusive) of the hierarchy relationship between L3 node and L2 node.

Time ID Start L3-2

Reference to the Effective start date (inclusive) of the hierarchy relationship between L3 node and L2 node.

Time ID End L3-2

Reference to the Effective end date (exclusive) of the hierarchy relationship between L3 node and L2 node.

Start Date L4-3

The Effective start date (inclusive) of the hierarchy relationship between L4 node and L3 node.

End Date L4-3

The Effective end date (exclusive) of the hierarchy relationship between L4 node and L3 node.

Time ID Start L4-3

Reference to the Effective start date (inclusive) of the hierarchy relationship between L4 node and L3 node.

Time ID End L4-3

Reference to the Effective end date (exclusive) of the hierarchy relationship between L4 node and L3 node.

Start Date L5-4

The Effective start date (inclusive) of the hierarchy relationship between L5 node and L4 node.

End Date L5-4

The Effective end date (exclusive) of the hierarchy relationship between L5 node and L4 node.

Time ID Start L5-4

Reference to the Effective start date (inclusive) of the hierarchy relationship between L5 node and L4 node.

Time ID End L5-4

Reference to the Effective end date (exclusive) of the hierarchy relationship between L5 node and L4 node.

User ID L5

Reference to a User. It is not null when a node is a leaf level User node. If a node is an intermediate node with children, it is always null.

Project ID L5

Reference to a Project. It is not null when a node is a leaf level Project node. If a node is an intermediate node with children, it is always null.

License Server Host ID L5

Reference to a License Server Host. It is not null when a node is a leaf level License Server Host node. If a node is an intermediate node with children, it is always null.

Org Node Display Name L1

The display name for the organization structure Level 1 node name.

Org Node Display Name L2

The display name for the organization structure Level 2 node name.

Org Node Display Name L3

The display name for the organization structure Level 3 node name.

Org Node Display Name L4

The display name for the organization structure Level 4 node name.

Org Node Display Name L5

The display name for the organization structure Level 5 node name.