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 NumberField NameData Type, Required, CodeValid Values
1District CodeChar, Required, Key
2School Year DateDate, Required, Key
  • 2019-06-30 = SY18-19
  • 2020-06-30 = SY19-20
3Student IDChar, Required, KeyEnter 9 digit student ID
4Award CodeChar, 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

5Award TypeChar, 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

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

 

Delete templateDelete ParametersTemplate(s) DeletedDelete Level
Student Award FactDistrict, School YearStudent Award FactAll 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 SchoolSeal Request Approval Date
1ACE Leadership High SchoolMonday, May 2, 2016
2Albuquerque Public SchoolsWednesday, March 29, 2017
3Bernalillo Public SchoolsThursday, May 11, 2017
4Bloomfield School DistrictMonday, April 18, 2016
5Clovis Municipal SchoolsTuesday, March 22, 2016
6Deming Public SchoolsWednesday, June 30, 2016
7Dexter Consolidated SchoolsMonday, May 2, 2016
8Española Public SchoolsWednesday, May 25, 2016
9Farmington Municipal SchoolsThursday, June 2, 2016
10Gadsden Independent School DistrictMonday, April 18, 2016
11Gallup McKinley County SchoolsTuesday, May 3, 2016
12Hatch Valley Public SchoolsMonday, April 18, 2016
13Las Cruces Public SchoolsTuesday, March 22, 2016
14Loving Municipal SchoolsTuesday, April 26, 2016
15Lovington Municipal SchoolsWednesday, May 25, 2016
16Monte del Sol Charter SchoolWednesday, March 29, 2017
17Portales Municipal SchoolsMonday, January 23, 2017
18Rio Rancho Public Schools*Monday July, 11, 2016
19Roswell Independent School DistrictWednesday, June 8, 2016
20Santa Fe Public SchoolsWednesday, May 4, 2016
21Taos Municipal Schools*Wednesday, March 29, 2017
22Tierra Encantada Charter SchoolWednesday, May 9,2018
23Vista Grande High SchoolThursday, May 11, 2017
24Zuni Public SchoolsFriday, 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