3Y/4Y Student Program (studentProgramAssociation)
This view captures details about 3Y/4Y program records in which a student participates or receives services as published in the StudentProgramAssociation resource within the Student Program category.
The layout includes the 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. Program associations reported in this resource include:
Primary PowerSchool Source Data
[Students]
[S_NM_STU_X]
[S_NM_STU_ProgramsFact_C]
Selection Criteria
Records are published if the following criteria are met:
General:
The student was previously published in the Student & Student Enrollments dashboard category.
StudentUniqueId must be populated in PowerSchool.
Student must not be a “no-show” (their entry date and exit date are the same date value).
The student must not be excluded from state reporting.
The school must not be excluded from state reporting.
Auto Generated Records:
Field Description | [Table]Field | Page | Notes |
|---|---|---|---|
3Y or 4Y Program Fact records flag | [S_NM_SCH_X]FLAG_3Y4Y | District Start Page, District Setup, Schools/School Info, Edit School | Box must be checked. |
Grade Level | [Students]Grade_Level | Start Page, Select Student, Transfer Info | Student's grade level must be -2 for a 3T record and -1 for a 4Y record. |
Special Education Indicator | [S_NM_STU_X]SpEd38_YN | Start Page, Select Student, State/Province - NM, Special Education | Must be Y. |
Date exited special education program after end of year last year | [S_NM_STU_X]ExitedSpEdStatus | Start Page, Select Student, State/Province - NM, Special Education | Must be blank or contain a date within the current year. |
Child Table Records [S_NM_STU_ProgramsFact_C]:
The record must be active at some point during the current reporting year.
Resource Output
A record is published for each student and each school enrollment the program record was active for.
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).
Data Element | Description | Data Type | Auto Generated Records: [Table]Field | Child Table Records: [Table]Field | Req'd |
|---|---|---|---|---|---|
educationOrganizationReference | |||||
educationOrganizationId | The school associated with this student. This is an eight-digit number comprising of: 35+[LEA Number - 3 digit]+[School Number - 3 digit] | String | LEA Number - [Prefs]Value [Prefs]Name where = districtnumber School Number: [S_NM_STU_X]LocationCode [Schools]Alternate_School_Number if the value greater is than zero, else the [Schools]School_Number | LEA Number - [Prefs]Value [Prefs]Name where = districtnumber School Number: [S_NM_STU_X]LocationCode [Schools]Alternate_School_Number if the value greater is than zero, else the [Schools]School_Number | R |
programReference | R | ||||
/educationOrganizationId | The LEA associated with this student and program. This is an eight-digit number comprising of: 35+[LEA Number - 3 digit]+000 | String | LEA Number - [Prefs]Value [Prefs]Name where = districtnumber The last 3 digits will be 000 | LEA Number - [Prefs]Value [Prefs]Name where = districtnumber The last 3 digits will be 000 | R |
/programTypeDescriptor | The type of program. | String | [Students]Grade_Level 4Y if student’s grade level is PK4 3Y if student’s grade level is PK3 | [S_NM_STU_ProgramsFact_C]ProgramCode | R |
/programName | The formal name of the program of instruction, training, services, or benefits available through federal, state, or local agencies. | String | Based on student’s grade level: Child participating in the Early Childhood 4Y Program Child participating in the Early Childhood 3Y Program | Based on the [S_NM_STU_ProgramsFact_C]ProgramCode value: Child participating in the Early Childhood 4Y Program Child participating in the Early Childhood 3Y Program | R |
studentReference | |||||
/studentUniqueId | The student associated with the program. | String | [Students]State_StudentNumber | [Students]State_StudentNumber | R |
/beginDate | The month, day, and year on which the student started the program. | Datetime | [Students]EntryDate [ReEnrollments]EntryDate | [S_NM_STU_ProgramsFact_C]BeginningDate If the above date is prior to the current school year: [Students]EntryDate [ReEnrollments]EntryDate | R |
/endDate | The month, day, and year on which the student exited the program or stopped receiving services. | Datetime | [Students]ExitDate [ReEnrollments]ExitDate | [S_NM_STU_ProgramsFact_C]EndingDate If the above date is blank or beyond the current school year: [Students]ExitDate [ReEnrollments]ExitDate | CR |