Student Programs

studentProgramAssociations

Tables: SPENROLLMENTS (sp), GEN, S_NE_SEN_X (xt)

studentUniqueId

A unique number or alphanumeric code assigned to a student by a state education agency.

A unique number or alphanumeric code assigned to a student by a state education agency.

derived from sp.studentid

State-assigned number for student (s.state_studentnumber)

Y

beginDate

The start date of the student’s enrollment or participation in a specific program. It indicates when the student officially began the program.

sp.enter_date

Y

endDate

The end date of the student’s enrollment or participation in the program. It marks the date when the student completed or exited the program.

sp.exit_date

Only if not null; requested if student has exited program - use last insession date prior to sp.exit_date; if none then exit_date - 1

NE

educationOrganizationId

Identifier for the educational organization associated with the program.

s_ne_sen_x.pgmfactdistschoolcode

State-assigned number for school

Y

programReference

educatonOrganizationId

State-assigned number for district

Y

programName

'Rule 18 Interim-Program School'

Y

programTypeDescriptor

'Neglected and Delinquent Program'

Y

additional fields for display only

sch.school_name

s.student_number

s.lastfirst

s/r.grade_level

studentSpecialEducationProgramAssociations

Tables: SPENROLLMENTS (sp), GEN, S_NE_SEN_SPED_X (xt)

studentUniqueId

A unique number or alphanumeric code assigned to a student by a state education agency.

derived from sp.studentid

Y

beginDate

The start date of the student’s enrollment or participation in a specific program. It indicates when the student officially began the program.

sp.enter_date

Y

endDate

The end date of the student’s enrollment or participation in the program. It marks the date when the student completed or exited the program.

sp.exit_date

NE

educationOrganizationId

Identifier for the educational organization associated with the program.

State-assigned number for district

Y

programReference

educatonOrganizationId

State-assigned number for district

Y

programName

'Special Education'

Y

programTypeDescriptor

'Special Education'

Y

reasonExitedDescriptor

derived from sp.exitcode

NE

disabilities

[Array]

NE

disabilityDescriptor

xt.primary_disability

Y

specialEducationProgramServices

[Array]

NE

specialEducationProgramServiceDescriptor

xt.related_services

Y

     '1' - Occupational Therapy

xt.related_services in ('1','4','6','7')

     '2' - Physical Therapy

xt.related_services in ('2','4','5','7')

     '3' - Speech-Language Therapy

xt.related_services in ('3','5','6','7')

specialEducationSettingDescriptor

The setting in which special education services are provided to the student. It includes various types of environments, such as regular classrooms, resource rooms, or separate schools, indicating where the student receives their special education services

xt.sped_inst_setting

schoolHoursPerWeek

The total number of hours per week that the student spends in school. It includes all instructional and non-instructional time during the school week.

xt.school_hoursperweek

specialEducationHoursPerWeek

The number of hours per week that the student receives special education services. It specifically accounts for the time dedicated to special education instruction and support.

xt.sped_hoursperweek

NE extensions

NE

placementTypeDescriptor

xt.primary_placement_type

NE

specialEducationProgramDescriptor

derived from xt.sped_inst_setting

NE

initialSpecialEducationEntryDate

xt.intialentry

NE

toTakeAlternateAssessment

xt.alternateassessment

NE

additional fields for display only

sch.school_name

s.student_number

s.lastfirst

s/r.grade_level

studentTitleIPartAProgramAssociations

Tables: STUDENTS (s), S_NE_STU_TITLEI_X (xt)

studentUniqueId

A unique number or alphanumeric code assigned to a student by a state education agency.

s.state_studentnumber

Y

beginDate

The start date of the student’s enrollment or participation in a specific program. It indicates when the student officially began the program.

s.entrydate, reenrollments.entrydate

Y

endDate

The end date of the student’s enrollment or participation in the program. It marks the date when the student completed or exited the program.

s.exitdate, reenrollments.exitdate

O

educationOrganizationId

Identifier for the educational organization associated with the program.

State-assigned number for district

Y

programReference

educatonOrganizationId

State-assigned number for district

Y

programName

'Title I Part A'

Y

programTypeDescriptor

'Title I Part A'

Y

