Sections (Georgia v3.6.1)

Tool Search: Ed-Fi

This educational entity represents a setting in which organized instruction of course content is provided to one or more students for a given period of time. A course may be offered to more than one class/section. Instruction, provided by one or more teachers or other staff members, may be delivered in person or via a different medium.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a section is created OR When a Section Student Detail record is created with a Course State Code Override that is different than the associated course's State Code.

  • Do not report a record if the any of the following exclusions are present:
    • Course is inactive (Active is unchecked)
    • Course State Exclude
    • Course State Code is NULL
    • Calendar Exclude
    • School Exclude
  • The section must be scheduled into a term/period (Section Placement) to report.
  • A record will be posted for each unique term the section is scheduled in.
  • Section records will exist for BOTH the original and override state codes (if entered).
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 is changed on the Course:
    • State Code
    • Online Learning
    • Alt School Code
    • Alt System Code
    • Active
    • State Exclude
    • Grading Task Credits
  • When the following information is changed on the Section:

    • Section ID (New Section)
    • Section Placement (Terms Offered)
    • Online Learning (Override)
    • Immersion Language
    • Alt School Code
    • Alt System Code
  • When the following information is changed on Section Student Detail:

    • Course State Code Override
  • When the following information is changed on Staff History:
    • Staff History ID (New Staff History)
    • Role

Delete
  • When the terms the section is offered in are changed or removed.
  • When the section is deleted.
  • When the Section Student Detail record that has a Course State Code Override is deleted.
  • 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.
DeleteIf a resource is toggled to 'OFF" after data has sent and an action is performed that would trigger a delete, that data will remain in the ODS until a resync is done.
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
Post/Delete

Natural Key Changes:

  • If the School ID changes, all data will remain under the old number and a resync will need to be completed to populate data under the new number. The delete tool would need to be used to remove all data from the old School ID.
Post/Delete

If any of the following changes in the Course Offerings resource:

  • Local Course Code
  • Session Name
Post/DeleteIf the natural key changes all dependent data will delete/post.
Dependent ResourcesStaff Section Associations, Student Section Associations, Student Section Attendance Events, Grades.


Scope Year Logic

This table describes scope year logic of this object.

Logic
Sections will report to the configured year to which they are aligned.
Data will only send for years that have valid configuration.


Resource Preferences

This table describes the Resource Preferences of this object.

Data Element LabelMapping Needed
Instructional Languages DescriptorAlternative Instruction Language
Educational Environment DescriptorsSection Distance Learning Provider
Medium of Instruction DescriptorsSection Course Delivery Model Code


Identity Mapping Object Key

This table describes the Resource Preferences of this object.

Campus Object KeyObject Key Data Source
SectionPlacementsectionID-termID


Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
sectionPost/Put/DeleteThe primary table used for sending data for this resource.
coursePut

Educational Environment Descriptor

Sequence of Course

gradingTaskCreditPutAvailable Credits


Object Data Elements

This table describes data elements sent within the Sections resource.

Data Element Label

Business Requirement and Business Rules

M, C or O

Data Source GUI Path

Database Field

sectionIdentifier

The local identifier assigned to a section.


Reports the Section ID.

M Course > Sectionsection.sectionID
courseOfferingReferenceA reference to the related CourseOffering resource.

Reports the fields that are part of the Natural Key for the Course Offering resource.
M N/AN/A
characteristics

Reports the below data elements in an array:

  • sectionCharacteristicDescriptor
    • Reports if:
      • Section Online Learning (Override) is set to "Y: Yes" OR
      • Course Online Learning is set to "Y: Yes" OR
      • Course State Code has a "3" after the decimal.
        • Example 10.3230000
    • Reports N in all other situations.
C

Course > Online Learning, State Code


Section > Online Learning (Override)


Course.distanceCode


Section.distanceCode


availableCreditsCredits or units of value awarded for the completion of a course.

Report the result of the following calculation:
  • Total Credits (from all Grading Tasks on the Course) / Number of Terms the Section occurs. 

CCourse > Grading Tasks > CreditgradingTaskCredit.
Credit
classPeriods The class period during which the Section meets.

For all class periods the course is offered in the reporting term, reports the fields that are part of the Natural Key for the Class Periods resource in an array.
M N/AN/A
instructionLanguageDescriptor The primary language of instruction, if omitted English is assumed.

  • Reports the Ed-Fi Code mapped to the value selected for "Immersion Language".
  • If "Immersion Language" is NULL, do not report.
