Staff Education Organization Employment Associations (Georgia 3.6.1)

Last Modified on 07/29/2024 12:19 pm CDT

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.

ActionTrigger
Post

When a person has a District Employment record with the District Staff check box checked and an Employment Status populated and mapped to an Ed-Fi Code OR when a person as a District Assignment record with Type populated and mapped to an Ed-Fi Code.

  • Do NOT report a record if any one of the following scenarios are true:  
    1. There is not a Social Security Number for the staff person.
    2. The staff records are not active based on the Scope Year logic listed below

    3. If the record is being triggered from a District Assignment record and it is marked as Exclude

    4. If the record is being triggered from a District Assignment record and the School is marked as Exclude

    5. 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.
    6. The Employment Status / Type 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 they have an eligible District Assignment record for.
Post/Delete/Put

A Post/Delete will occur if the natural key is changed. A Put will occur otherwise.

  • When the following information on the District Employment changes:
    • Employment Status
    • Start Date
    • End Date
  • When the following information on the District Assignment changes:
    • Start Date
    • End Date
    • Exclude
    • Type
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

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.
Delete/PostIf 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.

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

Data will only send for the years that have valid configuration.


Resource Preferences

This table describes the Resource Preferences of this object.

Data Element LabelMapping Needed

Separation Reason Descriptors

Employment Exit Reason


Level Of Education Institution DescriptorsEmployment Baccalaureate Degree Instituti


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 LabelBusiness RequirementBusiness RulesM, C or OData Source GUI PathDatabase Field

id  

The unique identifier of the resource


M


employmentStatus
Descriptor 

This descriptor defines the type of employment or contract

  • Report the Ed-Fi Code mapped to the Employment Status if reporting from the District Employment.
  • Report the Ed-Fi Code mapped to the Type if reporting from the District Assignment. 
M 

District Employment > Employment Status


OR


District Assignment > 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
  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 Assignment > Start Date



employmentassignment.StartDate
credentialReferenceA reference to the related Credential resource
  1. This is optional, does not report
O

educationOrganizationReference A reference to the related EducationOrganization resource
  1. If the District Employment record as the District Staff check box checked, report staff with the District Number.
  2. If reporting from the District Assignment record, report the SchoolID
M

System Administration > Resources > District Information > State District Number

OR

System Administration > Resources > School > State School Number



staffReferenceA reference to the related Staff resource
  1. Reports the data that is part of the Natural Key for the Staff resource.


M

departmentThe department or suborganization the employee/contractor is associated with in the Education Organization
  1. This is optional, do not report.
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
  1. When reporting from the District Employment record, report the District Employment End Date
    1. If NULL, do not report
  2. When reporting from the District Assignment record, report the District Assignment End Date
    1. If NULL, do not report
O

Census > People > District Employment > End Date



employmentassignment.EndDate
fullTimeEquivalencyThe 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
  1. This is optional, do not report
O

hourlyWageHourly wage associated with the employment position being reported

Do not report; this is not collected in SIS.

O

offerDateDate at which the staff member was made an official offer for this employment

Do not report; this is not collected in SIS.

O

 separationDescriptor 

Type of employment separation; for example: Voluntary separation, Involuntary separation, Mutual agreement, Other, etc.

Do not report; this is not collected in SIS.

O

separationReason
Descriptor

This descriptor defines the reasons for terminating the employment

Do not report; this is not collected in SIS.

C

highestCompleted
LevelOfEducatio
InstitutionDescriptor		Indicates the Institution or State that conferred Highest Degree.
  1. If the 'District Staff' checkbox is checked on the District Employment record AND the 'Qualification Status' on the District Employment record = "C: Certified".
    • Report mapped EdFi code of 'Highest Degree Institution' using Level Of Education Institution Descriptor.
  2. Else, if the 'Qualification Status' = NULL AND 'Type' = 'Certified' on the staff's active primary district assignment.
    • Report mapped EdFi code of 'Highest Degree Institution' from reporting DE using Level Of Education Institution Descriptor.
  3. Else, do not report.

