Arizona Ed-Fi Data v3.5 - Student Section Association

Classic View: System Administration > Ed-Fi 

Search Terms: 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

When a student is scheduled into a course section.

  • A record will report for each Section record that is reported based on the Sections logic.
  • If roster start date is after the term end date, do not report a record for the prior term.
  • Only send records if the student has a enrollment in the schedule structure where the student is scheduled and is not marked as No Show or State Exclude.

  • Do not send records if the Calendar Exclude checkbox is checked.
  • Do not send records if the School Exclude checkbox is checked.
  • Do  not send records if the Course is marked as Inactive.
  • Do not send a record if the State Reporting Exclude checkbox is selected on the course.
PostSend a new record if a student's roster start date is changed.
Put

When section information is updated for a student or section.

  • Update when the course or section's homeroom field is changed.
DeleteWhen a student is deleted from a course section.
Delete

Delete any future records if the student is given a roster end date for the course.

  • Roster End Date must be before Term Start date of future records.
Delete/PostDelete the record if a student's roster start date is changed.


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 student's 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.


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

Business Rules

M, C or O

Data Source GUI Path

Database Field

idThe unique identifier of the resource.


M

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'
  1. Report the roster start date for the term record in which the start date occurs.
    • For any records in the future terms for that course, use the earliest term start date.
  2. If Start Date is NULL, report the earliest term start date associated with the term descriptor selected for this section based on section schedule placement.
M

Student Information> General> Schedule> Roster Start Date


OR


System Administration> Calendar> Calendar> Terms

roster.startdate

or

terms.startdate


section
Reference
A reference to the related Section resource.

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

  1. For sessionName:
    • If the Session Name Override checkbox is checked in the Session resource preferences, then report the 'District Id - Term Descriptor of the term being reported'.
    • Otherwise, report the Term Descriptor of the term being reported.
M

student
Reference 
A reference to the related Student resource.

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


Note: The Ed-Fi ID reports from the Student State ID field.


M

attemptStatus
Descriptor

An indication of the student’s attempt status for the section.

This is optional, does not report.

O

endDate Month, day, and year of the withdrawal or exit of the student from the section.
  1. Report the Roster End Date for the student, if it exists.
    • If a roster end date is entered, delete any records for future terms for that section.
  2. If the Roster End Date is NULL, only report a value if:
    • When the resource is triggered to send, the current date is on or after the Section > Term end date for the last term of the section, and
    • The student is in grades 9-12.
      • The value reported should be the section's terms.endDate
  3. Otherwise, do not report.
O

Student Information> General> Schedule> Roster End Date


OR


System Administration> Calendar> Calendar> Terms

roster.endDate

or

terms.endDate

homeroom
Indicator 
Indicator that the class is the student''s designated homeroom used for daily attendance reporting.

This is optional, does not report.

O



CourseEntry
Descriptor
The way the student entered this course section, either as a new enrollee or as a transfer from another section at the same school.
  1. Report 'T' when the student transferred into a different section of the same course in the same school year.
    • Student's roster start date is after the earliest term start date based on section schedule placement.
    • Student must have been scheduled into the same course in a different section prior to the roster start date of the section being reported.
    • The sections must have the same section schedule placement in order to be considered.
  2. Report 'R' when the student left a section, then later returned to that same section.
  3. Else, report 'N'.
M

CourseExit
Descriptor
The type of exit the student had from this course section.
  1. If the Roster End Date is reported as the endDate,
    1. Check to see if there is an associated transcript credit posted.
      • If creditsAttemped = creditsEarned report 'CF'.
      • If creditsAttempted > creditsEarned and creditsEarned > 0 report 'CP'.
      • If creditsEarned = '0', check to see if Roster End Date = Enrollment End Date.
        • If yes, report 'LS'.
        • Else report 'CN'.
      • If no associated transcript credit is posted, check to see if Roster End Date = Enrollment End Date.
        • If yes, report 'LS'.
        • Otherwise report 'SC'.
  2. If the Roster End Date is NULL, and when the resource is triggered to send, currentDate is on or after the Section > Term end date for the last term of the section, and the student is in grades 9-12:
    • If creditsAttemped = creditsEarned report 'CF'.
    • If creditsAttempted > creditsEarned and creditsEarned > 0 report
      'CP'.
    • If creditsEarned = 0 report 'CN'.
  3. Otherwise, do not report.
CStudent Information > General > Transcript > Credits Earned

Student Information > General > Transcript > Credits Attempted

transcriptDetal.creditsEarned

transcriptDetal.creditsAttempted
DualCreditA flag indicating if this student is earning Dual Credit in a Dual Credit Course.
  1. Report 'True' if Dual Credit check box is selected on the Course editor.
  2. Report 'True' if Dual Credit check box is selected on the Section editor.
  3. Report 'True' if Dual Credit check box is selected on the Roster Batch Edit editor.
  4. Else report 'False'.
M

Course > Dual Credit


Course > Section > Dual Credit


Course > Section> Roster Batch Edit > Dual Credit

course.dualCredit
section.dualCredit

Concurrent
Enrollment
A Flag indicating If this student is concurrently enrolled in a course that offers concurrent enrollment.


  1. Report 'True' if the Post
    Secondary check box is checked on the course.
  2. Else, report 'False'.
MScheduling > Course > Post Secondarycourse.postSecondary
repeatIdentifier
Type
An indication as to whether a student has previously taken a given course. 

Does not report, this data is
not collected in Campus.

O

teacherStudent
DataLink
Exclusion
Indicates that the student-section combination is excluded from calculation of value-added or growth attribution calculations used for a particular teacher evaluation.

Does not report, this data is
not collected in Campus.

O

etagA unique system-generated value that identifies the version of the resource.
O






 

Course Entry Descriptor

Code ValueShort DescriptionDescription
NNew enrollment
RRe-entry
TTransfer