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.
Data Review
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 | Description | Submission | Data View Column | [Table]Field Name | Business Rules |
School | An educational institution that provides instructional services to students. | Required | School Number | [Schools]SIF_StatePRID [Schools]School_Number
| School Identifier format: ttdddbbbb 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. 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. Data is being pulled from schools no, the PS label name is school ID. |
SchoolYear
| The academic year for which data is being reported, typically spanning from fall of one year to summer of the next. | Required | Year | Calculated using [TERMS]YearID | If 2023-2024, then extract 2024 |
BeginDate | The start date of a particular session or term. | Required | First Day | [TERMS]FirstDay
| The valid start date of the session defined. |
EndDate | The end date of a particular session or term. | Required | Last Day | [TERMS]LastDay
| The valid end date of the session defined. |
SessionName | The name given to a specific period within the school year, such as "Fall Semester" or "Spring Term." | Required | Session Name | [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 | A code or label that describes the term, such as "Q1" for the first quarter or "S1" for the first semester. | Required | Term | Derived from [Terms] [Terms]Portion | Displayed under code set mapping of profile KEDS 2023-2024. |
TotalInstructionalDays | The total number of days within a session or term during which instruction is provided to students. | Required | Total Instruction Days | [TERMS]FirstDay [TERMS]LastDay | Sum of in-session days between TERMS.firstday and TERMS.lastday Provide valid total instructional days within the session defined
|