Entity: StaffEducationOrganizationEmploymentAssociation
The following table lists the Element ID, Element Name, Source field, TX PEIMS field, Valid values, and Additional Information for the Ed-Fi StaffEducationOrganizationEmploymentAssociation entity.
Element ID | Element Name | Source field | TX PEIMS field | Valid values | Data type | Additional Information |
|---|---|---|---|---|---|---|
Not applicable | Staff | Staff Information page. | Database field: tx_staff_employment.staff_id | Not applicable | varchar(9) | Not applicable |
Not applicable | LocalEducationAgency | Not applicable | Database field: tx_staff_employment.lea_id | Not applicable | int | Not applicable |
E0760 | PercentDayEmployed (DaysEmployedSet) | Value field on the TX Ed-Fi Staff Extensions page when Entity Name is DaysEmployedSet and Field Name is PercentDayEmployed. Database field: tx_staff_ext.field_value where staff_ext_key.entity_name= 'DaysEmployedSet' and tx_staff_ext.ext_id = staff_ext_key.ext_id and staff_ext.field_name = 'PercentDayEmployed' | Value field on the Staff Extensions tab of the Staff Information page. Database field: tx_staff_ext.field_value where staff_ext_key .entity_name= 'DaysEmployedSet' and tx_staff_ext.ext_id = staff_ext_key.ext_id and staff_ext.field_name = 'PercentDayEmployed' | Not applicable | varchar(300) | Not applicable |
E0160 | NumberDaysEmployed (DaysEmployedSet) | Value field on the TX Ed-Fi Staff Extensions page when Entity Name is DaysEmployedSet and Field Name is NumberDaysEmployed. Database field: tx_staff_ext.field_value where staff_ext_key.entity_name= 'DaysEmployedSet' and tx_staff_ext.ext_id = staff_ext_key.ext_id and staff_ext.field_name = 'NumberDaysEmployed' | Value field on the Staff Extensions tab of the Staff Information page. Database field: tx_staff_ext.field_value where staff_ext_key .entity_name= 'DaysEmployedSet' and tx_staff_ext.ext_id = staff_ext_key.ext_id and staff_ext.field_name = 'NumberDaysEmployed' | Not applicable | varchar(300) | Not applicable |
E3010 | BeginDate (DaysEmployedSet) | Begin Date field on the TX Ed-Fi Staff Extensions page when Entity Name is DaysEmployedSet. Database field: tx_staff_ext_key.begin_date where staff_ext_key.entity_name = 'DaysEmployedSet' | Begin Date field on the Staff Extensions tab of the Staff Information page. Database field: tx_staff_ext_key.begin_date where staff_ext_key.entity_name = 'DaysEmployedSet' | Not applicable | smalldatetime | Not applicable |
E3020 | EndDate (DaysEmployedSet) | End Date field on the TX Ed-Fi Staff Extensions page when Entity Name is DaysEmployedSet. Database field: tx_staff_ext_key.end_date where staff_ext_key.entity_name = 'DaysEmployedSet' | End Date field on the Staff Extensions tab of the Staff Information page. Database field: tx_staff_ext_key.end_date where staff_ext_key.entity_name = 'DaysEmployedSet' | Not applicable | smalldatetime | Not applicable |
E1594 | AuxiliaryRoleID (AuxiliaryRoleIdSet) | Value field on the TX Ed-Fi Staff Extensions page when Entity Name is AuxiliaryRoleIdSet and Field Name is AuxiliaryRoleID. Database field: tx_staff_ext.field_value where staff_ext_key.entity_name= 'AuxiliaryRoleSet' and tx_staff_ext.ext_id = staff_ext_key.ext_id and staff_ext.field_name = 'AuxiliaryRoleID' | Value field on the Staff Extensions tab of the Staff Information page. Database field: tx_staff_ext.field_value where staff_ext_key .entity_name= 'AuxiliaryRoleSet' and tx_staff_ext.ext_id = staff_ext_key.ext_id and staff_ext.field_name = 'AuxiliaryRoleID' | 000-999 | varchar(300) | Not applicable |
E3010 | BeginDate (AuxiliaryRoleIdSet) | Begin Date field on the TX Ed-Fi Staff Extensions page when Entity Name is AuxiliaryRoleIdSet. Database field: tx_staff_ext_key.begin_date where staff_ext_key.entity_name = 'AuxiliaryRoleIDSet' | Begin Date field on the Staff Extensions tab of the Staff Information page. Database field: tx_staff_ext_key.begin_date where staff_ext_key.entity_name = 'AuxiliaryRoleIDSet' | Not applicable | smalldatetime | Not applicable |
E3020 | EndDate (AuxiliaryRoleIdSet) | End Date field on the TX Ed-Fi Staff Extensions page when Entity Name is AuxiliaryRoleIdSet. Database field: tx_staff_ext_key.end_date where staff_ext_key.entity_name = 'AuxiliaryRoleIDSet' | End Date field on the Staff Extensions tab of the Staff Information page. Database field: tx_staff_ext_key.end_date where staff_ext_key.entity_name = 'AuxiliaryRoleIDSet' | Not applicable | smalldatetime | Not applicable |
E3032 | HireDate (EmploymentPeriod) | Hire Date field on the Employment tab of the Employee Information page. Database field: employee.hire_date or 01/01/1900 if blank | Hire Date field on the Demographic tab of the Staff Information page. Database field: tx_staff_employment.hire_date | Not applicable | smalldatetime | Not applicable |
E3020 | EndDate (EmploymentPeriod) | Last Day Worked field on the Terminate Employee page. If the Last Day Worked field is blank, the value is retrieved from the Last Date to Pay field. Database field: person.lastday_worked or person.term_date | End Date field on the Demographic tab of the Staff Information page. Database field: tx_staff_employment.end_date | Not applicable | smalldatetime | Not applicable |