Stores hierarchical relationships between academic units and academic levels. This table defines how different units contribute to institutional organization, program offerings, curriculum development, and student advising structures.

Table Specific Information

Select

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

For example:

SELECT * FROM AcademicUnitsLevels 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 level instance. This Id ensures that each academic unit level is distinctly tracked and managed within the institution’s hierarchy.
AcademicUnits_Id [KEY]	String	The unique Id for the academic unit that contains this level instance. This Id ensures the proper classification of academic units within the institutional structure.
Descriptor	String	The display name of the instance
EffectiveDate_Prompt	Date	Filters academic unit levels based on their effective date using the YYYY-MM-DD format. This filter determines which academic unit levels 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 unit levels as of the effective date. A value of 'true' returns only inactive academic unit levels, while the default value of 'false' retrieves only active ones.
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.