services

[Array]

NE

'4' TITLE I CIVICS GOVT

xt.T1_Part_Code_CG = 'Y'

'5' TITLE I EARLY CHILDHOOD EDUCATION

ps_customfields.getcf('students'

'6' TITLE I GUIDANCE COUNSELING

xt.T1_Part_Code_GCSW = 'Y'

'7' TITLE I HEALTH

xt.T1_Part_Code_HD = 'Y'

'8' TITLE I MATH

xt.T1_Part_Code_Math = 'Y'

'9' TITLE I READING ELA

xt.T1_Part_Code_RELA = 'Y'

'10' TITLE I SCIENCE

xt.T1_Part_Code_Sci = 'Y'

'11' TITLE I SOCIAL WORK

ps_customfields.getcf('students',,'NE_T1_PartCode_SW') = 'Y'

'12' TITLE I SUPPORT OTHER

xt.T1_Support_Other = 'Y'

'13' TITLE I VOCATIONAL CAREER

xt.T1_Voc_Career = 'Y'

titleIPartAParticipantDescriptor

A descriptor that categorizes the types of participation in Title I, Part A programs. Title I, Part A is a federal program that provides financial assistance to schools with high numbers or high percentages of children from low-income families. This descriptor helps to identify and standardize the different ways students can participate in these programs, such as:

• Targeted Assistance: Programs that provide services to a select group of eligible children identified as failing or most at risk of failing to meet state academic standards.

• Schoolwide Program: Programs that use Title I funds to improve the entire educational program of the school, benefiting all students.

derived from xt.Non_pub_Target_Assist

additional fields for display only

sch.school_name

s.student_number

s.lastfirst

s/r.grade_level

studentEarlyLearningProgramAssociations

Tables: SPENROLLMENTS (sp), GEN, S_NE_SEN_X (xt)

studentUniqueId

A unique number or alphanumeric code assigned to a student by a state education agency.

derived from sp.studentid

Y

beginDate

The start date of the student’s enrollment or participation in a specific program. It indicates when the student officially began the program.

sp.enter_date

Y

endDate

The end date of the student’s enrollment or participation in the program. It marks the date when the student completed or exited the program.

sp.exit_date

NE

educationOrganizationId

Identifier for the educational organization associated with the program.

sp.schoolid

Y

programReference

educatonOrganizationId

State-assigned number for district

Y

programName

'Early Childhood Ed Program, not Head Start Student' for program code 'ERLYCHLD'
'Early Childhood Ed Program, Head Start Student' for program code 'ECHEADST'

Y

programTypeDescriptor

'Public Preschool' for program code 'ERLYCHLD'
'Early Head Start' for program code 'ECHEADST'

Y

earlyLearningSettingDescriptor

A descriptor that categorizes the types of settings where early learning programs are provided.

derived from xt.pgmfactinfocode

N

additional fields for display only

sch.school_name

s.student_number

s.lastfirst

s/r.grade_level

studentCTEProgramAssociations

Tables: SPENROLLMENTS (sp), GEN, S_NE_SEN_X (xt)

studentUniqueId

A unique number or alphanumeric code assigned to a student by a state education agency.

derived from sp.studentid

Y

beginDate

The start date of the student’s enrollment or participation in a specific program. It indicates when the student officially began the program.

sp.enter_date

Y

endDate

The end date of the student’s enrollment or participation in the program. It marks the date when the student completed or exited the program.

sp.exit_date

NE

educationOrganizationId

Identifier for the educational organization associated with the program.

sp.schoolid

Y

programReference

educatonOrganizationId

State-assigned number for district

Y

programName

'Career and Technical Education'

Y

programTypeDescriptor

'Career and Technical Education'

Y

ctePrograms

[Array]

NE

careerPathwayDescriptor

xt.pgmfactprogramcode

Y

technicalSkillsAssessmentDescriptor

A descriptor that categorizes the types of technical skills assessments a student has taken. These assessments evaluate a student’s proficiency in specific technical skills or competencies, often related to career and technical education (CTE) programs.

derived from xt.pgmfacttechskillattain

NE

NE extensions

NE

careerEducationProgramDescriptor

derived from xt.pgmfactinfocode

NE

additional fields for display only

sch.school_name

s.student_number

s.lastfirst

s/r.grade_level

studentHomelessProgramAssociations

Tables: SPENROLLMENTS (sp), GEN, S_NE_SEN_X (xt)

studentUniqueId

A unique number or alphanumeric code assigned to a student by a state education agency.

derived from sp.studentid

Y

beginDate

The start date of the student’s enrollment or participation in a specific program. It indicates when the student officially began the program.

sp.enter_date

Y

endDate

The end date of the student’s enrollment or participation in the program. It marks the date when the student completed or exited the program.

sp.exit_date

NE

educationOrganizationId

Identifier for the educational organization associated with the program.

State-assigned number for district

Y

programReference

educatonOrganizationId

State-assigned number for district

Y

programName

'Homeless'

Y

programTypeDescriptor

'Other'

Y

homelessPrimaryNighttimeResidenceDescriptor

The type of nighttime residence where a homeless student primarily stays

derived from xt.PgmFactInfoCode,5,2

NE

homelessUnaccompaniedYouth

Indicates whether a homeless student is unaccompanied, meaning they are not in the physical custody of a parent or guardian.

S_NE_STU_X.Unaccomp_Homeless_Youth

NE

additional fields for display only

sch.school_name

s.student_number

s.lastfirst

s/r.grade_level

studentLanguageInstructionProgramAssociations

Tables: S_NE_STU_LEP_X (xt), STUDENTS (s), REENROLLMENTS ®

studentUniqueId

A unique number or alphanumeric code assigned to a student by a state education agency.

s.state_studentnumber

Y

beginDate

The start date of the student’s enrollment or participation in a specific program. It indicates when the student officially began the program.

r.entydate or s.entrydate

Y

educationOrganizationId

The end date of the student’s enrollment or participation in the program. It marks the date when the student completed or exited the program.

State-assigned number for district

Y

programReference

Identifier for the educational organization associated with the program.

educatonOrganizationId

State-assigned number for district

Y

programName

'English Learners'

Y

programTypeDescriptor

'English as a Second Language (ESL)'

Y

englishLearnerParticipation

Indicates if a student identified as an English Learner (EL) is actively participating in an English language development instructional program. This field is typically a binary indicator:

• 1 (Yes): The student is receiving regular and consistent English language development instruction from a licensed EL teacher.

• 0 (No): The student is not receiving such instruction, either because the parents have refused the service or the instruction is not provided by a licensed teacher^.

derived from xt.english_prof and xt.instructional_services

true if xt.english_prof = '11' or xt.instructional_services is not null, otherwise false

NE

languageInstructionProgramServices

[Array]

NE

languageInstructionProgramServiceDescriptor

xt.instructional_services

Y

NE extensions

NE

dismissedViaIEPReview

"(15) DISMISSED VIA IEP REVIEW" 

NE

redesignatedEnglishFluent

NE

additional fields for display only

sch.school_name

s.student_number

s.lastfirst

s/r.grade_level

xt.english_prof

studentSchoolFoodServiceProgramAssociations

Tables: S_STU_LUNCH_C (slc), STUDENTS (s)

studentUniqueId

A unique number or alphanumeric code assigned to a student by a state education agency.

s.state_studentnumber

Y

beginDate

The start date of the student’s enrollment or participation in a specific program. It indicates when the student officially began the program.

slc.start_date or STUDENTS/REENROLLMENTS.entrydate

Y

endDate

The end date of the student’s enrollment or participation in the program. It marks the date when the student completed or exited the program.

slc.end_date or start_date - 1 from next slc record (if exists)

NE

educationOrganizationId

Identifier for the educational organization associated with the program.

State-assigned number for district

Y

programReference

educatonOrganizationId

State-assigned number for district

Y

programName

'School Food Service'

Y

programTypeDescriptor

'Compensatory Services for Disadvantaged Students'

Y

schoolFoodServiceProgramServices

The services provided to students as part of a school’s food service program.

[Array]

NE

schoolFoodServiceProgramServiceDescriptor

slc.reportedvalue or slc.lunchstatus

Y

additional fields for display only

sch.school_name

s.student_number

s.lastfirst

s/r.grade_level