KIDS ASGT Extract (Kansas)

Classic View: KS State Reporting > Collection Extract > ASGT: Update Core Data

Search Terms: Collection Extract

The KIDS Collection ASGT Extract allows staff to obtain identification numbers (SSID) for new students, update core student data linked to a student's SSID, track students as they move between schools (i.e., claiming a student) and establish a student building link that allows a student record to be available in other KSDE applications.

It is recommended that ASGT records are submitted on a regular basis (daily or weekly).

KIDS ASGT Editor

Report Logic

This extract only reports enrollment records where the Enrollment Start Date is within the Reporting Range entered on the Extract Editor (Data Filter From Date, Data Filter To Date).

Students do not report when: 

  • The Enrollment record is marked as State Exclude or No Show.
  • The Calendar of Enrollment is marked as State Exclude.
  • The Grade Level of Enrollment is marked as State Exclude.

See the KIDS Collection Extracts article for additional general reporting logic.

Generate the Report

See the KIDS Collection Extracts editor for description of the Report Editor fields and Sample Report Formats.

  1. Select the ASGT: Update Core Data from the Extract Type dropdown list.
  2. Enter a Data Filter From Date, if desired.
  3. Enter a Data Filter To Date, if desired.
  4. Select the Assessment Disaggregation Method 1 option, if desired.
  5. Select the Assessment Disaggregation Method 2 option, if desired.
  6. Mark the Students without State IDs checkbox, if desired.
  7. Mark the Social Security Number Optional, if desired.
  8. Select an Ad hoc Filter, if desired.
  9. Select the appropriate Format for the extract.
  10. If generating the extract in the State Format (tab delimited), enter the Records Limit Per File  number.
  11. Select the Calendars to include in the extract.
  12. Click the Generate Report button. The report will display in the selected format.

Report Layout

Data Element

Description

Location

Record Type

Type of extract being generated, chosen on the Report Editor. 


Alphanumeric, 4 characters

Data not stored

Accountability School Identifier

Indicates the school number of the student's enrollment.


Alphanumeric, 4 characters

System Administration > Resources > School > School Detail > State School Number


School.number

Resident District

District number where student resides (but not necessarily attends).


If Home District field is blank, data reports from the State District Number field.


Alphanumeric, 5 characters

Student Information  > General > Enrollments > State Reporting Fields > Home District


Enrollment.residentDistrict


System Administration > Resources > District Information > District Info > State District Number


District.number

Legal Last Name

Reports the last name of the student.


If the Legal Last Name field is populated, information reports from that field.


Alphanumeric, 60 characters

Census > People > Identities > Identity Information > Protected Identity Information > Legal Last Name


Identity.legalLastName


Census > People > Demographics > Person Information > Last Name


Identity.lastName

Legal First Name

Reports the legal first name of the student.


If the Legal First Name field is populated, information reports from that field.


Alphanumeric, 60 characters

Census > People > Identities > Identity Information > Protected Identity Information > Legal First Name


Identity.legalFirstName


Census > People > Demographics > Person Information > First Name


Identity.firstName

Legal Middle Name

Middle name or middle initial of the student. If only the middle initial is available, this will be reported. If no middle name or initial is available for the student, this field will report blank.


If the Legal MIddle Name field is populated, information reports from that field.


Alphanumeric, 60 characters

Census > People > Identities > Identity Information > Protected Identity Information > Legal Middle Name


Identity.legalMiddleName


Census > People > Demographics > Person Information > Middle Name


Identity.middleName

Suffix

Indicates student's name is generational (Jr., III, etc.).


If the Legal Suffix field is populated, information reports from that field.


Alphanumeric, 10 characters

Census > People > Identities > Identity Information > Protected Identity Information > Legal Suffix


Identity.legalSuffix


Census > People > Demographics > Person Information > Suffix


Identity.suffix

Gender

Indication of student being either male or female.


If the Legal Gender field is populated, information reports from that field.


Numeric, 1 digit (0 = Female, 1 = Male)

Census > People > Identities > Identity Information > Protected Identity Information > Legal Gender


Identity.legalGender


Census > People > Demographics > Person Information > Gender


Identity.gender

Date of Birth

Date on which student was born.


Date field, 10 characters (MM/DD/YYYY)

