Student Program Data

This category presents information about student program participation as published within the Student Program category.

Student Programs

This view captures details about each program in which a student participates or is served as published in the StudentProgramAssociation resource within the Student Program category. The layout includes the School Name, Student Number, Student Name, Gender, and Grade Level, along with the Program, Entry Date, Exit Date, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.

studentProgramAssociation

This association represents the program(s) in which a student participates or receives services.

Primary PowerSchool Source Data

[CST_PubProgram] - programs downloaded from State
[SpEnrollments] – used as source for the following programs:
- After school program
- ASD Charter
- Bilingual
- Bilingual Summer
- Gifted and Talented
- Health Services Program
- Library/Media Services Program
- Magnet
- Section 504 Placement
[S_TN_STU_StuClassification_C] – used as source for the following programs:
- Adult – 'D'
- Alternative – 'A'
- CEP School – '3'
- Even Start – 'V'
- Head Start – 'E'
- Residential/Transient – 'H'
[Students] / [S_TN_STU_X] and [ReEnrollments] – used as source for the following programs:
- Pre-Kindergarten: if Grade_Level = -1
- ELL: if TN_ELB = 'L'
- Public School Choice: if [S_TN_STU_X]SchoolChoiceApplied = 'Y'

Selection Criteria

Records are published if the following criteria are met:

The student was published in the Student category.
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The programReference must refer to a program record previously downloaded in the Program resource in the Education Organization category.
The student program record is not published under another type of studentProgramAssociation, including CTE, Migrant Education, and Title I.
The beginDate for the program association falls with the year for the Term selected in the PowerSchool UI.

Resource Output

A single record is published for each student and for each enrollment period in each of the program associations included in the resource.
Records for special programs that have their own specific student program association resources (CTE, Migrant Education, andTitle I) are not included in the studentProgramAssociation resource.
The studentProgramAssociation resource is dependent on the prior publishing of the following resources: student.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Data Element	Description	Data Type	Stored in [Table]Field	Req’d
studentReference/studentIdentity	The student associated with the program.	Integer	StudentUniqueId downloaded from State Derived from: For Special Program records: [SPEnrollments]StudentID For Student Classification records: [S_TN_STU_StuClassification_C]foreignkey For Students and Reenrollments records: [Students]DCID	M
programReference/programIdentity (1-many) The program(s) associated with the student.				M
/programType	The type of program.	Enumerated List	[CST_PubProgram]Name Derived from: For Special Program records: [SPEnrollments]ProgramID From GEN table where (cat=specprog) For Student Classification records: [S_TN_STU_StuClassification_C]ClassificationType For Students and Reenrollments records: Fields specific to each program as indicated in “Primary PowerSchool Source Data” section	M
/programName	The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies.	Varchar(60)	[CST_PubProgram]Name Derived from: For Special Program records: [SPEnrollments]ProgramID From GEN table where (cat=specprog) For Student Classification records: [S_TN_STU_StuClassification_C]ClassificationType For Students and Reenrollments records: Fields specific to each program as indicated in “Primary PowerSchool Source Data” section	M
/educationOrganizationReference/ educationOrganizationIdentity	The Education Organization associated with the program; reported as the LEAId.	Integer	LEAId - Data element downloaded from State	M
beginDate	The month, day, and year on which the student entered the program or first received services.	Date	For Special Program records: [SPEnrollments]Enter_Date For Student Classification records: [S_TN_STU_StuClassification_C]BeginDate For Students and Reenrollments records: [Students]EntryDate [ReEnrollments]EntryDate	M
endDate	The month, day, and year on which the student exited the program or stopped receiving services.	Date	For Special Program records: [SPEnrollments]Exit_Date For Student Classification records: [S_TN_STU_StuClassification_C]EndDate For Students and Reenrollments records: [Students]ExitDate [ReEnrollments]ExitDate	O
reasonExited	The reason the child left the program within a school or district. This element is required if the student exited the program.	Descriptor	For Special Program records: [S_TN_SEN_EdFi_X]ReasonExited For Student Classification, Students, and Reenrollments records: ‘Unknown Reason’	C
educationOrganizationReference/ educationOrganizationIdentity	The education organization where the student is participating in or receiving the program services; reported as the LEAId.	Integer	LEAId - Data element downloaded from State	M
servedOutsideOfRegularSession	Indicates whether the student received services during the summer session or between sessions.	Boolean	[S_TN_SEN_EdFi_X]ServedOutsideOfRegularSession For programs sourced from [StudentClassification], [Students], or [ReEnrollments]: element not published	O

