Skip to Content

Student Award Fact Template

Student Award Fact Template 2019-06-13T13:51:37-06:00

Target Table: STUDENT_AWARD_FACT

Data Submission Schedule: End of Year (EOY)

Grain: One record per district / school year date / student ID/ award code / award type/ award date template

Load Sequences/Dependencies:

  1. Student Required

Template Description – The Student Award Fact Template is used to capture information for the following awards:

State Seal of Bilingualism/Biliteracy

Only districts with an approved seal request on file with the Bilingual Multicultural Education Bureau may submit this template. Districts are required to submit this template 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. Please consult the State of New Mexico Diploma of Excellence Bilingualism and Biliteracy Seal Guidance Handbook for additional guidance.

School Year 2019-2020 Changes: 

  1. No Changes

File Name Format:  DDD_STUDENT_AWARD_FACT_YYYYMMDDHHMM.fff
File Name Format Example:  001_STUDENT_AWARD_FACT_201907071201.csv

Field Number Field Name Data Type, Required, Code Valid Values
1 District Code Char, Required, Key
2 School Year Date Date, Required, Key
  • 2019-06-30 = SY18-19
  • 2020-06-30 = SY19-20
3 Student ID Char, Required, Key Enter 9 digit student ID
4 Award Code Char, Required, Key

  • 00 = English
  • 01 = Spanish
  • 02 = Vietnamese
  • 03 = Hmong; Mong
  • 04 = Chinese (Cantonese or Mandarin, also includes Chaozhou, Lahu, Taiwanese, Teochew, and Toishanese)
  • 05 = Cambodian – Khmer
  • 06 = Korean
  • 07 = Laotian (includes Khmu)
  • 08 = Navajo; Navaho (Diné)
  • 09 = Tagalog
  • 10 = Russian
  • 11 = Creoles, French-based
  • 12 = Arabic (spoken in numerous countries including Algeria, Egypt, Iran, Iraq, and Yemen)
  • 13 = Portuguese
  • 14 = Japanese
  • 16 = Tiwa
  • 17 = Tewa
  • 18 = Towa
  • 19 = Keres
  • 20 = Jicarilla Apache
  • 21 = Mescalero Apache
  • 22 = Zuni
  • 24 = Sign Languages – American
  • 25 = Sign Languages – English Based
  • 26 = Albanian
  • 27 = Armenian
  • 28 = Azerbaijani
  • 29 = Baltic languages
  • 30 = Basque
  • 31 = Bosnian
  • 32 = Bulgarian
  • 33 = Burmese
  • 34 = Chechen
  • 35 = Creoles, English based
  • 36 = Creoles, Portuguese-based
  • 37 = Croatian
  • 38 = Czech
  • 39 = Danish
  • 40 = Dutch; Flemish
  • 41 = Estonian
  • 42 = Farsi – Persian (includes Dari spoken in Afghanistan)
  • 43 = Filipino; Pilipino
  • 44 = Finnish
  • 45 = French
  • 46 = German
  • 47 = Greek
  • 48 = Haitian; Haitian Creole
  • 49 = Hawaiian
  • 50 = Hebrew
  • 51 = Hungarian
  • 52 = Icelandic
  • 53 = India and Bangladesh – Bengali
  • 54 = India – Gujarati
  • 55 = India – Marathi
  • 56 = India – Rajasthani
  • 57 = India – Telugu
  • 58 = India and Assam – Assamese
  • 59 = India and Pakistan – Hindi
  • 60 = India and Pakistan – Urdu
  • 61 = India or Pakistan Panjabi; Punjabi
  • 62 = India, Malaysia, Sri Lanka – Tamil
  • 63 = Indonesian
  • 64 = Iranian languages
  • 65 = Italian
  • 66 = North American Indian languages Other
  • 67 = Norwegian
  • 68 = Polish
  • 69 = Romanian; Moldavian; Moldovan
  • 70 = Somali ( also includes Tigrinya)
  • 71 = Serbian
  • 72 = Slavic languages
  • 73 = Swedish
  • 74 = Thai
  • 75 = Tibetan
  • 76 = Ukrainian
  • 77 = Hocano
  • 78 = Kurdish (includes any country where this is spoken such as Iraq and Afghanistan)
  • 79 = Syriac (includes Assyrian and Chaldean)
  • 80 = Cebuano (Visayan)
  • 81 = Chamorro
  • 82 = Kinyarwanda (includes Kirundi)
  • 83 = Lithuanian
  • 84 = Malayalam
  • 85 = Marshallese
  • 86 = Mixteco
  • 87 = Nepali
  • 88 = Pashto (also includes Pushto)
  • 89 = Samoan
  • 90 = Sinhalese (also includes Sinhala)
  • 91 = Swahili
  • 92 = Tongan (also includes Raratongan)
  • 93 = Turkish
  • 94 = Wolof
  • 95 = Yao (also includes Mien)
  • 96 = Fanti (spoken in Ghana)
  • 97 = Oromo

