Ed-Fi Staff Extensions - File Layout and Data Mapping
The Ed-Fi Staff Extensions import file format is .csv.
The following table shows the data's column names, descriptions, and destination database fields in the Ed-Fi Staff Extensions import file.
Column | Name | Description | Destination Database Field (table.field) |
|---|---|---|---|
A | Begin Date | The beginning date of the Ed-Fi staff extension record. | tx_staff_ext_key.begin_date |
B | Employee Number | The employee’s identification (ID) number. | tx_staff_ext_key.empl_no |
C | End Date | The ending date of the Ed-Fi staff extension record. | tx_staff_ext_key.end_date |
D | Entity Name | The name of the Ed-Fi entity. Valid values:
| tx_staff_ext_key.entity_name |
E | Staff ID | The employee’s social security number, without dashes. | tx_staff_ext_key.staff_id |
F | Description | The field description. | tx_staff_ext.description |
G | Field Name | The field name. For a list of fields under each entity, refer to Field Name - Descriptions. | tx_staff_ext.field_name |
H | Value | The field value. For a list of valid field values, refer to Field Name - Descriptions. | tx_staff_ext.field_value |
Field Name - Descriptions
The following table shows the entity names, their field names for which you can import values, descriptions, and the valid values.
Entity name | Field names | Description | Valid values |
|---|---|---|---|
AuxiliaryRoleIDSet | AuxiliaryRoleID | The code identifying the employee's auxiliary role. | The valid values are 000-999. |
DaysEmployedSet | NumberDaysEmployed | The number of days per year the employee works. | Not applicable |
PercentDayEmployed | The percent of the standard district day the employee works. | Not applicable | |
ParaProfessionalCertificationSet | ParaprofessionalCertification | Indicates whether the employee is a certified paraprofessional. | Valid values:
|
StaffTypeSet | StaffType | The employee’s staff type. | Valid values:
|