Tool Search: Assignment Import
The KS Assignment Import file is used to import State Identification numbers assigned to students by the state.
Assignment Import EditorOnce uploaded, a new browser window displays that includes the header and trailer record of what was imported. It does NOT include a list of student data that was imported.
Assignment Import Example
A file to import might look like the image below. Only files in *.txt format can be imported.
Assignment Import File Example Layout
Report Logic
This import matches the Student number to generate the report. If it does not find a match, the State ID number is not imported.
Assignment Import Report Layout
Report Header
| Data Element | Description | Type, Format and Length |
|---|---|---|
| Record Type | Reports the state defined record type. Always reports a value of TH. | Alphabetic, 2 characters |
| Extract Date | Indicates the date the file was generated. | Date field, 10 characters MM/DD/YYYY |
| Extract Time | Indicates the time the file was generated. | Time field, 10 characters HH:MM:SS |
| Transmission ID | Lists an arbitrary number that must match the Transmission ID in the Report Trailer record. | Numeric, 10 digits |
| Version | Always reports a value of 1.0. | Numeric, 2 digits |
| Delimiter Character | Reports a value of 0X09. | Alphanumeric, 25 characters. |
Report Layout
| Data Element | Description | Location |
|---|---|---|
| Record Type | Reports the state defined record type. This field always reports a value of ID. Alphanumeric, 4 characters | Not dynamically stored |
| AYP School | Indicates the student's AYP School. Alphanumeric, 4 characters | School Information > School Editor > State School Number School.number |
| Resident District | Lists the student's home district. Alphanumeric, 5 characters | District Information > District Information > State District Number Enrollment.residentdistrict |
| Last Name | Indicates the student's last name. Alphanumeric, 60 characters | Demographics > Person Information > Last Name Identity.lastName |
| First Name | Indicates the student's first name. Alphanumeric, 60 characters | Demographics > Person Information > First Name Identity.firstName |
| Middle Name | Indicates the students middle name. Alphanumeric, 60 characters | Demographics > Person Information > Middle Name Identity.middleName |
| Suffix | Indicates the suffix for the student, if applicable. Alphanumeric, 10 characters | Demographics > Person Information > Suffix Identity.suffix |
| Gender | Indicates the student's gender. Reports a value of 0 (zero) for female and 1 for male. Numeric, 1 digits | Demographics > Person Information > Gender Identity.gender |
| Birth Date | Lists the student's birth date. Date Field,10 digits (MM/DD/YYYY) | Demographics > Person Information > Birth Date Identity.birthDate |
| Grade | Indicates the student's grade level. Alphanumeric, 2 characters | Enrollments > Grade Enrollments.grade |
| Student Identifier | Reports the student's identifier as assigned by the district. Alphanumeric, 20 characters | Demographics > Person Identifiers > Local Student Number Person. localStudentNumber |
| Social Security Number | Reports the student's social security number. Alphanumeric, 9 characters | Demographics > Person Information > Soc Sec Num Person.socialSecurityNumber |
| Race | Lists the student's race/ethnicity. Alphanumeric, 1 character | Demographics > Person Information > Race/Ethnicity Identity.raceEthnicity |
| State Student Identifier | Indicates the student's identifier as assigned by the state. Numeric, 10 digits | Demographics > Person Identifiers > Student State ID Person.studentStateID |
| District Number | Lists the district number for the district the student attends. Alphanumeric, 5 characters | District Information > District Editor > District Detail > State District Number District.number |
| Year | Lists the current school year. Numeric, 4 digits | Calendar Infomation > Calendar > Year Calendar.endDate |
Report Trailer
| Data Element | Description | Type, Format and Length |
|---|---|---|
| Record Type | Reports the state defined record type. Always reports a value of TT. | Alphabetic, 2 characters |
| Transmission ID | Lists an arbitrary number that must match the Transmission ID in the Report Trailer record. | Numeric, 10 digits |
| Number of Records | Lists the count of the total number of records included in the import, including the Header and Trailer records. | Numeric, 10 digits |
