Tool Search: NJSLEDS Import
The SLEDS State ID Import allows districts to import state IDs from the NJSLEDS SID Management file. The import matches the student number in the import file, and produces a file of unknown records and errors.
NJSLEDS Import ToolImport Logic
Records are matched on the local student ID. Identity information (last name, first name, and birth date) is verified against 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. Alternatively, users can choose to overwrite existing State IDs in Campus with the IDs 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 you want to upload. 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 for later, reducing 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.
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 whether 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 |
