Student Programs
This category represents the programs a student participates in or is served by, and includes the following data views and resources:
Student Programs
This view captures details about each program in which a student participates or receives services as published in the StudentProgramAssociation resource within the Student Program category. The layout includes the School Name, PS Student Number, Student Name, Grade Level, Program Name, Entry Date, Exit Date, State Student Number, Last Publish Date, and Publishing ID.
studentProgramAssociations
This association represents the program(s) that a student participates in or is served by that are not reported in specific Student Program Associations (e.g. StudentSpecialEducationProgramAssociation). Program associations reported in this resource include:
Limited English Proficiency
Primary PowerSchool Source Data
[SpEnrollments]
[Gen]
[S_SEN_X]
Selection Criteria
Records are published if the following criteria are met:
The student was previously published in the Student Parent category.
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The school must not be excluded from state reporting.
The ProgramReference must refer to a Program record previously published in the Program resource in the Education Organization category.
The BeginDate for the program association falls within the year for the Term selected in the PowerSchool UI.
Resource Output
A single record is published for each student and each enrollment period in each of the program associations included in the resource.
The StudentProgramAssociation resource is dependent on the prior publishing of the following resources: Student.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand ("Run Now" button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
beginDate | The month, day, and year on which the student first received services. | Date | [SpEnrollments]enter_date | R |
educationOrganizationId | The Education Organization associated with the program; reported as the SchoolId. | Integer | [SpEnrollments]schoolid | R |
programReference | R | |||
/educationOrganizationId | State-assigned number for Education Organization associated with the program. | Integer | R | |
/programName | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | String | [Gen]name | R |
/programTypeDescriptor | Program Type - The type of program. CTE and TitleIPartA program are no longer available for publising in studentProgramAssociations | Type | Fixed mapping | R |
studentReference | ||||
/studentUniqueId | The student associated with the program. | String | [Students]State_StudentNumber | R |
endDate | The month, day, and year on which the student exited the program or stopped receiving services. | Date | [SpEnrollments]exit_date - 1 | O |
Student Special Education Programs
This view captures student Special Education Program participation as published in the StudentSpecialEducationProgram Association resource within the Student Program category. The layout includes the School Name, PS Student Number, Student Name, Grade Level, Program Name, Begin Date, End Date, State Student Number, Last Publish Date, and Publishing ID.
This is not required for Ed-Fi publishing and is no longer available for publishing in the Student Programs resource.
studentSpecialEducationProgramAssociations
This association represents the Special Education program(s) that a student participates in or receives services from. The association is an extension of the StudentProgramAssociation particularly for Special Education programs.
Primary PowerSchool Source Data
[SPENROLLMENTS]
[GEN]
[S_SEN_X]
Selection Criteria
Records are published if the following criteria are met:
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The school must not be excluded from state reporting.
The student must be identified as a Special Education student
The ProgramReference must refer to a Program record previously published in the Program resource in the Education Organization category.
The BeginDate for the program association falls within the year for the Term selected in the PowerSchool UI.
Resource Output
A separate record is published for each enrollment period the student was in Special Education.
The StudentSpecialEducationProgramAssociation resource is dependent on the prior publishing of the following resources: Student and StudentSchoolAssocation.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand ("Run Now" button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
studentReference | ||||
/studentUniqueId | The student associated with the program. | String | [Students]State_StudentNumber | R |
beginDate | The month, day, and year on which the student first received services. | Date | [Students]entrydate | R |
endDate | The month, day, and year on which the student exited the program or stopped receiving services. | Date | [Students]exitdate | O |
educationOrganizationReference | ||||
/educationOrganizationId | State-assigned number for the education organization where the student is participating in or receiving the program services; reported as the SchoolId. | Integer | [SPENROLLMENTS]SchoolId | R |
programReference | R | |||
/educationOrganizationId | The Education Organization associated with the Program; reported as the LEAId. | Integer |
| R |
/programName | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | String | 'Special Education' | R |
/programTypeDescriptor | Program Type - The type of program. | Type | If [S_SC_STU_X]InstrSetting,1,2='SE' then ProgramTypeDescriptor = 'Special Education Enrollment' | R |
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, PS Student Number, Student Name, Grade Level, Program Name, Title I Part A Participation Type, Entry Date, State Student Number, Last Publish Date, and Publishing ID.
studentTitleIPartAProgramAssociations
This association represents the Title I Part A program(s) that a student participates in or from which the student receives services. The association is an extension of the StudentProgramAssociation particularly for Title I Part A programs.
Primary PowerSchool Source Data
[SpEnrollments]
[Gen]
[S_SEN_X]
Selection Criteria
Records are published if the following criteria are met:
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The school must not be excluded from state reporting.
The student is identified as receiving Title I services
The ProgramReference must refer to a Program record previously published in the Program resource in the Education Organization category.
The BeginDate for the program association falls within the year for the Term selected in the PowerSchool UI.
The source data for the required TitleIPartAParticipant field is populated for the student.
Resource Output
A separate record is published for each student and enrollment period, for each Title I instructional service received by the student
Support services are included as part of each instructional service record
If only support services are received, these are included on a record where instructional service = 'Other'
The studentTitleITASProgramAssociation resource is dependent on the prior publishing of the following resources: Student and StudentSchoolAssociation.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand ("Run Now" button).
Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
beginDate | The month, day, and year on which the student first received services. | Date | [Students]entrydate | R |
endDate | The month, day, and year on which the student stopped receiving services. | Date | [Students]exitdate | |
programReference | ||||
/educationOrganizationId | The education organization where the student is participating in or receiving the program services; reported as the SchoolId. | Integer | [Students]SchoolId [ReEnrollments]schoolid | R |
/programName | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | If [S_SC_STU_X]Title1MathInd or [S_SC_STU_X]Title1ReadInd or [S_SC_STU_X]Title1AsstTypeCode or [S_SC_STU_X]Title1AsstTypeCode = T then ProgramName is ‘TitleIPartA’ | R | |
/programTypeDescriptor | The description of the type of Title I Part A program. | String | If [S_SC_STU_X]Title1MathInd = Y then ProgramTypeDescriptor = Mathematics Instructional Services If [S_SC_STU_X]Title1ReadInd= Y then ProgramTypeDescriptor = Reading/Language Instructional Services If If [S_SC_STU_X]Title1MathInd = Y and [S_SC_STU_X]Title1ReadInd= Y then ProgramTypeDescriptor = both Mathematics Instructional Services and Reading/Language Instructional Services If [S_SC_STU_X]Title1AsstTypeCode = T then ProgramTypeDescriptor = 'Public Targeted Assistance Program' else ProgramTypeDescriptor = Was not served If [S_SC_STU_X]Title1AsstTypeCode = T then ProgramTypeDescriptor = 'Public Targeted Assistance Program' else ProgramTypeDescriptor = Was not served If [S_SC_STU_X]Title1MathInd = Y AND [S_SC_STU_X]Title1ReadInd=Y then ProgramTypeDescriptor = Multiple Instructional Services | R |
studentReference | ||||
studentUniqueId | A unique alphanumeric code assigned to a student. | String | [Students]state_studentnumber | R |
titleIPartAParticipantType | 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. | Type | [S_SC_STU_X]Title1AsstTypeCode | O |
Student Career Education 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.
studentCTEProgramAssociations
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]
[Gen]
[S_SC_Stu_WBL_X]
[S_SC_STU_CATE_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 |
|---|---|---|---|---|
beginDate | The month, day, and year on which the student first received services. | Date | [S_SC_STU_CATE_X]WHENCREATED | R |
endDate | The month, day, and year on which the student stopped receiving services. | Date | [Students]exitdate | R |
educationOrganizationReference | ||||
educationOrganizationId | The education organization associated with the school or the district. | [STUDENTS]schoolid or [STUDENTS]enrollment_schoolid or [REENROLLMENTS]schoolid | R | |
programReference | R | |||
/educationOrganizationId | The Education Organization associated with the program; reported as the LEAId. | Integer | LEAId - Data element downloaded from State | R |
/programName | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | Varchar(60) | If [S_SC_STU_CATE_X]CATE_ConcntrInd1 or [S_SC_STU_CATE_X]CATE_CompleterInd1 is not null then programName = 'CTE Program 1' | R |
/programTypeDescriptor | The type of the program. | If [S_SC_STU_CATE_X]CATE_ConcntrInd1 or [S_SC_STU_CATE_X]CATE_CompleterInd1 is not null then programTypeDescriptor='CTE Program 1' | R | |
studentReference | ||||
/studentUniqueId | A unique alphanumeric code assigned to a student. | [students]state_studentnumber | ||
technicalSkillAssessmentDescriptor | Description to indicate if the student passed or failed the assessment. | Cert_Passed = "Y" then TechnicalSkillsAssessmentDescriptor = "Passed", | ||
CTEProgramService | ||||
/CTEProgramServiceDescriptor | Description of the student's CTE program. | Boolean | if S_SC_STU_CATE_X.CATE_CompleterInd is Y then CTEProgramServiceDescriptor is CN1Y. | R |
/CIPCode | Number and description of the CIP Code associated with the student's CTE program. | Integer | [S_SC_STU_CATE_X]CIPCode [S_SC_STU_CATE_X]CIPCode2 | |
participationStatusDescriptor | The number identifying the remote school the student attends. | If [S_SC_STU_CATE_X]CATE_RemoteSchCode is not null then is 'Remote Location'. | R | |
designatedBy | The Participation Status is designated by the student's remote school code. | [S_SC_STU_CATE_X]CATE_RemoteSchCode | R | |
Student Language Instruction Program
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.
studentLanguageInstructionProgramAssociations
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]
[Gen]
[S_SEN_X]
Selection Criteria
Records are published if the following criteria are met:
The student was published in the Student category.
The student's English proficiency reported in [S_SC_STU_X]Engl_Prof must not be 8* or 9.
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 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 |
|---|---|---|---|---|
beginDate | The month, day, and year on which the student first received services. | Date | [S_SC_STU_X]Init_TestDate | R |
educationOrganizationReference | ||||
educationOrganizationId | State-assigned value for the education organization associated with the school or the district. | [Students]schoolid [Students]enrollment_schoolid | R | |
studentReference | ||||
/studentUniqueId | A unique alphanumeric code assigned to a student. | [Students]state_studentnumber | ||
englishLanguageProficiencyAssessments | ||||
schoolYearTypeReference | ||||
/schoolYear | The school year associated with the studentAcademicRecord. | [TERMS]yearid + 1991 | R | |
proficiencyDescriptor | The student’s English proficiency level. | Concatenated [S_SC_STU_X]Engl_Prof with [S_SC_STU_X]engProfDecimal and [S_SC_STU_X]Prof8_Status | ||
Monitored | ||||
/monitoredDescriptor | [S_SC_STU_X]Engl_Prof is(M1,M2,M3,M4) | |||
languageInstructionProgramServices | ||||
languageInstructionProgramServiceDescriptor | [S_SC_STU_ESOL_ X]ELLI01 - ELLI11 | |||
englishLearnerParticipation | An indication that an English Learner student is served by an English language instruction. Valid values:
| True if [S_SC_STU_X]Engl_Prof,1,1); if [S_SC_STU_X]Waiver_Ind is 1 then this overrides the participation indicator | ||
programreference | ||||
/educationOrganizationId | State-assigned value for the Education Organization associated with the program. | Integer | [Students]schoolid [Students]enrollment_schoolid | R |
/programName | The formal name of the language instruction program - ESOL | Varchar(60) | ESOL | R |
/programTypeDescriptor | English to Speakers of Other Language | Namespace: uri://ed.sc.gov/ProgramTypeDescriptor If [S_SC_STU_X]Engl_Prof,1,1) is not in ('8','9') then ESOL English to Speakers of Other Language | R | |
studentNeglectedOrDelinquentProgramAssociations
Primary PowerSchool Source Data
[SpEnrollments]
[Gen]
[S_SEN_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 a SpEnrollments studentNeglectedOrDelinquentProgramAssociationsprogram record where the beginDate for the program association falls with the year for the Term selected in the PowerSchool UI.
Resource Output
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 |
|---|---|---|---|---|
beginDate | The month, day, and year on which the student first received services. | Integer | [SpEnrollments]enter_date | R |
educationOrganizationId | State-assigned value for the education organization associated with the school or the district. | [SpEnrollments]schoolid | R | |
neglectedOrDelinquentProgramDescriptor | All use cases are 'Neglected Programs' | [S_SEN_X]neglectedProgram | ||
neglectedOrDelinquentProgramServices | ||||
/neglectedOrDelinquentProgramServiceDescriptor | [S_SEN_X]neglectedProgramService | |||
/serviceBeginDate | [SpEnrollments]enter_date | |||
/primaryIndicator |
Homeless Programs
This view captures information about the Student Homeless Program associations successfully published to the DPI and represents the homeless program(s) that a student participates in or is served by.. The layout includes the School Name, Student Number, Student Name, WISEid, Grade Level, Program Type, Program Name, Begin Date, End Date, Primary Nighttime Resident Type, Last Publish Date, and the Publishing ID.
studentHomelessProgramAssociation
This association represents the homeless program for the student.
Primary PowerSchool Source Data
[Students]
[SPEnrollments]
[Gen]
[S_SEN_X]
[S_SC_STU_X ]
Selection Criteria
Records are published if the following criteria are met:
The student's school of enrollment must not be excluded from state reporting.
The student's school of enrollment must have an Ed-Fi State School number.
The student must not be excluded from state reporting.
A student record has been published for the student.
The studentUniqueId (Wisconsin Student Number/WISEid) must be populated in PowerSchool.
The student must have at least one school enrollment with an entry date that falls on or within the date range defined by [Terms]FirstDay and [Terms]LastDay of the year for the Term selected in the PowerSchool UI.
The enrollment exit date is greater than the entry date.
The student has a program record for A Homeless program where the begin date falls within the year for the Term selected in the PowerSchool UI.
Resource Output
A studentHomelessProgramAssociation record is published for each student enrolled in the current school year who meets the selection criteria.
The studentHomelessProgramAssociation resource is dependent on the prior publishing of the following resources: student and studentSchoolAssociation.
LEAs and Schools may upload (publish) data to the ODS in real-time ("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 |
beginDate | The month, day, and year on which the student first received services. | Date | [Students]entrydate | R |
endDate | The month, day, and year on which the student stopeed receiving services. | Date | [Students]exitdate | R |
educationOrganizationReference A reference to the related School resource. | R | |||
/educationOrganizationID | The education organization that is associated with the student. | Integer | Derived from: [Students]SchoolID [Students]enrollment_schoolid [Renrollment]schoolid | R |
programReference The programs associated with the student. | R | |||
/educationOrganizationID | The Education Organization associated with the program. | Integer | R | |
/programName | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | String | 'Homeless Program' | R |
/programTypeDescription | The type of program. | String | If [S_SC_STU_X]night_residence is not null then Homeless Program | R |
studentReference A reference to the related Student resource. | R | |||
/studentUniqueId | A unique number or alphanumeric code assigned to a student by a state education agency. | String | [Students]State_StudentNumber | R |
homelessprimaryNighttimeResidencyDescriptor | Indicates the primary nighttime residence for the student. Valid values:
| String | [S_SC_STU_X ]Nighttime_Residence_Type | R |
homelessUnaccompaniedYouth | Indicates if a student is unaccompanied youth. | Boolean | [S_SC_STU_X ]Unaccompanied_Youth
| R |