Staff Education Organization Contact Associations (Tennessee v5.3)

Tool Search: Ed-Fi

This association is used for the creation of SSO accounts in TEDS.

Object Triggering

ActionBusiness  Rule
Post

Staff must meet the following conditions to report a record:

  1. Have a District Assignment record with Assignment Code is not null.
    1. Assignment must overlap the configured scope year.
  2. Staff member has an Ed-Fi ID is not null.

Do NOT report a record if any one of the following scenarios are true:  

  1. There is not an Ed-FI ID for the staff person.
  2. The staff records are not active based on the Scope Year logic listed below
  3. If the record is being triggered from a District Assignment record and it is marked as Exclude

  4. If the record is being triggered from a District Assignment record and the School is marked as Exclude

PutWhen any data is edited for the person in the Data Elements fields below:
  • When the person’s identity record is changed.
  • When the person’s employment assignment record is changed.
  • When the person’s employment record is changed.
  • When one of the person’s employment credentials is changed.
DeleteStaff records are a shared resource among all districts, this record will not delete.

Object Data Elements

Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.

Data Element LabelBusiness RequirementBusiness RuleM, C, or OData Source GUI PathDatabase Field
contactTitleThis would be not a Title, but an identifier to distinguish the particular instance of the SIS package that is sending the data. This could be a serial number, or any unique identifier with a length <= 75 characters. If a local education agency has only one instance, this could be the local Education
AgencyId. 

Report theState District Number

MSystem Administration > Resources > District Information > State District NumberDistrict.number
educationOrganizationReference

A reference to the related EducationOrganization resource.


M

staffReferenceA reference to the related Staff resourceReports the data that is part of the Natural Key for the Staff resourceM

address
This is optional, do not report.O

contactTypeDescriptor
Reports 'Work'.O

electronicMailAddressStaff work email.Reports Email.MCensus > People > Demographics
telephonesPhone number used for SSO authenticationReports Cell Phone. If Cell Phone is null, do not report.
See array for field specific logic.
OCensus > People > Demographics

_ext.tdoe.submittedFor

SchoolYearTypeReference.

schoolYear

Key for School Year

Use the School Year tied to the configured year to identify the End Year

Report End Year

Format: CCYY

MSystem Administration > Ed-Fi > Ed-Fi Configuration > Connection > School YearSchoolYear.endYear
_ext.tdoe.submittedByEducation
OrganizationReference.education
OgranizationID
The identifier assigned to an education organization

Populate the State District Number

Format: Remove leading zeros

MSystem Administration > Resources > District Information

Arrays

Click here to expand...

Data Element LabelBusiness RulesM, C or O

Data Source GUI Path

Database Field
telephoneNumberTypeDescriptorReport 'Mobile'MN/A
doNotPublishIndicatorDo not reportON/A
orderOfPriorityDo not reportON/A
telephoneNumberReport Cell Phone.MCensus > People > Demographics
textMessageCapabilityIndicatorReport 'true'CN/A