Census > People > Demographics > Person Information > Birth Date


Identity.birthDate

Grade

Grade level or primary instructional level at which the student enters and receives services in a school or an educational institution during a given academic session.


See the Report Logic section for more information on grade levels.


When the enrollment State Grade Level is 04 and the Primary Disability reports a value of WD, a value of 02 reports. Otherwise, this field reports the mapped state grade level of the local grade level.


Alphanumeric, 2 characters

Student Information > General > Enrollments > General Enrollment Information > Grade


Enrollment.grade

Student Identifier

Unique identifier assigned to the student by the school and/or district.


Alphanumeric, 20 characters

Census > People > Demographics > Person Identifiers > Student Number


Person.studentNumber

Hispanic Ethnicity

Indication of student being of Hispanic/Latino ethnicity. If yes, will report as Y; if No, will report as N.



Alphanumeric, 1 character


Census > People > Demographics > Person Information > Race/Ethnicity > Is the individual Hispanic/Latino?


Identity.hispanicLatino

State Student Identifier

Student's state identification number.


If there is no value entered, field reports blank.


Numeric, 10 digits

Census > People > Demographics > Person Identifiers > State ID


Person.stateID

School Year

The ending year of the current school year. If reporting for the 2012-13 school year, this will report as 2012.


Numeric, 4 digits

System Administration > Calendar > Calendar > Calendar Information > End Date


Calendar.year

Funding School

Override field for the school that receives funding for the student.


Alphanumeric, 4 characters

System Administration > Resources > School > School Editor > State School Number


Student Information > General > Enrollments > State Reporting Fields > Funding School


EnrollmentKS.fundingSchool

Attendance School

Unique number of the school or program in which the student is physically located and where he/she takes the state assessments.


Numeric, 4 digits

Student Information > General > Enrollments > State Reporting Fields > Attendance School


EnrollmentKS.attendanceSchool

Virtual Education  Student 

No value reports for this field in the ASGT Extract.

N/A

School Entry  Date 

Reports the student's start date of enrollment at the school. If the Entry into School field is blank on the enrollment record, the pre-determined Override logic (see here) is used.


Date field, 10 characters (MM/DD/YYY)

Student Information > General > Enrollments > State Reporting Fields > Entry into School


EnrollmentKS.schoolDate

District Entry Date 

Reports the student's first date of entry at the district. If the Entry into District field is blank on the enrollment record, the pre-determined Override logic (see here) is used.

Date field, 10 characters (MM/DD/YYY)

Student Information > General > Enrollments > State Reporting Fields > Entry into District


EnrollmentKS.districtDate

State Entry Date 

Reports the student's first date of entry at a school in the state. If the Entry into State field is blank, the pre-determined Override logic (see here) is used.


Date field, 10 characters (MM/DD/YYY)

Student Information > General > Enrollments > State Reporting Fields > Entry into State


EnrollmentKS.stateDate

First Instructional Date

Reports the first day (month, day and year) the student receives instructional services during the school year. A value reports when the student meets the following criteria (at least one of these is true): 

  • Primary Disability reports as WD.
  • Gifted Student reports as GI.
  • Qualified for 504 reports a value that is not 0.
  • Residence of Homeless Student while Homeless reports a value that is not 0. 
  • Title I Participation reports a value that is not 0. 
  • Military Connected Student Indicator reports a value that is not 0. 
  • Immigrant Student reports a value that is not 0.
  • Neglected Student reports a value that is not 0. 

This reports the first day marked for instruction and attendance from the Calendar in which the student is enrolled.

  • If the student's most recent primary enrollment start date is after this date, the enrollment start date reports.
  • If the student has multiple primary enrollments, the most recent  enrollment start date that is on or after the first day of instruction and attendance on the calendar reports.
  • If the student has no primary enrollments, the most recent enrollment start date that is on or after the first day of instruction and attendance on the calendar reports.

If the school is marked as School Wide in the Title 1 field on the School Editor, all students within the school report their First Instruction Date. 


Date field, 10 characters (MM/DD/YYYY)

Student Information > General > Enrollment > General Enrollment Information > Start Date


Enrollment.startDate


Student Information > Program Participation > Gifted > Start Date