Student Special Education Programs

This view captures information about student participation in special education programs as published in the StudentSpecialEducationProgramAssociation resource within the Student Program category. The layout includes the School Name, Student Number, Student Name, Gender, and Grade Level, along with the Program, Entry Date, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.
Note: This is an abbreviated version of the resource, intended only to provide a flag to the state indicating that the student participates in a Special Education program. Additional data is to be provided directly to the state by EasyIEP.

studentSpecialEducationProgramAssociation

This association represents the Special Education program(s) in which a student participates or is served. Special Education Program data may come from either EasyIEP or SpEnrollments, depending on the district setup for that year.

The indicator for using EasyIEP is [Prefs]value = 'Y' where [Prefs]name = ''TN_Using_EasyIEP'.
If the district is using EasyIEP, then data must be imported from EasyIEP, which populates the table S_TN_STU_EasyIEP_C.
If TN_Using_EasyIEP in [Prefs] is not 'Y', then [SpEnrollments] will be used, where ProgramId = [Gen]Id and [Gen]Cat = 'specprog' and [Gen]SpedIndicator = 1.

Primary PowerSchool Source Data

[S_TN_STU_EasyIEP_C] (if district uses EasyIEP)
[SpEnrollments] (if district does not use EasyIEP)

Selection Criteria

Records are published if the following criteria are met:

The student was published in the Student category.
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The programReference must refer to a program record previously downloaded in the Program resource in the Education Organization category.
The student has a special education program record as specified above where the beginDate for the program association falls with the year for the Term selected in the PowerSchool UI.
The Special Education Program option type is 'Primary'.

Resource Output

A single studentSpecialEducationProgramAssociation record is published for each student in a Special Education program that meets the selection criteria.
The studentSpecialEducationProgramAssociation is dependent on the prior publishing of the following resources: student.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Data Element	Description	Data Type	Stored in [Table]Field	Req'd
studentReference/studentIdentity	The student associated with the program.	Integer	StudentUniqueId downloaded from State Derived from: EasyIEP: [S_TN_STU_EasyIEP_C]StudentsDCID SpEnrollments: [SPEnrollments]StudentID	M
programReference/programIdentity The CTE program associated with the student.				M
/programType	The type of program.	Enumerated List	'Special Education'	M
/programName	The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies.	Varchar(60)	'Special Education'	M
/educationOrganizationReference/ educationOrganizationIdentity	The Education Organization associated with the program; reported as the LEAId.	Integer	LEAId - Data element downloaded from State	M
beginDate	The month, day, and year on which the student first received services.	Date	EasyIEP: [S_TN_STU_EasyIEP_C]OptionStartDate SpEnrollments: [SPEnrollments]Enter_Date	M
educationOrganizationReference/ educationOrganizationIdentity	The education organization where the student is participating in or receiving the program services; reported as the LEAId.	Integer	LEAId - Data element downloaded from State	M

Student CTE Programs

This view captures information about student participation in career and technical education programs as published in the StudentCTEProgramAssociation resource within the Student Program category. The layout includes the School Name, Student Number, Student Name, Gender, and Grade Level, along with the Program, Entry Date, Exit Date, Career Pathway, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.

studentCTEProgramAssociation

This association represents the career and technical education (CTE) program in which a student participates. The association is an extension of the studentProgramAssociation particular for CTE programs.

