Skip to main content
Skip table of contents

Student Award Fact Extract

Introduction

This district-level extract reports data for each state seal of bilingualism-biliteracy awarded. State seals of bilingualism-biliteracy may be awarded for multiple languages. A separate record must be submitted for each language. Student award fact records are entered on Start Page > Student Selection > New Mexico State Information > Award Fact. The Student Award Fact returns records for students with a Student Award Fact record in the current school year for each Award Fact record with an award date between the report start and end dates. The Output File Name for Student Award Fact is [DistrictNum]_STUDENT_AWARD_FACT_[Timestamp].csv. 

Selection Criteria

Selection criteria determine which database records are used in the report.

Student Selection

  • The student must have an Award Fact record between the report start and end dates.

  • The student is HSDA-flagged.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Select Schools

Choose one of the following:

  • Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.

  • All Schools – Includes all student records on the PowerSchool server that meet selection criteria.

Note: The All Schools option is only available when running the report from the District Office.

Select Students

Choose one of the following:

  • The Selected [x] Students Only – Run the report for students in the current selection.

  • All Students – Run the report for all students in the current school or district.

Select Start Date

Enter the start date of the report.

Select End Date

Enter the end date of the report.

Back to Top

Report Output – Extract Version

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Tables for a definition of each column in the table.

Item #

Data Element

Description

[Table]FieldName

1

District Code

The PED assigned three-digit district number.

[Prefs]Name=DistrictNumber

[Prefs]Value

2

School Year Date

This value is automatically extracted as June 30th. The report determines the year by referencing the school year selected for the report input.

To change terms, click Terms at the top of the page and choose a term from the list.

The value is extracted in the format YYYY-MM-DD.

[Terms]LastDay

3

Student ID

The state assigned student identification number.

[Students]State_StudentNumber


4

Award Code

The language the student received their award for.

Valid codes:

  • 98 - |Latin |lat|


[S_NM_STU_AFE_C]AwardCode

5

Award Type

The type of award the student received.

[S_NM_STU_AFE_C]AwardType

6

Award Date

The date the student received the award for Bilingualism/Biliteracy.
This value is automatically extracted as June 30.
See School Year Date above for details.

[Terms]LastDay

Back to Top

JavaScript errors detected

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

If this problem persists, please contact our support.