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.

ActionTrigger
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.

ActionTrigger
NoneIf a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
ResyncIf 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.
ResyncIf 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.
ResyncIf 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.

ActionTrigger
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.

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 TableEd-Fi ActionFields
rosterPost/Put/DeleteThe primary table used for sending data for this resource.
rosterPutEnd date
termsPutEnd date
coursePuthomeroom
sectionPuthomeroom


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

beginDateMonth, 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


sectionReferenceA reference to the related Section resource.

Reports the fields that are part of the Natural Key for the Section resource.

MN/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.

MN/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 ValueDescriptionNamespaceShort Description
AKindergartenuri://gadoe.org/FteProgramCodeDescriptorKindergarten
BGrades 1-3uri://gadoe.org/FteProgramCodeDescriptorGrades 1-3
CGrades 4-5uri://gadoe.org/FteProgramCodeDescriptorGrades 4-5
9Middle Grades Program (Grades 6-8)uri://gadoe.org/FteProgramCodeDescriptorMiddle Grades Program (Grades 6-8)
HMiddle School Program (Grades 6-8)uri://gadoe.org/FteProgramCodeDescriptorMiddle School Program (Grades 6-8)
DGrades 9-12uri://gadoe.org/FteProgramCodeDescriptorGrades 9-12
EKindergarten EIP(Early Intervention)uri://gadoe.org/FteProgramCodeDescriptorKindergarten EIP(Early Intervention)
FPrimary Grades EIPuri://gadoe.org/FteProgramCodeDescriptorPrimary Grades EIP
G4th and 5th EIPuri://gadoe.org/FteProgramCodeDescriptor4th and 5th EIP
IGifteduri://gadoe.org/FteProgramCodeDescriptorGifted
JRemedial Educationuri://gadoe.org/FteProgramCodeDescriptorRemedial Education
KVocational H.S. Laburi://gadoe.org/FteProgramCodeDescriptorVocational H.S. Lab
6Dual Enrollment- General Ed.uri://gadoe.org/FteProgramCodeDescriptorDual Enrollment- General Ed.
7Dual Enrollment- Vocationaluri://gadoe.org/FteProgramCodeDescriptorDual Enrollment- Vocational
NStudy Halluri://gadoe.org/FteProgramCodeDescriptorStudy Hall
OOther, non State-fundeduri://gadoe.org/FteProgramCodeDescriptorOther, non State-funded
PMild Intellectual Disabilityuri://gadoe.org/FteProgramCodeDescriptorMild Intellectual Disability
QModerate Intellectual Disabilityuri://gadoe.org/FteProgramCodeDescriptorModerate Intellectual Disability
RSevere Intellectual Disabilityuri://gadoe.org/FteProgramCodeDescriptorSevere Intellectual Disability
SProfound Intellectual Disabilityuri://gadoe.org/FteProgramCodeDescriptorProfound Intellectual Disability
TEmotional/Behavioral Disorderuri://gadoe.org/FteProgramCodeDescriptorEmotional/Behavioral Disorder
USpecific Learning Disabilityuri://gadoe.org/FteProgramCodeDescriptorSpecific Learning Disability
VOrthopedic Impairmenturi://gadoe.org/FteProgramCodeDescriptorOrthopedic Impairment
WHearing Impairmenturi://gadoe.org/FteProgramCodeDescriptorHearing Impairment
XDeafuri://gadoe.org/FteProgramCodeDescriptorDeaf
YOther Health Impairmenturi://gadoe.org/FteProgramCodeDescriptorOther Health Impairment
ZVisual Impairmenturi://gadoe.org/FteProgramCodeDescriptorVisual Impairment
1Blinduri://gadoe.org/FteProgramCodeDescriptorBlind
2Deaf and Blinduri://gadoe.org/FteProgramCodeDescriptorDeaf and Blind
3Speech/Language Impairmenturi://gadoe.org/FteProgramCodeDescriptorSpeech/Language Impairment
4GNETS (Psycho-Ed Program)uri://gadoe.org/FteProgramCodeDescriptorGNETS (Psycho-Ed Program)

iepInclusionTypeDescriptor

Ed-Fi Code ValueDescriptionNamespaceShort Description
NNo Inclusion servicesuri://gadoe.org/IepInclusionTypeDescriptorNo Inclusion services
3Speech Language Pathologisturi://gadoe.org/IepInclusionTypeDescriptorSpeech Language Pathologist
4Paraprofessionaluri://gadoe.org/IepInclusionTypeDescriptorParaprofessional
5Interpreteruri://gadoe.org/IepInclusionTypeDescriptorInterpreter
6Job Coachuri://gadoe.org/IepInclusionTypeDescriptorJob Coach
7Assistive or Other personneluri://gadoe.org/IepInclusionTypeDescriptorAssistive or Other personnel
8Teacher-Not Special Educationuri://gadoe.org/IepInclusionTypeDescriptorTeacher-Not Special Education
9Certified Special Education Teacher/Collaborative Modeluri://gadoe.org/IepInclusionTypeDescriptorCertified Special Education Teacher/Collaborative Model

inclusionPersonnelDescriptor

Ed-Fi Code ValueDescriptionNamespaceShort Description
NNo Inclusion servicesuri://gadoe.org/InclusionPersonnelDescriptorNo Inclusion services
3Speech Language Pathologisturi://gadoe.org/InclusionPersonnelDescriptorSpeech Language Pathologist
4Paraprofessionaluri://gadoe.org/InclusionPersonnelDescriptorParaprofessional
5Interpreteruri://gadoe.org/InclusionPersonnelDescriptorInterpreter
6Job Coachuri://gadoe.org/InclusionPersonnelDescriptorJob Coach
7Assistive or Other personneluri://gadoe.org/InclusionPersonnelDescriptorAssistive or Other personnel
8Teacher-Not Special Educationuri://gadoe.org/InclusionPersonnelDescriptorTeacher-Not Special Education
9Certified Special Education Teacher/Collaborative Modeluri://gadoe.org/InclusionPersonnelDescriptorCertified Special Education Teacher/Collaborative Model

