Staff Education Organization Assignment Association (Indiana v3.6)

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	When a person has a District Employment record that overlaps the configured year with the District Staff checkbox marked and a District Assignment Code populated. OR When a person has a District Assignment record that overlaps the configured year. Do NOT report a record if any one of the following scenarios are true: There is not an Ed-FI ID for the staff person. 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. If data is sent prior to the Exclude check boxes are checked, the data will remain and the user will need to use the Delete Tool to remove data. If the Assignment Code field is not mapped in Resource Preferences. If school staff member has more than 1 qualifying District Assignment record, a record will generate for each eligible School/Start date. If a staff member has a District Employment record that is marked as District Staff and a District Assignment record, the staff member will get multiple records. One with an Ed Org Reference Number = to the District Number and one with an Ed Org Reference Number = to each school in which they have an eligible District Assignment record.
Put	When any field not part of the natural key changes: End Date Position Title
Delete/Post	When any field part of the natural key changes: Begin Date Staff Classification Descriptor
Delete/Post	If there are two District Assignment records that create the same natural Key and 1 is Deleted, the remaining record will be posted.
Delete	When a District Assignment record is deleted.
Delete	When a District Employment record 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 Number/Ed-Fi School Number changes or the Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the School ID/Ed-Fi ID Change triggers. If the Start Date or Assignment Code changes, the record will delete and repost.
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

Action

Trigger

Delete/Post

Natural Key change:

If the School Number/Ed-Fi School Number changes or the Ed-Fi ID changes, a delete/post will occur with the cascading deletes from the School ID/Ed-Fi ID Change triggers.
If the Start Date or Assignment Code changes, the record will delete and repost.

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
Employment District Assignment Code EmploymentAssignment Assignment Code	Staff Classification Descriptors

Data Element Label

Mapping Needed

Employment District Assignment Code

EmploymentAssignment Assignment Code

Staff Classification Descriptors

Identity Mapping Object Key

campusObjectType	Object Key Data Source
Employment	employmentID
EmploymentAssignment	assignmentID

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	Location
id	The unique identifier of the resource.		M
beginDate	The month, day, and year of the start or effective date of a staff member's employment, contract or relationship with the LEA.	When reporting from the District Employment record, report the District Employment Start Date. When reporting from the District Assignment record, report the District Assignment Start 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.	District Employment Reports the Ed-Fi Code mapped to the District Assignment Code selected. This reports district employees. District Assignment Reports the Ed-Fi Code mapped to the Title selected. This reports district assignments.	M	Census > People > District Employment > District Assignment Code Census > People > District Assignment > Title employment.assignmentCode employmentassignment.title
credentialReference		This is optional, does not report.	O
educationOrganization Reference	A reference to the related EducationOrganization resource.	District Employment Reports the School Corp ID (LEA ID). District Assignment Reports the School ID. 10+DistrictID+SchoolID Example: 1053105193	M	Hardcoded 10 + district.stateDistrictNumber + school.stateSchoolNumber
StaffEducation OrganizationEmployment AssociationReference	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.	O
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.	When reporting from the District Employment record, reports the District Employment End Date. If NULL, does not report. When reporting from the District Assignment record, reports the District Assignment End Date. If NULL, does not report.	O	Census > People > District Assignment > End Date employment.endDate 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.	Reports the Name of the District Assignment Code (District Employment) or Title (District Assignment) that is selected.	O	Census > People > District Employment > District Assignment Code Census > People > District Assignment > Title employment.assignmentCode employmentassignment.title
_etag	A unique system-generated value that identifies the version of the resource.		O

Type/Descriptor

Click here to expand...

Staff Classification Descriptors

