PowerSchool SIS Kansas

English as a Second Language (ESL)

The Student Language Instruction Program Association represents the Title III, language instruction program(s) that a student participates in or receives services from. The association is an extension of the StudentProgramAssociation particularly for language instruction programs.

Selection Criteria 

  • The student must not be excluded from state reporting. 

  • The student's school of enrollment must not be excluded from state reporting. 

  • [students.s_ks_stu_ell_x]esol_program_code > 0 

  • All student enrollments associated with programs in a selected year. 

Dependencies

  • EducationOrganizationId

  • Program Catalog

  • Student and 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      

English as a Second Language (ESL) 

Resource Output

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

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.

ESOL/Bilingual Program Entry Date  

Required

[S_KS_STU_ELL_X]ESOL_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 [students.s_ks_stu_ell_x]esol_program_code 

If [students.s_ks_stu_ell_x]esol_program_code > 0  then English as a  

Second Language (ESL) 

ProgramTypeDescriptor 

A descriptor that categorizes the type of program, such as “Homeless Education Program” or “Special Education Program.

Program Type 

Required

Derived from [students.s_ks_stu_ell_x]esol_program_code 

If [students.s_ks_stu_ell_x]esol_program_code > 0 then English as a  

Second Language (ESL) 

Dosage  

The amount or frequency of a particular intervention or treatment, often used in educational contexts to describe the intensity of instructional programs.

Dosage  

Not Required

[S_KS_STU_ELL_X]ESOL_Minutes 

  

Extension.USInitialSchoolEntryDate 

The date a student first entered school in the United States

Entry Date into a School in the United States 

Not Required

[Students.S_KS_STU_X]USA_Entry_Date 

  

  

Extension.FundingSourceDescriptor 

The source of funding for a particular program or initiative, such as federal, state, or private funding.

ESOL/Bilingual Program Participation Code 

Not Required

[Students.S_KS_STU_ELL_X]ESOL_Program_Code 

 

Extension LanguageInstructionProgramTypeDescriptor 

The type of language instruction program a student is enrolled in, such as bilingual education, English as a Second Language (ESL), or dual language programs.

Language Instruction Education Program Type 

Not Required

[Students.S_KS_STU_X]Lang_Inst_EDU_PRGM_Type 

 

StudentLanguageInstructionProgramAssociations.EndDate

Student Enrollment End Date

Program End Date 
(Enrollment Exit Date)

Not Required