Tool Search: Ed-Fi
This association indicates the education organization an employee, contractor, volunteer or other service provider is formally associated with typically indicated by which organization the staff member has a services contract with or receives compensation from.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
Action | Trigger |
---|---|
Post | When a person has a District Assignment record record that is active within the config year.
|
Put | When any field not part of the natural key changes:
|
Delete/Post | When any field part of the natural key changes:
|
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:
|
Delete/Post | If the Start Date or Employment Status Descriptor changes, the record will delete and repost. |
Delete/Post | Cascading update: There are no dependent resources. |
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.
|
Data will only send for the years that have valid configuration. |
Resource Preferences
This table describes the Resource Preferences of this object.
Data Element Label | Mapping Needed |
---|---|
Separation Reason Descriptors | Employment Exit Reason |
Level Of Education Institution Descriptors | Employment Baccalaureate Degree Instituti |
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 | |||
employmentStatus Descriptor | This descriptor defines the type of employment or contract |
Note:
| M | Census> People> District Employment> Qualification Status OR Census> People> District Assignment> Qualification Status | employment.status employmentassignment.type |
hireDate | The month, day, and year on which a contract between an individual and a governing authority specifies that employment is to begin (or the date on which the agreement is made valid). NEDM: Contract Beginning Date |
| M | Census>People>District Employment>Teaching Start Year Census>People>District Employment> Start Date | |
credentialReference | A reference to the related Credential resource |
| O | ||
education Organization Reference | A reference to the related EducationOrganization resource |
| M | System Administration > Resources > District > Ed-Fi District Number | |
staffReference | A reference to the related Staff resource |
| M | ||
department | The department or suborganization the employee/contractor is associated with in the Education Organization |
| O | ||
endDate | The month, day, and year on which a contract between an individual and a governing authority ends or is terminated under the provisions of the contract (or the date on which the agreement is made invalid). NEDM: Contract Ending Date |
Note:
| C | Census> People> District Employment> End Date Census> People> District Employment> Exit Reason | |
fullTimeEquivalency | The ratio between the hours of work expected in a position and the hours of work normally expected in a full-time position in the same setting |
| O | ||
hourlyWage | Hourly wage associated with the employment position being reported |
Note:
| O | Census>People>District Employment >Salary | |
offerDate | Date at which the staff member was made an official offer for this employment |
| O | ||
separationDescriptor | Type of employment separation; for example: Voluntary separation, Involuntary separation, Mutual agreement, Other, etc. |
| O | ||
separationReason Descriptor | This descriptor defines the reasons for terminating the employment |
| C | Census> People> District Employment>End Date Census> People> District Employment> Exit Reason | |
highestCompleted LevelOfEducatio InstitutionDescriptor | Indicates the Institution or State that conferred Highest Degree. |
Note:
| C | Census>People>District Employment>Highest Degree Institution | |
baccalaureateLevel OfEducationInstitution Descriptor | Indicates the Institution or State that conferred Baccalaureate Degree. |
Note:
| C | Census>People>District Employment>Baccalaureate Degree Institution | |
nationalCertified | The data is used to determine if a Staff Member is a National Board Certified Teacher. |
| R | Census > People > District Employment > National Board Certified Teacher | |
teacherOrPrincipal YearsInDistrict | The total number of years that an individual has previously held a Teacher or Principal position in the current district. |
| C | Census > People > District Assignment > Staff Assignment Code Census > People > District Employment > Yrs Experience in District Census > People > District Employment > Original Hire Date Census > People > District Employment > End Date | |
teacherOrPrincipal YearsOverall | The total number of years that an individual has previously held a Teacher or Principal position overall. |
| C | Census > People > District Assignment > Staff Assignment Code Census > People > District Employment > Yrs Experience in District Census > People > District Employment > End Date Census > People > District Employment > Teaching Years Modifier | |
_etag | A unique system-generated value that identifies the version of the resource | O |