MN v3.3 - Staff Section Associations

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

Object Triggering Logic

This table describes logic for triggering syncing of this object.

ActionTrigger
Post

When a staff is added to a course section on Staff History.

  • Must have a Staff Type of P:  Primary Teacher or T: Teacher in the Section Staff History Table.
  • Do not send records if the Calendar Exclude check box is checked.
  • Do not send a record if the Course is marked Inactive or Exclude.

  • Must have a role mapped to an Ed-Fi code populated to report.
  • Do not report a record if the Staff does not have an Ed-Fi ID.
    • OR Census > Credentials > Credential Type = LC Licensure/Certification > License Number
    • OR Census > District Employment > Employment Record > License Number
    • OR a License Number (EmploymentCredential.licenseNumber) in the HR Module > Qualifications
  • Do not report if the course is in a school marked as exclude.
  • Only send a record for sections in which staff have an overlapping section staff history record:

    1. Only post for session names where the start date of the term is on or before the section staff history end date or the section staff history end date is null.
    2. Only post for session names where the end date of the term is on or after the section staff history start date or the section staff history start date is null.

    PostWhen a Role mapped to an Ed-Fi code is added to an existing teacher on the Staff History Record.
    Put

    When Start or End dates are modified on the Staff History.

    DeleteWhen the staff member's District Assignment Record is Deleted.
    DeleteWhen a staff member is deleted from Staff History.
    DeleteWhen a Role is removed from a Teacher on Staff History.
    Delete/PostWhen the State Report Exclude on the Course is checked/unchecked.

    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/PostNatural Key changes: The natural key logic from Sections and Staffs will update this resource if they change.

    Scope Year Logic

    This table describes scope year logic of this object.

    Logic

    Reports for Sections in the scope year to which the course's calendar is aligned.

    • Data will only send for years that have valid configuration.

    Resource Preferences

    Data Element Label

    Mapping Needed

    Teacher RoleClassroom Position Descriptor

    Event Queue Detail

    This table describes the Event Queue Detail of this object.

    Campus TableEd-Fi ActionFields
    sectionstaffhistoryPost/Put/DeleteThe primary table used for sending data for this resource.
    employmentassignmentPutBegin Date, End date
    termPutBegin Date, End Date
    sectionstaffhistoryPutBegin Date, Role, End Date

    Object Data Elements

    This table describes data elements sent within the Staff 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

    sectionReferenceA reference to the related Section resource.
    1. Reports the data that is part of the Natural Key for the Section resource.


    M

     staffReferenceA reference to the related Staff resource.
    1. Reports the staffUniqueID
    1. 7 digit state staff ID
    2. If using HR Module, report from Qualifications > Number from the License record
    M

    Census > Staff > Credentials > Credential Type = LC Licensure/Certification > License Number

    OR


    Census > Staff > District Employment > Employment Record > License Number


    OR


    HR Module > HR Qualifications > Number

    EmploymentCredential.licenseNumber
    where employmentCredentialType = LC
    beginDateMonth, day and year of a teacher''s assignment to the section. If blank, defaults to the first day of the first grading period for the section. 

    Does not report.

    O

    N/A



    N/A



    classroom PositionDescriptorThe type of position the Staff member holds in the specific class/section; for example: Teacher of Record, Assistant Teacher, Support Teacher, Substitute Teacher...
    1. Reports the Ed-Fi Code from the Role that is selected.
    2. If Role is NULL, or no value is mapped, do not report a record.
    MScheduling & Courses > Courses > Section Information > Staff History > Rolesectionstaffhistory.
    role
    endDate Month, day and year of the last day of a teacher''s assignment to the section. NEDM: Ending Date. 
    1. Report the Staff History End Date if populated:
      • If Blank, look at the District Assignment record for the teacher for that School and report Assignment End Date if it is on or after the lowest Term Start Date and on or before the highest Term End Date for that section that is associated with the term descriptor selected for the section based on section schedule placement.
        • Else, Report the Term End Date for that section that is associated with the term descriptor selected for the section based on section schedule placement.
      • If the teacher has more than 1 District Assignment record that overlaps the section, report the End Date from the most Recent District Assignment record if it is on or after the lowest Term Start Date and on or before the highest Term End Date for that section that is associated with the term descriptor selected for the section based on section schedule placement.
        • Else, Report the Term End Date for that section that is associated with the term descriptor selected for the section based on section schedule placement.
    O

    N/A


    N/A







    Type/Descriptors

    Click here to expand...

    classroom Position Descriptor : SectionStaffHistory.role

    Campus Attribute CodeCampus Attribute NameEdFi Descriptor codeEdFi Descriptor description

    TR

    Teacher of Record

    TOR

    Teacher of Record

    Resource Preferences Continued

    The Ed-Fi Configuration tool is used to establish Ed-Fi data resources.

    The following describes how to set the resource preferences for the Staff Section Association resource. If the Configure or Edit button do not display, then the resource does not need to be mapped and the toggle button can be used to turn the resource on or off.

     If a mapping is changed, a resync must be performed on the resource in order for the new mappings to send correctly.
    1. Select the appropriate Ed-Fi Code for the Classroom Position Descriptors.

       Any item not mapped will not report to Ed-Fi.
      Classroom Position Descriptors
      Attribute DictionarySystem Settings > Custom Data and Links > Core Attribute Dictionary > Teacher > Role
      UI LocationScheduling & Courses > Courses > Section Information > Staff History > Role


    2. Click Save.