Student Section Associations (Georgia v3.6.1)

Tool Search: Ed-Fi

This association indicates the course sections to which a student is assigned.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	Reports a record when a student is scheduled into a section OR when the student has a Section Student Detail record with a Course State Code Override. Do not report a record if the any of the following exclusions are present: Enrollment State Exclude Enrollment No Show Enrollment Grade Exclude from State Reporting Course is inactive (Active is unchecked) Course State Exclude Course State Code is NULL Calendar Exclude School Exclude Student Section Association records will exist for ONLY the original or the override state code. If the Course State Code Override is present on a Section Student Detail record for the student, the Student Section Association records will be posted under that State Code. Otherwise, the associated course's State Code will be used. A record will report for each unique term the student is rostered into. The student must have an enrollment in the schedule structure where the student is scheduled to report a record.
Delete/Post/Put	A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is otherwise performed. When the following information on the student's Roster is changed: Start Date End Date When the following information on the Section Student Detail record is changed: Course State Code Override
Delete	When the student is removed from the roster entirely. Delete any future records when the student is given a roster end date. Delete any past records when the student's roster start date is changed. When the Course State Code Override on a Section Student Detail record is changed or removed.

Action

Trigger

Post

Reports a record when a student is scheduled into a section OR when the student has a Section Student Detail record with a Course State Code Override.

Do not report a record if the any of the following exclusions are present:
- Enrollment State Exclude
- Enrollment No Show
- Enrollment Grade Exclude from State Reporting
- Course is inactive (Active is unchecked)
- Course State Exclude
- Course State Code is NULL
- Calendar Exclude
- School Exclude
Student Section Association records will exist for ONLY the original or the override state code.
- If the Course State Code Override is present on a Section Student Detail record for the student, the Student Section Association records will be posted under that State Code.
- Otherwise, the associated course's State Code will be used.
A record will report for each unique term the student is rostered into.
The student must have an enrollment in the schedule structure where the student is scheduled to report a record.

Delete/Post/Put

A DELETE / POST is performed if the data element being altered is part of the resource's natural key. A PUT is otherwise performed.

When the following information on the student's Roster is changed:
- Start Date
- End Date
When the following information on the Section Student Detail record is changed:
- Course State Code Override

Delete

When the student is removed from the roster entirely.
Delete any future records when the student is given a roster end date.
Delete any past records when the student's roster start date is changed.
When the Course State Code Override on a Section Student Detail record is changed or removed.

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.

Action	Trigger
None	If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
Resync	If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table.
Resync	If a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS.
Resync	If a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes.

Natural Key Changes, Cascading Updates, and Deletes Logic

This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.

Action	Trigger
Delete/Post	Natural Key change: The natural key logic from Sections and Students will update this resource if they change. If the students Begin Date changes.
Delete/Post	If the natural key changes all dependent data will delete/post. Student Section Attendance Events, Grades

Action

Trigger

Delete/Post

Natural Key change:

The natural key logic from Sections and Students will update this resource if they change.
If the students Begin Date changes.

Delete/Post

If the natural key changes all dependent data will delete/post.

Student Section Attendance Events, Grades

Scope Year Logic

This table describes scope year logic of this object.

Logic
Reports records in the scope year in which the course/section's calendar is aligned. Data will only send for years that have valid configuration.

Logic

Reports records in the scope year in which the course/section's calendar is aligned.

Data will only send for years that have valid configuration.

Resource Preferences

Data Element Label	Mapping Needed
Special Program Code Descriptor	Course Dual/Concurrent Credit Indicator

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
roster	Post/Put/Delete	The primary table used for sending data for this resource.
roster	Put	End date
terms	Put	End date
course	Put	homeroom
section	Put	homeroom

Object Data Elements

This table describes data elements sent within the Student Section Association resource.

