Tool Search: SMART Extracts
The SMART State Submission gathers basic enrollment information for submission to the state. The report is sorted alphabetically by student's last names.
Report Logic
If the Reporting Period Start Date and End Date are the same (Snapshot Date), students have an active Enrollment on the Snapshot Date report. If the Enrollment End Date is before the Snapshot Date, the student data is not reported.
If the Reporting Period Start Date and Ending Date are different, the students who have at least one active day of enrollment on or between them report.
Report Editor
Field | Description |
|---|---|
Extract Type | Selection determines which extract generates. |
Reporting Period Start Date | Entered date determines the time frame of the extract, reporting only that student data as of that date. Dates are entered in mmddyy format or can be chosen by using the calendar icon. |
Reporting Period End Date | Entered date determines the time frame of the extract, reporting only that student data as of that date. Dates are entered in mmddyy format or can be chosen by using the calendar icon. The end date field is auto-populated with the current date. |
Students without state IDs | When marked, students who have not been assigned a state ID will be returned, along with those who do have a state ID. |
| Use Enrollment Programs | Program participation records are reported when the checkbox is NOT selected (the default). When the checkbox is marked, program fields on the enrollment record are considered. |
| State Exclude | Drop list options include:
|
Ad hoc Filter | When selected, only those students in the filter will be included on the selected SMART extract. |
Format | SMART Extracts generate in either HTML format or in CSV format (state format). |
Calendar Selection | Selection indicates from where the data is pulled. |
| Report Generation | Use the Generate Extract button to display the results of the extract immediately. If more than one calendar is selected, or the selection of data s larger than anticipated, use the Submit to Batch button to determine when the extract should be generated. |
Generate the SMART State Submission Extract
- Select SMART State Submission from the Extract Type dropdown list.
- Enter a Reporting Period Start Date.
- Enter a Reporting Period End Date.
- Mark the Student w/o stateIDs if those students should not appear in the report.
- Indicate the Format in which in which the report should generate.
- Click the Generate Extract button o generate the report in the desired format. Or, use the Submit to Batch button (if applicable) to choose when the extract generates.
SMART State Submission - State Format
SMART State Submission - HTML
SMART State Submission Extract Layout
Element Name | Description | Location |
|---|---|---|
Local Identification Number | The number assigned and maintained by the local school district that is unique for each student. Numeric, 20 digits | Census > People > Demographics > Student Number Person.studentNumber |
State Identification Number | The number assigned and maintained by the New Jersey Department of Education that is unique for each student. Numeric, 20 digits | Census > People > Demographics > State ID Person.stateID |
First Name | The legal first name of the student. Alphanumeric, 30 characters | Census > People > Demographics > First Name Person.firstName |
Last Name | The legal last name of the student. Alphanumeric, 50 characters | Census > People > Demographics > Last Name Person.lastName |
Date of Birth | The date of birth of the student. Date field, 8 digits (YYYYMMDD) | Census > People > Demographics > Birthdate Identity.birthdate |
City of Residence | The name of the city in which the student lives. If there is more than one primary city of residence, the most current city by start date reports. Any secondary city of residence does not report. Alphanumeric, 30 characters | Census > Address > City Address.city |
Migrant Status | Indicates if the student is eligible for migrant education services. Alphabetic, 1 character (Y or N) | Student Information > General > Enrollments > State Reporting Fields > Migrant Enrollment.migrant |
Eighth Technological Literacy | Indicates whether the student has met the eighth grade criteria of technological proficiency. Alphanumeric, 2 characters | Student Information > General > Enrollments > State Reporting Fields > 8 Tech Literacy EnrollmentNJ.8TechLiteracy |
Health Insurance Status | Indicates whether the student has health insurance coverage. Alphabetic, 1 character (Y or N) | Student Information > General > Enrollments > State Reporting Fields > Health Coverage EnrollmentNJ.healthCoverage |
Health Insurance Provider | The name of the heath insurance provider of the student. Alphanumeric, 50 characters | Student Information > General > Enrollments > State Reporting Fields > Health Insurance Provider EnrollmentNJ.healthInsurance Provider |
Home Language | The primary language or dialect that students use to communicate at home. Alphanumeric, 3 characters | Census > People > Identities > Home Primary Language Identity.homePrimaryLanguage |
Immigrant Status | Selection indicates student meets the Federal definition of being an immigrant:
Reports based on the Yes, No or no selection on the State Reporting Enrollment Editor field. Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > Immigrant Enrollment.immigrant |
First Entry Date into US School | Date the student first received schooling at a school in the United States. Reports the date associated with the student's Date Entered US School if the student's Birth Country is any selection other than 2330: United States or 1790: Puerto Rico. Reports a blank value if Birth Country is the United States or Puerto Rico. Date field, 8 characters (YYYYMMDD) | Census > People > Demographics > Date Entered US School Census > Person Information > Birth Country Identity.dateEnteredSchool |
Homeless | An indication that the student lacks a fixed, regular and adequate residence.
Homeless can be Yes at anytime during the reporting period start and end dates. Alphabetic, 2 characters | Student Information > Program Participation > Homeless Homeless.unaccompaniedYouth |
Homeless Primary Nighttime Residence | Indication of the nighttime residence of homeless students. Reports the selected value when the student has a homeless status of Yes at anytime during the reporting period start and end dates. Alphanumeric, 1 character | Student Information > Program Participation > Homeless > Primary Night Time Residence Homeless.primaryNightTime Resdence |
Alternative Education Program | Indication that the student is enrolled in an alternative education program. Alphabetic, 1 character (Y or N) | Student Information > General > Enrollments > State Reporting Fields > ASSA Reporting Fields > Alternative Program EnrollmentNJ.ASSAprogram |
Title 1 Science | Indicates the student is receiving Targeted Assistance in Science programming. Alphabetic, 1 character (Y or N) | Student Information > General > Enrollments > State Reporting Fields > Title 1 Science EnrollmentNJ.title1Science |
Title 1 Math | Indicates the student is receiving Targeted Assistance in Math programming. Alphabetic, 1 character (Y or N) | Student Information > General > Enrollments > State Reporting Fields > Title 1 Math EnrollmentNJ.title1Match |
Title 1 Language | Indicates the student is receiving Targeted Assistance in Language programming. Alphabetic, 1 character (Y or N) | Student Information > General > Enrollments >State Reporting Fields > Title 1 Language Arts EnrollmentNJ.title1Language |
