Staff Assignment
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 |