Use the table below to map fields in your import file to fields in the Assessment Fact for National Assessment Instrument Results virtual table in PowerSchool.
|
Required Field |
Element # in Extract |
Importing: [Table]Field |
DDE: [Table]Field |
|---|---|---|---|
|
Item Description |
4 |
[AssessmentFact2]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 |
[AssessmentFact2]SchoolID |
[VirtualTablesData3]schoolID |
|
Local Stanine |
22 |
[AssessmentFact2]LocalStanine |
[VirtualTablesData3]custom |
|
Percent Score |
21 |
[AssessmentFact2]PercentScore |
[VirtualTablesData3]foreignKey_alpha |
|
Scale Score |
20 |
[AssessmentFact2]ScaleScore |
[VirtualTablesData3]custom |
|
School Year |
3 |
[AssessmentFact2]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 |
[AssessmentFact2]foreignKey |
[VirtualTablesData3]foreignKey |
|
Test Date |
5 |
[AssessmentFact2]TestDate |
[VirtualTablesData3]user_defined_date |
|
Test Description |
2 |
[AssessmentFact2]TestDescription |
[VirtualTablesData3]user_defined_text |