PATH: SD State Reporting > Upload Wizard
Search Term: Upload Wizard
Districts that do not use the Infinite Campus District Edition to manage their district data can use the State Edition Upload tool to upload files containing their district's student information to the State System. Files uploaded with the tool must conform to the File Specifications noted in the following information.
Image 1: South Dakota Upload Wizard
To use the tool, users must have tool rights to Upload Wizard tool. Users must have their user account set to the district that they are trying to upload into or must have state-wide district rights.
Prior to uploading a file, a calendar for the current year and all required grade levels for that calendar must be setup within the SD State Edition user interface. If this is not done, an error message will be displayed when an upload is attempted.
Additionally, the upload tool assumes that a School/Year has only one calendar and one schedule structure defined within the State Edition. If multiple calendars or schedule structures are created for that school/year, an error will display when an upload is attempted.
Understanding the Upload Wizard
The Upload Wizard provides three actions that can be selected:
Action | Description |
---|---|
Validate and Test | In this mode the file will be uploaded and all data validation will be performed to ensure that the file conforms to the file specifications section. Additionally, a search will be performed on the District, School and Student Number to make sure the named District, School and Students actually exist. No data will change as a result of this action. A report will be generated listing errors and their corresponding line numbers and fields of error. |
Load Partial | This mode will insert or update data for each record from the file that has no errors. If a row has an error, it will be displayed in the report generated after the upload completes. |
Load Complete | In addition to Validating and Testing, the Load Complete mode will erase all student data from calendars named in the upload file. After that, the records in the file are inserted as new enrollments. This mode should be used if a complete refresh of the data is required. It should not be used if any data has been manually edited through the user interface as that data will be lost. This will remove all existing data. |
Uploading Files
- Select the appropriate action as defined above in the Work to Perform dropdown list.
- Locate the file to upload by selecting the Browse button in the File field. Follow the instructions for uploading and click the Upload button.
- Or, select a file from the Result File dropdown and click the Load button.
The file will be processed and a verification of the upload will be returned.
Image 2: Upload Confirmation
Not all fields are automatically overwritten at the state level. When Homeless, First Year in Country, Parent Does not want Meal Status shared with DSS, Meal Status or any type of Title 1 fields are not null at the state level but no or null at the district level, a message will appear when a status change is attempted indicating that a status that is not No or Null exists and should not be overwritten.
The Enrollment Upload will create split fields with the date of the Enrollment Report Upload for Meal Status (if the status is changed from F or R to Standard) and any Title 1 status (if changed from Yes to No), with a warning message indicating that the student record was successfully imported and a new record was created.
File Specifications
Files should follow the proper naming conventions and record definitions defined below:
- All files will be tab delimited with a header record.
- If a field is not required it can be left blank, but the proper number of tabs must be in each record.
- All dates within the file will be in the format MM/DD/YYYY.
- Times within the file will be displayed in military (24 hour) time HH:MM:SS such as 23:00:00 for 11:00pm.
File Name
Files must be named with the district number (maximum of 5 digits), underscore, date underscore and record type with the extension *.tsv. Forward slashes are not allowed in file names and should be left out.
Example:
District 10063 submitting a Student Demographics file on 12/01/2006 would name the file: 10063_12012006_SD.tsv
Header Record
The first line of all files will be the header record. This is required.
Name | Length | Code/Format | Description |
---|---|---|---|
Record Type | 2 | “HD” | Always the value “HD” |
Date | 01 | MM/DD/YYYY | Date report was generated |
Time | 8 | HH:MM:SS | Time report was generated |
Version | 15 | “SD2.0” | Always the value “SD2.0” |
Example Record:
Header record submitted on December 1, 2006 at 11:00 pm:
HD 12/01/2006 23:00:00SD2.0
School Calendar Upload Specifications
This record defines each School Calendar or track a school is running. There should be at least 1 record per school. There can be multiple records per school if the school has students receiving instruction on different days or for different durations.If the school has multiple calendars, each calendar must be given a distinct Calendar Number.
Element Name | Description | Type, Format and Length | Campus UI and Database Location |
Record Type | Type of record being generated. | Alphabetic, 2 characters | Not dynamically stored Not dynamically stored |
District Number | State-assigned district identification number. | Numeric, 5 digits | District.number System Administration > Resources > District Information > District Number |
School Number | State-assigned school identification number. | Numeric, 2 digits | School.number System Administration > Resources > School > State School Number |
Year | The end year of the calendar (i.e. for 2006-2007 = 2007). | Date field, 4 characters | Calendar. System Administration > Calendar > Calendar > Calendar Info > End Date |
Calendar Number | Number assigned to the calendar. Needs to match calendar number in associated SD-Extract-School Calendar file. | Numeric, 3 digits | Calendar.number System Administration > Calendar > Calendar > Calendar ID |
Calendar Type | The type of calendar for which information is being reported. If the value being imported is not a valid option, a warning will appear. If data already exists but the import file does not have a value entered, the existing value will not be overwritten. | Alphanumeric, 1 character | Calendar.type System Administration > Calendar > Calendar > Type |
Student Day | The number of minutes of instruction in the typical student day. | Numeric, 3 digits | Calendar. System Administration > Calendar > Calendar |
4 Day School Week | Indicates a 4 Day School Week. | Alphanumeric, 1 character | Calendar. System Administration > Calendar > Calendar |
Virtual | If this field = Y, check the Virtual box on the import calendar. If blank or N, do not check the box. If currently checked and field is blank or N, do not uncheck box. | Alphanumeric, 1 character Y or N | Calendar.virtual System Administration > Calendar > Calendar > Virtual |
Example Records:
An elementary school (0120) grades 1 through 6 that attend 360 minutes of instruction per day and has half-day Kindergarten that attends 180 minutes of instruction per day and starts on a different date then the other grades.
SS 63 2007 1 360 Y
SS 63 120 2007 2 180 Y
School Days Upload Specifications
This record defines when a school is open and when it provides instruction to students. There should be 1 record per date per School Calendar record within the date range that the school is open.
Element Name | Description | Type, Format and Length | Campus UI and Database Location |
Record Type | Type of record being generated. In this case, always a value of "DY". | Alphabetic, 2 characters | Not dynamically stored |
District Number | State-assigned district identification number. | Numeric, 5 digits | System Administration > Resources > District Information > District Number District.number |
School Number | State assigned school identification number | Numeric, 2 digits | System Administration > Resources > District Information > State School Number School.number |
Year | The end year of the calendar (i.e. for 2006-2007 = 2007). | Date field, 4 characters | System Administration > Calendar > Calendar > Calendar Info Calendar.endYear |
Calendar Number | Number assigned to the calendar. Needs to match calendar number in associated SD-Extract-School Calendar file. | Numeric, 3 digits | System Administration > Calendar > Calendar > Number Calendar.number |
Date | A day record for each day in the calendar | Date field, 10 characters | System Administration > Calendar > calendar > Days > Date Day.date |
Instructional Day | Indicates whether instruction was given to students on this date. | Alphabetic, 2 characters | System Administration > Calendar > Calendar > Days > Instruction Day.instruction |
School Day | Indicates if the school was open on this date (i.e. teacher in-service day will have Instruction = N and School Day = Y). | Alphabetic, 2 characters | System Administration > Calendar > Calendar > Days > School Day Day.schoolDay |
Attendance Day | Indicates if there is attendance for this day. | Alphabetic, 2 characters | System Administration > Calendar > Calendar > Days > Attendance Day.attendance |
Day Duration | Number of minutes of instruction offered on this day. | Numeric, 3 digits | System Administration > Calendar > Calendar > Days > Duration Day.duration |
Example Records:
The week of April 22, 2007 to April 28, 2007 has instruction starting Monday and continuing through Thursday, with a teacher in-service day on Friday; its records would look like:
DY 63 2007 1 04/22/2007 N N N 0
DY 63 2007 1 04/23/2007 Y Y Y 360
DY 63 120 2007 1 04/24/2007 Y Y Y 360
DY 63 120 2007 1 04/25/2007Y Y Y 360
DY 63 120 2007 1 04/26/2007 Y Y Y 360
DY 63 120 2007 1 04/27/2007 N Y N 0
DY 63 120 2007 1 04/28/2007 N N N 0
Student Demographic Upload Specifications
This record format contains basic student demographics fields. Typically there should be one record per student. The exception for this is when a student’s name or identifying information changes while at a district. The state needs to maintain a history of all name changes for students, and the effective date controls when this name was used.
When a new identity is created for a person, existing information in the Person Information area of the Demographics tab is not deleted for the following fields:
- Social Security Number
- Birth Country
- Date Entered US
- Date Entered US School
- Date Entered State School
- Birth Verification
- Nickname
- Comments
Element Name | Description | Type, Format and Length | Campus UI and Database Location |
Record Type | The type of record being generated. In this case, always the value of "SD" for student demographics. | Alphabetic, 2 characters | Not dynamically stored |
District Number | State-assigned district identification number. | Numeric, 5 digits | System Administration > Resources > District Information > District Number District.number |
State ID | State identification number assigned to students. When importing in the State Edition, if the State ID does not match any person, a new person is created and a new State ID is created. The State ID in the file is not imported. When importing in the District Edition, if the State ID is null, the record is ignored and not imported. If the State ID exists in the file but does not match a person, an error message is produced and the record is not imported. | Numeric, 9 digits | Census > People > Demographics > Person Identifiers > Student State ID Person. |
Last Name | Student's legal last name | Alphanumeric, 40 characters | Census > People > Demographics > Last Name Identity.lastName |
First Name | Student's legal first name | Alphanumeric, 35 characters | Census > People > Demographics > First Name Identity.firstName |
Middle Name | Student's legal middle name. | Alphanumeric, 20 characters | Census > People > Demographics > Middle Name Identity.middleName |
Suffix | Suffix attached to student's legal name. Accepts Jr. and SR. with or without punctuation. | Alphanumeric, 3 characters | Census > People > Demographics > Suffix Identity.suffix |
Gender | Student's gender | Alphabetic, 1 cahracter | Census > People > Demographics > Gender Person.gender |
Birth Date | Student's date of birth | Date field, 10 characters | Census > People > Demographics > Birth Date Identity.birthDate |
Race Determination | Code indicating how student race was determined.
| Numeric, 2 digits | Census > People > Demographics > Race Determination Identity. |
Hispanic Indicator | Indicates if student is Hispanic/Latino. | Numeric, 1 digits | Census > People > Demographics > Race/Ethnicity > Edit > Is the individual Hispanic/Latino? Identity. |
American Indian or Alaska Native | Indicates if student is American Indian or Alaska native. | Alphanumeric, 1 digit | Census > People > Demographics > Race/Ethnicity > American Indian or Alaska Native Identity. |
Asian | Indicates if student is Asian | Alphanumeric, 1 digit | Census > People > Demographics > Race/Ethnicity > Asian Identity. |
Black or African American | Indicates if student is Black or African American | Alphanumeric, 1 digit | Census > People > Demographics > Race/Ethnicity > Black or African American Identity. |
Native Hawaiian or Other Pacific Islander | Indicates if student is Native Hawaiian or Other Pacific Islander. | Alphanumeric, 1 digit | Census > People > Demographics > Race/Ethnicity >Native Hawaiian or Other Pacific Islander Identity. |
White | Indicates if student is White | Alphanumeric, 1 digit | Census > People > Demographics > Race/Ethnicity > White Identity. |
Primary Address | The reporting student's primary home address.
| Alphanumeric, 50 characters Allow leading zeros | Census > People > Households > Address StudentContacts. address |
City | The city the student resides in.
| Alphanumeric, 20 characters | Census > People > Households > City StudentContacts.city |
State | The state the student resides in.
| Alpha, 2 characters | Census > People > Households > State StudentContacts. state |
Zip Code | The zip code the student resides in.
| Numeric, 10 digits | Census > People > Households > Zip Code StudentContacts. zip |
Example Records:
A student record for Joe Smith,
SD 63 Smith Joe Alan II M 03/01/1997 05
Common errors:
- Gender or Race/Ethnicity left blank (data is required for these fields)
- Field names included in file (please remove all field names, such as legal entity number, gender, race/ethnicity, etc.).
- Date Fields must be in a MM/DD/YYYY format (e.g. 03/07/1999).
- Fields with no information still require a tab.
Enrollment Upload Specifications
This record contains information for the student enrollment. Typically there should be one record per student enrollment. For your file name, the record type is EN.
The Enrollment Import file will not overwrite existing Homeless records.
Header Record
Name | Length | Code/Format | Description |
---|---|---|---|
Record Type | 2 | “HD” | Always the value “HD” |
Date | 10 | MM/DD/YYYY | Date report was generated |
Time | 8 | HH:MM:SS | Time report was generated |
Version | 15 | “SD2.0” | Always the value “SD2.0” |
Enrollment Record
Name | Description | Type, Format and Length | Campus UI and Database Location |
District Number | State-assigned district identification number. | Number, 5 digits Zero padding required. | System Administration > Resources > District Information > District Number District.number |
School Number | State-assigned school identification number. | Number, 2 digits Zero padding required. | System Administration > Resources > School > State School Number School.number |
Calendar Number | Number assigned to the calendar. Needs to match calendar number in associated SD-Extract-School Calendar file. | Number, 3 digits | System Administration > Calendar > Calendar > Number Calendar.number |
District Code | The district associated with the enrollment record.
| Number, 2 digits | System Administration > Resources > District Information > District Code District.districtCode |
First Name | Student's legal first name. | Alphanumeric, 35 characters | Census > People > Demographics > First Name Identity.firstName |
Middle Name | Student's legal middle name. | Alphanumeric, 20 characters | Census > People > Demographics > Middle Name Identity.middleName |
Last Name | Student's legal last name. | Alphanumeric, 40 characters | Census > People > Demographics > Last Name Identity.lastName |
Birth date | Student's date of birth. | Date field, 10 characters | Census > People > Demographics > Birth Date Identity.birthdate |
Gender | Student's gender. | Alphabetic, 1 character | Census > People > Demographics > Gender Person.gender |
State ID Number | Student's state ID number. | Numeric, 9 digits | Census > People > Demographics > Person Identifiers > Student State ID Person.studentNumber |
Social Security Number | Student's Social Security number. | Numeric, 9 digits | Census > People > Demographics > Social Security Number Student.ssn |
Grade Level | Student grade level | Alphanumeric, 2 characters | Student Information > General > Enrollment > Grade Enrollment.grade |
Resident District Number | The identification number of the district in which the student resides. | Numeric, 5 digits | Student Information > General > Enrollments > State Reporting Fields > Resident District Enrollment.residentDistrict |
Attending District Number | The identification number of the district in which the student attends school. | Numeric, 5 digits | Student Information > General > Enrollments > State Reporting Fields > Serving (Attending) District Enrollment.servingDistrict |
Enrollment Start Date | The day student enrollment began. | Date field, 10 characters MM/DD/YYYY | Student Information > General > Enrollments > Start Date Enrollment.startDate |
Enrollment End Date | The day student enrollment ended. | Date field, 10 characters MM/DD/YYYY | Student Information > General > Enrollments > End Date Enrollment.endDate |
Service Type | Indicates type of service student is receiving.
| Alphabetic, 1 character | Student Information > General > Enrollments > Service Type Enrollment.serviceType |
Percent Enrolled | Percentage of time student was enrolled in the service, between 0 and 100. | Numeric, 3 digits | Student Information > General > Enrollments > State Reporting Fields > Percent Enrolled Enrollment.percentEnrolled |
Start Status | The reason for the student's entry into the school. | Numeric, 2 digits | Student Information > General > Enrollments > General Enrollment Information > Start Status Enrollment.startStatus |
End Status | Reason student enrollment was ended. If Enrollment End Date is supplied, an End Status must be entered. See options in the South Dakota Enrollments Tab article. | Numeric, 2 digits | Student Information > General > Enrollments > End Status Enrollment.endStatus |
County Number | State defined county number or code. | Numeric, 2 digits | Student Information > General > Enrollments > County County.number |
Enrollment Status | Status of the student's enrollment. If Resident District and Attending District are not the same, an Enrollment Status must be selected. If Resident District and Attending District are the same, only codes A and D are available. If the districts differ, codes B, C, E, G, J, M, O, P, T and W are available. | Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Enrollment Status EnrollmentSD. |
EL | Indicates student is participating in English Learner programming. This field will not import if the District Code field = 30 or blank. | Alphabetic, 1 character | Student Information > Program Participation > English Learners (EL) > Program Status LEP.programStatus |
Primary Language | Primary language the student speaks. Import logic is as follows:
See the Language List attachment for a complete list of accepted code values. | Alphanumeric, 3 characters | Census > People > Identities > Home Primary Language Enrollment.language |
EL Date | The date on which the student began participation in the English Learner program. This field will not import if the District Code field = 30 or blank. | Date field, 10 characters | Student Information > Program Participation > English Learners (EL) > EL Services > Start Date LEP.startDate |
EL Service Type | When this field is populated with an EL state code, create an EL services record on the EL Services screen
| Student Information > Program Participation > English Learners (EL) > EL Services > Service Type ELService.type | |
EL Service Start Date | Import this start date as the start date from the EL Service record created when importing the EL Service Type value. | MM/DD/YYYY | Student Information > Program Participation > English Learners (EL) > EL Services > Start Date ELService.startDate |
Gifted | Indicates if the student is considered gifted. | Alphanumeric, 1 character Y or N | Student Information > General > Enrollments > State Reporting Fields > Gifted Enrollment.giftedTalented |
Documented Hearing Loss | Indicates if the student has documented hearing loss.
| Alphanumeric, 1 character Y or N | Student Information > General > Enrollments > State Reporting Fields > Documented Hearing Loss Enrollment.hearingLoss |
504 Plan | Indicates if the student has a 504 Plan. | Alphanumeric, 1 character Y or N | Student Information > General > Enrollments > State Reporting Fields > 504 Plan Enrollment.section504 |
Special Ed Category | Code indicating category into which student's special education program participation fits. If Special Ed Category is entered, Special Ed Start Date must not be empty. | Numeric, 8 digits | Student Information > General > Enrollments > Special Ed Fields > Special Ed Category Enrollment. |
Occupational Therapy Hours | Number of hours student participated in occupational therapy. Round to 3 decimals. | Decimal, 8 digits | Student Information > General > Enrollments > Special Ed Fields > Occupational Therapy Hours CustomEnrollment |
Physical Therapy Hours | Number of hours student participated in physical therapy. Round to 3 decimals. | Decimal, 8 digits | Student Information > General > Enrollments > Special Ed Fields > Physical Therapy Hours CustomEnrollment |
Psychological Therapy Hours | Number of hours student participated in psychological therapy. Round to 3 decimals. | Decimal, 8 digits | Student Information > General > Enrollments > Special Ed Fields > Psychological Therapy Hours CustomEnrollment |
Counseling Hours | Number of hours student participated in counseling services. Round to 3 decimals. | Decimal, 8 digits | Student Information > General > Enrollments > Special Ed Fields > Counseling Services Hours CustomEnrollment |
Social Work Hours | Number of hours student participated in social work services. Round to 3 decimals. | Decimal, 8 digits | Student Information > General > Enrollments > Special Ed Fields > Social Work Services Hours CustomEnrollment |
Audiological Therapy Hours | Number of hours student participated in audiological services. Round to 3 decimals. | Decimal, 8 digits | Student Information > General > Enrollments > Special Ed Fields > Audiological Services Hours CustomEnrollment |
Recreational Therapy Hours | Number of hours student participated in recreational therapy. Round to 3 decimals. | Decimal, 8 digits | Student Information > General > Enrollments > Special Ed Fields > Recreational Therapy Hours CustomEnrollment |
School Health Hours | Number of hours student participated in school health services. Round to 3 decimals. | Decimal, 8 digits | Student Information > General > Enrollments > Special Ed Fields > School Health Services Hours CustomEnrollment |
Speech Therapy Hours | Number of hours student participated in speech/language therapy. Round to 3 decimals. | Decimal, 8 digits | Student Information > General > Enrollments > Special Ed Fields > Speech/Language Therapy Hours CustomEnrollment |
SPED Transportation | Indicates whether student is receiving transportation assistance. | Alphabetic, 1 character | Student Information > General > Enrollments > Special Ed Fields > Transportation CustomEnrollment |
Other Service Hours | Number of hours student participated in other services. Round to 3 decimals. | Decimal, 8 digits | Student Information > General > Enrollments > Special Ed Fields > Other Service Hours CustomEnrollment |
SPED Assistive Technology | Indicates whether student is receiving assistive technology services. | Alphabetic, 1 character | Student Information > General > Enrollments > Special Ed Fields > Assistive Technology CustomEnrollment |
Orientation Mobility Hours | Number of hours student participated in orientation mobility therapy. Round to 3 decimals. | Decimal, 8 digits | Student Information > General > Enrollments > Special Ed Fields > Orientation Mobility Hours CustomEnrollment |
ASD Severity Behaviors | Indicates if the student requires ASD Behavioral support and the severity level of this support.
This field is required when Primary Disability = 560: Autism Spectrum Disorder. | Alpha, 1 character | Student Information > General > Enrollments > Special Ed Fields > ASD Severity Behaviors CustomEnrollment sped.asdSeverity Behaviors |
ASD Severity Communication | Indicates if the student requires ASD Communication support and the severity level of this support.
| Alpha, 1 character | Student Information > General > Enrollments > Special Ed Fields > ASD Severity Communication CustomEnrollment sped. asdSeverity Communication |
Participates in Alt Assessment | Indicates if the student participates in alternative assessment.
| Alphabetic, 1 character Y or N | Student Information > General > Enrollments > Special Ed Fields > Participates in Alt Assessment CustomEnrollment sped.cognitive Disabilities |
Special Ed Program | Code indicating the type of special education program in which the student is participating. If Special Ed Program is entered, SPED Start Date must not be empty.
| Alphabetic, 1 character | Student Information > General > Enrollments > Special Ed Fields > Special Ed Program Enrollment.specialEdStatus |
Primary Disability | Student's primary disability. If Primary Disability is entered, SPED Start Date must not be empty. See Disability Codes Table below. | Alphanumeric, 3 characters | Student Information > General > Enrollments > Special Ed Fields > Primary Disability Enrollment.disability1 |
Multiple Disability 1 | Student's disability in addition to Primary Disability. See Disability Codes Table below. | Alphanumeric, 3 characters | Student Information > General > Enrollments > Special Ed Fields > Multiple Disability 1 Enrollment.disability2 |
Multiple Disability 2 | Student's disability in addition to Primary Disability. See Disability Codes Table below. | Alphanumeric, 3 characters | Student Information > General > Enrollments > Special Ed Fields > Multiple Disability 2 Enrollment.disability3 |
Multiple Disability 3 | Student's disability in addition to Primary Disability. See Disability Codes Table below. | Alphanumeric, 3 characters | Student Information > General > Enrollments > Special Ed Fields > Multiple Disability 3 Enrollment.disability4 |
Multiple Disability 4 | Student's disability in addition to Primary Disability. See Disability Codes Table below. | Alphanumeric, 3 characters | Student Information > General > Enrollments > Special Ed Fields > Multiple Disability 4 Enrollment.disability5 |
Multiple Disability 5 | Student's disability in addition to Primary Disability. See Disability Codes Table below. | Alphanumeric, 3 characters | Student Information > General > Enrollments > Special Ed Fields > Multiple Disability 5 Enrollment.disability6 |
SPED Start Date | Beginning date of Special Education program participation. | Date field, 10 characters MM/DD/YYYY | Student Information > General > Enrollments > Special Ed Fields > Effective Date Enrollment.spedStartDate |
SPED End Date | Ending date of Special Education program participation. | Date field, 10 characters MM/DD/YYYY | Student Information > General > Enrollments > Special Ed Fields > End Date Enrollment.spedExitDate |
SPED Exit Code | Exit code attached to the ending of the student's special education participation. Special Ed Exit Code is required when the Special Ed End Date is not null. See Special Ed Exit Codes Table below. | Numeric, 10 digits | Student Information > General > Enrollments > Special Ed Fields > Exit Code Enrollment.spedExitReason |
Days Absent | Number of days student was absent. | Decimal, 8 digits | Student Information > General > Enrollments > State Reporting Fields > Absent Days Calculated, not dynamically stored |
Title 1 Status | Indicates whether student is participating in title 1 services. | Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > Title 1 Enrollment.title1 |
Citizenship | Code indicating student's citizenship status.
| Numeric, 1 digits | Student Information > General > Enrollments > State Reporting Fields > Citizenship Enrollment.citizenship |
Transportation | Indication of transportation assistance provided to the student, if applicable.
| Numeric, 2 digits | Student Information > General > Enrollments > State Reporting Fields > Transportation Category Enrollment.transportation |
Homeless | Indicates student's homeless status. If student was homeless at any point during the school year, field should remain populated even if student is no longer homeless.
| Alphanumeric, 1 character | Student Information > Program Participation > Homeless > Primary Nighttime Residence Homeless. |
Homeless Start Date | The first day the student was identified as homeless.
| Date field, 10 characters MM/DD/YYYY | Student Information > Program Participation > Homeless > Start Date Homeless.startDate |
Unaccompanied Youth | Indicates the student is not in the presence of a parent, guardian or legal status identified by the court system. Accepted values are as follows:
The most recent Homeless record is reported.F
| Alphanumeric, 3 characters | Student Information > Program Participation > Homeless > Unaccompanied Youth Homeless. unaccompaniedYouth |
Title 1 Math | Indicates student's participation in Title 1 Math program. | Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > Title 1 Math EnrollmentSD.title1Math |
Title 1 Reading | Indicates student's participation in Title 1 Reading program. | Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > Title 1 Reading EnrollmentSD.title1Reading |
Title 1 Science | Indicates student's participation in Title 1 Science program. | Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > Title 1 Science EnrollmentSD.title1Science |
Title 1 Social Science | Indicates student's participation in Title 1 Social Science program. | Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > Title 1 Social Science EnrollmentSD.title1SocialScience |
Title 1 Vocational | Indicates student's participation in Title 1 Vocational program. | Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > Title 1 Vocational EnrollmentSD. title1Vocational |
Title 1 Health | Indicates student's participation in Title 1 Health program. | Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > Title 1 Health/ Dental/Eye Care EnrollmentSD.title1Health |
Title 1 Guidance | Indicates student's participation in Title 1 Guidance program. | Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > Title 1 Supporting Guidance EnrollmentSD. |
First Year In Country | Indicates that this enrollment represents the student's first year in the country. | Alphabetic, 1 character | Student Information > General > Enrollments > State Reporting Fields > First Year in Country EnrollmentSD. firstYearInCountry |
Date Entered US Schools | The date the student enrolled in a US school. | Date field, 10 characters MM/DD/YYYY | Census > People > Demographics > Data Entered US Schools Identity. |
Date Entered 9th Grade | Indicates the date in which the student entered 9th grade. Data is imported into the student's Graduation > Date First Entered the 9th Grade field.
| Date field, 10 characters MM/DD/YYYY | Student Information > General > Graduation > Date First Entered the 9th Grade Graduation.grade9Date |
Diploma Type | The student's graduation diploma type.
| Alphanumeric, 2 characters | Student Information > General > Graduation > Diploma Type Graduation. |
Diploma Date | The date the student received | Date field, 10 characters MM/DD/YYYY | Student Information > General > Graduation > Diploma Date Graduation. |
Diploma Period | Indicates when the diploma was issued. Reported values are as follows:
If a Diploma Period value already exists for the student, the value in Campus will be updated to the value in the upload file. If a Diploma Period value exists for a student but their Diploma Period is blank in the upload file, the student's Diploma Period value will be removed and replaced with null. | Alphanumeric, 2 characters | Student Information > General > Graduation > Diploma Period Graduation. diplomaPeriod |
Graduation Endorsement 1 | Indicates if the student has a Graduation Endorsement of 'Advanced Endorsement'.
| Alphanumeric, 1 character Y or N | Student Information > General > Graduation > Endorsements GraduationSealstateSeal |
Graduation Endorsement 2 | Indicates if the student has a Graduation Endorsement of 'Advanced Career Endorsement'.
| Alphanumeric, 1 character Y or N | Student Information > General > Graduation > Endorsements GraduationSeal.stateSeal |
Graduation Endorsement 3 | Indicates if the student has a Graduation Endorsement of 'Advanced Honors Endorsement'.
| Alphanumeric, 1 character Y or N | Student Information > General > Graduation > Endorsements GraduationSeal.stateSeal |
Student of Active Military Parent | Indicates the student has a parent who is actively in the military.
| Alphanumeric, 1 character | Student Information > General > Enrollments > State Reporting Fields > Student of Active Military Parent Enrollment. studentOfActive MilitaryParent |
Student Directory Information | Indicates whether or not the school is allowed to share information about the student with non school entities. | Alphabetic, 3 character Yes or No | Student Information > General > Enrollments > State Reporting Fields > Student Directory Info 7-12 ONLY EnrollmentSD. doNotShare |
Student GPA | The student's GPA..
| Numeric, 5 digits X.XXXX | Student Information > General > Enrollments > State Reporting Fields > GPA EnrollmentSD.gpa |
Year | The end year of the enrollment (i.e. for SY2006-2007 = 2007). | Date field, 4 characters | System Administration > Calendar > Calendar > Calendar Info Calendar.endYear |
Example:
A student record for Kelsey Kramer.
12345 12 123 Kelsey Ann Kramer 10/11/1991 F
123456789 223456789 10 22345 32345 08/26/2006 P 100 12 T N N N 2.5 N 1 1 D N N N N N N N N 2007
Codes and Descriptions
The following tables define codes used in the file upload.
Special Ed Category Codes
Code | Description |
---|---|
0100 | General Class with Modifications 80-100% |
0110 | Resource Room 40-79% |
0120 | Self-Contained Classroom 0-39% |
0130 | Separate Day School |
0140 | Residential Facility |
0150 | Home/Hospital |
0310 | EC 10 hrs +/wk, services in Reg EC |
0315 | EC 10 hrs +/wk, services in other location |
0325 | EC less than 10 hrs/wk, services in Reg EC |
0330 | EC less than 10 hrs/wk, services in other location |
0335 | Separate Class |
0345 | Separate School |
0355 | Residential Facility |
0365 | Home |
0375 | Service Provider Location |
Primary Disability Codes
Code | Description |
---|---|
500 | Deaf-Blindness |
505 | Emotional Disturbance |
510 | Cognitive Disability |
515 | Hearing Loss |
525 | Specific Learning Disability |
530 | Multiple Disabilities |
535 | Orthopedic Impairments |
540 | Visual Loss |
545 | Deafness |
550 | Speech/Language |
555 | Other Health Impairment |
560 | Autism Spectrum Disorder |
565 | Traumatic Brain Injury |
570 | Developmental Delay |
Enrollment Status Codes
Code | Description | Only Valid If |
---|---|---|
A | School Choice | Only Valid If Resident District Same As Attending District |
D | Persistently Dangerous | Only Valid If Resident District Same As Attending District |
B | Placed and Paid by Tribal | Only Valid If Resident District Different From Attending District |
C | Contracting Student | Only Valid If Resident District Different From Attending District |
E | Paid for by Auxiliary Placement | Only Valid If Resident District Different From Attending District |
G | Whole Grade Sharing | Only Valid If Resident District Different From Attending District |
J | Placed and Paid by Corrections | Only Valid If Resident District Different From Attending District |
M | Parentally Placed in Private School | Only Valid If Resident District Different From Attending District |
O | Open Enrollment | Only Valid If Resident District Different From Attending District |
P | Tuition Paid by District | Only Valid If Resident District Different From Attending District |
R | Residential Placement Paid by DOE | Only Valid If Resident District Different From Attending District |
T | Tuition Paid by Other | Only Valid If Resident District Different From Attending District |
W | Tuition Waived | Only Valid If Resident District Different From Attending District |
Multiple Disability Codes
Code | Description |
---|---|
505 | Emotional Disturbance |
510 | Cognitive Disability |
515 | Hearing Loss |
525 | Specific Learning Disability |
535 | Orthopedic Impairments |
540 | Visual Loss |
545 | Deafness |
550 | Speech/Language |
555 | Other Health Impairment |
560 | Autism Spectrum Disorder |
565 | Traumatic Brain Injury |
570 | Developmental Delay |
Special Ed Exit Codes
Code | Description |
---|---|
1 | Not receiving SE services |
2 | Graduated (high school diploma) |
03 | Continues/Completed IEP team mod/ course reqs |
4 | Reached the maximum age |
5 | Died |
6 | Moved, known to be continuing |
7 | Moved, not known to be continuing |
8 | Dropped out |
9 | Refused services |
10 | ISFP done before max age/Pt C |
11 | Change in IEP |
12 | Student Continues |
13 | Discontinued/Completed IEP team mod/course reqs |
14 | Aged Out/Completed IEP team mod/course reqs |
15 | Revocation of consent |
Suffix Codes
Code |
---|
Jr. |
Sr. |
I |
II |
III |
IV |
V |
VI |
VII |
Important Fields to Note
In preparation of future importing and state reporting requirements, you should be aware of and begin using ASD Severity Behavior Level and ASD Severity Communication Level fields (Student Information > General > Enrollments > Special Ed Fields).
See the South Dakota Enrollment Tab article for more information about these fields.
You should also begin using the Endorsement field found in the Graduation Endorsements section of the Graduation tab (Student Information > General > Graduation > Graduation Endorsements).
See the Graduation Tab - South Dakota article for more information.