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 |