View Public Events Calendar
NM Public Education Department logo
stripes illustration

Student and Student Snapshot Templates

  1. Home
  2. Offices and Programs
  3. Information Technology
  4. STARS Information, Manuals, and Supporting Documents
  5. Student Domain
  6. Student and Student Snapshot Templates

Target Table Student: STUDENT

Target Table Student Snapshot: STUD_SNAPSHOT

Data Submission Schedule: K5P, 40 Day, 80 Day, 120 Day, End of Year (EOY), Open Year Round (7/15)

Grain for Student: One record per district / school year / student

Grain for Student Snapshot: One record per district / school year / student / snapshot date

Load Sequences/Dependencies for Student Snapshot:

  1. Student

TEMPLATES DESCRIPTION :

  • STUDENT – contains one record for each student for each school year. This template includes any student enrolled during the school year and students who are pre-enrolled, rollovers, or returning 12th grade students receiving Special Education and related services with a continuing (C) or transition (T) IEP. The Student template can be submitted at all reporting periods other than EOY in either a point-in-time fashion (only including active students) or in a cumulative fashion (all students enrolled in the district for the school year). End of year Student template submission must be a cumulative submission. All students, regardless of whether or not they were active on a PED reporting date, must be included in the end of year and summer session submissions.  Note:  In the table below, an asterisk (*) indicates the field is not used in STUDENT SNAPSHOT but is used in STUDENT.
  • STUDENT SNAPSHOT – contains the same information as the Student Template with the addition of a snapshot date. The template contains one record for each student per snapshot date per school year per district. Only active students at each reporting period should be included in this template. Active students include returning 12th grade students receiving Special Education and related services with a continuing (C) or transition (T) IEP and EOY graduates.  Note:  In the table below, a double asterisk (**) indicates the field is not used in STUDENT but is used STUDENT SNAPSHOT.

School Year 2019-2020 Changes:

  • STUDENT
    • No Changes
  • STUDENT SNAPSHOT
    • No Changes
  • STUDENT File Name Format:  DDD_STUDENT_YYYYMMDDHHMM.fff
    File Name Format Example:  001_STUDENT_201907071201.csv
  • STUDENT SNAPSHOT File Name Format:  DDD_STUD_SNAPSHOT_YYYYMMDDHHMM.fff
    File Name Format Example:  001_STUD_SNAPSHOT_201907071201.csv

in the table below a single asterisk (*) indicates that the field is in Student only
a double asterisk (**) indicates that the field is in Student Snapshot only

Field Number Field Name Data Type, Required, Code Valid Values
1 DISTRICT CODE Character, Required, Key
2 LOCATION CODE Character, Required, Updateable
3 SCHOOL YEAR DATE Date, Required, Key
  • 2019-06-30 = SY18-19
  • 2020-06-30 = SY19-20
4 STUDENT ID Character, Required, Key 9 digit Student ID from UniqID
9 MIDDLE INITIAL Character, Optional, Updateable
10 CURRENT GRADE LEVEL ** Character, Required, Updateable
Valid Values
  • PK = Pre-Kindergarten
  • KN = Kindergarten, Half-Day
  • KF = Kindergarten, Full-Day
  • 01 = First Grade
  • 02 = Second Grade
  • 03 = Third Grade
  • 04 = Fourth Grade
  • 05 = Fifth Grade
  • 06 = Sixth Grade
  • 07 = Seventh Grade
  • 08 = Eighth Grade
  • 09 = Ninth Grade
  • 10 = Tenth Grade
  • 11 = Eleventh Grade
  • 12 = Twelfth Grade
  • OS = Out of School
14 BIRTHDATE Date, Required, Updateable YYYY-MM-DD
15 GENDER CODE Character, Required, Updateable
  • M = Male
  • F = Female
16 ADDRESS 1 Character, Required, Updateable
17 ADDRESS 2 Character, Optional, Updateable
18 CITY Character, Required, Updateable
19 STATE CODE Character, Required, Updateable
22 PRIMARY GUARDIAN NAME Character, Required, Updateable
25 UNACCOMPANIED YOUTH Character, Conditionally Required, Updateable
Valid Values
  • U = Unaccompanied Youth. Homeless student NOT in the presence of a parent, guardian or legal status identified by the court system (e.g., Guardian ad Litem, or foster parent).
  • A = Accompanied Youth. Homeless student In the presence of a parent, guardian or legal status identified by the court system.
27 ETHNIC CODE SHORT Character, Required, Updateable
Valid Values
  • C = Caucasian
  • B = Black  or African American
  • A = Asian
  • I = American Indian/Alaskan Native
  • P = Native Hawaiian or Other Pacific Islander
33 FOOD PROGRAM PARTICIPATION CODE Character, Required, Updateable
Valid Values
  • F = Free
  • R = Reduced
  • N = Not participating as Free or Reduced.  This is for students that pay full price for their school meals.
