Sessions (Terms)
This view captures the sessions/terms defined at each school within the district as published in the Session resource within the Organization Info category. Ed-Fi sessions are the equivalent of PowerSchool terms. The layout provides the School Name, Year, Name of Term, First Day of Term, Last Day of Term, Last Publish Date, and the Publishing ID.
session
This resource represents the prescribed span of time when an education institution is open, instruction is provided, and students are under the direction and guidance of teachers and/or education institution administration. A session may be interrupted by one or more vacations.
Primary PowerSchool Source Data
[Terms]
Selection Criteria
Records are published if the following criteria are met:
A session record is created for each TERM defined for a school.
A Grading Period record is created for each TERM defined for a school
The school must not be excluded from state reporting.
The term or term portion exists within the year for the Term selected in the PowerSchool UI.
Resource Input
Field | Selection |
Choose Category |
|
Choose Data View |
|
Resource Output
Publishes organization info for Sessions (Terms).
A separate Session record is published for each unique term record at each school based on [Terms]Portion and [Terms]Abbreviation.
LEAs and Schools may upload (publish) data to the state in real time or on-demand ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Ed-Fi Data Element | Data View Column | Submission | [Table]Field Name | Business Rules |
School | School Number | Required | [Schools]schoolnumber
| School Identifier format: ttdddbbbb Org Id is defaulted to D=14, if district needs another value to be published then district must append alphabet in their district number as per KSDE educationOrganizationID. |
SchoolYear
| Year | Required | Calculated using [TERMS]YearID | If 2023-2024, then extract 2024 |
BeginDate | First Day | Required | [TERMS]FirstDay
| The valid start date of the session defined. |
EndDate | Last Day | Required | [TERMS]LastDay
| The valid end date of the session defined. |
SessionName | Session Name | Required | [TERMS]YearID [TERMS]Name | SessionName format: School Year Term Name If 2023-2024, then it extracts 2024 Session name is a string that represents any of these time periods: |
TermDescriptor | Term | Required | Derived from [Terms] [Terms]Portion | Displayed under code set mapping of profile KEDS 2023-2024. |
TotalInstructionalDays | Total Instruction Days | Required | [TERMS]FirstDay [TERMS]LastDay | Sum of in-session days between TERMS.firstday and TERMS.lastday Provide valid total instructional days within the session defined
|