PowerSchool SIS New Mexico
PowerSchool SIS New Mexico
Breadcrumbs

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:

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

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