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
| Action | Business Rules |
|---|---|
| Post | Staff must meet the following conditions to report:
|
Do NOT report a record if any one of the following scenarios are true:
| |
| Put | When any field not part of the natural key is changed:
|
| End Date | |
| Delete/Post | When any field part of the natural key is changed:
|
| Delete | When all District Assignment records are deleted. |
| Delete | When Ed-Fi ID is deleted. |
| Delete | When Email Address is deleted. |
Resource Toggle/Resync
Action | Business Rule |
|---|---|
| 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, Deletes
Action | Business Rule |
|---|---|
| Delete/Post | Natural Key changes: |
| 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. | |
| Delete/Post | If the Start Date or Employment Status Descriptor changes, the record will delete and repost |
| N/A | Cascading update: There are no dependent resources |
Scope Year
| Business Rules |
|---|
| 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 |
Event Queue Detail
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
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 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 | The descriptor defines the type of contact. | Always report 'Other'. | M | ||
| hireDate | The actual date of the employee's hire or change of status. | Report the Start Date of the active District Employment record. | M | Census > People > District Employment > Start Date | employmentassignment. StartDate |
| credentialReference | A reference to the related Credential resource |
| O | ||
| educationOrganization Reference | A reference to the related EducationOrganization resource. The following EIS 060 Staff Member definitions apply:
|
| M | System Administration > Resources > District Information > State District Number | 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 date used to terminate employees state SSO account. | Report the End Date of most recent District Employment record. | O | Census> People> District Assignment> End Date | employmentassignment.EndDate |
| 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 |
| O | ||
| 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 | ||
| separationReasonDescriptor | This descriptor defines the reasons for terminating the employment |
| O | ||
| _ext.tdoe.submittedForSchool YearTypeReference.SchoolYear | The key for School Year. | Use the School Year tied to the configured year to identify the End Year and | 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. | Reports the State District Number. Leading zeros are removed. | M | System Administration > Resources > District Information | district.number |
| _etag | A unique system-generated value that identifies the version of the resource | O | district.number |
Type/Descriptors
