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.
Data Review
|
Field |
Selection |
|
Choose Category |
|
|
Choose Data View |
|
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 |
Description |
Data View Column |
Submission |
[Table] Field Name
|
Business Rules |
|
StudentUniqueId |
A unique identifier assigned to each student within the state. |
State Identifier |
Required |
[Students]State_StudentNumber |
Not applicable. |
|
SchoolId |
A unique identifier assigned to each school within the state. |
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 |
The date a student enrolls in a school. |
Entry Date/ First Instructional Date |
Required |
[S_KS_STU_X]First_INSTR_Date [S_KS_REN_X]First_INSTR_Date
|
Not applicable. |
|
EntryGradeLevelDescriptor |
The grade level at which a student enters the school. |
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 |
The date a student withdraws or exits from the school.
|
|
Optional |
[S_KS_STU_X]exit_date |
Not applicable. |
|
ExitWithdrawTypeDescriptor |
The reason or type of withdrawal or exit from the school. |
|
Optional |
[S_KS_STU_X]exit_type |
Not applicable. |
|
Extension.LocalEducationAgencyEntryDate |
The date a student first enrolls in the local education agency. |
District Entry Date |
Required |
[S_KS_STU_X]District_Entry_Date [S_KS_REN_X]District_Entry_Date
|
Not applicable. |
|
Extension.StateEntryDate |
The date a student first enrolls in the local education agency. |
State Entry Date |
Required |
[S_KS_STU_X]State_Entry_Date |
Not applicable. |
|
Extension.MembershipDays |
The number of days a student is a member of the school. |
|
Optional |
Calculated [PS_ADAADM_DEFAULTS_ALL] MEMBERSHIPVALUE |
SUM(MEMBERSHIPVALUE) FROM PS_ADAADM_DEFAULTS_ALL FOR Extension.MembershipDays |
|
Extension.MinutesEnrolled |
The total number of minutes a student is enrolled in school. |
|
Optional |
[S_KS_STU_X]Minutes_Enrolled |
Not applicable. |
|
Extension.Qualifiedfor504Descriptor |
Indicates whether a student qualifies for accommodations under Section 504 of the Rehabilitation Act. |
|
Optional |
[S_KS_STU_X]Qualified_504 |
Not applicable. |
|
Extension.CTEContactMinutes |
The number of minutes a student is engaged in Career and Technical Education (CTE) activities. |
|
Optional |
[S_KS_STU_X]tech_ed_minutes |
Not applicable. |
|
Extension.IndividualPlaOptionalfStudy |
Indicates whether a student has an individual plan of study. |
|
Optional |
[S_KS_STU_X]INDIVIDUAL_PLAN_STUDY |
Not applicable. |
|
Extension. CreditsRequiredtoGraduate |
The number of credits required for a student to graduate. |
|
Optional |
[S_KS_STU_X]HS_CREDITS_GRADUATE
|
Not applicable. |
|
Not Published |
Indicates whether the data element is optional for publishing. |
Student Legal Name |
Not Published |
Concatenate |
[S_KS_STU_Demographic_X]Legal_Last_Name + [S_KS_STU_Demographic_X]Legal_First_Name
|