The StudentKPPProgramAssociation table stores data regarding the affiliation between students and the Kansas PreK Pilot program, detailing their participation and involvement.
Selection Criteria
-
The student must not be excluded from state reporting.
-
The student's school of enrollment must not be excluded from state reporting.
-
[S_KS_STU_X.EL_Participant] is 1 (True).
-
Publish all student enrollments associated with programs in a selected year.
Note: Student Programs from current enrolment are only published.
Dependencies
-
EducationOrganizationId
-
Program Catalog
-
Student
-
StudentSchoolAssociation
Data Review
|
Field |
Selection |
|
Choose Dashboard |
Programs |
|
Choose Category
|
Programs info Summary Programs info Published Programs info Dependencies Programs info Errors |
|
Choose Data view |
Kansas Pre-K Pilot Program |
Resource Output
-
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Optional" button).
-
Publishes student associations and data related to programs.
|
Ed-Fi Data Element |
Description |
Data view Column |
Submission |
[Table] Field |
Business Rules |
|
BeginDate |
The start date of the student’s enrollment or participation in a program. |
School Entry Date
|
Required |
students.s_ks_stu_x.school_entry_date students.s_ks_ren_x.school_entry_date |
|
|
StudentUniqueId |
A unique identifier assigned to each student. |
State Identifier |
Required |
[Students]State_StudentNumber
|
|
|
educationOrganizationId |
An identifier for the educational organization (such as a school or district) where the student is enrolled. |
Ed Org Id |
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 [S_KS_REN_X]Attendance_School
[Schools]School_Number |
Format: ttbbbdddd |
|
ProgrameducationOrganizationId |
An identifier for the educational organization that administers the program in which the student is participating. |
Program Ed Org Id |
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 [S_KS_REN_X]Attendance_School [Schools]School_Number |
Format: ttbbbdddd |
|
ProgramName |
The name of the program in which the student is enrolled. |
Program Name |
Required |
Derived from [S_KS_STU_X.EL_Participant] |
When Kansas Pre-K Pilot Program (KPP) value is 1 (True), submit Kansas Pre-K Pilot Program as value. |
|
ProgramTypeDescriptor |
A descriptor that categorizes the type of program |
Program Type |
Required |
Derived from [S_KS_STU_X.EL_Participant] |
When Kansas Pre-K Pilot Program (KPP) value is 1 (True), submit Kansas Pre-K Pilot Program as value. |