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 | |