C

Section > Immersion Language


Section.immersionLanguage
alternateEducationOrganizationId

Indicates Concurrent enrollment system


  • Report if both Alt School Code and Alt System Code are populated on the Section.
  • If Section is empty, report if both Alt School Code and Alt System Code are populated on Course.
  • Else, do not report.
C

Course > Alt School Code, Alt System Code

Section > Alt School Code, Alt System Code



sectionName
  • Report the Section Number

    • If the Section Number is less than 3 digits, 0-pad it from the left to make it 3 digits long.
    • If the Section Number is more than 3 digits, report the last 3 digits.
M
Section > Number

Section.number


classPeriodNumber

Reports the lowest Sequence of the class periods the section is scheduled into.

  • Example: If the section is scheduled into a class period with the sequence of "5" and "6", it will report "05".
  • The format for this data element will always be ##.
    • If the Sequence is "3" in Campus, it should send as "03".
M
Section Information
sectionPlacement.periodID

Type/Descriptor

Click here to expand...

sectionCharacteristicDescriptor

Ed-Fi Value Code
Description
Namespace
Short Description
Y
Yes, the student is taking this course online.
uri://gadoe.org/SectionCharactersticDescriptor
Yes, the student is taking this course online.
NNo, the student is not taking this course onlineuri://gadoe.org/SectionCharactersticDescriptorNo, the student is not taking this course online

instructionLanguageDescriptor

