Skip to main content
Skip table of contents

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

 [Table] Field Name 

 

Business Rules

StudentUniqueId 

State Identifier 

Required 

[Students]State_StudentNumber 

 Not applicable.

SchoolId  

School Number 

Required

[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

[S_KS_STU_X]School_Entry_Date 

[S_KS_REN_X]School_Entry_Date 

 

 Not applicable.

EntryGradeLevelDescriptor 

Grade 

Required

[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 

[S_KS_STU_X]exit_date 

Not applicable.  

ExitWithdrawTypeDescriptor 

 

Optional 

[S_KS_STU_X]exit_type 

Not applicable.

Extension.LocalEducationAgencyEntryDate 

District Entry Date 

Required

[S_KS_STU_X]District_Entry_Date 

[S_KS_REN_X]District_Entry_Date 

 

 Not applicable.

Extension.StateEntryDate 

State Entry Date 

Required

[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 

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.