AcademicUnitsRelatedSupervisoryOrganizations
Links academic units to their related supervisory organizations. This table supports workflow approvals, reporting hierarchies, budget allocations, and faculty management within an institution.
Table Specific Information
Select
The Workday add-in requires filtering on AcademicUnits_Id in order to perform the query.
For example:
SELECT * FROM AcademicUnitsRelatedSupervisoryOrganizations 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 accurately tracked and managed within the institution’s hierarchical structure. |
| AcademicUnits_Id [KEY] | String | The unique Id for the academic unit that contains this level instance. This Id ensures that each academic unit level is correctly associated with the appropriate academic unit, allowing for structured categorization and reporting. |
| Descriptor | String | A human-readable summary of the academic unit level instance. This summary provides a descriptive label that helps users quickly identify the academic level within the institution’s hierarchy. |
| 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 academic unit levels that are inactive as of the effective date. A value of 'true' returns only inactive academic unit levels, while the default value of 'false' retrieves only active levels. |
| 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 proper hierarchical structuring of academic units and can be retrieved using GET /academicUnits. |