Classic View: System Administration > Ed-Fi
Search Terms: 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 | This indicates whether an employee is (F)ull time, (P)art time, (U)niversity, employed at another district's (S)ervice school (if the record submitter is the primary school). The following EIS 060 Staff Member definitions apply:
|
| 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