Ed-Fi Code Value	Short Description	Description	Namespace
504 Coordinator	504 Coordinator	504 Coordinator	uri://doe.in.gov/StaffClassificationDescriptor
Assistant Principal	Assistant Principal	Assistant Principal	uri://doe.in.gov/StaffClassificationDescriptor
Assistant Superintendent	Assistant Superintendent	Assistant Superintendent	uri://doe.in.gov/StaffClassificationDescriptor
Board Member	Board Member	Board Member	uri://doe.in.gov/StaffClassificationDescriptor
Board President	Board President	Board President	uri://doe.in.gov/StaffClassificationDescriptor
Board Secretary	Board Secretary	Board Secretary	uri://doe.in.gov/StaffClassificationDescriptor
Board Treasurer	Board Treasurer	Board Treasurer	uri://doe.in.gov/StaffClassificationDescriptor
Board Vice President	Board Vice President	Board Vice President	uri://doe.in.gov/StaffClassificationDescriptor
Chief Technology Officer	Chief Technology Officer	Chief Technology Officer	uri://doe.in.gov/StaffClassificationDescriptor
Corporation Test Coordinator	Corporation Test Coordinator	Corporation Test Coordinator	uri://doe.in.gov/StaffClassificationDescriptor
Counselor	Counselor	Counselor	uri://doe.in.gov/StaffClassificationDescriptor
Data Administrator	Data Administrator	Data Administrator	uri://doe.in.gov/StaffClassificationDescriptor
Data Certification	Data Certification	Data Certification	uri://doe.in.gov/StaffClassificationDescriptor
Data Exchange Contact	Data Exchange Contact	Data Exchange Contact	uri://doe.in.gov/StaffClassificationDescriptor
Data Viewer	Data Viewer	Data Viewer	uri://doe.in.gov/StaffClassificationDescriptor
Financial Administrator	Financial Administrator	Financial Administrator	uri://doe.in.gov/StaffClassificationDescriptor
Financial Contact	Financial Contact	Financial Contact	uri://doe.in.gov/StaffClassificationDescriptor
Grant Contributor	Grant Contributor	Grant Contributor	uri://doe.in.gov/StaffClassificationDescriptor
Grant Viewer	Grant Viewer	Grant Viewer	uri://doe.in.gov/StaffClassificationDescriptor
Instructional Aide	Instructional Aide	Instructional Aide	uri://doe.in.gov/StaffClassificationDescriptor
Job Poster	Job Poster	Job Poster	uri://doe.in.gov/StaffClassificationDescriptor
LEA Administrator	LEA Administrator	LEA Administrator	uri://ed-fi.org/StaffClassificationDescriptor
Librarians/Media Specialists	Librarians/Media Specialists	Librarians/Media Specialists	uri://ed-fi.org/StaffClassificationDescriptor
Nurse	Nurse	Nurse	uri://doe.in.gov/StaffClassificationDescriptor
Operational Support	Operational Support	Operational Support	uri://doe.in.gov/StaffClassificationDescriptor
Other	Other	Other	uri://doe.in.gov/StaffClassificationDescriptor
Principal	Principal	Principal	uri://doe.in.gov/StaffClassificationDescriptor
Psychologist	Psychologist	Psychologist	uri://doe.in.gov/StaffClassificationDescriptor
School Administrator	School Administrator	School Administrator	uri://ed-fi.org/StaffClassificationDescriptor
School Health	School Health	School Health	uri://doe.in.gov/StaffClassificationDescriptor
School Leader	School Leader	School Leader	uri://doe.in.gov/StaffClassificationDescriptor
School Safety Specialist	School Safety Specialist	School Safety Specialist	uri://doe.in.gov/StaffClassificationDescriptor
School Test Coordinator	School Test Coordinator	School Test Coordinator	uri://doe.in.gov/StaffClassificationDescriptor
Secondary Corporation Test Coordinator	Secondary Corporation Test Coordinator	Secondary Corporation Test Coordinator	uri://doe.in.gov/StaffClassificationDescriptor
Social Worker	Social Worker	Social Worker	uri://doe.in.gov/StaffClassificationDescriptor
Special Education Director	Special Education Director	Special Education Director	uri://doe.in.gov/StaffClassificationDescriptor
Student Support Plans	Student Support Plans	Student Support Plans	uri://doe.in.gov/StaffClassificationDescriptor
Substitute Teacher	Substitute Teacher	Substitute Teacher	uri://doe.in.gov/StaffClassificationDescriptor
Superintendent	Superintendent	Superintendent	uri://doe.in.gov/StaffClassificationDescriptor
Support Services Staff	Support Services Staff	Support Services Staff	uri://doe.in.gov/StaffClassificationDescriptor
Teacher	Teacher	Teacher	uri://doe.in.gov/StaffClassificationDescriptor
Title IX Coordinator	Title IX Coordinator	Title IX Coordinator	uri://doe.in.gov/StaffClassificationDescriptor

Staff Education Organization Assignment Association (Indiana v3.6)

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

Identity Mapping Object Key

Event Queue Detail

Object Data Elements

Type/Descriptor

Staff Classification Descriptors

Related Articles