Ed-Fi Code Value
Description
Namespace
Short Description
1
Ghanaian Languages (including Akan, Twi, Fante)
uri://gadoe.org/LanguageDescriptor
Ghanaian Languages (including Akan, Twi, Fante)
2American Indian (except Cherokee, Mohawk)uri://gadoe.org/LanguageDescriptorAmerican Indian (except Cherokee, Mohawk)
4Arabicuri://gadoe.org/LanguageDescriptorArabic
5Chineseuri://gadoe.org/LanguageDescriptorChinese
7Dutch / Flemishuri://gadoe.org/LanguageDescriptorDutch / Flemish
8English, Standard Americanuri://gadoe.org/LanguageDescriptorEnglish, Standard American
9Persian languages (including Farsi and Dari)uri://gadoe.org/LanguageDescriptorPersian languages (including Farsi and Dari)
10Frenchuri://gadoe.org/LanguageDescriptorFrench
11Germanuri://gadoe.org/LanguageDescriptorGerman
12Greekuri://gadoe.org/LanguageDescriptorGreek
13Gujaratiuri://gadoe.org/LanguageDescriptorGujarati
14Creoles and pidgins - Haitian Creole (Patois)uri://gadoe.org/LanguageDescriptorCreoles and pidgins - Haitian Creole (Patois)
15Hebrewuri://gadoe.org/LanguageDescriptorHebrew
16Hindiuri://gadoe.org/LanguageDescriptorHindi
17Italianuri://gadoe.org/LanguageDescriptorItalian
18Japaneseuri://gadoe.org/LanguageDescriptorJapanese
19Khmer (including North, South, and Central Khmer, and Mon-Khmer)uri://gadoe.org/LanguageDescriptorKhmer (including North, South, and Central Khmer, and Mon-Khmer)
20Koreanuri://gadoe.org/LanguageDescriptorKorean
21Laouri://gadoe.org/LanguageDescriptorLao
22Philippine languages (including Cebuano, Filipino, Tagalog, and Visaya)uri://gadoe.org/LanguageDescriptorPhilippine languages (including Cebuano, Filipino, Tagalog, and Visaya)
23Polishuri://gadoe.org/LanguageDescriptorPolish
24Portugueseuri://gadoe.org/LanguageDescriptorPortuguese
25Russianuri://gadoe.org/LanguageDescriptorRussian
26Spanishuri://gadoe.org/LanguageDescriptorSpanish
27Swedishuri://gadoe.org/LanguageDescriptorSwedish
28Thaiuri://gadoe.org/LanguageDescriptorThai
29Turkishuri://gadoe.org/LanguageDescriptorTurkish
30Vietnameseuri://gadoe.org/LanguageDescriptorVietnamese
31Other African languages (for example, Bariba Bassa, Berber, Fula, Mende, Nuer)uri://gadoe.org/LanguageDescriptorOther African languages (for example, Bariba Bassa, Berber, Fula, Mende, Nu
32Other Asian language (for example, Kyrgyz)uri://gadoe.org/LanguageDescriptorOther Asian language (for example, Kyrgyz)
33Other European languages (for example, Belarusian, Catalan, Faroese)uri://gadoe.org/LanguageDescriptorOther European languages (for example, Belarusian, Catalan, Faroese)
34Other Indian languages (for example, Bangldeshi, Bhili, Kannada, Kashmiri, Konkani, Malayalam, Meituri://gadoe.org/LanguageDescriptorOther Indian languages (for example, Bangldeshi, Bhili, Kannada, Kashmiri, 
35Central American Indian languages (including Mayan Languages such as K iche, Q eqchi, Mam, and Q anuri://gadoe.org/LanguageDescriptorCentral American Indian languages (including Mayan Languages such as K iche
36Mixtecouri://gadoe.org/LanguageDescriptorMixteco
37Nahuatluri://gadoe.org/LanguageDescriptorNahuatl
38Zapotecouri://gadoe.org/LanguageDescriptorZapoteco
39Bosnianuri://gadoe.org/LanguageDescriptorBosnian
40Bulgarianuri://gadoe.org/LanguageDescriptorBulgarian
41Serbo-Croatianuri://gadoe.org/LanguageDescriptorSerbo-Croatian
42Hmonguri://gadoe.org/LanguageDescriptorHmong
43Hungarianuri://gadoe.org/LanguageDescriptorHungarian
44Iranianuri://gadoe.org/LanguageDescriptorIranian
45Punjabiuri://gadoe.org/LanguageDescriptorPunjabi
46Romanian languages (including Moldovan, Romany)uri://gadoe.org/LanguageDescriptorRomanian languages (including Moldovan, Romany)
47Somaliuri://gadoe.org/LanguageDescriptorSomali
48Swahiliuri://gadoe.org/LanguageDescriptorSwahili
49Ukrainianuri://gadoe.org/LanguageDescriptorUkrainian
50Urduuri://gadoe.org/LanguageDescriptorUrdu
52Creoles and pidgins (Other)uri://gadoe.org/LanguageDescriptorCreoles and pidgins (Other)
53Creoles and pidgins - English based (including Jamaican, Krio, Sotho, Sranan Togo)uri://gadoe.org/LanguageDescriptorCreoles and pidgins - English based (including Jamaican, Krio, Sotho, Srana
54Creoles and pidgins - French baseduri://gadoe.org/LanguageDescriptorCreoles and pidgins - French based
55Creoles and pidgins - Portuguese-based (including Crioulo)uri://gadoe.org/LanguageDescriptorCreoles and pidgins - Portuguese-based (including Crioulo)
60Afrikaansuri://gadoe.org/LanguageDescriptorAfrikaans
61Albanian (including Gheg)uri://gadoe.org/LanguageDescriptorAlbanian (including Gheg)
62Armenianuri://gadoe.org/LanguageDescriptorArmenian
63Bengali/Bangla languages (including Rohingya)uri://gadoe.org/LanguageDescriptorBengali/Bangla languages (including Rohingya)
64Bantu languages (for example, Bemba, Bube, Bulu, Chichewa, Fang, Kirundi, Lingala, Nguni, Nyanji, Suri://gadoe.org/LanguageDescriptorBantu languages (for example, Bemba, Bube, Bulu, Chichewa, Fang, Kirundi, L
65Burmese, Hakha Chin languages (including Lai and Mizo)uri://gadoe.org/LanguageDescriptorBurmese, Hakha Chin languages (including Lai and Mizo)
67Cantoneseuri://gadoe.org/LanguageDescriptorCantonese
68Cherokeeuri://gadoe.org/LanguageDescriptorCherokee
69Czechuri://gadoe.org/LanguageDescriptorCzech
70Danishuri://gadoe.org/LanguageDescriptorDanish
71Estonianuri://gadoe.org/LanguageDescriptorEstonian
72Finnishuri://gadoe.org/LanguageDescriptorFinnish
74Gbe languages (including, Adja, Aja, Ewe, Mina)uri://gadoe.org/LanguageDescriptorGbe languages (including, Adja, Aja, Ewe, Mina)
75Gaelicuri://gadoe.org/LanguageDescriptorGaelic
76Georgianuri://gadoe.org/LanguageDescriptorGeorgian
77Hakkauri://gadoe.org/LanguageDescriptorHakka
78Hawaiianuri://gadoe.org/LanguageDescriptorHawaiian
79Icelandicuri://gadoe.org/LanguageDescriptorIcelandic
80Indonesianuri://gadoe.org/LanguageDescriptorIndonesian
81Kazakhuri://gadoe.org/LanguageDescriptorKazakh
82Kurdishuri://gadoe.org/LanguageDescriptorKurdish
83Laotianuri://gadoe.org/LanguageDescriptorLaotian
85Latvianuri://gadoe.org/LanguageDescriptorLatvian
86Lithuanianuri://gadoe.org/LanguageDescriptorLithuanian
87Macedonianuri://gadoe.org/LanguageDescriptorMacedonian
88Malay (including Calypso Malay)uri://gadoe.org/LanguageDescriptorMalay (including Calypso Malay)
89Mandarinuri://gadoe.org/LanguageDescriptorMandarin
90Mande languages (including Bambara, Gio, Soninke)uri://gadoe.org/LanguageDescriptorMande languages (including Bambara, Gio, Soninke)
91Micronesian and Polynesian languages (including Kosraean, Mokilese, Norfolk, Pohnpeian, and Tahitiauri://gadoe.org/LanguageDescriptorMicronesian and Polynesian languages (including Kosraean, Mokilese, Norfolk
92Mohawkuri://gadoe.org/LanguageDescriptorMohawk
93Mongolianuri://gadoe.org/LanguageDescriptorMongolian
94Nepaliuri://gadoe.org/LanguageDescriptorNepali
95Norwegianuri://gadoe.org/LanguageDescriptorNorwegian
96Middle Eastern languages (including Balochi)uri://gadoe.org/LanguageDescriptorMiddle Eastern languages (including Balochi)
97Nigerian languages (including Bini, Bokyi, Edo, Gokana, Hausa, Igbo, Ogoni, Urhobo)uri://gadoe.org/LanguageDescriptorNigerian languages (including Bini, Bokyi, Edo, Gokana, Hausa, Igbo, Ogoni,
98South American Indian languages (including Aymara, Guarani, and Ixil)uri://gadoe.org/LanguageDescriptorSouth American Indian languages (including Aymara, Guarani, and Ixil)
99Sindhiuri://gadoe.org/LanguageDescriptorSindhi
100Pashto/Pushtuuri://gadoe.org/LanguageDescriptorPashto/Pushtu
102Samoanuri://gadoe.org/LanguageDescriptorSamoan
103Sign Languagesuri://gadoe.org/LanguageDescriptorSign Languages
104Slovakuri://gadoe.org/LanguageDescriptorSlovak
105Turkmenuri://gadoe.org/LanguageDescriptorTurkmen
106Uzbekuri://gadoe.org/LanguageDescriptorUzbek
107Welshuri://gadoe.org/LanguageDescriptorWelsh
108Senegal Languages (including Fulani, Mandinka or Mandingo, and Wolof)uri://gadoe.org/LanguageDescriptorSenegal Languages (including Fulani, Mandinka or Mandingo, and Wolof)
109Sudan Languages (including Kuku, Masalit, or Shilluk)uri://gadoe.org/LanguageDescriptorSudan Languages (including Kuku, Masalit, or Shilluk)
110Chad Languages (including Kaba, Sara)uri://gadoe.org/LanguageDescriptorChad Languages (including Kaba, Sara)
111Karen languages (including Karenni)uri://gadoe.org/LanguageDescriptorKaren languages (including Karenni)
113Tamiluri://gadoe.org/LanguageDescriptorTamil
114Teluguuri://gadoe.org/LanguageDescriptorTelugu
115Marathiuri://gadoe.org/LanguageDescriptorMarathi
116Kinyarwandauri://gadoe.org/LanguageDescriptorKinyarwanda
117Yorubauri://gadoe.org/LanguageDescriptorYoruba
118Dinkauri://gadoe.org/LanguageDescriptorDinka
119Amharicuri://gadoe.org/LanguageDescriptorAmharic
120Tigrinyauri://gadoe.org/LanguageDescriptorTigrinya
121Afaruri://gadoe.org/LanguageDescriptorAfar
122Eritrean Languages (Including Kunama, Tigre)uri://gadoe.org/LanguageDescriptorEritrean Languages (Including Kunama, Tigre)
123Ethiopian languages (including Oromo, Sidaama)uri://gadoe.org/LanguageDescriptorEthiopian languages (including Oromo, Sidaama)
124Sangouri://gadoe.org/LanguageDescriptorSango