Primary PowerSchool Source Data

[SpEnrollments]
[S_TN_SEN_EdFi_X]

Selection Criteria

Records are published if the following criteria are met:

The student was published in the Student category.
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The programReference must refer to a program record previously downloaded in the Program resource in the Education Organization category.
The student has an SpEnrollments CTE program record where the beginDate for the program association falls with the year for the Term selected in the PowerSchool UI.

Resource Output

A separate studentCTEProgramAssociation record is published for each student and CTE program that meets the selection criteria.
The studentCTEProgramAssociation resource is dependent on the prior publishing of the following resources: student.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Data Element	Description	Data Type	Stored in [Table]Field	Req'd
studentReference/studentIdentity	The student associated with the program.	Integer	StudentUniqueId downloaded from State Derived from: [SPEnrollments]StudentID	M
programReference/programIdentity The CTE program associated with the student.				M
/programType	The type of program.	Enumerated List	'Career and Technical Education' Derived from: [SPEnrollments]ProgramID From GEN table where (cat=specprog)	M
/programName	The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies.	Varchar(60)	'Career and Technical Education' Derived from: [SPEnrollments]ProgramID From GEN table where (cat=specprog)	M
/educationOrganizationReference/ educationOrganizationIdentity	The Education Organization associated with the program; reported as the LEAId.	Integer	LEAId - Data element downloaded from State	M
beginDate	The month, day, and year on which the student first received services.	Date	[SPEnrollments]Enter_Date	M
endDate	The month, day, and year on which the student exited the program or stopped receiving services.	Date	[SPEnrollments]Exit_Date	O
reasonExited	The reason the child left the program within a school or district. This element is required if the student exited the program.	Descriptor	[S_TN_SEN_EdFi_X]ReasonExited Default = 'Unknown Reason'	C
educationOrganizationReference/ educationOrganizationIdentity	The education organization where the student is participating in or receiving the program services; reported as the LEAId.	Integer	LEAId - Data element downloaded from State	M
cteProgram(1-many) The career cluster or pathway representing the career path of the Vocational/Career Tech concentrator.				R
/careerPathway	A sequence of courses within an area of interest that is a student's educational road map to a chosen career.	Enumerated List	Derived from: [S_TN_SEN_EdFi_X]CTE_CareerPathwayType 1 = 'Agriculture, Food and Natural Resources' 2 = 'Architecture and Construction' 3 = 'Arts, A/V Technology and Communications' 4 = 'Business, Management and Administration' 5 = 'Education and Training' 6 = 'Finance' 7 = 'Government and Public Administration' 8 = 'Health Science' 9 = 'Hospitality and Tourism' 10 = 'Human Services' 11 = 'Information Technology' 12 = 'Law, Public Safety, Corrections and Security' 13 = 'Manufacturing' 14 = 'Marketing, Sales and Service' 15 = 'Science, Technology, Engineering and Mathematics' 16 = 'Transportation, Distribution and Logistics'	R
/cipCode	Number and description of the CIP Code associated with the student's CTE program.	Integer	[S_TN_SEN_EdFi_X]CTE_CIPCode	O
/primaryCTEProgramIndicator	An indicator of whether this CTE program is the student's primary CTE program.	Boolean	[S_TN_SEN_EdFi_X]CTE_PrimaryProgramIndicator	O
/cteProgramCompletionIndicator	An indicator of whether the student has completed the CTE program.	Boolean	[S_TN_SEN_EdFi_X]CTE_ProgramCompletionIndicator	O

Student Title I Part A Programs

This view captures information about student Title I program participation as published in the StudentTitleIPartAProgram Association resource within the Student Program category. The layout includes the School Name, Student Number, Student Name, Gender, and Grade Level, along with the Program, title I Part A Participation Type, Entry Date, Exit Date, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.

studentTitleIPartAProgramAssociation

