Student Education Award
This view captures details about students who have been awarded within the current reporting period.
studentEducationOrganizationAwards
Awards received by students.
Primary PowerSchool Source Data
- [S_NM_STU_AFE_C]
Selection Criteria
Records are published if the following criteria are met:
- The student was published in the Student category.
- The student has received an award.
- The award date is within the current school year.
- StudentUniqueId must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The school must not be excluded from state reporting.
Resource Output
- A single record is published for each student and for each enrollment period in each of the program associations included in the resource.
- The studentEducationOrganizationAward resource is dependent on the prior publishing of the Student resource.
- LEAs and Schools may upload (publish) data to the ODS in real-time or on-demand ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req’d |
| educationOrganizationReference | ||||
| educationOrganizationId | The identifier assigned to the Education Organization. | Integer | Always an 8 digit value:
Note: If the student is a mid transfer (Enrollment_SchoolID != SchoolID and Enroll_Status = 2), the building number will be the Alt School Number or School Number that corresponds with the Enrollment_SchoolID building (assuming the sx.LocationCode field is null. If the sx.LocationCode field is not null, the building number will be the not null value.) | M |
| schoolYearTypeReference | ||||
| schoolYear | The school year in which the student received the award. The identifier for the school year, for example, 2021-2022. | Integer | Derived from school year: The value will be the trailing year. For example, if the school year is 2021 - 2022, then the value will be 2022. | M |
| studentReference | ||||
| StudentUniqueId | A unique number assigned to the student by the state. | String | StudentUniqueId downloaded from State Derived from: [Students]State_StudentNumber | M |
| awardDate | The date on which the student received the award. This date will report as YYYY-06-30 (based on the saved award date value) | Datetime | [S_NM_STU_AFE_C]AwardDate | |
| studentAwardLanguageDescriptor | The language for which the State Seal of Bilingualism-Biliteracy (SSBB) was awarded. | String | [S_NM_STU_AFE_C]AwardCode | |
| studentAwardTypeDescriptor | The type of award received by the student. | String | [S_NM_STU_AFE_C]AwardType | |