38 SPECIAL EDUCATION Character, Required, Updateable Y = Students with Disabilities (Primary or Secondary)
N = Regular Education and Gifted-only Students
40 LEVEL OF INTEGRATION Character, Conditional Required, Updateable
Valid Values
  • 1 = Less than 10% of the day (minimum or “A”)
  • 2 = 11% to 49% of the day (moderate or “B”)
  • 3 = 50% of the day or more, but not a full day (extensive or “C”)
  • 4 = Up to a full day or program 3Y/4Y (maximum or “D”)
46 REPEATING LAST YEAR Character, Required, Updateable Y = Retained
N = Promoted
67 STUDENT STATUS* Character, Conditionally Required, Updateable G = Graduated
68 LAST STATUS DATE* Date, Conditionally Required, Updateable YYYY-MM-DD (actual date of graduation)
70 PLAN 504 INDICATOR Character, Conditionally Required, Updateable

Y = Student qualifies as an individual with disabilities under section 504 of the Rehabilitation Act.

N= Student does not qualify as an individual with disabilities under section 504 of the Rehabilitation Act.
73 FOREIGN EXCHANGE STUDENT Character, Required, Updateable Y = Yes student is a foreign exchange student.
N = No student
80 GIFTED PARTICIPATION CODE Character, Required, Updateable Y = Gifted
N = Not gifted
83 SNAPSHOT DATE **
SY 18-19 Valid Values
  • 2018-10-01 = 40D
  • 2018-12-15 = 80D
  • 2019-03-01 = 120D
  • 2019-06-01 = EOY
  • 2019-06-29 = Summer (Optional)
  • 2018-09-01 = K3P
  • 2018-07-15 = Open-Year-Round

 

SY 19-20 Valid Values
  • 2019-10-01 = 40D
  • 2019-12-15 = 80D
  • 2020-03-01 = 120D
  • 2020-06-01 = EOY
  • 2020-06-29 = Summer (Optional)
  • 2019-09-01 = K5P
  • 2019-07-15 = Open-Year-Round
88 DIRECT CERTIFICATION STATUS CODE Character, Conditionally Required, Updateable
  • 1 = SNAP Direct Cert as identified in the direct certification report and certified by the district.
  • 2 = Other Direct Cert Eligible (Homeless, FDPIR, Foster, Migrant, and Head Start)
  • 3 = Family Members of SNAP identified students that were not found in the Direct Certification report)
91 DIPLOMA TYPE CODE * Character, Conditionally Required, Updateable
  • 1 = Diploma of Excellence without an Alternate Demonstration of Competency (ADC).
  • 2 =Certificate of Course Work Completed (May include students in special education if they are on a continuing or transition IEP. Does NOT end student’s right to FAPE.)
93 ALTERNATE STUDENT ID Character, Optional, Updateable  District’s local student ID
97 GRADE 9 ENTRY DATE Date, Optional, Updateable  YYYY-MM-DD
103 FAMILIY IDENTIFIER Character, Optional, Updateable
107 ALTERNATE GUARDIAN NAME Character, Optional, Updateable
111 HOMELESS Character, Required, Updateable
Valid Values
  • Y – Student is Homeless.
  • N – Student is not homeless.
113 ENGLISH PROFICIENCY CODE Character, Conditionally Required, Updateable
Valid Values
  • 0 =  IFEP – Initially Fluent English Proficient – Student was never EL
  • 1 = Current EL Student
  • 2 = RFEP1 – Reclassified Fluent English Proficient – exited Year 1
  • 3 = RFEP2 – Reclassified Fluent English Proficient – exited Year 2
  • 4 = RFEP3 – Reclassified Fluent English Proficient – exited Year 3
  • 5 = RFEP4 – Reclassified Fluent English Proficient – exited Year 4
  • 6 = RFEP 5+ – Reclassified Fluent English Proficient – exited Year 5+
  • NT = Not Tested (For PreK only)
114 RACE OR ETHNICITY SUBGROUP CODE Character, Required, Updateable
Valid Values
00 = Not Applicable
01 = Acoma
02 = Cochiti
03 = Isleta
04 = Jemez
05 = Jicarilla Apache
06 = Laguna
07 = Mescalero Apache
08 = Nambe
09 = Navajo
10 = Picuris
11 = Pojoaque
12 = San Felipe
13 = San Ildefonso
14 = Ohkay Owingeh (formerly San Juan)
15 = Sandia
16 = Santa Ana
17 = Santa Clara
18 = Kewa (formerly Santo Domingo)
19 = Taos
20 = Tesuque
21 = Zia
22 = Zuni
23 = Other
120 PARENTAL STATUS CODE Character, Required, Updateable
Valid Values
  • S = Single parent means “an individual who is unmarried or legally separated from a spouse; AND has a minor child or children for which the parent has either custody or joint custody; or (ii) Is pregnant.”
  • NS = Legally married student has a minor child or children for which the parent has either custody or joint custody).
  • NP = Student is not a parent.