This association represents the Title I Part A program(s) in which a student participates or is served. The association is an extension of the studentProgramAssociation for Title I Part A programs.

Primary PowerSchool Source Data

[SpEnrollments]
[S_TN_STU_StuClassification_C]

Selection Criteria

Records are published if the following criteria are met:

The student was published in the Student Parent category.
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The programReference must refer to a program record previously downloaded in the Program resource in the Education Organization category.
The student has a Title I SpEnrollments program record or a Title I StudentClassification record where the beginDate for the program association falls with the year for the Term selected in the PowerSchool UI.

Resource Output

A separate studentTitleIPartAProgramAsssociation record is published for each student and Title I program/classification that meets the selection criteria.
The studentTitleIPartAProgramAssociation resource is dependent on the prior publishing of the following resources: student.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Data Element	Description	Data Type	Stored in [Table]Field	Req'd
studentReference/studentIdentity	The student associated with the program.	Integer	StudentUniqueId downloaded from State Derived from: For Special Program records: [SPEnrollments]StudentID For Student Classification records: [S_TN_STU_StuClassification_C]foreignKey	M
programReference/programIdentity The Title I program associated with the student.				M
/programType	The type of program.	Enumerated List	'Title I Part A' Derived from: For Special Program records: [SPEnrollments]ProgramID For Student Classification records: [S_TN_STU_StuClassification_C]ClassificationType	M
/programName	The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies.	Varchar(60)	For Special Program records: 'Title I Part A' Derived from: [Gen]Name [SPEnrollments]ProgramID For Student Classification records: 'Public Targeted Assistance Program'	M
/educationOrganizationReference/ educationOrganizationIdentity	The Education Organization associated with the program; reported as the LEAId.	Integer	LEAId - Data element downloaded from State	M
beginDate	The month, day, and year on which the student first received services.	Date	For Special Program records: [SPEnrollments]Enter_Date For Student Classification records: [S_TN_STU_StuClassification_C]BeginDate [Students]EntryDate [ReEnrollments]EntryDate	M
endDate	The month, day, and year on which the student exited the program or stopped receiving services.	Date	For Special Program records: [SPEnrollments]Exit_Date For Student Classification records: [S_TN_STU_StuClassification_C]EndDate [Students]ExitDate [ReEnrollments]ExitDate	O
reasonExited	The reason the child left the program within a school or district. This element is required if the student exited the program.	Descriptor	For Special Program records: [S_TN_SEN_EdFi_X]ReasonExited For Student Classification records: 'Unknown Reason'	C
educationOrganizationReference/ educationOrganizationIdentity	The education organization where the student is participating in or receiving the program services; reported as the LEAId.	Integer	LEAId - Data element downloaded from State	M
titleIPartAParticipant	An indication of the type of Title I program, if any, in which the student is participating and served: Public Targeted Assistance Program, Public Schoolwide Program, Private school student participating, Local Neglected Program.	Enumerated List	For Special Program records: [S_TN_SEN_EdFi_X]TitleIPartAType For Student Classification records: 'Public Targeted Assistance Program'	M

Student Migrant Education Programs

This view captures information about student Migrant Education program participation as published in the StudentMigrantEducationProgram Association resource within the Student Program category. The layout includes the School Name, Student Number, Student Name, Gender, and Grade Level, along with the Program, Entry Date, Exit Date, Reason Exited, Priority for Services, Last Qualifying Move Date, Ed-Fi Unique ID, Last Publish Date, and the Publishing ID.

studentMigrantEducationProgramAssociation

This association represents the Migrant Education program(s) in which a student participates or is served. The association is an extension of the StudentProgramAssociation for Migrant Education programs.

Primary PowerSchool Source Data

[SpEnrollments]
[S_TN_SEN_EdFi_X]