5 Award Type Char, Required, Key

  •  TLC = Tribal Language Certification
  • CA = 4 units of Credit and an Assessment
  • CPP =4 Units of Credit and an Alternative Process Portfolio
  • APP = Assessment and Alternative Process Portfolio

6 Award Date Date, Required, Key
  • 2019-06-30 = SY18-19
  • 2020-06-30 = SY19-20

 

Delete template Delete Parameters Template(s) Deleted Delete Level
Student Award Fact District, School Year Student Award Fact All Records for Period

 

FAQS

Q – How do I know if my district or charter school has an approved seal request on file with the Language and Culture Bureau (formerly the Bilingual Multicultural Education Bureau (BMEB))?

 The Language and Culture Bureau receives Seal Request Forms from districts and charter schools for the Seal of Bilingualism-Bi-literacy on the New Mexico Diploma of Excellence. Once a school board has adopted the seal rule [6.32.3.1 NMAC – N, 09-15-15] into their policies, a Seal Request Form must be submitted by district superintendents or charter school directors. You may contact your district Bilingual Multicultural Education (BME) Director, district Superintendent or charter school Director to ensure there is an approved seal request on file with the Language and Culture Bureau. For additional guidance please consult the State of New Mexico Diploma of Excellence Bilingualism and Bi-literacy Seal Guidance Handbook located at https://webnew.ped.state.nm.us/bureaus/languageandculture/seal-of-bilingualism-biliteracy/

Approved as of 5/10/2018

Districts and State Charters with an approved seal request on file with the Bilingual Multicultural Education Bureau
District or State Charter School Seal Request Approval Date
1 ACE Leadership High School Monday, May 2, 2016
2 Albuquerque Public Schools Wednesday, March 29, 2017
3 Bernalillo Public Schools Thursday, May 11, 2017
4 Bloomfield School District Monday, April 18, 2016
5 Clovis Municipal Schools Tuesday, March 22, 2016
6 Deming Public Schools Wednesday, June 30, 2016
7 Dexter Consolidated Schools Monday, May 2, 2016
8 Española Public Schools Wednesday, May 25, 2016
9 Farmington Municipal Schools Thursday, June 2, 2016
10 Gadsden Independent School District Monday, April 18, 2016
11 Gallup McKinley County Schools Tuesday, May 3, 2016
12 Hatch Valley Public Schools Monday, April 18, 2016
13 Las Cruces Public Schools Tuesday, March 22, 2016
14 Loving Municipal Schools Tuesday, April 26, 2016
15 Lovington Municipal Schools Wednesday, May 25, 2016
16 Monte del Sol Charter School Wednesday, March 29, 2017
17 Portales Municipal Schools Monday, January 23, 2017
18 Rio Rancho Public Schools* Monday July, 11, 2016
19 Roswell Independent School District Wednesday, June 8, 2016
20 Santa Fe Public Schools Wednesday, May 4, 2016
21 Taos Municipal Schools* Wednesday, March 29, 2017
22 Tierra Encantada Charter School Wednesday, May 9,2018
23 Vista Grande High School Thursday, May 11, 2017
24 Zuni Public Schools Friday, May 12, 2017
*Awarded provisionally for one year pursuant to Indian Education Act

 

Q – The State Seal of Bilingualism-Biliteracy is only reported at EOY, how do I report this award fact template for students that graduate during the school year?

The district or charter school BME Director and the high school Registrar should work together to ensure that graduates that obtain a seal are tracked and logged throughout the school year. Mid-year graduates should be reported will all other graduates at EOY.

Page last updated June 13, 2019