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:
|