Note: Migrant Education Program data is separate from the studentClassification Migrant flag ('I') and requires a Migrant SpEnrollments record in the selected school year. This is a change from previous releases. Since PowerSchool now fully supports the Ed-Fi studentMigrantEducationProgramAssociation resource, abbreviated Migrant Education program data is no longer published in the general studentProgamAssociation resource. Setting the studentClassification Migrant flag alone will not generate a corresponding student program record as it previously did.

Selection Criteria

Records are published if the following criteria are met:

The student was published in the Student Parent category.
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The programReference must refer to a program record previously downloaded in the Program resource in the Education Organization category.
The student has a Migrant SpEnrollments program record where the beginDate for the program association falls with the year for the Term selected in the PowerSchool UI.

Resource Output

A separate studentMigrantEducationProgramAsssociation record is published for each student and migrant program that meets the selection criteria.
The studentMigrantEducationProgramAssociation resource is dependent on the prior publishing of the following resources: student.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Data Element	Description	Data Type	Stored in [Table]Field	Req'd
studentReference/studentIdentity	The student associated with the program.	Integer	StudentUniqueId downloaded from State Derived from: [SPEnrollments]StudentID	M
programReference/programIdentity The Migrant program associated with the student.				M
/programType	The type of program.	Enumerated List	'Migrant Education' Derived from: [SPEnrollments]ProgramID From GEN table where (cat=specprog)	M
/programName	The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies.	Varchar(60)	'Migrant Education' Derived from: [SPEnrollments]ProgramID From GEN table where (cat=specprog)	M
/educationOrganizationReference/ educationOrganizationIdentity	The Education Organization associated with the program; reported as the LEAId.	Integer	LEAId - Data element downloaded from State	M
beginDate	The month, day, and year on which the student first received services.	Date	[SPEnrollments]Enter_Date	M
endDate	The month, day, and year on which the student exited the program or stopped receiving services.	Date	[SPEnrollments]Exit_Date	O
reasonExited	The reason the child left the program within a school or district. *This element is required if the student exited the program.	Descriptor	[S_TN_SEN_EdFi_X]ReasonExited Default = 'Unknown Reason'	C*
educationOrganizationReference/ educationOrganizationIdentity	The education organization where the student is participating in or receiving the program services; reported as the LEAId.	Integer	LEAId - Data element downloaded from State	M
servedOutsideOfRegularSession	Indicates whether the student received services during the summer session or between sessions.	Boolean	[S_TN_SEN_EdFi_X]ServedOutsideOfRegularSession	O
priorityForServices	Report migratory children who are classified as having priority for services because they are failing, or most at risk of failing to meet the State's challenging State academic content standards and challenging State student academic achievement standards, and their education has been interrupted during the regular school year.	Boolean	[S_TN_SEN_EdFi_X]Migrant_PriorityForServices	R
lastQualifyingMove	Date the last qualifying move occurred; used to compute MEP status.	Date	[S_TN_SEN_EdFi_X]Migrant_LastQualMoveDate	R
continuationOfServicesReason	The "continuation of services" provision found in Section 1304(e) of the statute provides that (1) a child who ceases to be a migratory child during a school term shall be eligible for services until the end of such term; (2) a child who is no longer a migratory child may continue to receive services for one additional school year, but only if comparable services are not available through other programs; and (3) secondary school students who were eligible for services in secondary school may continue to be served through credit accrual programs until graduation. Only students who received services at any time during their 36-month eligibility period may continue to receive services (not necessarily the same service).	Descriptor	[S_TN_SEN_EdFi_X]Migrant_ContOfServReason	O
usInitialEntry	The month, day, and year on which the student first entered the US.	Date	[S_TN_SEN_EdFi_X]Migrant_USInitialEntry	O
usMostRecentEntry	The month, day, and year of the student's most recent entry into the US.	Date	[S_TN_SEN_EdFi_X]Migrant_USMostRecentEntry	O
usInitialSchoolEntry	The month, day, and year on which the student first entered a US School.	Date	[S_TN_SEN_EdFi_X]Migrant_USInitialSchoolEntry	O