Gifted.startDate


Student Information > Special Education > General > State Reporting > Start Date


SpecialEDState.startDate


System Administration > Calendar > Calendar > Calendar > Days > Instruction, Attendance


Membership Days 

No value reports for this field in the ASGT Extract.

N/A

Attended Days 

No value reports for this field in the ASGT Extract.

N/A

Truant Student 

No value reports for this field in the ASGT Extract.

N/A

Minutes Enrolled 

No value reports for this field in the ASGT Extract.

N/A

Concurrent HS Enrollment 

No value reports for this field in the ASGT Extract.

N/A

Exit Withdrawal Date 

 No value reports for this field in the ASGT Extract.

N/A

Exit Withdrawal Type 

 NNo value reports for this field in the ASGT Extract. 

N/A

Unweighted Grade Point AverageNo value reports for this field in the ASGTExtract.N/A

Special Circumstance Transfer Choice 

No value reports for this field in the ASGT Extract.

N/A

Post Graduation Plans 

 No value reports for this field in the ASGT Extract. 

N/A

Comprehensive Race

Indicates the student's race/ethnicity.

All five positions must be filled with either a 0 or a 1. For a student designed as being White, this field will report as 00005.

  • Position 5 - White
  • Position 4 - Native Hawaiian or Other Pacific Islander
  • Position 3 - Black or African American
  • Position 2 - Asian
  • Position 1 - American Indian or Alaska Native

Bit field, 6 characters

Census > People > Demographics > Person Information > Federal Race


Identity.raceEthnicity

Lunch Program 

No value reports for this field in the ASGT Extract.

N/A

Primary Disability Indicator

Indicates student's primary disability. 


When a student has an active Special Education State Reporting record OR an active IEP, a value of WD reports. Otherwise, a value of ND reports.


An active Special Education State Reporting record is calculated as follows: 

  • The Start Date on the Special Education State Reporting record is on or before the Date To field on the Extract Editor.  
  • The End Date on the Special Education State Reporting record is blank or on or after the Date From field on the Extract editor. 

SPED State Reporting records that were ended prior to the selected calendar year do not report when the Date From field on the extract editor is not populated.


An active IEP record is calculated as follows:

  • The Start Date of the IEP is on or before the Date To field on the Extract Editor.  
  • The End Date of the IEP is blank or on or after the Date From field on the Extract editor. 

When there is more than one SPED records in a given year for a student, the most recent record that overlaps the dates entered on the extract editor reports. 


Alphanumeric, 2 characters

Student Information > Special Education > General > State Reporting > Disability


SpecialEDState.primaryDisability


Student Information > Special Education > General > State Reporting > Start Date, End Date


SpecialEDState.startDate

SpecialEDState.endDate


Student Information > Special Education > Documents > IEP > Start Date, End Date


Plan.startDate

Plan.endDate


Gifted Student Indicator

Indicates whether student is considered gifted/talented.


When the student has an active Gifted record, a value of GI reports. 


Otherwise, a blank value reports. 


Gifted records that were ended prior to the selected calendar year do not report when the Date From field on the extract editor is not populated.


An active Gifted record is calculated as follows:

  • The Start Date on the Gifted record is on or before the Date To field on the Extract editor.  
  • The End Date on the Gifted record is blank or on or after the Date From field on the Extract editor. 

Alphanumeric, 2 characters

Student Information > Program Participation > Gifted > Start Date, End Date


Gifted.startDate

Gifted.endDate


Section 504 

No value reports for this field in the ASGT Extract.

N/A

Residence of Homeless 

No value reports for this field in the ASGT Extract.

N/A

ESOL/Bilingual Program Entry Date

No value reports for this field in the ASGT Extract.

N/A

First Entry Date into a school in the US

No value reports for this field in the ASGT Extract.

N/A

First Language 

No value reports for this field in the ASGT Extract.

N/A

ESOL/Bilingual Participation Code

Indicates the status of the student's ESOL Participation. See the ESOL Participation section for reporting logic.


If no value is selected, a default value zero (0) reports.


Alphanumeric, 1 character

Student Information > Program Participation > English Learners > EL Services > ESOL Participation


LepServices.service Type

Language Instruction Program Type

No value reports for this field in the ASGT Extract.


