Kansas Parent as Teacher (KPAT) Program

The StudentKPATProgramAssociation table stores data regarding the affiliation between students and the Kansas Parent as Teacher (KPAT) 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.PAT_Participant] is 1 (True).
Publish all student enrollments associated with programs in a selected year.

Dependencies

EducationOrganizationId
Program Catalog
Student
StudentSchoolAssociation

Note: Student Programs from current enrolment are only published.

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 Parent as Teacher 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.PAT_Participant]	When Kansas Parents as Teachers Program (KPAT) value is 1 (True), submit Kansas Parents as Teachers Program as value.
ProgramTypeDescriptor	A descriptor that categorizes the type of program.	Program Type	Required	Derived from [S_KS_STU_X.PAT_Participant]	When Kansas Parents as Teachers Program (KPAT) value is 1 (True), submit Kansas Parents as Teachers Program as value.