Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.