Use the table below to map fields in your import file to fields in the StaffAssignment virtual table in PowerSchool.
|
Required Field |
Importing: [Table]Field |
DDE: [Table]Field |
|---|---|---|
|
Controlling District Code |
[StaffAssignment]NE_ControlDistrict |
[VirtualTablesData3]NE_ControlDistrict |
|
Position Assignment Code |
[StaffAssignment]NE_StaffAssignCode |
[VirtualTablesData3]user_defined_text |
|
Full-Time Equivalency (FTE) |
[StaffAssignment]NE_StaffAssignPercent |
[VirtualTablesData3]user_defined_numeric |
|
Assignment Date |
[StaffAssignment]NE_StaffAssignDate |
[VirtualTablesData3]user_defined_date |
|
Completion Date |
[StaffAssignment]NE_StaffAssignCompleteDate |
[VirtualTablesData3]user_defined_date2 |
|
Assigned Subject Code |
[StaffAssignment]NE_StaffAssignSubjectCode |
[VirtualTablesData3]user_defined_text2 |
|
Assigned Grade Level |
[StaffAssignment]NE_StaffAssignPercent |
[VirtualTablesData3]user_defined_numeric |
|
School ID |
[StaffAssignment]SchoolID |
[VirtualTablesData3]SchoolID |
|
ID
Note: This is the internal ID of the staff member. This value can be viewed in Direct Database Export (DDE) in the ID field of the staff member's record. |
[StaffAssignment]foreignKey |
[VirtualtablesData3]foregnKey |