Skip to main content
Skip table of contents

Assessment Response

Use the table below to map fields in your import file to fields in the Assessment Response virtual table in PowerSchool.

Required Field

Element # in Extract

Importing: [Table]Field

DDE: [Table]Field

Achievement Level

13

[AssessmentResponse]AchievementLevel

[VirtualTablesData3]foreignKey_alpha

Item Description

4

[AssessmentResponse]ItemDescription

[VirtualTablesData3]user_defined_text2

Item Response Description

7

[AssessmentResponse]ItemResponseDesc

[VirtualTablesData3]custom

Location Code

Note: This value must match the school number, rather than the alternate school number. The value is stored in [Schools]School_Number.

12

[AssessmentResponse]SchoolID

[VirtualTablesData3]schoolID

School Year

3

[AssessmentResponse]SchoolYear

[VirtualTablesData3]user_defined_date

Student ID

Note: This value must match the internal ID of the student, which can be identified at the bottom of the Teacher Comments page. The value is stored in [Students]ID.

6

[AssessmentResponse]foreignKey

[VirtualTablesData3]foreignKey

Test Date

5

[AssessmentResponse]TestDate

[VirtualTablesData3]user_defined_date2

Test Description

2

[AssessmentResponse]TestDescription

[VirtualTablesData3]user_defined_text

JavaScript errors detected

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

If this problem persists, please contact our support.