Student Education Organization Association | PowerSchool SIS Compliance

This association represents student information as reported in the context of the student's relationship to the education organization. Enrollment relationship semantics are covered by StudentSchoolAssociation.

Selection Criteria

Not excluded from state reporting 
The studentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The student's school of enrollment must not be excluded from state reporting.
The student must have at least one school enrollment with an Entry Date that falls within the date range defined by [Terms]FirstDay and [Terms]LastDay for the year of the Term selected in the PowerSchool UI.
The enrollment exit date is greater than the entry date.
Student Demographics Record will be published for each enrollment(current/previous). If enrollments(current/previous) is in the same school more than once, then publish the latest of that school.

Dependencies

Students, Organization Catalog (Schools) and StudentSchoolAssociation

Data Review

Field	Selection
Dashboard Description	Publish Student Education Organization Association record(s). This is student demographic information.
Choose Category	Student Education Organization Association Info Summary Student Education Organization Association Info Published Student Education Organization Association Info Dependencies Student Education Organization Association Info Errors
Choose Data view	Student Education Organization Association

Resource Output

LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Optional" button).
Publishes a record for each student and section (class).

Note:

Click Export to export the data collection results to an Excel spreadsheet.
See the Data Publishing > Published Resource > Resource Details to view the data elements that are not available in the Data View Column.

