Tool Search: SMART Import
The SMART Import allows districts to import state IDs from the SMART SID Management file. The import matches the student number in the import file and produces a file of unknown records and errors.
SMART Import Editor
Import Logic
Records are matched on the local student ID. Identity information (last name, first name, birth date) is checked with the local ID. If there are multiple matching identities, it is considered a found match.
If the State ID field is blank in Campus, running the import populates that field with the value located in the imported file. Or, users can elect to overwrite existing State IDs in Campus with the ID in the file.
Running the Import File
- Determine if existing state IDs should be overwritten with different state IDs. If yes, mark the Overwrite State ID checkbox.
- Click the Browse button to locate the file that should be uploaded. When found, click the Open button on the File Upload window. The file being uploaded should be in CSV format.
- Click the Upload button when ready.
If files are particularly large, click the Submit to Batch button to save the uploading process until after hours to reduce the tax on Campus servers. See the Batch Queue article for more information.
When the import is complete, an Import Results Summary displays, listing what has been imported.
SMART Import Results Summary
Import File Layout
The import file may have more columns than those fields marked as required. If that is the case, the additional columns will be ignored and NOT imported. This layout matches the layout of the SID Management Extract.
Element Name | Description | Location |
|---|---|---|
Local Identification Number Required | The number assigned and maintained by the local school district that is unique for each student. Numeric, 6 digits | Census > People > Demographics > Student Number Person.studentNumber |
State Identification Number Required | The number assigned and maintained by the New Jersey Department of Education that is unique for each student. Numeric, 10 digits | Census > People > Demographics > State ID Person.stateID |
First Name Required | The legal first name of the student. Alphanumeric, 35 characters | Census > People > Demographics > First Name Identity.firstName |
Middle Name Required | The legal middle name of the student. Alphanumeric, 30 characters | Census > People > Demographics > Middle Name Identity.middleName |
Last Name Required | The legal last name of the student. Alphanumeric, 40 characters | Census > People > Demographics > Last Name Identity.lastName |
Suffix Required | The suffix attached to the student's name, such as Jr or III. Alphanumeric, 50 characters | Census > People > Demographics > Suffix Identity.suffix |
Gender Required | The gender of the student. Alphanumeric, 1 character (M or F) | Census > People > Demographics > Gender Identity. gender |
Date of Birth Required | The date of birth of the student. Date field, 8 digits (YYYYMMDD) | Census > People > Demographics > Birthdate Identity.birthdate |
City of Birth | The name of the city in which the student was born. Alphanumeric, 30 characters | Census > People > Demographics > City of Birth Identity.birthCity |
State of Birth | The abbreviation of the state in which the student was born. Alphanumeric, 2 characters | Census > People > Demographics > State of Birth Identity.birthState |
Country of Birth | The code representing the country in which the student was born. Alphanumeric, 4 characters | Census > People > Demographics > Country of Birth Identity.birthCountry |
Ethnicity | Indicates whether the student is considered to be Hispanic/Latino Alphanumeric, 1 character (Y or N) | Census > People > Demographics > Is this person Hispanic/Latino? Identity. hispanicEthnicity |
American Indian Race | Indicates if the student's race/ethnicity is American Indian or Alaska Native. Alphanumeric, 1 character (Y or N) | Census > People > Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
Asian Race | Indicates if the student's race/ethnicity is Asian. Alphanumeric, 1 character (Y or N) | Census > People > Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
Black Race | Indicates if the student's race/ethnicity is Black or African American. Alphanumeric, 1 character (Y or N) | Census > People > Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
Pacific Race | Indicates if the student's race/ethnicity is Native Hawaiian or Other Pacific Islander. Alphanumeric, 1 character (Y or N) | Census > People > Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
White Race | Indicates if the student's race/ethnicity is White. Alphanumeric, 1 character (Y or N) | Census > People > Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
Status | The student's current enrollment status as of the snapshot date. Options are A: Active and I: Inactive. Alphanumeric, 1 character (A or I) | Student Information > General > Enrollments > Start Date/End Date Enrollment.startDate |
Enrollment Type | Percentage of the school day a student is in attendance at the school listed as the Attending School. Alphanumeric, 1 character (F or S) | Student Information > General > Enrollments > State Reporting Fields > Shared Time EnrollmentNJ.sharedTime |
Resident County | The New Jersey county in which the student resides. Alphanumeric, 2 characters | Student Information > General > Enrollments > State Reporting Fields > Resident County EnrollmentNJ.residentCounty |
Resident District | The district in which the student resides. If no selection is made, the default value reports. Alphanumeric, 4 characters | Student Information > General > Enrollments > State Reporting Fields > Resident District EnrollmentNJ.residentDistrict |
Resident School | The unique school code the student would attend based on the permanent or other home address. Alphanumeric, 3 characters | Student Information > General > Enrollments > State Reporting Fields > Resident School EnrollmentNJ.residentSchool |
District Entry Date | The date on which the student enrolled in the district. Date field, 8 digits (YYYYMMDD) | Student Information > General > Enrollments > State Reporting Fields > District Entry Date Enrollment.districtEntryDate |
County Code Receiving | The code of the county in which the student is received in a sending/receiving relationship. Alphanumeric, 2 characters | Student Information > General > Enrollments > State Reporting Fields > Receiving County EnrollmentNJ.receivingCounty |
District Code Receiving | The code of the receiving district of the student in a sending/receiving relationship. If no value is selected, the default value reports. Alphanumeric, 4 characters | Student Information > General > Enrollments > State Reporting Fields > Receiving District EnrollmentNJ.receivingDistrict |
School Code Receiving | The code of the receiving school of the student in a sending/receiving relationship. Alphanumeric, 3 characters | Student Information > General > Enrollments > State Reporting Fields > Receiving School EnrollmentNJ.receivingSchool |
Attending County | The code of the county in which the student is attending school. Alphanumeric, 2 characters | Student Information > General > Enrollments > State Reporting Fields > Attending County EnrollmentNJ.attendingCounty |
Attending District | The code of the district in which the student is attending school. If no value is selected, the default value reports. Alphanumeric, 4 characters | Student Information > General > Enrollments > State Reporting Fields > Attending District EnrollmentNJ.attendingDistrict |
Attending School | The code of the school the student is attending. Alphanumeric, 3 characters | Student Information > General > Enrollments > State Reporting Fields > Attending School EnrollmentNJ.attendingSchool |
School Entry Date | The date on which the student enrolled in the attending school. Date field, 8 digits (YYYYMMDD) | Student Information > General > Enrollments > State Reporting Fields > School Entry Date Enrollment.schoolEntryDate |
School Exit Date | The date of the first day after the date of a student's last attendance at a school. Date field, 8 digits (YYYYMMDD) | Student Information > General > Enrollments > End Date Enrollment.endDate |
Withdrawal Code | The type of exit/withdrawal of a student from a school. Reports if the student's Exit Date is within the reporting period. Alphanumeric, 3 characters | Student Information > General > Enrollments > End Status Enrollment.endStatus |
Cumulative Days in Membership | The number of school days in session that have occurred between the enrollment Start Date and the enrollment End Date. When a student ends enrollment and re-enrolls at a later date, this field calculates days in membership from all enrollment records in the selected calendar. Numeric, 5 characters | Not stored, calculated value |
Cumulative Days Present | The number of days an individual is present when school is in session during a given reporting period. When a student ends enrollment and re-enrolls at a later date, this field calculates days present from all enrollment records in the selected calendar. Numeric, 5 characters | Not stored, calculated value |
Cumulative Days Towards Truancy | The number of school days an individual is absent and falls under the Local Education Agency definition of truant. When a student ends enrollment and re-enrolls at a later date, this field calculates days towards truancy from all enrollment records in the selected calendar. Numeric, 5 characters | Not stored, calculated value |
Year of Graduation | The projected year of the student's high school graduation. Date field, 4 digits (YYYY) | Student Information > General > Graduation > State Reporting Graduation Fields > Projected Graduation Year Graduation.gradYear |
Tuition Code | The indicator of the source of payment for a non-resident student. Numeric, 2 digits | Student Information > General > Enrollments > State Reporting Fields > Tuition Code EnrollmentNJ.tuitionCode |
Free/Reduced Rate Lunch Status | Indicates if the student is enrolled in the national school lunch program. Alphanumeric, 1 character (Y or N) | Student Information > General > Enrollments > State Reporting Fields > Free/Reduced Meal Status Enrollment.mealStatus |
Grade Level | The grade level of the student's enrollment Alphanumeric, 2 characters | Student Information > General > Enrollments > Grade Enrollment.grade |
Program Type Code | The primary program of instruction for the student. Alphanumeric, 2 characters | Student Information > General > Enrollments > State Reporting Fields > Program Type EnrollmentNJ.programType |
Retained | Indicates if the student is repeating the current grade level. Alphanumeric, 1 character (Y or N) | Student Information > General > Enrollments > District Defined Elements > Retained Enrollment.retained |
Special Education Classification | The outcome of an eligibility assessment for special education and related services. This field reports a null value unless a primary disability code is selected. Numeric, 2 digits | Student Information > General > Enrollments > Special Ed Fields > Primary Disability Enrollment.disability |
LEP Program Start Date | The date on which the student began participation in a Limited English Proficient program. Date field, 8 digits (YYYYMMDD) | Student Information > General > Enrollments > LEP Reporting Fields > LEP Entry Date EnrollmentNJ.lepEntryDate |
LEP Program Completion Date | The date on which the student successfully completed a Limited English Proficient program. Date field, 8 digits (YYYYMMDD) | Student Information > General > Enrollments > LEP Reporting Fields > LEP Exit Date EnrollmentNJ.lepExitDate |
NonPublic | Indicates the student has been parentally placed into a private school and receives services under an individual services plan. Alphanumeric, 1 character (Y or blank) | Student Information > General > Enrollments > Special Education Fields > NonPublic EnrollmentNJ.nonPublic |
