Staff Education Organization Assignment Association (Tennessee v5.3)

Tool Search: Ed-Fi

This association indicates the education organization to which a staff member provides services; also known as school of service.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	Staff must meet the following conditions to report: Have a District Assignment record with Assignment Code is not null. Assignment must overlap the configured scope year. Staff member has an Ed-Fi ID is not null. Staff member has an Email Address is not null.
Post	Do NOT report a record if any one of the following scenarios are true: There is not an Ed-FI ID and Email Address for the staff person. The staff records are not active based on the Scope Year logic listed below If the record is being triggered from a District Assignment record and it is marked as Exclude If the record is being triggered from a District Assignment record and the School is marked as Exclude
Put	When any field not part of the natural key changes: End Date Change to License Number Change to Licensure Check
Delete/Post	When any field part of the natural key changes: A change to a district assignment's Start Date. A change to the district assignment's Assignment Code
Delete	When District Assignment records are deleted.
Delete	When Assignment Code is removed.
Delete	When Ed-Fi ID is deleted.
Delete	When Email Address is deleted.

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.

Action	Trigger
None	If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send.
Resync	If 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.
Resync	If 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.
Resync	If 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.

Action	Trigger
Delete/Post	Natural Key change: 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. If an Ed-Fi ID changes, this will happen with the cascading deletes from the Ed-Fi ID Change trigger.
Delete/Post	The logic for an Ed-FI ID change will update all resources impacted by this change.
Delete/Post	If the Start Date or Assignment Code changes, the record will delete and re-post.
Delete/Post	Cascading Updates: The Staff Education Organization Assignment Association establishes ownership of the Staff record. If the natural key changes all dependent resources of staff will delete/post. Staff Education Organization Employment Associations, Staff School Associations, Staff Section Associations, Staff Cohort Associations

Scope Year Logic

This table describes scope year logic of this object.

Logic
A record will report when a person has a District Assignment or District Employment record that is aligned to a scoped year. Report when a staff has an active District Assignment or District Employment record that overlaps with the School year Start and End Dates. If School Year Start Date is NULL, 7/1/xxxx will be the default start date used. If School Year End Date is NULL, 6/30/xxxx will be the default end date used. Data will only send for the years that have valid configuration.
When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to. Current Year: Records will be compared to today's date to determine if the record is eligible to report. Previous Years: The record's date must be on or before the schools year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used. Future Years: The record's date must be on or after the schools year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

Logic

A record will report when a person has a District Assignment or District Employment record that is aligned to a scoped year.

Report when a staff has an active District Assignment or District Employment record that overlaps with the School year Start and End Dates.
- If School Year Start Date is NULL, 7/1/xxxx will be the default start date used.
- If School Year End Date is NULL, 6/30/xxxx will be the default end date used.
Data will only send for the years that have valid configuration.

When using data in Campus that has an effective date, the following logic will be applied to determine the scope year(s) to report the data to.

Current Year: Records will be compared to today's date to determine if the record is eligible to report.
Previous Years: The record's date must be on or before the schools year's end date defined in the School Years editor. If blank, the default date of 6/30/xxxx is used.
Future Years: The record's date must be on or after the schools year's start date defined in the School Years editor. If blank, the default date of 7/01/xxxx is used.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Staff Classification Descriptors	Employment District Assignment Code EmploymentAssignment Assignment Code

Data Element Label

Mapping Needed

Staff Classification Descriptors

Employment District Assignment Code

EmploymentAssignment Assignment Code

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus Table	Ed-Fi Action	Fields
employment	Post/Put/Delete	The primary table used for sending data for this resource.
employmentassignment	Post/Put/Delete	The primary table used for sending data for this resource.

Object Data Elements