Ed-Fi Data Element	Description	Data View Column	Submission	[Table] Field Name	Business Rules
EducationOrganizationId	A unique identifier assigned to an education organization, such as a school or district.	Ed Org Id	Y	[S_KS_STU_X]Accountability_School [S_KS_REN_X]Accountability_School [S_KS_STU_X]Funding_School [S_KS_REN_X]Funding_School [S_KS_STU_X]Attendance_School [Schools]School_Number	If [S_KS_STU_X]Accountability_School null [S_KS_REN_X]Accountability_School Else if [S_KS_STU_X]Funding_School null [S_KS_REN_X]Funding_School Else if [S_KS_STU_X]Attendance_School [S_KS_REN_X] Attendance_School else [Schools]School_Number   Format: ttbbbdddd
StudentUniqueId	A unique identifier assigned to each student within the education system.	State Student Number	Y	[Students]State_StudentNumber
Address.AddressTypeDescriptor	A description of the type of address (e.g., home, mailing, work).	Address Type	Y	Hardcoded	Use Home as default value as per descriptor
Address.StateAbbreviationDescriptor	The abbreviation of the state in which the address is located.	Address Abbreviation	Y	Hardcoded
Address.City	The city in which the address is located.	City	Y	[S_KS_STU_X]Transport_City
Address.PostalCode	The postal code of the address.	Zip	Y	[S_KS_STU_X]Transport_Zip
Address.StreetNumberName	The street number and name of the address.	Street Address	Y	[S_KS_STU_X]Transport_Address
HispanicLatinoEthnicity	An indication of whether the student is of Hispanic or Latino ethnicity.	Hispanic Ethnicity	Y	[Students]FedEthnicity
Language.LanguageDescriptor	A description of the language spoken by the student (e.g., English, Spanish).	First Language	Y	[S_KS_STU_ELL_X]First_Language
Race.RaceDescriptor	A description of the student's race (e.g., Asian, Black or African American).	Race	Y	[StudentRace]RaceCd
Sex.Descriptor	A description of the student's sex (e.g., male, female).	Sex	Y	[Students]Gender
StudentIdentificationCode.StudentIdentificationCodes	A list of identification codes assigned to the student.	Student ID	Y	[Students]Student_Number [Students]State_StudentNumber	If [Students]Student_Number is null pull Student[State_StudentNumber]
StudentIdentificationCode.StudentIdentificationSystemDescriptor	A description of the system used to assign the student identification code (e.g., state, district).	Student ID Codeset	Y	Derived from: [Students]Student_Number [Students]State_StudentNumber	If [Students]Student_Number not null then publish District Else if Student[State_StudentNumber] not null publish State
StudentIdentificationCode.AssigningOrganizationIdentificationCode	The identification code of the organization that assigned the student identification code.	Student Org ID	Y	Calculated	Org Id + District Format: ttddd
Extension.DistrictOfResidence	The district in which the student resides.	Residence District Identifier	N	[Students]DistrictOfResidence [ReEnrollments]DistrictOfResidence	If [Students]DistrictOfResidence Null then [ReEnrollments]DistrictOfResidence
Extension.MilitaryConnectedStudentDescriptor	A descriptior of the student's connection to the military (e.g., active duty, veteran).	Military Connected Student Indicator	N	[S_KS_STU_Demographic_X]Military_Family	For value 1, submit a Codevalue Active Duty ▪ For value 2, submit a Codevalue National Guard Or Reserve
Extension.ImmigrantStudentDescriptor	A description of the student's immigrant status.	Immigrant Student	N	[S_KS_STU_Demographic_X]Immigrant_Status	For value 1, submit a Codevalue Yes, and receiving Title III Immigrant Services For value 2, submit a Codevalue Yes, not receiving Title III Immigrant Services
Extension.NeglectedDelinquentStudentDescriptor	A description of the student's status as neglected or delinquent.	Neglected Student	N	[S_KS_STU_X]Neglected_Student	▪ For value 1, submit a Codevalue Neglected student currently served ▪ For value 2, submit a Codevalue Neglected student not currently served ▪ For value 3, submit a Codevalue Neglected student not receiving Title I services
CTE.CTECertificationEarnedDescriptor	A description of the certification earned by the student in a Career and Technical Education (CTE) program.	CTE Certification Earned	Y	[S_KS_STU_CTECertification_C]CertCode
CTE.CertificationTermDescriptor	A description of the term during which the CTE certification was earned.	CTE Certification Term Descriptor	N	[Terms]Term_Name	The certification date earned will be based on ranks: first is quarter, next is semester, last is year-long. If a Quarter exists and the Certification date earned is within that Quarter, then the related Quarter (Q1, Q2, etc.) will be published. If only a Semester exists, and the Certification date earned is within that Semester, then the related Semester (S1, S2, etc.) will be published.
CTE.CTECertificationDateEarned	The date on which the CTE certification was earned.	CTE Date Earned	N	[S_KS_STU_CTECertification_C]DateEarned	Term in which CTE certification is earned that term should be reported. Term is Derived.
CTE.Sched_YearOfGraduation	The year in which the student is expected to graduate from the CTE program.	Graduation Year	N	[S_KS_STU_GRAD_X]Graduation_Year
KSAtRiskEligibilities.ksAtRiskEligibility Descriptor	This field collects students' eligibility criteria for being indicated At-Risk. Multiple values can be uploaded, and this field uses the KSAtRiskEligibilityCriteriaDescriptor to populate values. Note: The descriptor must be downloaded.	Kansas At-Risk Program Participation	Y	[S_KS_STU_X]K12_Program_Participation	Only Option fields with a value “Yes” will be published. Option fields mapping: Not working on academic grade level = Not working on academic grade level Not meeting req. for promotion/failing course = Not meeting the requirements necessary for promotion to the next grade; is failing subjects or courses of study. Not meeting req. for graduation from High School = Not meeting the requirements necessary for graduation from high school (e.g., potential dropout) Not meeting state standards = Has insufficient mastery of skills or is not meeting state standards. Has been retained = Has been retained. Has high rate of absenteeism = Has high rate of absenteeism. Has repeated suspensions or expulsions from school = Has repeated suspensions or expulsions from school. Qualifies for homeless and/or migrant = Qualifies for homeless and/or migrant. Identified as an English Language Learner = Identified as an English Language Learner Has needs that cause student to be unsuccessful = Has social emotional needs that cause a student to be unsuccessful in school. Identified as student with dyslexia = Is identified as a student with dyslexia or characteristics of dyslexia. Foster care student or in custody = Is a foster care student or otherwise in the custody of the secretary for children and families.
PRAtRiskEligibilities.prAtRiskEligibilityDescriptor	This field collects students eligibility criteria for being indicated At-Risk. Multiple values can be uploaded, and this field uses the PRAtRiskEligibilityCriteriaDescriptor to populate values. Note: The descriptor must be downloaded.	Preschool-Aged At-Risk Program Participation	Y	[S_KS_STU_X]PREKG_Program_Participation	Only Option fields with a value “Yes” will be published. Option fields mapping: Poverty, student qualifies for FREE meals = Poverty – student qualifies for FREE meals under the National School Lunch Program Single Parent Family = Single Parent Family Kansas DCF referral = Kansas Department for Child and Families DCF referral Teen Parent = Teen Parent Either parent is lacking a HS diploma or GED = Either parent is lacking a high school diploma or GED Limited English Proficiency = Limited English Proficiency Delayed but not eligible for IEP = Developmentally or academically delayed based on validated assessments, but not eligible for IEP. Child qualifying for Migrant status = Child qualifying for Migrant status. Child experiencing homelessness = Child experiencing homelessness
Transportation.MilesTransported	The number of miles the student is transported to and from school.	Miles Transported	N	[S_KS_STU_X]Miles_Transported
Transportation.TransportationFTE	The full-time equivalent (FTE) of transportation services provided to the student.	Transportation FTE	N	[S_KS_STU_X]Transport_FTE
StudentCharacteristic.StudentCharacteristicDescriptor	A description of the student's characteristics (e.g., gifted, special education).	Student Characteristic Descriptor	Y	Below fields are mapped to StudentCharacteristicDescriptor which is an array. If all are populated, then all will be published. This is a required element, only mentioned values in rules columns will be sent. If there are other values or blank, then no value will be sent.
		Gifted Student Indicator	Y	[S_KS_STU_X]Gifted_Student	Only students with a Gifted Student Indicator = GI should be submitted. StudentCharacteristicDescriptor Codevalue = Gifted Student.
		Primary Disability Indicator	Y	[S_KS_STU_X]Primary_Disability	Only students with a Primary Disability Indicator = WD should be submitted. StudentCharacteristicDescriptor Codevalue = IEP Student.
		Special Circumstances Transfer Choice	Y	[S_KS_STU_X]Special_Circumstances _Transfer_Choice	Only students with a Special Circumstances Transfer Choice values > 0 should be submitted. StudentCharacteristicDesriptor Codevalue = Special Circumstances Transfer Choice Student.
		Truant Student	Y	[S_KS_STU_X]truant_Override	Only students with a Truant Student value of 1 (Yes) should be submitted. StudentCharacteristicDesriptor Codevalue = Truant.
		Concurrent High School Enrollment	Y	[S_KS_STU_X]Concurrent_School	Only students with a Concurrent High School Enrollment value of 1 (True) should be submitted. StudentCharacteristicDesriptor Codevalue = Concurrent High School Enrolled Student.
		Part-Time Virtual Education	Y	[S_KS_STU_X]Virtual_Education	Only students with a Virtual Education Student value > 0 should be submitted. For value 1 or 2, submit StudentCharacteristicDescriptor Codevalue = Virtual Education Student. For value 4, submit StudentCharacteristicDescriptor Codevalue = Part-Time Virtual Education Student
		Single Parent	Y	[S_KS_STU_X]Single_Parent	Only students with a Student is a Single Parent value of 1 (Yes) should be submitted. StudentCharacteristicDescriptor Codevalue = Single Parent.
		Dropout Diploma Completion Virtual Student	Y	[S_KS_STU_X]Dropout_Diploma_Virtual	Only students with a Student is a Dropout Diploma Completion Virtual Student value of 1 (Yes) should be submitted StudentCharacteristicDescriptor Codevalue = Dropout Diploma Completion Virtual Student
		Migrant Student	Y	[S_KS_STU_Demographic_X]Migrant_Status [Students]Migrant_status	If [S_KS_STU_Demographic_X]Migrant_Status null, then [Students]Migrant_status Only students with a Migrant Student value of 1 (Yes) should be submitted StudentCharacteristicDescriptor Codevalue = Migrant
		Community Service Postsecondary Asset	Y	[S_KS_REN_X]COMM_SERV_POSTSEC_ASSET [S_KS_STU_X]COMM_SERV_POSTSEC_ASSET	Only students with a Community Service Postsecondary Asset value of 1 (Yes) should be submitted StudentCharacteristicDescriptor Codevalue = 40+ Hours Community Service Postsecondary Asset
		Two or More High School Athletics/Activities Postsecondary Asset	Y	[S_KS_REN_X]ATHL_ACT_POSTSEC_ASSET [S_KS_STU_X]ATHL_ACT_POSTSEC_ASSET	Only students with a Two or More High School Athletics/Activities Postsecondary Asset value of 1 (Yes) should be submitted StudentCharacteristicDescriptor Codevalue = 2+ High School Athletics or Activities Postsecondary Asset
		Junior ROTC Postsecondary Asset	Y	[S_KS_REN_X] JNR_ROTC_POSTSEC_ASSET [S_KS_STU_X] JNR_ROTC_POSTSEC_ASSET	Only students with a Junior ROTC Postsecondary Asset value of 1 (Yes) should be submitted StudentCharacteristicDescriptor Codevalue = JROTC Postsecondary Asset
		Dyslexia Indicator	Y	[S_KS_REN_X]Dyslexia_Indicator [S_KS_STU_X]Dyslexia_Indicator	Only students with a value “Yes” must be submitted. StudentCharacteristicDescriptor Codevalue = Student Indicated with Dyslexia
		Open Enrollment Student	Y	[S_KS_STU_X]OPEN_ENR_STUDENT	Only students with an Open Enrollment value of 1 (Yes) should be submitted StudentCharacteristicDescriptor Codevalue = Open Enrollment Student

