Staff Education Organization Assignment Association (Indiana v3.6)

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.

ActionTrigger
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:  

  1. There is not an Ed-FI ID for the staff person.
  2. If the record is being triggered from a District Assignment record and it is marked as Exclude.
  3. If the record is being triggered from a District Assignment record and the School is marked as Exclude.

  4. 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.
  5. 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/PostIf there are two District Assignment records that create the same natural Key and 1 is Deleted, the remaining record will be posted.
DeleteWhen a District Assignment record is deleted.
DeleteWhen 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.

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:

  • 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.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element LabelMapping Needed

Employment District Assignment Code

EmploymentAssignment Assignment Code

Staff Classification Descriptors


Identity Mapping Object Key

campusObjectTypeObject Key Data Source
EmploymentemploymentID
EmploymentAssignmentassignmentID

Event Queue Detail

This table describes the Event Queue Detail of this object.

Campus TableEd-Fi ActionFields
employmentPost/Put/DeleteThe primary table used for sending data for this resource.
employmentassignmentPost/Put/DeleteThe 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
beginDateThe month, day, and year of the start or effective date of a staff member's employment, contract or relationship with the LEA.
  1. When reporting from the District Employment record, report the District Employment Start Date.
  2. 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.


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


staffReferenceA reference to the related Staff resource.

Reports the data that is part of the Natural Key for the Staff resource.



endDate Month, day and year of the end or termination date of a staff member''s employment, contract or relationship with the LEA. 
  1. When reporting from the District Employment record, reports the District Employment End Date.
    • If NULL, does not report.
  2. When reporting from the District Assignment record, reports the District Assignment End Date.
    • If NULL, does not report.
OCensus > People > District Assignment > End Date

employment.endDate

employmentassignment.

endDate


orderOfAssignmentDescribes 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

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


Type/Descriptor

Click here to expand...

Staff Classification Descriptors

Ed-Fi Code ValueShort DescriptionDescriptionNamespace
504 Coordinator504 Coordinator504 Coordinatoruri://doe.in.gov/StaffClassificationDescriptor
Assistant PrincipalAssistant PrincipalAssistant Principaluri://doe.in.gov/StaffClassificationDescriptor
Assistant SuperintendentAssistant SuperintendentAssistant Superintendenturi://doe.in.gov/StaffClassificationDescriptor
Board MemberBoard MemberBoard Memberuri://doe.in.gov/StaffClassificationDescriptor
Board PresidentBoard PresidentBoard Presidenturi://doe.in.gov/StaffClassificationDescriptor
Board SecretaryBoard SecretaryBoard Secretaryuri://doe.in.gov/StaffClassificationDescriptor
Board TreasurerBoard TreasurerBoard Treasureruri://doe.in.gov/StaffClassificationDescriptor
Board Vice PresidentBoard Vice PresidentBoard Vice Presidenturi://doe.in.gov/StaffClassificationDescriptor
Chief Technology OfficerChief Technology OfficerChief Technology Officeruri://doe.in.gov/StaffClassificationDescriptor
Corporation Test CoordinatorCorporation Test CoordinatorCorporation Test Coordinatoruri://doe.in.gov/StaffClassificationDescriptor
CounselorCounselorCounseloruri://doe.in.gov/StaffClassificationDescriptor
Data AdministratorData AdministratorData Administratoruri://doe.in.gov/StaffClassificationDescriptor
Data CertificationData CertificationData Certificationuri://doe.in.gov/StaffClassificationDescriptor
Data Exchange ContactData Exchange ContactData Exchange Contacturi://doe.in.gov/StaffClassificationDescriptor
Data ViewerData ViewerData Vieweruri://doe.in.gov/StaffClassificationDescriptor
Financial AdministratorFinancial AdministratorFinancial Administratoruri://doe.in.gov/StaffClassificationDescriptor
Financial ContactFinancial ContactFinancial Contacturi://doe.in.gov/StaffClassificationDescriptor
Grant ContributorGrant ContributorGrant Contributoruri://doe.in.gov/StaffClassificationDescriptor
Grant ViewerGrant ViewerGrant Vieweruri://doe.in.gov/StaffClassificationDescriptor
Instructional AideInstructional AideInstructional Aideuri://doe.in.gov/StaffClassificationDescriptor
Job PosterJob PosterJob Posteruri://doe.in.gov/StaffClassificationDescriptor
LEA AdministratorLEA AdministratorLEA Administratoruri://ed-fi.org/StaffClassificationDescriptor
Librarians/Media SpecialistsLibrarians/Media SpecialistsLibrarians/Media Specialistsuri://ed-fi.org/StaffClassificationDescriptor
NurseNurseNurseuri://doe.in.gov/StaffClassificationDescriptor
Operational SupportOperational SupportOperational Supporturi://doe.in.gov/StaffClassificationDescriptor
OtherOtherOtheruri://doe.in.gov/StaffClassificationDescriptor
PrincipalPrincipalPrincipaluri://doe.in.gov/StaffClassificationDescriptor
PsychologistPsychologistPsychologisturi://doe.in.gov/StaffClassificationDescriptor
School AdministratorSchool AdministratorSchool Administratoruri://ed-fi.org/StaffClassificationDescriptor
School HealthSchool HealthSchool Healthuri://doe.in.gov/StaffClassificationDescriptor
School LeaderSchool LeaderSchool Leaderuri://doe.in.gov/StaffClassificationDescriptor
School Safety SpecialistSchool Safety SpecialistSchool Safety Specialisturi://doe.in.gov/StaffClassificationDescriptor
School Test CoordinatorSchool Test CoordinatorSchool Test Coordinatoruri://doe.in.gov/StaffClassificationDescriptor
Secondary Corporation Test CoordinatorSecondary Corporation Test CoordinatorSecondary Corporation Test Coordinatoruri://doe.in.gov/StaffClassificationDescriptor
Social WorkerSocial WorkerSocial Workeruri://doe.in.gov/StaffClassificationDescriptor
Special Education DirectorSpecial Education DirectorSpecial Education Directoruri://doe.in.gov/StaffClassificationDescriptor
Student Support PlansStudent Support PlansStudent Support Plansuri://doe.in.gov/StaffClassificationDescriptor
Substitute TeacherSubstitute TeacherSubstitute Teacheruri://doe.in.gov/StaffClassificationDescriptor
SuperintendentSuperintendentSuperintendenturi://doe.in.gov/StaffClassificationDescriptor
Support Services StaffSupport Services StaffSupport Services Staffuri://doe.in.gov/StaffClassificationDescriptor
TeacherTeacherTeacheruri://doe.in.gov/StaffClassificationDescriptor
Title IX CoordinatorTitle IX CoordinatorTitle IX Coordinatoruri://doe.in.gov/StaffClassificationDescriptor