KIDS Collection TASC
Teacher and Student Course
The TASC extract is used to collect a teacher and student connection for use in creating rosters in other applications, i.e., K-FIT, KITE, etc. The Kansas Collection TASC report will be used to submit data elements, based on the TASC collection cycle, to the Kansas Department of Education (KSDE) Kansas Individual Data on Students (KIDS) system. The TASC data collection focuses on providing links between the courses students take during the school year and the educators teaching the courses.
Selection Criteria
Exclude students from this report by setting the student's Exclude From State Reporting flag located on the State/Province - KS page. This extract replaces the STCO roster.
Required Data Setup
Review the Kansas State Reporting Guide and confirm that all required student and school information has been entered.
When running the TASC report the State Course Codes must be populated and it must be one of the following:
'01','02','51','52','80','81','82
(The report only pulls English and Math based on the requirements)
Roster Results
Student roster results are based on the term that is selected at run time (note: selecting an entire school year will only return courses that are assigned to that term.
Courses and Sections that are configured to be "Excluded From State Reporting" will not be listed.
Report Input
Select School(s) to Include.
Confirm that you are in the correct School Term (upper right corner of the screen).
Select Students to Include.
Select an As of Date to Include (current system date is the default).
Click Submit.
Report Output
This report is published if:
The student’s grade level is 0 through 12
The student's grade level is less than 0 or greater than 12, and the grade level override has IT, PR, or UG. If not, the student's grade level is extracted.
Each field in the report output is described below. See Understanding the Report Output Table for a definition of each column in the table.
Note: PowerSchool checks for [S_KS_STU_Demographic_X]Legal_First_Name, [S_KS_STU_Demographic_X]Legal_Last_Name, and [S_KS_STU_Demographic_X]Legal_Middle_Name to include in report output. If ALL three fields are blank then it checks for [STUDENTS]First_Name, [STUDENTS]Last_Name, and STUDENTS.Middle_Name to include in report output.
Field Ref | Data Element | Description | [Table]FieldName | Required | Max Length |
H1 - H6 | Header records | See KIDS Collection for more information. | |||
C1 | Record Type | The name of the file. | Always “TASC” | Y | 4 |
C2 | Student’s Accountability School Identifier | The unique number that has been assigned to the school building by the state and which is reporting the student and course. | [S_KS_STU_X]Accountability_School [Schools]Alternate_School_Number [Students]SchoolID | Y | 4 |
C3 | Students Legal Last Name | Students Last Name | [S_KS_STU_Demographic_X]Legal_Last_Name or [Students]Last_Name | Y | 60 |
C4 | Students Legal First Name | Students First Name | [S_KS_STU_Demographic_X]Legal_First_Name or [Students]First_Name | Y | 60 |
C5 | Students Legal Middle Name | Students Middle Name | [S_KS_STU_Demographic_X]Legal_Middle_Name or [Students]Middle_Name | N | 60 |
C6 | Students Generation Code | Students generation (i.e., Jr., Sr., III) | [S_KS_STU_Demographic_X]Generation_Code | N | 10 |
C7 | Students Gender | The gender of the student | [Students]Gender | Y | 1 |
C8 | Students Date of Birth | Birth date of the student | [Students]DOB | Y | 10 |
C9 | Current Grade Level | The grade level or primary instructional level at which a student enters and receives services in a school or an educational institution during a given academic session.
Note: The "Ungraded” code applies to adults students. An “adult” student is defined as either a general education student who is over the age of 18 and whose 5-year cohort (beginning his/her freshman year) has graduated, or any student over the age of 21. Students, age 22 and older as of 10/01/2023, must be submitted as grade level ‘UG’. | [S_KS_STU_X]Grade_Level [S_KS_REN_X]Grade_Level | Y | 2 |
C10 | Students Local ID | ID assigned to the student by the school | [Students]Student_Number | N | 20 |
C11 | Students Hispanic Ethnicity | Indicates whether or not the student is Hispanic | [Students]FedEthnicity | Y | 1 |
C12 | SSID | Student's state-assigned unique identification number. This number is provided by the KIDS Assignment System. | [Students]State_StudentNumber | Y | 10 |
C13 | School Year | The ending year of the current school year. | Calculated | Y | 4 |
C14 | Students Comprehensive Race | The student’s race is based on his or her own identification.
Valid values:
| [Students]RaceCD | Y | 5 |
C15 | State Subject Area Code | One of the defined Kansas Subject Area Codes. | [S_KS_CRS_X]State_Course_ID | Y | 2 |
C16 | State Course Identifier | One of the defined Kansas Course Identifiers | [S_KS_CRS_X]Local_Course_ID | Y | 3 |
C17 | Local Course ID | The unique identifier used by the school or district to identify an individual course | [Courses]Course_Number | Y | 50 |
C18 | Course Status | Indication of the student’s status in the course. 01 = Enrolled 99 = Record Submitted in Error Note: This field is calculated but can be overwritten by selecting one of the above values. | Calculated [S_KS_CC_X]Completion_Status | Y | 2 |
C19 | Educator Identifier | The unique number assigned to the teacher in the teacher licensure system. | [S_KS_CC_X]State_Teacher_Number_Override [S_KS_USR_X]State_Teacher_Number | Y | 10 |
Educator Identifier Override | Populate this field if the Educator Identifier needs to be overridden. If the field is blank, then the Educator Identifier will be reported. | N | 10 | ||
C20 | Educator’s Last Name | The last name of the Educator | [Users]Last_Name | Y | 60 |
C21 | Educator’s First Name | The first name of the Educator | [Users]First Name | Y | 60 |
C22 | Educator’s Middle Name | The middle name of the Educator | [Users]Middle_Name | N | 60 |
C23 | Educators District Email Address | The email address assigned to the educator by the school district. | [Users]Email_Addr | Y | 100 |
C24 | User Field 1 | Field available to the data extractor. This field may contain any data (except the “delimiter character” defined in the header record). The field must exist in the extract file. | [S_KS_STU_X]UserField_1 | R | 500 |
C25 | User Field 2 | Field available to the data extractor. This field may contain any data (except the “delimiter character” defined in the header record). The field must exist in the extract file. | [S_KS_STU_X]UserField_2 | R | 500 |
C26 | User Field 3 | Field available to the data extractor. This field may contain any data (except the “delimiter character” defined in the header record). The field must exist in the extract file. | [S_KS_STU_X]UserField_3 | R | 500 |
T1 - T3 | Trailer Records | See KIDS Collection for more information. |