Descriptors

Mapping Method	Descriptor Name	Namespace	Code Value	Short Description	Description
Core	CalendarEventDescriptor	uri://ksde.org/CalendarEventDescriptor	Holiday	Holiday	Holiday
Core	CalendarEventDescriptor	uri://ksde.org/CalendarEventDescriptor	Instructional Day	Instructional Day	Instructional Day
Core	CalendarEventDescriptor	uri://ksde.org/CalendarEventDescriptor	Make-up Day	Make-up Day	Make-up Day
Core	CalendarEventDescriptor	uri://ksde.org/CalendarEventDescriptor	Other	Other	Other
Core	CalendarEventDescriptor	uri://ksde.org/CalendarEventDescriptor	Student late arrival/early dismissal	Student late arrival/early dismissal	Student late arrival/early dismissal
Core	CalendarEventDescriptor	uri://ksde.org/CalendarEventDescriptor	Staff Development or In-Service Day	Staff Development or In-Service Day	Staff Development or In-Service Day
Core	CalendarEventDescriptor	uri://ksde.org/CalendarEventDescriptor	Inclement Weather Day	Inclement Weather Day	Inclement Weather Day

TitleIPartAParticipantDescriptors

Descriptor Name	Namespace	CodeValue	ShortDescription	Description
TitleIPartAParticipantDescriptor	uri://ed-fi.org/TitleIPartAParticipantDescriptor	Private school students participating	Private school students participating	Private school students participating
TitleIPartAParticipantDescriptor	uri://ed-fi.org/TitleIPartAParticipantDescriptor	Public Schoolwide Program	Public Schoolwide Program	Public Schoolwide Program
TitleIPartAParticipantDescriptor	uri://ed-fi.org/TitleIPartAParticipantDescriptor	Public Targeted Assistance Program	Public Targeted Assistance Program	Public Targeted Assistance Program
TitleIPartAParticipantDescriptor	uri://ed-fi.org/TitleIPartAParticipantDescriptor	Was not served	Was not served	Was not served