ODBC Driver for Workday

Build 25.0.9434

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 driver 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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434