This table describes data elements sent within the Staff Education Organization Assignment Association resource.

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
id	The unique identifier of the resource.		M
beginDate	Month, day and year of the start or effective date of a staff member''s employment, contract or relationship with the LEA. The following EIS 062 Staff Member Current Assignment definitions apply: Current Assignment Begin Date - Report the first day of current assignment in a school.	If the Start Date of the District Assignment is on or after the calendar's event type of 'CS', report Start Date. Otherwise, if the Start Date is prior to the event type of 'CS', report the event date.	M	Census> People> District Employment> Start Date Census> People> District Assignment> Start Date	employment.startDate employmentassignment.StartDate
staffClassification Descriptor	The titles of employment, official status, or rank of education staff. The following EIS 062 Staff Member Current Assignment definitions apply: Current Assignment - Report the position a staff member is assigned to provide service. A staff member may have multiple assignments.	Report the Ed-Fi Code Value mapped to the District Assignment Code of the District Assignment.	M	Census > People> District Assignment> Start Date > Assignment Code	EmploymentAssignment. assignmentCode
credentialReference	The following EIS 062 Staff Member Current Assignment definitions apply: Teacher License Number - Report the current license number of staff member.	This is optional, does not report.	O	See array logic below.
educationOrganization Reference	A reference to the related EducationOrganization resource.	Report the State District Number.	M	System Administration > Resources > District Information	district.number
StaffEducationOrganization EmploymentAssociation Reference	A reference to the related Staff Education Organization Employment Association resource.	Reports the data that is part of the Natural Key for the Staff Education Organization Employment Association	M
staffReference	A reference to the related Staff resource.	Reports the data that is part of the Natural Key for the Staff resource.	M
endDate	Month, day and year of the end or termination date of a staff member''s employment, contract or relationship with the LEA. The following EIS 062 Staff Member Current Assignment definitions apply: Current Assignment End Date - Report the last day a staff member was in the current assignment.	Report the District Assignment End Date.	O	Census > People > District Assignment > End Date	employmentassignment.endDate
orderOfAssignment	Describes whether the assignment is this the staff member's primary assignment, secondary assignment.	This is optional, do not report.	O
positionTitle	The descriptive name of an individual''s position.	Report the Ed-Fi Description mapped to the Assignment Code of the District Assignment.	O	Census > People> District Assignment> Start Date > Assignment Code	employmentassignment. assignmentCode
_ext.tdoe.licensure CheckDescriptor	The following EIS 060 Staff Member definitions apply: The reason a Staff Member may not be located on the licensure file.	For the Staff Member: If License Number is mpt null, populate NULL. Else If Licensure Check is not null, report the Ed-Fi Code Value mapped to the Licensure Check of the Staff Members District Employment record. If multiple district employment records exist, use the latest record. Otherwise, report null.	O	Census > People > District Employment > Licensure Check	CustomEmployment.value
_ext.tdoe.submittedForSchool YearTypeReference.schoolYear	The key for School Year.	Use the School Year tied to the configured year to identify the End Year.	M	System Administration > Ed-Fi > Ed-Fi Configuration > Connection > School Year	SchoolYear.endYear
_ext.tdoe.submittedByEducation OrganizationReference.education OgranizationID	The identifier assigned to an education organization.	State District Number + State School Number Note: Leading zeros are included to complete 7 character code.	M	System Administration > Resources > School System Administration > Resources > District Information	School.number district.number
_etag	A unique system-generated value that identifies the version of the resource.		O

Arrays

Click here to expand...

Credential Reference

Data Element Label	Business Requirements	Business Rule	M, C, or O	Data Source GUI Path	Database Field
credentialIdentifier	The following EIS 062 Staff Member Current Assignment definitions apply: Teacher License Number - Report the current license number of staff member	For the Staff Member: If Licensure Check is not null, report null. Otherwise, if License Number is not null, populate License Number. Otheriwse report null.	M	Census > People > District Employment > License Number	Employment. licenseNumber
stateOfIssueState AbbreviationDescriptor	Tennessee's code value for licensed staff.	For the Staff Member: If Licensure Check is not null, report null. Otherwise, if License Number is not null, populate License Number. Otheriwse report null.	M

Data Element Label

Business Requirements

Business Rule

M, C, or O

Data Source GUI Path

Database Field

credentialIdentifier

The following EIS 062 Staff Member Current Assignment definitions apply:

Teacher License Number - Report the current license number of staff member

For the Staff Member:

If Licensure Check is not null, report null.
Otherwise, if License Number is not null, populate License Number.
Otheriwse report null.

Census > People > District Employment > License Number

Employment.
licenseNumber

stateOfIssueState
AbbreviationDescriptor

Tennessee's code value for licensed staff.

For the Staff Member:

If Licensure Check is not null, report null.
Otherwise, if License Number is not null, populate License Number.
Otheriwse report null.

Type/Descriptor

Click here to expand...

Staff Classification Descriptors

District will be required to be map Calendar Event Descriptors to Day Events Types via Ed-Fi Configuration Resource Preferences.

Licensure Check Descriptor

District will be required to be map Calendar Event Descriptors to Day Events Types via Ed-Fi Configuration Resource Preferences

Code Value	Namespace	Description	Short Description
U	uri://tdoe.edu/LicensureCheckDescriptor	University Teacher	University Teacher
E	uri://tdoe.edu/LicensureCheckDescriptor	IEA Teacher	IEA Teacher
N	uri://tdoe.edu/LicensureCheckDescriptor	New Teacher	New Teacher
O	uri://tdoe.edu/LicensureCheckDescriptor	Other	Other
R	uri://tdoe.edu/LicensureCheckDescriptor	ROTC	ROTC

Staff Education Organization Assignment Association (Tennessee v5.3)

Object Triggering Logic

School Exclude, Calendar Exclude, Resource Toggle and Resync Logic

Natural Key Changes, Cascading Updates, and Deletes Logic

Scope Year Logic

Resource Preferences

Event Queue Detail

Object Data Elements

Arrays

Credential Reference

Type/Descriptor

Staff Classification Descriptors

Licensure Check Descriptor

Related Articles