Academic Week

This Ed-Fi resource captures academic weeks and includes key data elements such as the school number, week identifier, week begin and end dates, and total instructional days.

academicWeek

This association represents the academic weeks for a school year.

Primary PowerSchool Source Data

[Terms]

Selection Criteria 

The school must not be excluded from state reporting. 
The calendar week date for the district or the school falls within the year for the Term selected in the PowerSchool UI.
The calendar In-session days.

Data Review

Field	Selection
Choose Dashboard	Organization Info
Choose Category	Organization InfoSummary    Organization Info Published    Organization Info Dependencies    Organization Info Errors
Choose Data view	Academic Week

Resource Output

Ed-Fi Data Element	Description	Data View Column Name	Submission	[Table] Field Name	Business Rules	Comments
SchoolID	A unique identifier assigned to a school within the district.	School Number	Y	[Schools]SIF_StatePRID [Schools]schoolnumber Derived from Calendar	School Number Format: ttbbbdddd If [Schools]SIF_StatePRID is blank, [Schools]School_number is pulled. The [Schools]SIF_StatePRID or [Schools]School_number must match with the Organization Catalog.
WeekIdentifier	A unique identifier assigned to each academic week within a school year. This identifier helps in tracking and organizing data related to specific weeks, including the start and end dates, and the total instructional days within that week.	Week Identifier	Y	School Label for the Week Derived from [Calendar]	Week Start Date-School Name	Name of the school for the start and end date of week.
BeginDate	The start date of a particular session, term, or grading period.	Week Begin date	Y	Derived from [Calendar]		Start date of week as per Calendar
EndDate	The end date of a particular session, term, or grading period.	Week End Date	Y	Derived from [Calendar]		End date of week as per Calendar
TotalInstructionalDays	The total number of days within a session, term, or grading period during which instruction is provided to students.	Total Instructional Days	Y	Derived from [Calendar]		Total Instructional Days during the academic week.