Skip to main content
Skip table of contents

Student Education Award

This view captures details about students who have been awarded within the current reporting period.


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


Data Type

Stored in [Table]Field


educationOrganizationIdThe identifier assigned to the Education Organization.Integer

Always an 8 digit value:

  • First 2 digits will ALWAYS be 35 (indicating NM)
  • Next 3 digits will always be the LEA Number ([Prefs]Value where [Prefs]Name = 'DistrictNumber')
  • Final 3 digits will be the building number (sx.LocationCode if not null. If null, then Alt School Number if > 0. Else, School_Number)

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

schoolYearThe school year in which the student received the award. The identifier for the school year, for example, 2021-2022.IntegerDerived 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
StudentUniqueIdA unique number assigned to the student by the state. String

StudentUniqueId downloaded from State

Derived from:



The date on which the student received the award.

This date will report as YYYY-06-30 (based on the saved award date value)

studentAwardLanguageDescriptorThe language for which the State Seal of Bilingualism-Biliteracy (SSBB) was awarded.String[S_NM_STU_AFE_C]AwardCode
studentAwardTypeDescriptorThe type of award received by the student.String[S_NM_STU_AFE_C]AwardType

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.