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 |