Skip to main content
Skip table of contents

Assessment Fact

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

Required Field

Element # in Extract

Importing: [Table]Field

DDE: [Table]Field

Assessment Accountable District

42

[AssessmentFact]AssessAccountDistrict

[VirtualTablesData3]custom

Assessment Accountable School

47

[AssessmentFact]AssessAccountSchool

[VirtualTablesData3]custom

Assessment Status

15

[AssessmentFact]AssessmentStatus

[VirtualTablesData3]custom

Item Description

4

[AssessmentFact]ItemDescription

[VirtualTablesData3]user_defined_text2

Location Code

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

7

[AssessmentFact]SchoolID

[VirtualTablesData3]schoolID

School Year

3

[AssessmentFact]SchoolYear

[VirtualTablesData3]user_defined_date2

Student ID

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

6

[AssessmentFact]foreignKey

[VirtualTablesData3]foreignKey

Test Date

5

[AssessmentFact]TestDate

[VirtualTablesData3]user_defined_date

Test Description

2

[AssessmentFact]TestDescription

[VirtualTablesData3]user_defined_text

Testing Accommodation

43

[AssessmentFact]TestingAccomodation

[VirtualTablesData3]custom

Testing Modification

34

[AssessmentFact]TestingModification

[VirtualTablesData3]foreignKey_alpha

JavaScript errors detected

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

If this problem persists, please contact our support.