N/A


ESOL/Bilingual Program Ending Date

No value reports for this field in the ASGT Extract.

N/A

ESOL/Bilingual Student Contact Minutes 

No value reports for this field in the ASGT Extract.

N/A

Career Tech Ed Contact Minutes 

No value reports for this field in the ASGT Extract.

N/A

Title 1 Participation 

No value reports for this field in the ASGT Extract.

N/A

Miles Transported 

No value reports for this field in the ASGT Extract.

N/A

Transportation FTE 

No value reports for this field in the ASGT Extract.

N/A

Student's Street Address 

No value reports for this field in the ASGT Extract.

N/A

Student's City 

No value reports for this field in the ASGT Extract.

N/A

Student's  Zip 

No value reports for this field in the ASGT Extract.

N/A

Non-Resident Transportation 10 Mile Law 

No value reports for this field in the ASGT Extract.

N/A

Military Connected Student
 

No value reports for this field in the ASGT Extract.

N/A

Immigrant Student 

No value reports for this field in the ASGT Extract.

N/A

Country of Birth 

No value reports for this field in the ASGT Extract.

N/A

Neglected Student 

No value reports for this field in the ASGT Extract.

N/A

Kansas Preschool Program (KPP)
No value reports for this field in the ASGT Extract.N/A
Kansas Parents as Teachers Participant (KPAT)
No value reports for this field in the ASGT Extract.N/A
Dyslexia Screener

No value reports for this field in the ASGT Extract.


N/A


Dyslexia Subtest

No value reports for this field in the ASGT Extract.


N/A


Dyslexia Spring Benchmark Performance Level

No value reports for this field in the ASGT Extract.


N/A


Math Grouping Indicator 1 

No value reports for this field in the ASGT Extract.

N/A

Math Grouping Indicator 2 

No value reports for this field in the ASGT Extract.

N/A

English Language Arts - ELA Grouping Indicator 1 

No value reports for this field in the ASGT Extract.

N/A

English Language Arts - ELA Reading Grouping  Indicator 2 

No value reports for this field in the ASGT Extract.

N/A

Science Grouping Indicator 1

No value reports for this field in the ASGT Extract.N/A
Science Grouping Indicator 2No value reports for this field in the ASGT Extract.

N/A

Comprehensive Agriculture Grouping Indicator
No value reports for this field in the ASGT Extract.

N/A

Animal Systems Grouping Indicator
No value reports for this field in the ASGT Extract.

N/A

Plant Systems Grouping Indicator 

No value reports for this field in the ASGT Extract.

N/A

KELPA2 Grouping Indicator 1
No value reports for this field in the ASGT Extract.

N/A

KELPA2 Grouping Indicator 2
No value reports for this field in the ASGT Extract.

N/A

State Mathematics Assessment TypeNo value reports for this field in the ASGT Extract.

N/A

State English Language Arts - ELA Assessment TypeNo value reports for this field in the ASGT Extract.

N/A

State Science Assessment Type
No value reports for this field in the ASGT Extract.

N/A

State History/Government Assessment Type

No value reports for this field in the ASGT  Extract.

N/A

History/Gov Claim/Thesis Score

No value reports for this field in the ASGT  Extract.


N/A


History/Gov Evidence Score

No value reports for this field in the ASGT  Extract.


N/A


History/Gov Reasoning Score

No value reports for this field in the ASGT  Extract.


N/A


Comprehensive Agriculture AssessmentNo value reports for this field in the ASGT Extract.

N/A

Animal Systems AssessmentNo value reports for this field in the ASGT Extract.

N/A

Plant System AssessmentNo value reports for this field in the ASGT Extract.

N/A

Kansas English Language Proficiency Assessment (KELPA)
No value reports for this field in the ASGT Extract.

N/A

KELPA Proctor IDNo value reports for this field in the ASGT Extract.

N/A

KELPA Proctor NameNo value reports for this field in the ASGT Extract.

N/A

KELPA Proctor Last Name
No value reports for this field in the ASGT Extract.

N/A

Individual Plan of StudentNo value reports for this field in the ASGT Extract.N/A

User Field 1 

N/A

N/A 

User Field 2 

N/A 

N/A 

User Field 3 

N/A 

N/A