Tool Search: Student & Student Snapshot
This tool extracts data for completing the Student Template and Student Snapshot Template extracts.
- The STUDENT extract reports one record per student that is actively enrolled at least one day on or between the Start Date and End Date in at least one of the Calendar/s selected.
- The STUD_SNAPSHOT extract reports one record per student that is actively enrolled on the Standardized Reporting Date in at least one of the Calendars selected.
Student Template & Student Snapshot Template Editor
Report Logic
Report Editor
| Field | Description |
|---|---|
| Extract Type | A dropdown list of all available extracts.
|
| Submission Schedule | A dropdown list of submission schedules.
|
| Standardized Reporting Date | STUD_SNAPSHOT Only The reporting date of the collection. |
Snapshot Date | STUDENT Only The reporting date of the collection. This field only displays when the Submission Schedule is Open Yr Round. |
Submission Start Date Submission End Date | STUDENT Only The first day and the last day of the reporting range. |
| Grade | The Grade field allows you to limit report results to students in the selected mapped state grade(s). |
| Ad Hoc Filter | Ad Hoc Filters allow you to limit report results to those included in the filter. This option is useful for troubleshooting. For example, you could filter report results to specific students. |
Format | The format in which the report will generate. Options include HTML and State Format (CSV). |
| Select Calendars | The calendar(s) from which data is pulled for the report. |
| Generate Extract/ Submit to Batch | The report can be marked to generate immediately using the Generate Extract button or can be marked to generate at a later time using the Submit to Batch button. See the Batch Queue article for additional guidance. |
Report Examples
Student Snapshot Template Example
Student Template Example
Report Layout
| # | Element | Logic | Campus Location | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | District Code | A three character district code. Numeric, 3 digits | System Administration > Resource > District Information District.number | ||||||||||||||||||
| 2 | Location Code | The state school number. This number reports from the student's active reporting primary enrollment. If Student Information > Special Education > General > NM Exceptionality (State Reporting ) Data Entry Plan is active based on Participation Start & End Dates AND Location = 998, 998 reports. Otherwise, the State School Number reports from the reporting enrollment record. The number reports according to the following hierarchy.
If multiple enrollments exist, reports from the most recent start date. Numeric, 3 digits | Student Information > Special Education > General > NM Exceptionality (State Reporting ) Data Entry Plan
nmExceptionalityPlan.participationStart Date nmExceptionalityPlan.participationEndDate nmExceptionalityPlan.locationCode | ||||||||||||||||||
| 3 | School Year Date | The end year of the selected calendar(s) plus the date 06-30. For example, 2016-06-30. Date field, 10 characters YYYY-MM-DD | N/A | ||||||||||||||||||
| 4 | Student ID | Reports the state-assigned identifier for the student. Numeric, 9 digits | Census > People > Demographics > State ID | ||||||||||||||||||
| Filler 5 - 8 | N\A | N\A | |||||||||||||||||||
| 9 | Middle Initial | The student's middle initial. Alphanumeric, 1 character | Census > People > Demographics > Person Information > Middle Name Person.middleName | ||||||||||||||||||
| 10 | Current Grade Level | The student's mapped State Grade Level based on their enrollment grade level. Alphanumeric, 2 characters | Student Information > General > Enrollment > General Enrollment Information > Grade System Administration > Calendar > Grade Levels > Grade Level Editor > Grade Level Detail > State Grade Level Code Enrollment.grade StateGradeLevelDefinition.stateGradeLevelCode | ||||||||||||||||||
| Filler 11 - 13 | N\A | N\A | |||||||||||||||||||
| 14 | Birth date | The student's birth date. Date field, 10 characters YYYY-MM-DD | Census > People > Identities > Identity Information > Birth Date Identity.birthdate | ||||||||||||||||||
| 15 | Birth Gender Code | The gender of the student. Valid Values
Alphanumeric, 1 character | Census > People > Demographics > Gender Identity.gender | ||||||||||||||||||
| 16 | Address 1 | Line 1 of the student's primary home address. Alphanumeric, 30 characters | Household > Address > Primary Address Number, Prefix, Street, Tag Address.number Address.prefix Address.street Address.tag | ||||||||||||||||||
| 17 | Address 2 | Line 2 of the student's primary home address. Alphanumeric, 30 characters | Household > Address > Primary Address Apt, Unit number Address.apt Address.unit | ||||||||||||||||||
| 18 | City | The city name of the student's address. Alphanumeric, 25 characters | Household > Address > City Address.city | ||||||||||||||||||
| 19 | State Code | The state name of the student's address. Alphanumeric, 2 characters | Household > Address > State Address.state | ||||||||||||||||||
| Filler 20 - 21 | N\A | N\A | |||||||||||||||||||
| 22 | Primary Guardian Name | The guardian name linked to the student's record through the Relationships tool (Census > People > Relationships > Guardian). If a student is an unaccompanied youth or an emancipated youth, the guardian name is Self. Campus considers guardians in the student's primary household first. If multiple guardians are found in the student's primary household, then the person with the lowest person ID reports. If there isn't a guardian in their primary household, the guardian with the lowest personID in the secondary household reports; otherwise, the guardian with the lowest personID that has a relationship with the student reports. Alphanumeric, 40 characters | Census > People > Identity > Person Information > First Name Census > People > Identity > Person Information > Last Name Identity.firstName Identity.lastName | ||||||||||||||||||
| Filler 23 | N\A | N\A | |||||||||||||||||||
| 24 | Guardian Daytime Phone | The guardian phone number linked to the student's record through the Relationships tool (Census > People > Relationships > Guardian). Guardian's mobile number reports first if populated. Otherwise, the guardian's home number reports. In the absence of a guardian phone number, the student's household number reports. If mobile/daytime number is NULL, then report (000)000-0000. If a student is an unaccompanied youth or an emancipated youth, the guardian daytime phone reports as the student's. Campus considers guardians in the student's primary household first. If multiple guardians are found in the student's primary household, then the person with the lowest person ID reports. If there isn't a guardian in their primary household, the guardian with the lowest personID in the secondary household reports; otherwise, the guardian with the lowest personID that has a relationship with the student reports. If the student is a member of more than one household, the guardian's daytime phone of the most recent household reports. | Census > People > Identity > Person Information > Cell Phone Census > Households > Household Info > Phone Number | ||||||||||||||||||
| 25 | Unaccompanied Youth | Identifies a student who fits the McKinney-Vento definition of homeless and who is without a parent or guardian to advocate for them and exercise parental rights. Campus first looks looks for an active Homeless record.
Alphanumeric, 1 character | Student Info > Program Participation > Homeless > Homeless Detail
Homeless.primaryNightTimeResidence Homeless.unaccompaniedYouth | ||||||||||||||||||
| Filler 26 | N\A | N\A | |||||||||||||||||||
| 27 | Ethnic Code Short | The student's race/ethnicity. Valid Values
Alphanumeric, 1 character | Census > People > Identities > Identity Information > Race/Ethnicity > Race Ethnicity Identity.raceEthnicity | ||||||||||||||||||
| Filler 28 - 32 | N\A | N\A | |||||||||||||||||||
| 33 | Food Program Participation Code | Identifies whether the student participates in the National School Lunch Program (NSLP). Valid Values
Alphanumeric, 1 character | FRAM > Eligibility FreeReducedVerificationStatus.status | ||||||||||||||||||
| Filler 34 - 37 | N\A | N\A | |||||||||||||||||||
| 38 | Special Education | Indicates whether the student has a current IEP and is receiving services under IDEA 618, Part B. Reports from the active NM Exceptionality (State Reporting) Data Entry Plan. If the Primary Area of Exceptionality is 1, 2, or 4, Y reports. Otherwise, this element reports N. Valid Values
Alphanumeric, 1 character | Student Information > Special Education > General > NM Exceptionality (State Reporting ) Data Entry Plan
nmExceptionalityPlan.participationStartDate nmExceptionalityPlan.participationEndDate nmExceptionalityPlan.primaryAreaExceptionality | ||||||||||||||||||
| Filler 39 | N\A | N\A | |||||||||||||||||||
| 40 | Level Of Integration | The level of special services provided to the student. Reports the value selected in SPED Service Level on the active NM Exceptionality (State Reporting) Data Entry Plan.
Otherwise, this element reports blank. Numeric, 1 digit | Student Information > Special Education > General > NM Exceptionality (State Reporting ) Data Entry Plan
nmExceptionalityPlan. nmExceptionalityPlan. nmExceptionalityPlan. | ||||||||||||||||||
| Filler 41 - 45 | N\A | N\A | |||||||||||||||||||
| 46 | Repeating Last Year | Indicates whether the student was retained or failed to be promoted following the completion of the past school year. If the Repeating Last Year checkbox is marked, Y reports, Otherwise, this element reports N. Alphanumeric, 1 character | Student Information > General > Enrollment > Repeating Last Year Enrollment.repeatingLastYe | ||||||||||||||||||
| Filler 47 - 65 | N\A | N\A | |||||||||||||||||||
| 66 | Planned Post Graduate Activity Filler 66 | Student Template Only Reports the student's post grad plans. This element reports the code from the Post Grad Plans drop down field for the student when the student's primary enrollment End Date and the student's Diploma Date occur during the reporting range (or the selected date when the Submission Schedule is Open Yr Round) and the student's enrollment end status is WG (Graduated) or the student's Diploma Type is not null AND the student special ed field 38 is Y. Otherwise, this element reports blank. | Student Info> General> Graduation > Post Grad Plans Graduation.postGradPlans | ||||||||||||||||||
| 67 | Student Status Filler 67 | Student Template Only Indicates whether the student graduated. This element reports G when the student's primary enrollment End Date and the student's Diploma Date occur during the reporting range (or the selected date when the Submission Schedule is Open Yr Round) and either the student's enrollment end status is WG (Graduated) or the student's Diploma Type is not null. Otherwise, this element reports blank. Alphanumeric, 1 character | Student Information > General > Graduation > Diploma Type; Diploma Date Graduation.diplomaType Graduation.diplomaDate | ||||||||||||||||||
| 68 | Last Status Date Filler 68 | Student Template Only The student's actual graduation date. This field only reports if the Student Status field is reporting G. When the Submission Schedule is Open Yr Round, the student's enrollment of record end date AND graduation diploma date must be the date selected on the extract editor to report. Date field, 10 characters YYYY-MM-DD | Student Information > General > Graduation > Diploma Date Graduation.diplomaDate | ||||||||||||||||||
| Filler 69 | N\A | N\A | |||||||||||||||||||
| 70 | Plan 504 Indicator | Indicates whether the student qualifies as an individual with disabilities under Section 504 of the Rehabilitation Act. If this checkbox is marked, this element reports Y. Otherwise, this element reports N. Alphanumeric, 1 character | Student Information > General > Enrollment > State Reporting Fields > Plan 504 Indicator Enrollment.section504 | ||||||||||||||||||
| Filler 71 - 72 | N\A | N\A | |||||||||||||||||||
| 73 | Foreign Exchange Student | Identifies whether the student is a foreign exchange student. If the Foreign Exchange Student checkbox is marked, this element reports Y. Otherwise, this element reports N. | Student Information > General > Enrollments > State Reporting Fields > Foreign Exchange Student Enrollment.foreignExchangeStudent | ||||||||||||||||||
| Filler 74 - 79 | N\A | N\A | |||||||||||||||||||
| 80 | Gifted Participation Code | Identifies whether the student is gifted. Y reports if the student has an active NM Exceptionality (state reporting) Data Entry Plan where the Primary Area of Exceptionality is 3 (gifted only). Otherwise, N reports. Alphanumeric, 1 character | Student Information > Special Education > General > NM Exceptionality (State Reporting) Data Entry Plan
nmExceptionalityPlan. nmExceptionalityPlan. nmExceptionalityPlan. | ||||||||||||||||||
| Filler 81 - 82 | N\A | N\A | |||||||||||||||||||
| 83 | Snapshot Date Filler 83 | Student Snapshot Only The logical reporting date. This element reports the year plus a specific value for the selected Submission Schedule. YYYY represents the year in which the logical reporting date falls. School years run from 07/01 to 6/30. Valid Values
Examples
Date field, 10 characters YYYY-MM-DD | N/A | ||||||||||||||||||
| Filler 84 - 87 | N\A | N\A | |||||||||||||||||||
| 88 | Direct Certification Status Code | Identifies whether the student has been Directly Certified as eligible for free meals. Valid Values
Numeric, 1 digit | FRAM > Eligibility > Direct Certified Type POSEligibility.directType | ||||||||||||||||||
| Filler 89 - 90 | N\A | N\A | |||||||||||||||||||
| 91 | Diploma Type Code Filler 91 | Student Snapshot Only The student's Diploma Type. This field only reports if the Student Status field is reporting G. When the Submission Schedule is Open Yr Round, the student's enrollment of record end date AND graduation diploma date must be the date selected on the extract editor to report. Valid Values
Numeric, 1 digit | Student Information > General > Graduation > Diploma Type Graduation.diplomaType | ||||||||||||||||||
| Filler 92 | N\A | N\A | |||||||||||||||||||
| 93 | Alternate Student ID | The student's local student number. Numeric, 25 digits | Census > People > Demographics > Person Identifiers > Student Number Person.studentNumber | ||||||||||||||||||
| Filler 94 -96 | N\A | N\A | |||||||||||||||||||
| 97 | Grade 9 Entry Date | The date the student entered the 9th grade. If the Date First Entered the 9th Grade is empty, this element reports blank. Date field, 10 characters YYYY-MM-DD | Student Information > General > Graduation > Date First Entered the 9th Grade Graduation.grade9Date | ||||||||||||||||||
| Filler 98 - 102 | N\A | N\A | |||||||||||||||||||
| 103 | Family Identifier | This field reports blank. | N/A | ||||||||||||||||||
| Filler 104 - 106 | N\A | N\A | |||||||||||||||||||
| 107 | Alternate Guardian Name | The guardian name linked to the student's record through the Relationships tab (Census > People > Relationships > Guardian) if the student has more than one guardian. The guardian with the lowest person ID reports. The guardian with the lowest person ID that is NOT reported in field 22 reports. Campus considers guardians in the student's primary household first. If multiple guardians are found in the student's primary household, then the person with the lowest person ID reports. If there isn't a guardian in their primary household, the guardian with the lowest personID in the secondary household reports; otherwise, the guardian with the lowest personID that has a relationship with the student reports. Alphanumeric, 40 characters | Census > People > Identity > Person Information > First Name Census > People > Identity > Person Information > Last Name Identity.firstName Identity.lastName | ||||||||||||||||||
| Filler 108 - 110 | N\A | N\A | |||||||||||||||||||
| 111 | Homeless | Indicates whether the student is homeless and was served under McKinney Vento. Campus looks for an active Homeless program participation. If one is found, Y reports. Otherwise N reports.
Alphanumeric, 3 characters | Student Information > Program Participation > Homeless > Homeless Detail:
Homeless.homelessServed Homeless.primaryNightTimeResidence Homeless.startDate Homeless.endDate | ||||||||||||||||||
| Filler 112 | N\A | N\A | |||||||||||||||||||
| 113 | English Proficiency Code | Identifies whether a current ELL students or former English Language Learner (ELL) students has been re-classified as Fluent English Proficient. Exited Status is determined by the Extract AND Submission schedule.
Otherwise, this field reports blank. Alphanumeric, 2 characters | Student Information > Program Participation > English Learners (EL) > EL > Active EL Record
lep.programStatus lep.identifiedDate lep.exitDate | ||||||||||||||||||
| 114 | Race Or Ethnicity Subgroup Code | The primary Tribe or Pueblo with which the student is affiliated. See the following Tribal Codes for more information. If the Tribe field is null and a Default Value is set on the data dictionary, the default value reports. If the field is Null and no Default Value exists, the field reports null. Numeric, 2 digits | Census> People > Demographics > Tribal Identity.tribe | ||||||||||||||||||
| Filler 115 - 119 | N\A | N\A | |||||||||||||||||||
| 120 | Parental Status Code | Indicates the parental status of the student. Valid Values
Alphanumeric, 2 character | Student Information > General > Enrollments > State Reporting Fields > Parental Status Enrollment.parentalStatus | ||||||||||||||||||
| 121 | Student Is Expecting | Indicates whether the student is pregnant. If the Student Expecting checkbox is marked, this element reports Y. Otherwise, this element reports N. Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Student Expecting Enrollment.studentExpecting | ||||||||||||||||||
| Filler 122 | N\A | N\A | |||||||||||||||||||
| 123 | Home Language Code | Report the language spoken in the student's home. If no language is selected, this element reports 00. Numeric, 4 digits | Census > People > Demographics > Home Primary Language Identity.home PrimaryLanguage | ||||||||||||||||||
| Filler 124 | N\A | N\A | |||||||||||||||||||
| 125 | Years In US Schools | Indicates whether the student has been enrolled in U.S. schools for three consecutive years without dropping out. Reports the code selected in the Years in US Schools field. If that field is empty, the default value set in the attribute dictionary reports. Numeric, 1 digit | Census > People > Demographics > Person Information > Years in US Schools Identity.schoolingUS | ||||||||||||||||||
| Filler 126 - 130 | N\A | N\A | |||||||||||||||||||
| 131 | Food Program Eligibility | The student's eligibility for free or reduced meals. Valid Values
Alphanumeric, 1 character | FRAM > Eligibility POSEligibility.eligibility | ||||||||||||||||||
| Filler 132 | N\A | N\A | |||||||||||||||||||
| 133 | Last Name Long | The student's last name. Alphanumeric, 60 characters | Census > People > Identities > Identity Information > Last Name Identity.lastName | ||||||||||||||||||
| 134 | First Name Long | The student's first name. Alphanumeric, 60 characters | Census > People > Identities > Identity Information > First Name Identity.firstName | ||||||||||||||||||
| Filler 135 - 143 | N\A | N\A | |||||||||||||||||||
| 144 | Hispanic Ethnicity Indicator | Indicates whether the student identifies with an ethnicity of Hispanic/Latino. The element reports Yes or No. Alphanumeric, 1 character | Census > People > Identities > Person Information > Race/Ethnicity > Is the individual Hispanic/Latino? Identity.raceEthnicity | ||||||||||||||||||
| Filler 145 | N\A | N\A | |||||||||||||||||||
146 147 148 149 | Race 2 Code Race 3 Code Race 4 Code Race 5 Code | If the student has additional race/ethnicity selections, the value(s) report in these elements. Otherwise, these elements report blank. Valid Values
Alphanumeric, 4 characters | Census > People > Demographics > Person Information > Race/Ethnicity > Federal Race Ethnicity
Identity.federalRaces fedRace.americanIndian fedRace.asian fedRace.blackOrAfricanAmerican fedRace.pacificIslander fedRace.white | ||||||||||||||||||
| 150 | Federal Form 506 Indicator | Indicates whether the student has a verified Federal Form 506 or Census Number on file. If the FF 506 checkbox is marked, this element reports Y. Otherwise, this element reports N. Alphanumeric, 1 character | Census > People > Demographics > FF 506 Identity.ff506 | ||||||||||||||||||
| Filler 151 | N\A | N\A | |||||||||||||||||||
| 152 | Immigrant Indicator | Indicates whether the student is identified as an immigrant. If the Immigrant checkbox is marked, this element reports Y. Otherwise, this element reports N. Alphanumeric, 1 character | Census > People > Identities > Identity Information > Immigrant Identity.immigrant | ||||||||||||||||||
| 153 | BEP Program Language Code | Indicates the student's BEP Program Language Code. A record reports ONLY if the student has an active BEP state program record that is active on at least one date during the reporting range. If no code is selected, the default value set in the data dictionary reports. Otherwise, this field reports blank. | Student Information > Program Participation > State Programs > Bilingual Education Program (BEP) BilingualEducationProgram.language | ||||||||||||||||||
| Filler 154 | N\A | N\A | |||||||||||||||||||
| 155 | Base Zip code | The zip code from the student's address. Numeric, 5 digits | Household > Address > Zip Address.zip | ||||||||||||||||||
| Filler 156 - 165 | N\A | N\A | |||||||||||||||||||
| 166 | Displaced Homemaker | Indicates whether the student is a displaced homemaker. If the Displaced Homemaker checkbox is marked, this element reports Y. Otherwise, this element reports N. Displaced Homemaker Definition
Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Displaced Homemaker Enrollment.displacedHomemaker | ||||||||||||||||||
| 167 | Sped Referral Code | Indicates whether the special education student was referred from Part C to B or through Child Find. Valid Values
The Sped Referral Code element reports C or F based on a hierarchy when both are present. If the student has an active Event where the Event Type is 18, C reports. Only if an active 18 or 20-24 event does NOT exist, the report checks the student for an active Event where the Event Type is 30 and reports F. Otherwise, the SPED Referral Code reports null. Alphanumeric, 1 character | Student Information > Special Ed > General > Documents > Plan Outline nmGiftedPlan > Events Details
| ||||||||||||||||||
| Filler 168 - 173 | N\A | N\A | |||||||||||||||||||
| 174 | Dwelling Arrangement Code | If the student is homeless, this element identifies the student's primary residence. If the student is not homeless, this element reports blank.
Valid Values
Alphanumeric, 2 characters | Student Information > Program Participation > Homeless > Homeless Detail > Homeless Residence Homeless.primaryNightTimeResidence | ||||||||||||||||||
| Filler 175 - 187 | N\A | N\A | |||||||||||||||||||
| 188 | Home Schooled Indicator/ Filler 188 | Student Template Only Identifies home schooled students that take courses in the district. If the Home Schooled checkbox is marked, this element reports Y. Otherwise, this element reports N. Alphanumeric, 1 character | Student Information > General> Enrollments > State Reporting Fields > Home Schooled Enrollment.homeSchooled | ||||||||||||||||||
| 189 | Filler 189-191 | ||||||||||||||||||||
| 192 | Guardian Email Address | The guardian phone number linked to the student's record through the Relationships tool (Census > People > Relationships > Guardian). Reports the guardians email address if the Student Special Ed field 38 is Y. Otherwise, reports blank. If a student is an unaccompanied youth or an emancipated youth, the guardian daytime phone reports as the student's. Campus considers guardians in the student's primary household first. If multiple guardians are found in the student's primary household, then the person with the lowest person ID reports. If there isn't a guardian in their primary household, the guardian with the lowest personID in the secondary household reports; otherwise, the guardian with the lowest personID that has a relationship with the student reports. | Census > Demographics > Personal Contact Information > Email | ||||||||||||||||||
| Filler 189 - 206 | N\A | N\A | |||||||||||||||||||
| 207 | Military Family Code | The military status of the student's family. If a Military Family Code is not selected, this element reports blank. Valid Values
Alphanumeric, 1 character | Student Information > General > Enrollment > State Reporting Fields > Military Family Code Enrollment.militaryFamily | ||||||||||||||||||
| Filler208-224 | N/A | N/A | |||||||||||||||||||
| 225 | Gender Identity | Student Reports the gender value from the Identity record that is active on the date selected if the value is different than the birth gender. Stud_Snapshot or Student Reports the gender value from the Identity record that is active on the date selected. Valid Values:
| Census > People > Identities > Identity Information > Protected Identity > Gender Identity Census > People > Identities > Identity Information > Gender Identity.gender |
Tribal Codes
| Code | Description |
|---|---|
| 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 |
| 15 | Sandia |
| 16 | Santa Ana |
| 17 | Santa Clara |
| 18 | Kewa |
| 19 | Taos |
| 20 | Tesuque |
| 21 | Zia |
| 22 | Zuni |
| 23 | Other |
