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 |