workBasedLearningProgramDescriptor

Ed-Fi Code ValueDescriptionNamespaceShort Description
CCooperative Educationuri://gadoe.org/WorkBasedLearningProgramDescriptorCooperative Education
IInternshipuri://gadoe.org/WorkBasedLearningProgramDescriptorInternship
GGreat Promise Partnershipuri://gadoe.org/WorkBasedLearningProgramDescriptorGreat Promise Partnership
EEmployability Skills Developmenturi://gadoe.org/WorkBasedLearningProgramDescriptorEmployability Skills Development
YYouth Apprenticeship Programuri://gadoe.org/WorkBasedLearningProgramDescriptorYouth Apprenticeship Program
WWorkforce Ready Blankuri://gadoe.org/WorkBasedLearningProgramDescriptorWorkforce Ready Blank

N/Auri://gadoe.org/WorkBasedLearningProgramDescriptorN/A

eipDeliveryModelDescriptor

Ed-Fi Code ValueDescriptionNamespaceShort Description
1Augmenteduri://gadoe.org/EipDeliveryModelDescriptorAugmented
2Self-Containeduri://gadoe.org/EipDeliveryModelDescriptorSelf-Contained
3Pull-Outuri://gadoe.org/EipDeliveryModelDescriptorPull-Out
5Reading Recoveryuri://gadoe.org/EipDeliveryModelDescriptorReading Recovery
6Innovative Modeluri://gadoe.org/EipDeliveryModelDescriptorInnovative Model

N/Auri://gadoe.org/EipDeliveryModelDescriptorN/A

esolDeliveryModelDescriptor

Ed-Fi Code ValueDescriptionNamespaceShort Description
1Pull-Out (PO)uri://gadoe.org/EsolDeliveryModelDescriptorPull-Out (PO)
2Push-In (PI)uri://gadoe.org/EsolDeliveryModelDescriptorPush-In (PI)
4Resource Center/Lab (RC)uri://gadoe.org/EsolDeliveryModelDescriptorResource Center/Lab (RC)
5Scheduled Class Period (Scheduled Language Acquisition)uri://gadoe.org/EsolDeliveryModelDescriptorScheduled Class Period (Scheduled Language Acquisition)
6Innovative Delivery Modeluri://gadoe.org/EsolDeliveryModelDescriptorInnovative Delivery Model
8Sheltered Contenturi://gadoe.org/EsolDeliveryModelDescriptorSheltered Content
9Dual Language Immersionuri://gadoe.org/EsolDeliveryModelDescriptorDual Language Immersion
AScheduled Class Period (Scheduled Language Acquisition at a Newcomer Program.)uri://gadoe.org/EsolDeliveryModelDescriptorScheduled Class Period
BSheltered Content at a Newcomer Programuri://gadoe.org/EsolDeliveryModelDescriptorSheltered Content at a Newcomer Program

giftedDeliveryModelDescriptor

Ed-Fi Code ValueDescriptionNamespaceShort Description
1Resource Modeluri://gadoe.org/GiftedDeliveryModelDescriptorResource Model
2Advanced Content(not AP or IB)uri://gadoe.org/GiftedDeliveryModelDescriptorAdvanced Content(not AP or IB)
3Cluster Groupuri://gadoe.org/GiftedDeliveryModelDescriptorCluster Group
4Collaborativeuri://gadoe.org/GiftedDeliveryModelDescriptorCollaborative
5Internship/Mentorshipuri://gadoe.org/GiftedDeliveryModelDescriptorInternship/Mentorship
7Innovative Modeluri://gadoe.org/GiftedDeliveryModelDescriptorInnovative Model
8Advanced Placement (AP)uri://gadoe.org/GiftedDeliveryModelDescriptorAdvanced Placement (AP)
9International Baccalaureate (IB)uri://gadoe.org/GiftedDeliveryModelDescriptorInternational Baccalaureate (IB)
ADirected Studyuri://gadoe.org/GiftedDeliveryModelDescriptorDirected Study
BCommunity Service Learninguri://gadoe.org/GiftedDeliveryModelDescriptorCommunity Service Learning

specialEducationDeliveryModelDescriptor

Ed-Fi Code ValueDescriptionNamespaceShort Description
1Additional Supportive Service to the Studenturi://gadoe.org/SpecialEducationDeliveryModelDescriptorAdditional Supportive Service to the Student
2Additional Supportive Service to the Teacheruri://gadoe.org/SpecialEducationDeliveryModelDescriptorAdditional Supportive Service to the Teacher
3Direct Service: Consultativeuri://gadoe.org/SpecialEducationDeliveryModelDescriptorDirect Service: Consultative
4Direct Service: Collaborativeuri://gadoe.org/SpecialEducationDeliveryModelDescriptorDirect Service: Collaborative
5Direct Service: Co-Teachinguri://gadoe.org/SpecialEducationDeliveryModelDescriptorDirect Service: Co-Teaching
6Specialized Placement (Outside General Ed) / Individual or Small Groupuri://gadoe.org/SpecialEducationDeliveryModelDescriptorIndividual or Small Group
7Specialized Placement (Outside General Ed) / Individual or Small Group with an Additional Content certified teacher.uri://gadoe.org/SpecialEducationDeliveryModelDescriptorIndividual or Small Group with an Additional Content certified teacher.