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 for every Award Fact child table record 
- If the award date is within the reporting year but does not fall in any school enrollment, then the award fact record will be published corresponding to a prior school enrollment in the same reporting year 
- 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 | |
