Information describing school calendars, grading periods, and sessions (academic terms).
Grading Periods
Describes grading periods related to terms. Each grading period has a descriptor and sequence number.
Primary PowerSchool Source Data
Core tables used in this resource:
-
[Terms]
-
[Termbins]
-
[CST_PubCodeMappingMisc]
Selection Criteria
Business logic for publishing this resource:
-
Term must match the school and year being published
-
Term abbreviation must resolve to valid grading period descriptor
-
Sequence is determined by last character of abbreviation (1-9) or '1' for full year terms
-
Deduplicates by descriptor + sequence to prevent duplicate Ed-Fi keys
Resource Output
Expected output from the selection criteria:
-
schoolReference - Reference to the school
-
schoolYearTypeReference - Academic year
-
gradingPeriodDescriptor - Ed-Fi descriptor identifying the period type
-
periodSequence - Sequence number (1-9) for periods of the same type
-
beginDate - First day of grading period
-
endDate - Last day of grading period
-
totalInstructionalDays - Count of instructional days in period
Automatic Publishing
Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.
Data Elements
Details of each data element published in this resource:
|
Data Element |
Description |
[Table]Data Type |
Stored in [Table]Field |
|
schoolReference |
Reference to the school that defines this grading period |
customobject |
[Terms]SchoolID formatted via formatLEASchoolID() |
|
schoolYearTypeReference |
Academic school year (e.g., 2023-2024) |
customobject |
[Terms]YearID converted to school year format |
|
gradingPeriodDescriptor |
Ed-Fi descriptor for grading period type (e.g., Quarter1, Semester1, Trimester1, etc.) via getGradingPeriodDescriptor() or termbins store code |
string |
[Terms]Portion, [Terms]Abbreviation via CST_PUBSTAGE_LIB.getGradingPeriodDescriptor() |
|
periodSequence |
Sequence number (1-9) for ordering periods of the same type within the school year |
number |
[Terms]Abbreviation (last digit) or [termbins]storecode |
|
beginDate |
Start date of the grading period |
datetime |
[Terms]FirstDay |
|
endDate |
End date of the grading period |
datetime |
[Terms]LastDay |
|
totalInstructionalDays |
Total number of instructional days in this grading period |
number |
Calculated or stored in [Terms]Instructional_Days |
Sessions
Information describing school terms (sessions). Each session represents an academic term like Fall, Spring, etc.
Primary PowerSchool Source Data
Core tables used in this resource:
-
[Terms]
-
[section_meeting]
Selection Criteria
Business logic for publishing this resource:
-
Term must match the school and year being published
-
Term must not be excluded
-
One record per term per school per year
Resource Output
Expected output from the selection criteria:
-
schoolReference - Reference to the school
-
schoolYearTypeReference - Academic year
-
termDescriptor - Ed-Fi descriptor for term type (e.g., Fall, Spring, Summer)
-
sessionName - Name of the session
-
beginDate - First day of the term
-
endDate - Last day of the term
-
totalInstructionalDays - Count of school days in the term
Automatic Publishing
Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.
Data Elements
Details of each data element published in this resource:
|
Data Element |
Description |
[Table]Data Type |
Stored in [Table]Field |
|
schoolReference |
Reference to the school that operates this session |
customobject |
[Terms]SchoolID formatted via formatLEASchoolID() |
|
schoolYearTypeReference |
Academic school year for this session |
customobject |
[Terms]YearID converted to school year format (+ 1991) |
|
termDescriptor |
Ed-Fi descriptor for term type (e.g., Fall, Spring, Summer, Winter, Year-Round) |
string |
[Terms]Portion via descriptor |
|
sessionName |
Human-readable name of the session/term |
string |
[Terms]Abbreviation |
|
beginDate |
First day of instruction for this session |
datetime |
[Terms]FirstDay |
|
endDate |
Last day of instruction for this session |
datetime |
[Terms]LastDay |
|
totalInstructionalDays |
Count of instructional days (school days) in this term |
number |
[Terms]Instructional_Days |