Data Element Label	Business Requirement and Business Rules	M, C or O	Data Source GUI Path	Database Field
beginDate	Month, day and year of the student''s entry or assignment to the section. If blank, default is the start date of the first grading period. Reports the Roster Start Date. If NULL, reports the Term Start Date.	M	Section > Roster > Start Date System Administration > Calendar > Calendar > Terms	roster.startDate terms.startDate
sectionReference	A reference to the related Section resource. Reports the fields that are part of the Natural Key for the Section resource.	M	N/A	N/A
studentReference	A reference to the related Student resource. Reports the fields that are part of the Natural Key for the Student resource.	M	N/A	N/A
endDate	Month, day, and year of the withdrawal or exit of the student from the section. Reports the Roster End Date. If NULL, reports the Term End Date.	C	Section > Roster > End Date System Administration > Calendar > Calendar > Terms	roster.endDate term.endDate
creditRecovery	If the student has a Section Student Detail record: Report True if Credit Recovery is set to "Y: Yes" on the Section Student Detail record. Report False if Credit Recovery is set to "N: No" on the Section Student Detail record. Look at the Section-level logic below if Credit Recovery is Blank / NULL on the Section Student Detail record. If the student does NOT have a Section Student Detail record OR Credit Recovery is Blank / NULL on their record: Report True if Credit Recovery is checked on the Section. Report False if Credit Recovery is NOT checked on the Section.	C	Section > Section Student Detail > Credit Recovery Section > Credit Recovery	SectionStudentDetailValue.value Section.creditRecovery
workBasedLearningProgramDescriptor	Report the Ed-Fi Code mapped to the value selected for Work Based Learning Program on the Section Student Detail record. If NULL or not mapped, report the Ed-Fi Code mapped to the value selected for Category of WBL Program - Override on Section. If NULL or not mapped, report the Ed-Fi Code mapped to the value selected for WBL Course Type on Course. If NULL or not mapped, do not report.	C	Section > Section Student Detail > Work Based Learning Program Section > Category of WBL Program - Override Course > WBL Course Type	SectionStudentDetailValue.value Section.wblProgramCategorySec Course.wblCourseType
eipDeliveryModelDescriptor	Report the Ed-Fi Code mapped to the value selected for EIP Delivery Model on the Section Student Detail record. If NULL or not mapped, report the Ed-Fi Code mapped to the value selected for EIP Delivery Model on Section. If NULL or not mapped, do not report.	C	Section > Section Student Detail > EIP Delivery Model Section > EIP Delivery Model	SectionStudentDetailValue.value Section.transcriptField7
esolDeliveryModelDescriptor	Report the Ed-Fi Code mapped to the value selected for ESOL Delivery Model on the Section Student Detail record. If NULL or not mapped, report the Ed-Fi Code mapped to the value selected for ESOL Delivery Model on Section. If NULL or not mapped, do not report.	C	Section > Section Student Detail > ESOL Delivery Model Section > ESOL Delivery Model	SectionStudentDetailValue.value CustomSection.value
giftedDeliveryModelDescriptor	Report the Ed-Fi Code mapped to the value selected for Gifted Delivery Model on the Section Student Detail record. If NULL or not mapped, report the Ed-Fi Code mapped to the value selected for Gifted Delivery Model on Section. If NULL or not mapped, do not report.	C	Section > Section Student Detail > Gifted Delivery Model Section > Gifted Delivery Model	SectionStudentDetailValue.value Section.giftedDelivery
specialEducationDeliveryModelDescriptor	Report the Ed-Fi Code mapped to the value selected for SPED Delivery Model on the Section Student Detail record. If NULL or not mapped, report the Ed-Fi Code mapped to the value selected for SPED Delivery Model on Section. If NULL or not mapped, do not report.	C	Section > Section Student Detail > SPED Delivery Model Section > SPED Delivery Model	SectionStudentDetailValue.value Section.spedDelivery
additionalTeacher	For ALL situations below, the teacher must be active in Staff History at the same time the student was active in the Roster. Report the staff member in the array if any of the below are true: The Role selected is "01: Teacher of Record."The student has an active EL record of Program Status = EL AND the Section OR Section Student Detail record has an ESOL Delivery Model value of 01, 02, or 06 AND the Role selected is "04: ESOL Teacher". The student's enrollment has Special Ed Status = Y: Yes OR a value other than Blank/NULL in Area of Exceptionality OR a SPED State Reporting tab record (that overlaps the Roster dates) with a value other than Blank/NULL in Area of Exceptionality AND the Role selected is 02 or 07 AND Section Student Detail record has a value that is NOT 9C for IEP Inclusion Type AND the Section OR Section Student Detail record has a value that is NOT NULL for SPED Delivery ModelIf the Course State Code being reported is ##.8###### AND the Role selected is "05: EIP Teacher" AND the Section Student Detail record has a value that is NOT 04 for EIP Delivery Model (If Section Student Detail record is NULL, check Section)If the Course State Code being reported is ##.1###### AND the Section OR Section Student Detail record has a value of 07 for SPED Delivery Model AND the Role selected is 02, 07, or 08If the Course State Code being reported is ##.2###### AND the Role selected is "06: Gifted Teacher"If the Course State Code being reported is NOT ##.8###### and NOT ##.9###### AND the Section Student Detail record has a value of 09 for IEP Inclusion Type AND the Role selected is "08: SPED Consult Teacher."If the Course State Code being reported is .0, .1, .2, .3, or .4 AND the Section OR Section Student Detail record has a value of 01 for SPED Delivery Model AND the Section Student Detail record has a value of 08 for IEP Inclusion Type AND the Role selected is 02, 07, or 08.
attendance90Percent	Report True if the most recent Section Student Detail record for the student in the section has 90% Attendance as Y: Yes or YO: Yes - Override. Report False in all other situations.	M	Student Section Detail	SectionStudentDetailValue.value

