Ed-Fi Batch Staff Extensions - File Layout and Data Mapping
The Ed-Fi Batch 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 Batch Staff Extensions import file.
Column | Name | Description | Destination Database Field (table.field) |
|---|---|---|---|
A | Control Number | The unique identifier or reference number for the record batch. | tx_batch_ext_key.batch_no |
B | Begin Date | The beginning date of the Ed-Fi staff extension record. | tx_batch_ext_key.begin_date |
C | Effective Date | The date when this particular extension attribute becomes active or valid. | tx_batch_ext_key.eff_date |
D | Employee Number | The employee’s identification (ID) number. | tx_batch_ext_key.empl_no |
E | End Date | The ending date of the Ed-Fi staff extension record. | tx_batch_ext_key.end_date |
F | Entity Name | The name of the Ed-Fi entity. Valid values:
| tx_batch_ext_key.entity_name |
G | Staff ID | The employee’s social security number, without dashes. | tx_batch_ext_key.staff_id |
H | Description | The field description. | tx_batch_ext.description |
I | Field Name | The field name. For a list of fields under each entity, refer to Field Name - Descriptions. | tx_batch_ext.field_name |
J | Field Value | The field value. For a list of valid field values, refer to Field Name - Descriptions. | tx_batch_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 percentage 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:
|