Student Teacher Sections

Information describing associations between staff and students within sections

Staff Section Associations

Teachers and their role within each assigned section.

Primary PowerSchool Source Data

Core tables used in this resource:

[CC]
[Staff]
[Sections]
[Terms]
[Courses]

Selection Criteria

Business logic for publishing this resource:

Section must have enrolled students
Staff member must have teaching assignment in section
Section must have meeting times
Staff member must be in active teaching role (determined by CC/section teacher records)
90% attendance calculation uses function call with up to 4 attempts

Resource Output

Expected output from the selection criteria:

sectionReference - Reference to the section
staffReference - Reference to the staff member
classroomPositionDescriptor - Ed-Fi descriptor for teacher role
beginDate - Start date of assignment
endDate - End date of assignment
attendance90Percent - GA extension: Boolean for 90% attendance threshold

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element	Description	[Table]Data Type	Stored in [Table]Field
sectionReference	Reference to the section this staff member teaches	customobject	[Sections]id
staffReference	Reference to the staff member (teacher)	customobject	[Users]DCID
staffUniqueId	Unique identifier for the staff member	string	[Users]dcid or SSN (last 9 digits) via getStaffUniqueId()
classroomPositionDescriptor	Ed-Fi descriptor for the staff member's role in the classroom (e.g., Teacher, Teacher Assistant, Paraprofessional)	string	[SectionTeacher]RoleId via ROLEDEF
beginDate	Date when staff assignment to section begins	datetime	[SectionTeacher]BeginDate
endDate	Date when staff assignment to section ends	datetime	[SectionTeacher]EndDate
attendance90Percent	GA extension: Boolean indicator of whether teacher achieved 90% attendance in section (nested in _ext.Gadoe)	boolean	Calculated via function with up to 4 attendance attempts
chwCertFieldCodeDescriptor	GA extension: Certification field code descriptor for Community Health Worker (nested in _ext.Gadoe, optional)	string	chwCertFieldCode_DX from [S_GA_SEC_X]

Student Section Associations

Students and their enrolled sections.

Primary PowerSchool Source Data

Core tables used in this resource:

[cc]
[students]
[sections]
[courses]
[terms]
[spenrollments]
[s_ga_stu_esol_c]
[s_ga_stu_eip_c]
[s_ga_stu_speced_x]

Selection Criteria

Business logic for publishing this resource:

Student must be enrolled in CC (class roster)
Enrollment period must overlap with section dates
Student must not be excluded from reporting
Course must not be reserved (code starting with '00')
CC record must show enrollment before withdrawal (DateEnrolled < DateLeft)
Section must have meeting times
Checks for ESOL, EIP, and Special Education flags based on enrollment dates

Resource Output

Expected output from the selection criteria:

sectionReference - Reference to the section
studentReference - Reference to the student
beginDate - Student enrollment date in section
endDate - Student withdrawal date from section (optional)
GA extension fields for programs and delivery models

Automatic Publishing

Whenever the related fields in the UI are updated, this resource will automatically generate the necessary DCF events to publish the resource with the updated values.

Data Elements

Details of each data element published in this resource:

Data Element	Description	[Table]Data Type	Stored in [Table]Field
sectionReference	Reference to the section student is enrolled in	customobject	[Sections]ID
studentReference	Reference to the student	customobject	[Students]State_StudentNumber
studentUniqueId	Unique identifier for the student	string	[Students]State_StudentNumber or [Students]ID
beginDate	Date student enrolled in this section	datetime	[CC]DateEnrolled
endDate	Date student withdrew from this section (optional)	datetime	[CC]DateLeft
creditRecovery	GA extension: Boolean indicator of credit recovery program participation (nested in _ext.Gadoe, optional)	boolean	[S_GA_CC_X]CreditRecovery
workBasedLearningProgramDescriptor	GA extension: Descriptor for work-based learning program type (nested in _ext.Gadoe, optional)	string	WorkBasedLearning_DX from [S_GA_CC_X]
eipDeliveryModelDescriptor	GA extension: Delivery model for EIP (English Intervention Program) when student is enrolled (nested in _ext.Gadoe, optional)	string	EIPDeliveryModel_DX from [S_GA_STU_EIP_C]
esolDeliveryModelDescriptor	GA extension: Delivery model for ESOL when student is enrolled (nested in _ext.Gadoe, optional). Values: Pullout, Inclusion, Combination	string	ESOLDeliveryModel_DX from [S_GA_STU_ESOL_C]
giftedDeliveryModelDescriptor	GA extension: Delivery model for Gifted services when applicable (nested in _ext.Gadoe, optional)	string	GiftedDeliveryModel_DX
specialEducationDeliveryModelDescriptor	GA extension: Delivery model for Special Education services (nested in _ext.Gadoe, optional). Values: General Ed Classroom, Resource Room, Self-Contained, Separate Facility, Homebound/Hospital, Correctional Facility	string	SPEDDeliveryModel_DX from [S_GA_STU_Speced_X]
iepInclusionTypeDescriptor	GA extension: IEP inclusion type descriptor (nested in _ext.Gadoe, optional). Determines level of inclusion in general education	string	IepInclusionType_DX
numberParapros	GA extension: Number of paraprofessionals assigned to student in this section (nested in _ext.Gadoe, optional)	number	[S_GA_CC_X]NumberParaPros
attendance90Percent	GA extension: Boolean indicator of student achieving 90% attendance in section (nested in _ext.Gadoe, optional)	boolean	Calculated via function
enrollmentLocationDescriptor	GA extension: Location descriptor for enrollment (nested in _ext.Gadoe, optional)	string	EnrollmentLocation_DX from [S_GA_CC_X]
additionalTeachers	GA extension: Array of additional teachers assigned to this student's section (nested in _ext.Gadoe, optional)	array	[S_GA_CC_Additional_Teachers] Staff References