Types/Descriptors

Click here to expand...

fteProgramCodeDescriptor

Ed-Fi Code Value	Description	Namespace	Short Description
A	Kindergarten	uri://gadoe.org/FteProgramCodeDescriptor	Kindergarten
B	Grades 1-3	uri://gadoe.org/FteProgramCodeDescriptor	Grades 1-3
C	Grades 4-5	uri://gadoe.org/FteProgramCodeDescriptor	Grades 4-5
9	Middle Grades Program (Grades 6-8)	uri://gadoe.org/FteProgramCodeDescriptor	Middle Grades Program (Grades 6-8)
H	Middle School Program (Grades 6-8)	uri://gadoe.org/FteProgramCodeDescriptor	Middle School Program (Grades 6-8)
D	Grades 9-12	uri://gadoe.org/FteProgramCodeDescriptor	Grades 9-12
E	Kindergarten EIP(Early Intervention)	uri://gadoe.org/FteProgramCodeDescriptor	Kindergarten EIP(Early Intervention)
F	Primary Grades EIP	uri://gadoe.org/FteProgramCodeDescriptor	Primary Grades EIP
G	4th and 5th EIP	uri://gadoe.org/FteProgramCodeDescriptor	4th and 5th EIP
I	Gifted	uri://gadoe.org/FteProgramCodeDescriptor	Gifted
J	Remedial Education	uri://gadoe.org/FteProgramCodeDescriptor	Remedial Education
K	Vocational H.S. Lab	uri://gadoe.org/FteProgramCodeDescriptor	Vocational H.S. Lab
6	Dual Enrollment- General Ed.	uri://gadoe.org/FteProgramCodeDescriptor	Dual Enrollment- General Ed.
7	Dual Enrollment- Vocational	uri://gadoe.org/FteProgramCodeDescriptor	Dual Enrollment- Vocational
N	Study Hall	uri://gadoe.org/FteProgramCodeDescriptor	Study Hall
O	Other, non State-funded	uri://gadoe.org/FteProgramCodeDescriptor	Other, non State-funded
P	Mild Intellectual Disability	uri://gadoe.org/FteProgramCodeDescriptor	Mild Intellectual Disability
Q	Moderate Intellectual Disability	uri://gadoe.org/FteProgramCodeDescriptor	Moderate Intellectual Disability
R	Severe Intellectual Disability	uri://gadoe.org/FteProgramCodeDescriptor	Severe Intellectual Disability
S	Profound Intellectual Disability	uri://gadoe.org/FteProgramCodeDescriptor	Profound Intellectual Disability
T	Emotional/Behavioral Disorder	uri://gadoe.org/FteProgramCodeDescriptor	Emotional/Behavioral Disorder
U	Specific Learning Disability	uri://gadoe.org/FteProgramCodeDescriptor	Specific Learning Disability
V	Orthopedic Impairment	uri://gadoe.org/FteProgramCodeDescriptor	Orthopedic Impairment
W	Hearing Impairment	uri://gadoe.org/FteProgramCodeDescriptor	Hearing Impairment
X	Deaf	uri://gadoe.org/FteProgramCodeDescriptor	Deaf
Y	Other Health Impairment	uri://gadoe.org/FteProgramCodeDescriptor	Other Health Impairment
Z	Visual Impairment	uri://gadoe.org/FteProgramCodeDescriptor	Visual Impairment
1	Blind	uri://gadoe.org/FteProgramCodeDescriptor	Blind
2	Deaf and Blind	uri://gadoe.org/FteProgramCodeDescriptor	Deaf and Blind
3	Speech/Language Impairment	uri://gadoe.org/FteProgramCodeDescriptor	Speech/Language Impairment
4	GNETS (Psycho-Ed Program)	uri://gadoe.org/FteProgramCodeDescriptor	GNETS (Psycho-Ed Program)

