PES_ObjectAssociation

This table manages the hierarchical relationship among items and resource teams.

Column	Data Type	Description
oa_AncestorUID	int	The ID of the ancestor object.
oa_DescendantUID	int	The ID of the descendant object.
oa_Level	smallint	The number of levels down in the item hierarchy the descendant is from the ancestor.

For example:

SELECT oa_DescendantUID FROM PES_ObjectAssociation WHERE oa_AncestorUID IN (1)

This table is often used in a MACRO’s inner filter clause to bring back all items at a certain level and lower. For example:

SELECT * FROM PES_MACRO_INVESTMENT(inv, obj_UID IN (SELECT oa_DescendantUID FROM PES_ObjectAssociation WHERE oa_AncestorUID IN (1)), Project_Status