KIDS Collection KCAN

Introduction

The Kansas Collection KCAN report is used to submit data elements, based on the KCAN collection cycle, to the Kansas Department of Education (KSDE) Kansas Individual Data on Students (KIDS) system. The KCAN data collection focuses on collecting the course outcomes in accordance with the State Board initiatives.

This report generates course completion information for each student, including the grade received. The school or district must include all K-12 students who have received a course outcome from an educator who is assigned to that course in the Educator Data Collection System (EDCS). Data must be current as of the last day of the course grading period. By sending a KCAN Record, a link is established to provide an educator, course, and student link.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to the selection criteria for analysis when the report does not return the correct records.

Course Selection

The report selects records from the [Students], [Courses], [Sections] and [StoredGrades] table based on the following criteria:

The student is classified as one of the following:
- All Students in grades 07-12, and UG
- a migrant student
- a student who has completed Pathways Courses
- a Virtual Education student age 19 and over on or before September 20
- a student who has completed CTE Certifications
- a student who has taken History/Government assessments
The student has courses and sections assigned.
The College/Career for CTE pathway identification should be equal to 'N', 'T', F',' C', 'L',' X', 'D', 'R'
The student received a grade.
The student must not be excluded from state reporting.
The school must not be excluded from state reporting.
The course must not be excluded from state reporting.
For Pathways Courses:
- the student’s technical education minutes must be greater than zero
- submit only where the KCC Identifier field ends in F, C, L, or X.

Note: This report currently doesn't support migrant students who attended summer school.

Required Data Setup

If the sequence override for sections and/or courses is not going to be used, then the Kansas State Term Store code Mapping must be set up for each school for each calendar year.

Running the Report

Select Students to Include.
Report Period Start Date and Report Period End Date are used to process class enrollments within these dates. By default, these dates are set to the start and end date of the selected term.
Enter the store codes to be included, separated by commas. (i.e., Q1,Q2,S1). Leave blank for all store codes to be included.
Enter the courses to be included, separated by commas. Leave blank for all courses to be included.
Enter the sections to be included, separated by commas. Leave blank for all sections to be included.
Click Submit.

Completion Status will be calculated based on the "Completed Pass Letter Grades" and "Completed Fail Letter Grades" entered for each school on the Schools/Schools Info page (District>District>Schools/Schools Info).

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools	When run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Current Selection Students	Indicate which students to include in the report by selecting one of the following options: The Selected [number] Students Only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running the report.
Select Reporting Year*	Select the reporting year.
Reporting Period Start Date*	Enter the reporting period start date.
Reporting Period End Date*	Enter the reporting period end date.
KCAN Store Codes	Enter the store codes separated by a comma or leave blank for all store codes.
KCAN Course Numbers	Enter specific course number(s) separated by a comma or leave blank for all courses. Every student in the selected course(s) will process.
KCAN Section Numbers	Enter specific section number(s) separated by a comma or leave blank for all sections. Every student in the selected section(s) will process.
Courses to Include	Select the courses you want to include in the report: All Regular Courses Certificate Courses
Print Report Headers Do not print headers for final submission to state	Choose Yes or No from the pop-up menu. The default is No.

Back to Top

