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:
Note: The All Schools option is only available when running the report from the District Office. |
Select Students | Choose one of the following:
|
Select Start Date | Enter the start date of the report. |
Select End Date | Enter the end date of the report. |
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:
| [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. | [Terms]LastDay |