Student School Association

StudentSchoolAssociation

This association indicates where the student is being served and for what reason, the enrollment begin and end dates, and various characteristics that apply to the specific enrollment period (such as the grade level or the membership).

Selection Criteria  

The school is Optionalt excluded from state reporting
The student is Optionalt excluded from state reporting
The school must have student EnrolledSchools
Enrollment Records in the current School Year.

Resource Input

Field	Selection
Choose Category	Enrollment info Summary Enrollment info Published Enrollment info Dependencies Enrollment info Errors
Choose Data View	Statistical Summary Student School

Resource Output

LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Optionalw" button).

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	Data View Column	Submission	PowerSchool Field	[Table] Field Name	Business Rules
StudentUniqueId	State Identifier	Required	Student Number Start Page > Student	[Students]State_StudentNumber	Not applicable.
SchoolId	School Number	Required	School Id  State/Province - KS > Demographics	[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 [Students]SchoolID [ReEnrollments]SchoolID	School Identifier format: ttdddbbbb Org Id is defaulted to D=14, if district needs another value to be published then district must append alphabet in their district number as per KSDE educationOrganizationID.
EntryDate	Entry Date	Required	Entry Date State/Province - KS > Demographics	[S_KS_STU_X]School_Entry_Date [S_KS_REN_X]School_Entry_Date	Not applicable.
EntryGradeLevelDescriptor	Grade	Required	Grade Level State/Province - KS > Demographics	[S_KS_STU_X]Grade_Level [S_KS_REN_X]Grade_Level [Students]Grade_Level	If [S_KS_STU_X]Grade_Level null Pull [S_KS_REN_X]Grade_Level else Pull [Students]Grade_Level
ExitWithdrawDate		Optional	Exit date State/Province - KS > Demographics	[S_KS_STU_X]exit_date	Not applicable.
ExitWithdrawTypeDescriptor		Optional	Exit type State/Province - KS > Demographics	[S_KS_STU_X]exit_type	Not applicable.
Extension.LocalEducationAgencyEntryDate	District Entry Date	Required	District Entry Date State/Province - KS > Demographics	[S_KS_STU_X]District_Entry_Date [S_KS_REN_X]District_Entry_Date	Not applicable.
Extension.StateEntryDate	State Entry Date	Required	State Entry Date State/Province - KS > Demographics	[S_KS_STU_X]State_Entry_Date	Not applicable.
Extension.MembershipDays		Optional		Calculated [PS_ADAADM_DEFAULTS_ALL] MEMBERSHIPVALUE	SUM(MEMBERSHIPVALUE) FROM PS_ADAADM_DEFAULTS_ALL FOR Extension.MembershipDays
Extension.AttendanceDays		Optional		Calculated [PS_ADAADM_DEFAULTS_ALL] ATTENDACEVALUE	ATTENDACE_DAY Derived from PS_ADAADM_DEFAULTS_ALL core table
Extension.MinutesEnrolled		Optional		[S_KS_STU_X]Minutes_Enrolled	Not applicable.
Extension.UnweightedGradePointAverage		Optional		Calculated Unweighted GPA	This pulls the unweighted GPA for each student, taking into account conditions on stored grades and certain grade levels. It then determines whether to use the calculated GPA or a default value of 1 based on the student's exit type. Finally, it retrieves the dcid of the student.
Extension.Qualifiedfor504Descriptor		Optional		[S_KS_STU_X]Qualified_504	Not applicable.
Extension.CTEContactMinutes		Optional		[S_KS_STU_X]tech_ed_minutes	Not applicable.
Extension.IndividualPlaOptionalfStudy		Optional		[S_KS_STU_X]INDIVIDUAL_PLAN_STUDY	Not applicable.
Extension. CreditsEarned		Optional		[S_KS_STU_X]HS_CREDITS_EARNED	Not applicable.
Extension. CreditsRequiredtoGraduate		Optional		[S_KS_STU_X]HS_CREDITS_GRADUATE	Not applicable.
Optionalt Publishing	Student Legal Name	Optional		Concatenate	[S_KS_STU_Demographic_X]Legal_Last_Name + [S_KS_STU_Demographic_X]Legal_First_Name