Report Output

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.
F1	Record Type	The name of the file.	Always “KCAN”	Yes	4
F2	Student’s School Identifier	The unique number of the school in which the student is included for accountability purposes.	[S_KS_STU_X]Accountability_School [S_KS_REN_X]Accountability_School [Schools]Alternate_School_Number [Students]SchoolID	Yes	4
F3	Student's Legal Last Name	The student's last name.	[S_KS_STU_Demographic_X]Legal_Last_Name or [Students]Last_Name	Yes	60
F4	Student's Legal First Name	The student's first name.	[S_KS_STU_Demographic_X]Legal_First_Name or [Students]First_Name	Yes	60
F5	Student's Legal Middle Name	The student's middle name.	[S_KS_STU_Demographic_X]Legal_Middle_Name or [Students]Middle_Name	No	60
F6	Student's Generation Code	The student's generation (i.e., Jr., Sr., III).	[S_KS_STU_Demographic_X]Generation_Code	No	10
F7	Student's Gender	The student's gender.	[Students]Gender	Yes	1
F8	Student's Date of Birth	The student's date of birth.	[Students]DOB	Yes	10
F9	Current Grade Level	The student's grade level. Valid values: IT = Infant Toddler PR = PreSchooler KG = Kindergarten 01 through 12 UG = Ungraded Notes: Infant/Toddler must be 0-2yrs on or before August 31st. Preschool student must be 3 or 4 years old on or before August 31st of the Current school year.	[S_KS_STU_X]Grade_Level [S_KS_REN_X]Grade_Level [Students]Grade_Level	Yes	2
F10	Student's Local ID	The ID assigned to the student by the school.	[Students]Student_Number	No	20
F11	Student's Hispanic Ethnicity	An indicator of whether or not the student is Hispanic.	[Students]FedEthnicity	Yes	1
F12	SSID	The unique number assigned to the student by the KIDS Assignment System.	[Students]State_StudentNumber	Yes	10
F13	School Year	The ending year of the current school year. Format: YYYY	Calculated	Yes	4
F14	Students Comprehensive Race	The student’s race, based on his or her own identification. Position 1 – American Indian or Alaska Native Position 2 – Asian Position 3 – Black or African American Position 4 – Native Hawaiian or Other Pacific Islander Position 5 – White Valid values: 0 – No 1 – Yes	[StudentRace]RaceCd	Yes	5
F15	Virtual Education Student	An indicator of whether the student is participating in virtual education that is approved for state funding. Valid values: 0 – Student is not a Virtual Education Student and has not been during the current school year. 1 – Student is currently a Virtual Education Student. 2 – Student is not currently a Virtual Education Student, but has been at some point during the current school year. Note: Level must be IT, PR, KG, 01-12, or UG.	[S_KS_STU_X]Virtual_Education	Yes	1
F16	Migrant Student	Indicator of whether the student is a migrant student receiving migrant services at the time the course information is submitted to KSDE. Valid values: 0 – No 1 - Yes Note: If KCC Identifier equals MigrantServices, then Migrant Student must equal "1".	[S_KS_STU_Demographic_X]Migrant_Status [Students]Migrant_status	Yes	1
F17	Single Parent Student	Indicator of whether the student is a single parent at the time the course information is submitted to KSDE. Valid values: 0 – No 1 - Yes Note: This data is only required for students enrolled in CTE Pathways courses.	[S_KS_STU_X]Single_Parent	No	1
F18	Term	The term in which the course was taken.	[StoredGrades]Term_Name See KIDS Collection KCAN#Store Code Mapping section below.	Yes	2
F19	KCC Identifier	This KCC identifier includes all the course attributes indicated for the individual course during the mapping process in KCCMS. It is a combination of several fields combined to make one number.	Derived based on multiple data elements. If Course Status equals 70, "HistoryGovScore" is reported. If Course Status equals 90, "Certificate" is reported Otherwise, see the KIDS Collection KCAN#KCC Identifier Logic section below.	Yes	17
F20	Course Section	The unique identifier assigned by the school that refers to an individual section.	[Courses[Course_Number + [Sections]Section_Number + Term_Name Notes: If KCC Identifier equals HistoryGovScore, then "HistoryGovScore" is reported. If KCC Identifier equals Certificate, then "Certificate" is reported. If KCC Identifier equal MigrantServices, then "MigrantServices" is reported.	Yes	30
F21	Local Course ID	The unique identifier used by the school or district to identify an individual course.	[S_KS_CRS_X]LocalCourseId [Courses]Course_Number Notes: If [S_KS_CRS_X]LocalCourseId is blank then extract from [Courses]Course_Number If KCC Identifier equals HistoryGovScore, then "HistoryGovScore" is reported. If KCC Identifier equals Certificate, then "Certificate" is reported. If KCC Identifier equal MigrantServices, then "MigrantServices" is reported.	Yes	50
F22	Course Status	An indication of the student’s status in the course. Valid values: 00 - Enrolled (Migrant Only) 01 - Completed (Pass) 02 - Completed (Fail) 04 - Exited before course completion (Migrant only) 05 - Incomplete (Disabled) 80 - Received Services (Summer Migrant only) 90 - Certificate Earned (CTE Certification only) 99 - Record Submitted in Error	Calculated [S_KS_CC_X]Completion_Status Notes: If blank, the default value of “00” is reported. If the student received a grade and the grade is among the school setup completion and passing grades [S_KS_SCH_X]Completed_Pass, “01” is reported. If the student received a grade from the class and the grade is among the school setup completion and fail grades [S_KS_SCH_X]Completed_Fail, “02” is reported. If the student earned a CTE Certification, "90" is reported. Records with a Course Status of ’00 = Enrolled’ or ’04 = Exited before course completion (Migrant only)’ will only be accepted for records submitted with Migrant Student = ‘1’. Records with a Course Status of ’80’ = Received Services (Summer Migrant only) will only be accepted for records submitted with a value of ‘MigrantServices’ in KCC Identifier. Records with a Course Status of ’90’ = Certificate Earned will only be accepted for records submitted with a value of ‘Certificate’ in the KCC Identifier.	Yes	2
F23	Letter Grade	The categorical letter grade achieved as of the end of the course.	[StoredGrades]Grade	No	2
F23	Letter Grade Override	Populate this field if the Letter Grade needs to be overridden. If the field is blank, the stored letter grade will be reported. Note: If Standard-based grades will be used, a letter grade must be entered in this field or a percent grade must be specified in the Percent Grade Override field in order to report the Standard grade.	[S_KS_CC_X]Letter_Grade_Override	No	2
F24	Percent Grade	The percent achieved as of the end of the course from 0 to 100%. Note: If decimals are entered, any data after the decimal will not be reported.	[StoredGrades]Percent	No	4
F24	Percent Grade Override	Populate this field if the Percent Grade needs to be overridden. If the field is blank, the stored percent grade will be reported. Note: If Standard-based grades will be used, a percent grade must be entered in this field or a letter grade must be specified in the Letter Grade Override field in order to report the Standard grade.	[S_KS_CC_X]Percent_Grade_Override	No	2
F25	Work-based Learning	This field indicates a Work-based Learning course when the KCC ID (F19) is present. Valid values: • 00 = Not work-based course. • 02 = Internship/placement (business/industry/community) • 03 = Youth registered apprenticeship • 04 = Simulated work-based experience (school district) • 05 = Entrepreneurship/ownership • 06 = Service learning Note : If KCC Identifier is not ‘Certificate’ or ‘MigrantServices’ then Work-based Learning is required.	[S_KS_CRS_X]Work_Based_Learning	No	2
F26	College Credits Earned	The number of college credits earned for the dual credit course.	[S_KS_CRS_X]CollegeCredits [S_KS_CC_X]CollegeCredits	No	2
F27	CTE Certification Earned	The code associated with the CTE certification earned by the student during the current school year. Note: If KCC Identifier equals Certificate, then this field must not be blank.	[S_KS_STU_CTECertification_C]CertCode	No	4
F28	Date Earned	The date on which the student earned the CTE certification. Note: If KCC Identifier equals Certificate, then this field must not be blank.	[S_KS_STU_CTECertification_C]DateEarned	No	10
F29	Graduation Year	The school year during which the student has or will graduate from high school. For example, if it is the 2024-2025 school year, enter 2025. Note: Graduation year must be between 2024-2029 Note: If KCC Identifier equals Certificate, then this field must not be blank.	[S_KS_STU_GRAD_X]Graduation_Year	No	11
F30	First Instruction Date	The first day a migrant student received instruction during the current school year. Note: This field only populates if the student's Migrant Status is 1 and the KCC Identifier is not "Certificate". Otherwise, the field is blank.	[Students]EntryDate [S_KS_STU_Demographic_X]Migrant_Status [Students]Migrant_status	Yes	10
F31	Last Instruction Date	The last day a migrant student received instruction during the current school year. Note: This field only populates if the student's Migrant Status is 1 and Course Status is ‘01’, ‘02’, or ‘04’. Otherwise, the field is blank.	[Students]ExitDate [S_KS_STU_Demographic_X]Migrant_Status [Students]Migrant_status	No	10
F32	Instructional Minutes Completed	The number of instructional hours the migrant student completed during the term. Note: This field only populates if the student's Migrant Status is 1 and Course Status ‘04’ = Exited before course completion. Otherwise, the field is blank.	Calculated [S_KS_STU_Demographic_X]Migrant_Status [Students]Migrant_status	No	N/A
F33	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.	[S_KS_STU_X]UserField_1	No	500
F34	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.	[S_KS_STU_X]UserField_2	No	500
F35	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.	[S_KS_STU_X]UserField_3	No	500
T1 - T3	Trailer Records	See KIDS Collection for more information.	N/A	N/A	N/A

Back to Top

KCC Identifier Logic

The KCC Identifier is constructed using several data elements concatenated together in a string of 7 characters length as shown in the table below.

KCC Identifier Fragments	Extract Logic	[Table]FieldName
State Subject Area Code	Direct Value from C17. State Subject Area	[S_KS_CRS_X]State_Subject_Area
State Course Identifier	Direct Value from C18. State Course Identifier. Note: State Course Identifier can have a maximum of 3 alphanumeric characters.	[S_KS_CRS_X]State_Course_ID
Course Level	Direct Value from C7. Course Level	[S_KS_CRS_X]Course_Level
Credits	If Course Credit Hours Override is not Null, then extract Course Credit Hours Override Else extract Credit Hours	[S_KS_CRS_X]Course_Credit_Hours_Ovrd OR [Courses]Credit_Hours
Sequence	If Section.Sequence (Override) is not 0 or null, then extract Section.Sequence (Override) Else extract Direct Value from C9. Sequence	[S_KS_SEC_X]Seq_Override OR [S_KS_CRS_X]Course_Sequence
Sequence Total	If Section.Sequence_Total (Override) is not 0 or null, then extract Section.Sequence_Total (Override) Else extract Direct Value from C10. Sequence Total	[S_KS_SEC_X]Seq_Total_Override OR [S_KS_CRS_X]Sequence_Total
Grade Level (course)	Direct Value from C11. Course Level	[S_KS_CRS_X]KCC_Grade_Level
Targeted Program	Direct Value from C12. Targeted Program	[S_KS_CRS_X]Target_Program
Delivery Type	Direct Value from C13. Delivery Type	[S_KS_CRS_X]Delivery_Type
College/Career	Direct Value from C14. College/Career	[S_KS_CRS_X]College_Career_Credits

Example, KCC Identifier = 02052G0.501214GGN is constructed as shown in the table below.

02	052	G	0.50	1	2	14	G	G	N
State Subject Area Code	State Course Identifier	Course Level	Credits	Sequence	Sequence Total	Grade Level (course)	Targeted Program	Delivery Type	College/ Career

Store Code Mapping

The KCAN Extract has a StoreCode mapping that must be completed each year, for each school in the district. With the mapping in place, there is no longer the need to populate the Course Term Type and Count fields.

To map a school's term and store codes:

Go to District Office > District > Schools/School Info page and select a school.
Under the Other Information section, click the store code mapping link named, "Kansas Term StoreCode Mapping". Each school in the district is listed. You will now be able to add, edit, or delete the Term StoredCode mappings.
1. To add a new mapping, select New and enter the Term Name and Store Codes.
2. To edit the mapping, select an existing item and update the Term Name and Store Codes.

Important: Store Codes must be entered one at a time.

For example, the school has:

Year-long courses with year-long sections
- The Term Name for the year is 2018-2019 (for the 2018/2019 school year) and the Store Code may be YR.
Year-long courses with semester-long sections
- The Term Name maybe 2018-2019 (for the 2018/2019 school year) with a Store Code of S1. Select Submit.
- Then add a Term ID of 2800 with a Store Code of S2. Select Submit.
Year-long courses with quarter-long sections
- the Term Name would be 2018-2019 (for the 2018/2019 school year) with a Store Code of Q1. Select Submit.
- Add a Term Name of 2800 with a Store Code of Q2. Select Submit.
- Add a Term Name of 2800 with a Store Code of Q3. Select Submit.
- Add a Term Name of 2800 with a Store Code of Q4. Select Submit.
Semester-long courses with semester-long sections
- Semester 1 (Semester 1 for 2018/2019 school year) courses would have Term Name of Semester 1 and a Store Code of S1. Select Submit.
- Semester 2 courses would have a Term Name of Semester 2 and a Store Code of S2. Select Submit.

To edit a mapping:

On the District Office > District > Schools/School Info page, click the Kansas Term Store Code Mapping link.
Select a school, then select Kansas Term Storecode Mapping.
Select the applicable term and edit the Store Code.
Click Submit.

To delete a mapping:

On the District Office > District > Schools/School Info page, click the Kansas Term Store Code Mapping link.
Select a school, then select Kansas Term Storecode Mapping.
Select the applicable term and click Delete.
Click Submit.

Note: In rare cases, the Term Store Code Mapping may not work for a school. If this happens, select the Use the sequence field on the Section or on the Course checkbox; the KCAN report will bypass any Term Store Code Mapping that has been set up and use the Sequence and Sequence Total Override fields that are located at the bottom of the School > School Info > Selected School > Sections page. If these override fields are blank, the report will use the current values in the C9/C10 Sequence/Sequence Total Override fields, which are located on the School > School Info > Selected School > Courses page.

Alignment of KCCMS and KCAN Extracts

Courses that Span Multiple Terms

Every attempt should be made to align your course catalog with the mapping in Kansas Course Code Mapping System (KCCMS); however, not every school creates a schedule based on separate courses for separate terms. Many schools use a single course for the year, then differentiate and report credit and grades through the use of individual sections per term. In this case, KCCMS must be mapped to specify the full sequence of a course.

For example:

English II is a full-year course but is awarded credit, graded, and reported by semester; therefore, two records exist in KCCMS for English II:

English II, Semester 1 would be Sequence 1 of 2, and
English II, Semester 2 would be Sequence 2 of 2

Your local course number (the PowerSchool course number) is entered in the Course Identifier field in KCCMS with the appropriate sequencing as mentioned above. You will need to differentiate separate KCCMS records by placing an appropriate remark, such as "Sem1" for Semester 1 and "Sem2" for Semester, in the KCCMS Descriptor field 2.

In PowerSchool, you have only one course and course number. The credit you award is set according to your school's scheduling requirements and the KCC sequencing is set to 1 of 1 (indicating that it is a year-long course or multiple term course).

Navigate to your course’s “Edit Course” page (District > Courses > Course Number) and set the Course Term Type – [S_KS_CRS_X]Course_Term_Type and Term – [S_KS_CRS_X]Course_Term_Total fields using the Course Term Type and Count pop-up menu at the bottom of the Kansas Course Code Information section. These are set as follows:

The first drop-down box sets the KS_KCC_Term field. This determines how the course is graded. The second drop-down box sets the KS_KCC_Term_Total field and determines the correct sequencing:

Set 1^st Dropbox to:	AND set 2^nd Dropbox to:	Credit awarded and Sequencing will be reported as:
(QTR) Quarter	4	Fourths (0.25): 1 of 4, 2 of 4, 3 of 4, 4 of 4
(SEM) Semester	2	Halves (0.50): 1 of 2, 2 of 2
(TRI) Trimester	3	Thirds (0.33): 1 of 3, 2 of 3, 3 of 3
(FY) Full Year	1	Full (1.00): 1 of 1

Note: Term Abbreviations are the driving factor for this solution. Therefore, Term Abbreviations need to follow the desired sequencing pattern for this solution to work. For example:

Term	Set Term Abbreviation To
Semester 1	S1
Semester 2	S2
Trimester 1	T1
Trimester 2	T2
Trimester 3	T3
Quarter 1	Q1
Quarter 2	Q2
Quarter 3	Q3
Quarter 4	Q4
Year	Y1

Separate Courses for Each Term and Courses that Do Not Span Multiple Terms

If a school has separate courses for each term in both PowerSchool and in the KCCMS, no change is needed. These schools should continue to use the available Kansas Collection fields to identify and report course sequencing as normal. The fields Course Term Type – [S_KS_CRS_X]Course_Term_Type and Count – [S_KS_CRS_X]Course_Term_Total should remain blank. Courses should be aligned and mapped the same way in KCCMS; a one-to-one relationship exists and the KCAN report will extract correctly, reporting both credit and sequencing as in the Credit and KCC Sequence fields.

The pop-up menu will be unpopulated (left blank) for all courses that do not span multiple terms. This allows the Kansas Collection to credit and sequence the course according to the normal KCC settings.

Note: While you gain the ability to retain your school’s normal scheduling procedures, through the use of these fields your ability to directly import/export from PowerSchool into KCCMS is diminished. You will have to manually modify any Kansas CourseWalk export from PowerSchool before import into KCCMS.

[data-colorid=a1e9pvpw5i]{color:#202124} html[data-color-mode=dark] [data-colorid=a1e9pvpw5i]{color:#dbdcdf}Introduction