Assignment Import (Kansas)

Tool Search: Assignment Import

The KS Assignment Import file is used to import State Identification numbers assigned to students by the state.

screenshot of the assignment import editorAssignment Import Editor

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 ElementDescriptionType, Format and Length
Record TypeReports the state defined record type. Always reports a value of TH.Alphabetic, 2 characters
Extract DateIndicates the date the file was generated.

Date field, 10 characters

MM/DD/YYYY

Extract TimeIndicates the time the file was generated.

Time field, 10 characters

HH:MM:SS

Transmission IDLists an arbitrary number that must match the Transmission ID in the Report Trailer record.Numeric, 10 digits
VersionAlways reports a value of 1.0.Numeric, 2 digits
Delimiter CharacterReports a value of 0X09.Alphanumeric, 25 characters.

Report Layout

Data ElementDescriptionLocation
Record TypeReports the state defined record type. This field always reports a value of ID.

Alphanumeric, 4 characters
Not dynamically stored
AYP SchoolIndicates the student's AYP School.

Alphanumeric, 4 characters
School Information > School Editor > State School Number

School.number
Resident DistrictLists the student's home district.

Alphanumeric, 5 characters
District Information > District Information > State District Number

Enrollment.residentdistrict
Last NameIndicates the student's last name.

Alphanumeric, 60 characters

Demographics > Person Information > Last Name


Identity.lastName

First NameIndicates the student's first name.

Alphanumeric, 60 characters

Demographics > Person Information > First Name


Identity.firstName

Middle NameIndicates the students middle name.

Alphanumeric, 60 characters

Demographics > Person Information > Middle Name


Identity.middleName

SuffixIndicates 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 DateLists the student's birth date.

Date Field,10 digits (MM/DD/YYYY)

Demographics > Person Information > Birth Date


Identity.birthDate

GradeIndicates the student's grade level.

Alphanumeric, 2 characters

Enrollments > Grade


Enrollments.grade

Student IdentifierReports the student's identifier as assigned by the district.

Alphanumeric, 20 characters
Demographics > Person Identifiers > Local Student Number

Person. localStudentNumber
Social Security NumberReports the student's social security number.

Alphanumeric, 9 characters

Demographics > Person Information > Soc Sec Num


Person.socialSecurityNumber

RaceLists the student's race/ethnicity.

Alphanumeric, 1 character

Demographics > Person Information > Race/Ethnicity


Identity.raceEthnicity

State Student IdentifierIndicates the student's identifier as assigned by the state.

Numeric, 10 digits
Demographics > Person Identifiers > Student State ID

Person.studentStateID
District NumberLists the district number for the district the student attends.

Alphanumeric, 5 characters
District Information > District Editor > District Detail > State District Number

District.number
YearLists the current school year.

Numeric, 4 digits
Calendar Infomation > Calendar > Year

Calendar.endDate

Report Trailer

Data ElementDescriptionType, Format and Length
Record TypeReports the state defined record type. Always reports a value of TT.Alphabetic, 2 characters
Transmission IDLists 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