Classic Path: KS State Reporting > Assignment Import
Search Terms: Assignment Import
The KS Assignment Import file is used to import State Identification numbers assigned to students by the state.
Kansas Assignment Import
Once 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 | Type, |
Campus Database | Campus Interface |
|---|---|---|---|---|
| Record Type | Reports the state defined record type. This field always reports a value of ID. | Alphanumeric, 4 characters | Not dynamically stored | Not dynamically stored |
| AYP School | Indicates the student's AYP School. | Alphanumeric, 4 characters | School.number | System Administration > Resources > School > School Editor > State School Number |
| Resident District | Lists the student's home district. | Alphanumeric, 5 characters | Enrollment. residentdistrict | System Administration > Resources > District Information > District Information > State District Number |
| Last Name | Indicates the student's last name. | Alphanumeric, 60 characters | Identity.lastName | Census > People > Demographics > Person Information > Last Name |
| First Name | Indicates the student's first name. | Alphanumeric, 60 characters | Identity.firstName | Census > People > Demographics > Person Information > First Name |
| Middle Name | Indicates the students middle name. | Alphanumeric, 60 characters | Identity.middleName | Census > People > Demographics > Person Information > Middle Name |
| Suffix | Indicates the suffix for the student, if applicable. | Alphanumeric, 10 characters | Identity.suffix | Census > People > Demographics > Person Information > Suffix |
| Gender | Indicates the student's gender. Reports a value of 0 (zero) for female and 1 for male. |
Numeric, 1 digits |
Identity.gender | Census > People > Demographics > Person Information > Gender |
| Birth Date | Lists the student's birth date. | Date Field, 10 digits MM/DD/YYYY |
Identity.birthDate | Census > People > Demographics > Person Information > Birth Date |
| Grade | Indicates the student's grade level. | Alphanumeric, 2 characters | Enrollments.grade | Student Information > General > Enrollments > Grade |
| Student Identifier | Reports the student's identifier as assigned by the district. | Alphanumeric, 20 characters | Person. localStudentNumber | Census > People > Demographics > Person Identifiers > Local Student Number |
| Social Security Number | Reports the student's social security number. | Alphanumeric, 9 characters | Person. socialSecurityNumber | Census > People > Demographics > Person Information > Soc Sec Num |
| Race | Lists the student's race/ethnicity. | Alphanumeric, 1 character | Identity. raceEthnicity | Census > People > Demographics > Person Information > Race/Ethnicity |
| State Student Identifier | Indicates the student's identifier as assigned by the state. | Numeric, 10 digits | Person. studentStateID | Census > People > Demographics > Person Identifiers > Student State ID |
| District Number | Lists the district number for the district the student attends. | Alphanumeric, 5 characters | District.number | System Administration > Resources > District Information > District Editor > District Detail > State District Number |
| Year | Lists the current school year. | Numeric, 4 digits | Calendar.endDate | System Administration > Calendar > Calendar > Calendar > Year |
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 |
