PES_Dependency

This table contains information related to item dependencies.

Column	Data Type	Description
obj_UID	int	A unique identifier. Every record in the table has a unique ID.
obj_SourceUID	int	The ID of the dependency’s source item.
cls_UID	smallint	Identifies the dependency type of a particular row entry. The type appears in the PES_Class table.
obj_TargetUID	int	The ID of the dependency’s target item.
obj_LastChange	datetime	The last time the object was changed by a user or the system (includes system).
obj_BinData	image	Contains all the custom attribute data for a dependency. Use a macro to extract it.
obj_Description	ntext	The description of a particular item.
obj_LastChangeBy	int	The ID of the user who last changed the object (includes system).
obj_LastUserChangeDate	datetime	The last time the object was changed by a user (excludes system).
obj_LastUserChangeBy	int	The ID of the user who last changed the object (excludes system).

MACRO: PES_MACRO_DEPENDENCY. For example:

SELECT source.obj_Name as Source, target.obj_Name as Target, dep.obj_Name as Dependency
FROM PES_MACRO_DEPENDENCY(dep, ,Name)
JOIN PES_Object source ON dep.obj_SourceUID = source.obj_UID
JOIN PES_Object target ON dep.obj_TargetUID = target.obj_UID