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 |