121 STUDENT IS EXPECTING Character, Required, Updateable
  • Y = Yes
  • N = No
123 HOME LANGUAGE CODE Character, Required, Updateable
Valid Values
00 = English
01 = Spanish
02 = Vietnamese
03 = Hmong; Mong
04 = Chinese (Cantonese or Mandarin)
05 = Cambodian – Khmer
06 = Korean
07 = Laotian
08 = Navajo; Navaho (Diné)
09 = Tagalog
10 = Russian
11 = Creoles, French-based
12 = Arabic
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
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
71 = Serbian
72 = Slavic languages
73 = Swedish
74 = Thai
75 = Tibetan
76 = Ukrainian
77 = Hocano
78 = Kurdish (includes any country where spoken such as Iraq and Afganistan)
79 = Syriac
80 = Cebuano (Visayan)
81 = Chamorro
82 = Kinyarwanda (includes Kirundi)
83 = Lithuanian
84 = Malayalam
85 = Marshallese
86 = Mixteco
87 = Nepali
88 = Pashto (includes Pushto)
89 = Samoan
90 = Sinhalese (includes Sinhala)
91 = Swahili
92 = Tongan (includes Raratongan)
93 = Turkish
94 = Wolof
95 = Yao (includes Mien)
96 = Fanti (spoken in Ghana)
97 = Oromo
125 YEARS IN U.S. SCHOOLS Number (0), Required, Updateable
  • 0 = Student has not reached 12 months of time in U.S. schools
  • 1 = Has reached 12 or more months of time in U.S. schools
131 FOOD PROGRAM ELIGIBILITY Character, Required, Updateable
  • F= Free
  • R = Reduced
  • N = Not participating as Free or Reduced.
133 LAST NAME LONG Character, Required, Updateable
134 FIRST NAME LONG Character, Required, Updateable
144 HISPANIC ETHNICITY INDICATOR Character, Required, Updateable
  • Y = Yes this student is of Hispanic ethnicity.
  • N = No this student is not of Hispanic
146 RACE 2 CODE Character, Optional, Updateable
Valid Values
  • C = Caucasian
  • B = Black  or African American
  • A = Asian
  • I = American Indian/Alaskan Native
  • P = Native Hawaiian or Other Pacific Islander
147 RACE 3 CODE Character, Optional, Updateable
Valid Values
  • C = Caucasian
  • B = Black  or African American
  • A = Asian
  • I = American Indian/Alaskan Native
  • P = Native Hawaiian or Other Pacific Islander
148 RACE 4 CODE Character, Optional, Updateable
Valid Values
  • C = Caucasian
  • B = Black  or African American
  • A = Asian
  • I = American Indian/Alaskan Native
  • P = Native Hawaiian or Other Pacific Islander
149 RACE 5 CODE Character, Optional, Updateable
Valid Values
  • C = Caucasian
  • B = Black  or African American
  • A = Asian
  • I = American Indian/Alaskan Native
  • P = Native Hawaiian or Other Pacific Islander
150 FEDERAL FORM 506 INDICATOR Character, Conditionally Required, Updateable
  • Y = Yes.  Student has a verified Form 506 or Census number on file.
  • N = No.  Student does not have a verified Form 506 or Census number on file.
152 IMMIGRANT INDICATOR Character, Required, Updateable
  • Y = Yes.  Student is an Immigrant.
  • N = No.  Student is not an Immigrant.
155 BASE ZIP CODE Number, Required, Updateable
166 DISPLACED HOMEMAKER Character, Required, Updateable
  • Y = Yes
  • N = No
167 SPED REFERRAL CODE Character, Conditionally Required, Updateable
Valid Values
  • C = Child served in Part C (Birth-3) and was referred to Part B (Age 3-21) for eligibility determination.  “C” is required only if the child was referred from Part C to B.  Event Type Code 18 must exist in Special Ed Events, field #5.
  • F = Child was referred thru Child Find (NOT Receiving Part C Services).   “F” is required only if the student was referred through Child Find (not Part C) and a Parental Request for INITIAL Evaluation was received. Event Type Code 30 must exist in Special Ed Events, field #5.
174 DWELLING ARRANGEMENT CODE Character, Conditionally Required, Updateable
Valid Values
  • S = Shelters
  • D = Doubled–Up
  • U = Unsheltered
  • HM = Hotels/Motels
188 HOME SCHOOLED INDICATOR* Character, Required, Updateable
  • Y = Yes  Student is home schooled.
  • N = No.  Student is not home schooled.
207 MILITARY FAMILY CODE Character, Conditionally Required, Updateable
  • Active
  • National Guard
  • Reserve

*   Indicates field is not used in STUDENT SNAPSHOT but is used in STUDENT.
** Indicates field is not used in STUDENT but is used STUDENT SNAPSHOT.