iepInclusionTypeDescriptor

Ed-Fi Code Value	Description	Namespace	Short Description
N	No Inclusion services	uri://gadoe.org/IepInclusionTypeDescriptor	No Inclusion services
3	Speech Language Pathologist	uri://gadoe.org/IepInclusionTypeDescriptor	Speech Language Pathologist
4	Paraprofessional	uri://gadoe.org/IepInclusionTypeDescriptor	Paraprofessional
5	Interpreter	uri://gadoe.org/IepInclusionTypeDescriptor	Interpreter
6	Job Coach	uri://gadoe.org/IepInclusionTypeDescriptor	Job Coach
7	Assistive or Other personnel	uri://gadoe.org/IepInclusionTypeDescriptor	Assistive or Other personnel
8	Teacher-Not Special Education	uri://gadoe.org/IepInclusionTypeDescriptor	Teacher-Not Special Education
9	Certified Special Education Teacher/Collaborative Model	uri://gadoe.org/IepInclusionTypeDescriptor	Certified Special Education Teacher/Collaborative Model

inclusionPersonnelDescriptor

Ed-Fi Code Value	Description	Namespace	Short Description
N	No Inclusion services	uri://gadoe.org/InclusionPersonnelDescriptor	No Inclusion services
3	Speech Language Pathologist	uri://gadoe.org/InclusionPersonnelDescriptor	Speech Language Pathologist
4	Paraprofessional	uri://gadoe.org/InclusionPersonnelDescriptor	Paraprofessional
5	Interpreter	uri://gadoe.org/InclusionPersonnelDescriptor	Interpreter
6	Job Coach	uri://gadoe.org/InclusionPersonnelDescriptor	Job Coach
7	Assistive or Other personnel	uri://gadoe.org/InclusionPersonnelDescriptor	Assistive or Other personnel
8	Teacher-Not Special Education	uri://gadoe.org/InclusionPersonnelDescriptor	Teacher-Not Special Education
9	Certified Special Education Teacher/Collaborative Model	uri://gadoe.org/InclusionPersonnelDescriptor	Certified Special Education Teacher/Collaborative Model

workBasedLearningProgramDescriptor

Ed-Fi Code Value	Description	Namespace	Short Description
C	Cooperative Education	uri://gadoe.org/WorkBasedLearningProgramDescriptor	Cooperative Education
I	Internship	uri://gadoe.org/WorkBasedLearningProgramDescriptor	Internship
G	Great Promise Partnership	uri://gadoe.org/WorkBasedLearningProgramDescriptor	Great Promise Partnership
E	Employability Skills Development	uri://gadoe.org/WorkBasedLearningProgramDescriptor	Employability Skills Development
Y	Youth Apprenticeship Program	uri://gadoe.org/WorkBasedLearningProgramDescriptor	Youth Apprenticeship Program
W	Workforce Ready Blank	uri://gadoe.org/WorkBasedLearningProgramDescriptor	Workforce Ready Blank
	N/A	uri://gadoe.org/WorkBasedLearningProgramDescriptor	N/A

eipDeliveryModelDescriptor

Ed-Fi Code Value	Description	Namespace	Short Description
1	Augmented	uri://gadoe.org/EipDeliveryModelDescriptor	Augmented
2	Self-Contained	uri://gadoe.org/EipDeliveryModelDescriptor	Self-Contained
3	Pull-Out	uri://gadoe.org/EipDeliveryModelDescriptor	Pull-Out
5	Reading Recovery	uri://gadoe.org/EipDeliveryModelDescriptor	Reading Recovery
6	Innovative Model	uri://gadoe.org/EipDeliveryModelDescriptor	Innovative Model
	N/A	uri://gadoe.org/EipDeliveryModelDescriptor	N/A

