Stores associations between academic calendars and their respective academic years, enabling structured time period management for institutional planning. This table ensures that term-based activities such as admissions, enrollment, tuition calculations, and graduation requirements align with defined academic cycles.

Table Specific Information

Select

The Workday component requires filtering on AcademicCalendars_Id in order to perform the query.

For example:

SELECT * FROM AcademicCalendarsAcademicYears WHERE AcademicCalendars_Id = '1234';

Workday Resource Information

Retrieves the academic year associated with the specified academic calendar ID with the specified ID.

Secured by: Set Up: Academic Calendar

Scope: Academic Foundation

Columns

Name	Type	Description
Id [KEY]	String	The unique identifier (Id) for the academic calendar academic year instance. This Id is used internally to track and manage different academic years within a specific academic calendar.
AcademicCalendars_Id [KEY]	String	The unique Id for the academic calendar associated with this academic year. This linkage ensures that each academic year is correctly assigned to its respective calendar, allowing institutions to manage multiple years under a single academic structure.
Descriptor	String	A human-readable summary of the academic year instance. This value provides a descriptive label that helps users quickly identify the academic year within the broader academic calendar.
EndDate	Datetime	The end date for the academic year within the specified academic calendar. This date marks the conclusion of the academic cycle and is used for scheduling, reporting, and compliance purposes.
StartDate	Datetime	The start date for the academic year within the specified academic calendar. This date signifies the beginning of the academic cycle, impacting course scheduling, enrollment, and institutional planning.