Assessment Fact for National Assessment Instrument Results

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