Power BI Connector for Workday

Build 25.0.9454

AcademicPeriods

Stores data about specific academic periods, including start and end dates, session types, and associated academic calendars. This table supports institutional operations such as registration windows, course scheduling, student billing, and compliance with accreditation requirements.

Workday Resource Information

Retrieves information about the academic periods with the specified ID.

Secured by: Set Up: Academic Appointments and Related Data, Set Up: Academic Calendar

Scope: Academic Faculty, Academic Foundation

Columns

Name Type Description
Id [KEY] String The unique identifier (Id) for the academic period instance. This Id ensures that each academic period is distinctly tracked and managed within the institution’s academic structure.
AcademicCalendar_Descriptor String The display name of the instance
AcademicCalendar_Href String A direct link to the academic calendar instance associated with this academic period. This link provides programmatic access for retrieving detailed information about the academic calendar.
AcademicCalendar_Id String The unique Id for the academic calendar linked to this academic period. This Id establishes a structured relationship between academic periods and their corresponding academic calendars.
AcademicYear_Descriptor String The display name of the instance
AcademicYear_EndDate Datetime The end date of the academic year associated with this academic period. This date marks the official conclusion of the academic year and impacts reporting, grading, and transition planning.
AcademicYear_Id String The unique Id for the academic year associated with this academic period. This Id ensures proper tracking and management of academic years within an institution.
AcademicYear_StartDate Datetime The start date of the academic year associated with this academic period. This date determines when the academic year officially begins and affects course enrollment and scheduling.
Descriptor String The display name of the instance
EndDate Datetime The official end date of the academic period. This date determines when the academic period concludes and affects academic scheduling, grading, and reporting.
PeriodType_Descriptor String The display name of the instance
PeriodType_Href String A direct link to the period type instance associated with this academic period. This link provides programmatic access to retrieve detailed information about the period type.
PeriodType_Id String The unique Id for the period type linked to this academic period. This Id ensures consistency in categorizing academic periods within an institution’s academic structure.
Standard Bool Indicates whether this academic period is a standard academic period within the academic calendar. A value of 'true' means the period follows a predefined, institutionally recognized schedule.
StandardEndDate Datetime The standard end date of this academic period if it is classified as a standard period in the academic calendar. This date ensures uniformity in academic scheduling and reporting.
StandardStartDate Datetime The standard start date of this academic period if it is classified as a standard period in the academic calendar. This date ensures consistency in academic planning and course structuring.
StartDate Datetime The official start date of the academic period. This date determines when courses, instructional activities, and academic events begin.
WeeksOfInstruction Decimal The total number of instructional weeks within this academic period. This value helps institutions plan course durations, faculty schedules, and student workload distribution.
AcademicCalendar_Prompt String The unique Id for the academic calendar that contains this academic period. This Id ensures proper association between academic periods and academic calendars.
AcademicYear_Prompt String The unique Id for the academic year that includes this academic period. This Id allows institutions to structure academic planning and maintain accurate historical records.
FromDate_Prompt Date Filters academic periods based on their start date using the YYYY-MM-DD format. This filter returns academic periods starting on or after the specified date when used alone or within a date range when combined with ToDate_Prompt.
ToDate_Prompt Date Filters academic periods based on their end date using the YYYY-MM-DD format. This filter returns academic periods ending on or before the specified date when used alone or within a date range when combined with FromDate_Prompt.

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