Note: 

  • Primary District Assignment is calculated as follows:
    • Look at all active District Assignments - determine which one has the highest total FTE value.
    • If FTE is null or multiple assignments have the same highest value, derive using most recent.
CCensus>People>District Employment>Highest Degree Institution
baccalaureateLevel
OfEducationInstitution
Descriptor		Indicates the Institution or State that conferred Baccalaureate Degree.
  1. If the 'District Staff' checkbox is checked on the District Employment record AND the 'Qualification Status' on the District Employment record = "C: Certified".
    • Report mapped EdFi code of 'Baccalaureate Degree Institution' from reporting DE using Level Of Education Institution Descriptor.
  2. Else, if the 'Qualification Status' = NULL AND 'Type' = 'Certified' on the staff's active primary district assignment.
    • Report mapped EdFi code of 'Baccalaureate Degree Institution' from reporting DE using Level Of Education Institution Descriptor.
  3. Else report as null/blank.

Note: 

  • Primary District Assignment is calculated as follows:
    • Look at all active District Assignments - determine which one has the highest total FTE value.
    • If FTE is null or multiple assignments have the same highest value, derive using most recent.
CCensus>People>District Employment>Baccalaureate Degree Institution
nationalCertifiedThe data is used to determine if a Staff Member is a National Board Certified Teacher.
  1. If National Board Certified Teacher is checked, report true
    1. Else, report false.

RCensus > 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.
  1. If staff member has any assignment in the current scope year with a title code = 14-19, 00, 20-23, 25, 28, 30, 73-75, 94, 96, 97, 101, 103-104, 106, 110, 110S, or 139-140 (teacher or principle):
    • If 'Yrs Experience in District' from the staff's reporting District Employment is populated, report value
    •  Else if 'Yrs Experience in District' is null 
      1. Calculate by taking the difference between the original hire date (value calculated for hire date field) and the District Employment End Date (use current date if employment end date is blank)
        • MUST Report 0 if calculated value is less than one year
        • If >1yr - Report calculated value as a whole number - normal rounding rules apply.
  2. Else leave as null/blank
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.
  1. If staff member has any assignment in the current scope year with a title code = 14-19, 00, 20-23, 25, 28, 30, 73-75, 94, 96, 97, 101, 103-104, 106, 110, 110S, or 139-140 (teacher or principle):
    • If 'Yrs Experience in District' from the staff's reporting District Employment is populated, report value
    • Else if 'Yrs Experience in District' is null 
      1. Calculate by taking the difference between the original hire date (value calculated for hire date field) and the District Employment End Date  (use current date if employment end date is blank) THEN add Teaching Years Modifier to the calculated value.
        1. MUST Report 0 if calculated value is less than one year
        2. If >1yr - Report calculated value as a whole number - normal rounding rules apply.
  2. Else, leave as null/blank
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


Census > People > District Employment > Teaching Years Modifier



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

annualSalary

Indicates annual salary for certified and classified employees

Do not report, this is optional.
O


annualContractWorkDays

Indicates annual contract work days for certified and classified employees

Do not report, this is optional.
O


employmentBasis

Indicates employee basis for certified and classified employees

Do not report, this is optional.
O


salaryPayStepDescriptor

Indicates Salary Pay Step

Do not report, this is optional.
O


staffEmploymentCharacteristics

Collection of Staff Employment Characteristics

Do not report, this is optional.
O


staffEmploymentIndicators

Collection of Staff Employment Indicators

Do not report, this is optional.
O


Type/Descriptor

employmentStatusDescriptor

Ed-Fi Code Value
Description
Namespace
Short Description
C
Certified
uri://gadoe.org/EmploymentStatusDescriptor
Certified
NClassifieduri://gadoe.org/EmploymentStatusDescriptorClassified

Related Articles

  • None
Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Copyright ©️ Infinite Campus, Inc. All rights reserved. | Terms of Use | Privacy Policy | infinitecampus.com