Skip to Content

Student and Student Snapshot Templates

/////Student and Student Snapshot Templates
Student and Student Snapshot Templates 2019-10-09T16:33:00-06:00

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 NumberField NameData Type, Required, CodeValid Values
1DISTRICT CODECharacter, Required, Key
2LOCATION CODECharacter, Required, Updateable
3SCHOOL YEAR DATEDate, Required, Key
  • 2019-06-30 = SY18-19
  • 2020-06-30 = SY19-20
4STUDENT IDCharacter, Required, Key9 digit Student ID from UniqID
9MIDDLE INITIALCharacter, 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
14BIRTHDATEDate, Required, UpdateableYYYY-MM-DD
15GENDER CODECharacter, Required, Updateable
  • M = Male
  • F = Female
16ADDRESS 1Character, Required, Updateable
17ADDRESS 2Character, Optional, Updateable
18CITYCharacter, Required, Updateable
19STATE CODECharacter, Required, Updateable
22PRIMARY GUARDIAN NAMECharacter, Required, Updateable
25UNACCOMPANIED YOUTHCharacter, 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.
27ETHNIC CODE SHORTCharacter, 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
33FOOD PROGRAM PARTICIPATION CODECharacter, 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.
38SPECIAL EDUCATIONCharacter, Required, UpdateableY = Students with Disabilities (Primary or Secondary)
N = Regular Education and Gifted-only Students
40LEVEL OF INTEGRATIONCharacter, 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”)
46REPEATING LAST YEARCharacter, Required, UpdateableY = Retained
N = Promoted
67 STUDENT STATUS*Character, Conditionally Required, UpdateableG = Graduated
68 LAST STATUS DATE*Date, Conditionally Required, UpdateableYYYY-MM-DD (actual date of graduation)
70PLAN 504 INDICATORCharacter, Conditionally Required, UpdateableY = 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.

73FOREIGN EXCHANGE STUDENTCharacter, Required, UpdateableY = Yes student is a foreign exchange student.
N = No student
80GIFTED PARTICIPATION CODECharacter, Required, UpdateableY = 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

88DIRECT CERTIFICATION STATUS CODECharacter, 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.)
93ALTERNATE STUDENT IDCharacter, Optional, Updateable District’s local student ID
97GRADE 9 ENTRY DATEDate, Optional, Updateable YYYY-MM-DD
103FAMILIY IDENTIFIERCharacter, Optional, Updateable
107ALTERNATE GUARDIAN NAMECharacter, Optional, Updateable
111HOMELESSCharacter, Required, Updateable 

Valid Values

  • Y – Student is Homeless.
  • N – Student is not homeless.
113ENGLISH PROFICIENCY CODECharacter, 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)
114RACE OR ETHNICITY SUBGROUP CODECharacter, 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
120PARENTAL STATUS CODECharacter, 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.
121STUDENT IS EXPECTINGCharacter, Required, Updateable
  • Y = Yes
  • N = No
123HOME LANGUAGE CODECharacter, 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
125YEARS IN U.S. SCHOOLSNumber (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
131FOOD PROGRAM ELIGIBILITYCharacter, Required, Updateable
  • F= Free
  • R = Reduced
  • N = Not participating as Free or Reduced.
133LAST NAME LONGCharacter, Required, Updateable
134FIRST NAME LONGCharacter, Required, Updateable
144HISPANIC ETHNICITY INDICATORCharacter, Required, Updateable
  • Y = Yes this student is of Hispanic ethnicity.
  • N = No this student is not of Hispanic
146RACE 2 CODECharacter, 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
147RACE 3 CODECharacter, 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
148RACE 4 CODECharacter, 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
149RACE 5 CODECharacter, 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
150FEDERAL FORM 506 INDICATORCharacter, 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.
152IMMIGRANT INDICATORCharacter, Required, Updateable
  • Y = Yes.  Student is an Immigrant.
  • N = No.  Student is not an Immigrant.
155BASE ZIP CODENumber, Required, Updateable
166DISPLACED HOMEMAKERCharacter, Required, Updateable
  • Y = Yes
  • N = No
167SPED REFERRAL CODECharacter, 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.
174DWELLING ARRANGEMENT CODECharacter, Conditionally Required, Updateable 

Valid Values

  • S = Shelters
  • D = Doubled–Up
  • U = Unsheltered
  • HM = Hotels/Motels
188HOME SCHOOLED INDICATOR*Character, Required, Updateable
  • Y = Yes  Student is home schooled.
  • N = No.  Student is not home schooled.
207MILITARY FAMILY CODECharacter, 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.

 

Page last updated October 9, 2019
English English Spanish Español
| © Copyright 2024 New Mexico Public Education Department | Sitemap
FacebookTwitterLinkedin