Tracks subordinate relationships within academic units. These relationships define structural dependencies between departments, divisions, and other academic entities for budgeting, reporting, and governance purposes.

Table Specific Information

Select

The Workday connector requires filtering on AcademicUnits_Id in order to perform the query.

For example:

SELECT * FROM AcademicUnitsSubordinates WHERE AcademicUnits_Id = '12345';

Workday Resource Information

Retrieves information about the Academic Unit with the specified ID, as of the specified effective date. If you don't specify the effectiveDate query parameter, the effective date defaults to the current date.

Secured by: Reports: Academic Units, Set Up: Academic Unit Configuration, Set Up: Academic Units

Scope: Academic Faculty, Academic Foundation

Columns

Name	Type	Description
Id [KEY]	String	The unique identifier (Id) for the academic unit subordinate instance. This Id ensures that each subordinate academic unit is accurately tracked and associated with its superior unit.
AcademicUnits_Id [KEY]	String	The unique Id for the academic unit that contains this subordinate unit. This Id establishes a structured relationship between the superior academic unit and its subordinates, supporting hierarchical organization and reporting.
Inactive	Bool	Indicates whether the academic unit is inactive as of the effective date. A value of 'true' signifies that the academic unit is no longer active within the institution’s academic structure.
Institution	Bool	Indicates whether the academic unit is designated as an institution as of the effective date. A value of 'true' signifies that the academic unit represents a full institution rather than a subdivision such as a department or faculty.
Name	String	The official name of the academic unit as of the effective date. This name provides a recognizable label for the unit within the institution’s academic hierarchy.
EffectiveDate_Prompt	Date	Filters academic units based on their effective date using the YYYY-MM-DD format. This filter determines which academic units are retrieved based on their status as of the specified date, with the default being the current date.
Inactive_Prompt	Bool	Indicates whether to retrieve inactive academic units as of the effective date. A value of 'true' returns only inactive academic units, while the default value of 'false' retrieves only active units.
Institution_Prompt	Bool	Indicates whether to retrieve academic units designated as institutions as of the effective date. A value of 'true' returns only institutions, while the default value of 'false' retrieves all types of academic units.
Superior_Prompt	String	The unique Id for the immediate superior academic unit as of the effective date. This Id ensures hierarchical structuring and can be retrieved using GET /academicUnits.