esolDeliveryModelDescriptor

Ed-Fi Code Value	Description	Namespace	Short Description
1	Pull-Out (PO)	uri://gadoe.org/EsolDeliveryModelDescriptor	Pull-Out (PO)
2	Push-In (PI)	uri://gadoe.org/EsolDeliveryModelDescriptor	Push-In (PI)
4	Resource Center/Lab (RC)	uri://gadoe.org/EsolDeliveryModelDescriptor	Resource Center/Lab (RC)
5	Scheduled Class Period (Scheduled Language Acquisition)	uri://gadoe.org/EsolDeliveryModelDescriptor	Scheduled Class Period (Scheduled Language Acquisition)
6	Innovative Delivery Model	uri://gadoe.org/EsolDeliveryModelDescriptor	Innovative Delivery Model
8	Sheltered Content	uri://gadoe.org/EsolDeliveryModelDescriptor	Sheltered Content
9	Dual Language Immersion	uri://gadoe.org/EsolDeliveryModelDescriptor	Dual Language Immersion
A	Scheduled Class Period (Scheduled Language Acquisition at a Newcomer Program.)	uri://gadoe.org/EsolDeliveryModelDescriptor	Scheduled Class Period
B	Sheltered Content at a Newcomer Program	uri://gadoe.org/EsolDeliveryModelDescriptor	Sheltered Content at a Newcomer Program

giftedDeliveryModelDescriptor

Ed-Fi Code Value	Description	Namespace	Short Description
1	Resource Model	uri://gadoe.org/GiftedDeliveryModelDescriptor	Resource Model
2	Advanced Content(not AP or IB)	uri://gadoe.org/GiftedDeliveryModelDescriptor	Advanced Content(not AP or IB)
3	Cluster Group	uri://gadoe.org/GiftedDeliveryModelDescriptor	Cluster Group
4	Collaborative	uri://gadoe.org/GiftedDeliveryModelDescriptor	Collaborative
5	Internship/Mentorship	uri://gadoe.org/GiftedDeliveryModelDescriptor	Internship/Mentorship
7	Innovative Model	uri://gadoe.org/GiftedDeliveryModelDescriptor	Innovative Model
8	Advanced Placement (AP)	uri://gadoe.org/GiftedDeliveryModelDescriptor	Advanced Placement (AP)
9	International Baccalaureate (IB)	uri://gadoe.org/GiftedDeliveryModelDescriptor	International Baccalaureate (IB)
A	Directed Study	uri://gadoe.org/GiftedDeliveryModelDescriptor	Directed Study
B	Community Service Learning	uri://gadoe.org/GiftedDeliveryModelDescriptor	Community Service Learning

specialEducationDeliveryModelDescriptor

Ed-Fi Code Value	Description	Namespace	Short Description
1	Additional Supportive Service to the Student	uri://gadoe.org/SpecialEducationDeliveryModelDescriptor	Additional Supportive Service to the Student
2	Additional Supportive Service to the Teacher	uri://gadoe.org/SpecialEducationDeliveryModelDescriptor	Additional Supportive Service to the Teacher
3	Direct Service: Consultative	uri://gadoe.org/SpecialEducationDeliveryModelDescriptor	Direct Service: Consultative
4	Direct Service: Collaborative	uri://gadoe.org/SpecialEducationDeliveryModelDescriptor	Direct Service: Collaborative
5	Direct Service: Co-Teaching	uri://gadoe.org/SpecialEducationDeliveryModelDescriptor	Direct Service: Co-Teaching
6	Specialized Placement (Outside General Ed) / Individual or Small Group	uri://gadoe.org/SpecialEducationDeliveryModelDescriptor	Individual or Small Group
7	Specialized Placement (Outside General Ed) / Individual or Small Group with an Additional Content certified teacher.	uri://gadoe.org/SpecialEducationDeliveryModelDescriptor	Individual or Small Group with an Additional Content certified teacher.