Assessment Fact File Layout

1

*DISTRICT CODE

(DISTRICT OF RESPONSIBILITY CODE)

1 - 8

NYS Reporting

reg_district.state_code_equiv

If length is Not 8 or first character is Not "8", then "NY" + first 6 characters

Administration > General Setup > District > District: State Equivalency Code

2

*TEST DESCRIPTION

(TEST GROUP)

9 - 23

NYS Reporting

nytb_tests.test_group

where ltdb_subtest.state_code_equiv = nytb_tests.test_code

Administration > General Setup > District > Validation Tables > select New York State Reporting > Test Definitions table: Test Group. This is linked to the Test in the Test Definition.

3

*ASSESSMENT SCHOOL YEAR DATE

(VERSION)

24 - 33

NYS Reporting

School Year Prompt-06-30

N/A

4

*SUBTEST IDENTIFIER

(ASSESSMENT MEASURE STANDARD DESCRIPTION)

34 - 233

NYS Reporting

nytb_tests.description

Administration > General Setup > District > Validation Tables > select New York State Reporting > Test Definitions table: Description. This is linked to the Test in the Test Definition.

5

*TEST DATE (ASSESSMENT DATE OF ADMINISTRATION)

234 - 243

NYS Reporting

ltdb_stu_subtest.test_date

Test Scores > All > Student > Test History by Student: Test Date

6

*STUDENT ID (SCHOOL DISTRICT STUDENT ID)

244 - 255

NYS Reporting

ltdb_stu_subtest.student_id

Registration > Entry & Reports > Student Demographic > Personal: Student ID

7

*LOCATION CODE

256 - 261

Local use only

ltdb_stu_test.building

Check value for program with state_code_equiv 'NYALTACC'. If set then report reg_programs.program_value

Test Scores > All > Student > Test History by Student: Building on Test Date

Or,

Registration > Entry & Reports > Student Demographic > Programs: Program where State Code Equiv = "NYALTACC"

8

SCORE DISPLAY

262 - 267

Local use only

9

+ALPHA SCORE

(ASSESSMENT SCORE)

268 - 273

NYS Reporting

ltdb_stu_subtest.score

Test Scores > All > Student > Test History by Student > Click on Test Description hyperlink: Score field with a State Code Equiv of ALPHASCORE

10

+NUMERIC SCORE

(ASSESSMENT SCORE)

274 - 281

NYS Reporting

ltdb_stu_subtest.score

Test Scores > All > Student > Test History by Student > Click on Test Description hyperlink: Score field with a State Code Equiv of SCORE

11

CREDITS

282 – 289

Local use only

12

NATIONAL PERCENTILE

290 – 297

Local use only

13

LOCAL PERCENTILE

298 – 305

Local use only

14

MASTERY

306 – 308

Local use only

15

ASSESSMENT STATUS

309 – 328

NYS Reporting and Local Use

16

*ASSESSMENT LANGUAGE CODE

(ASSESSMENT LANGUAGE CODE)

329 – 348

NYS Reporting

ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv = 'LANGUAGE'

Defaulted to ENG if none found

Test Scores > All > Student > Test History by Student: field for Language (State Code Equiv of LANGUAGE)

17

*STANDARD ACHIEVED CODE

(ASSESSMENT STANDARD MET CODE)

349 – 378

NYS Reporting and Local Use

ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv = 'STANDARD'

For NYSITELL, the download converts Numeric Score using state conversion rules.

Test Scores > All > Student > Test History by Student: field for Performance Level (State Code Equiv of STANDARD)

For NYSITELL subtests, the download converts the Numeric Score to the appropriate Standard Achieved Code based on state conversion rules.

18

NORM CURVE EQUIV

379 – 385

Local use only

19

RAW SCORE

386 – 393

Local use only

20

SCALE SCORE

394 – 403

Local use only

21

PERCENT SCORE

404 – 409

Local use only

22

LOCAL STANINE

410 – 415

Local use only

23

NATIONAL STANINE

416 – 421

Local use only

24

NATIONAL PERCENTILE BY AGE

422 – 427

Local use only

25

NUMBER OF ITEMS CORRECT

428 – 433

Local use only

26

OBJECTIVE MASTERY SCORE

434 – 439

Local use only

27

DEGREES OF READING POWER

440 – 445

Local use only

28

INTELLIGENCE QUOTIENT

446 – 451

Local use only

29

STANDARD PERFORMANCE INDEX

452 – 457

Local use only

30

STANDARD PERFORMANCE LEVEL

458 – 463

Local use only

31

GRADE EQUIVALENT

464 – 469

Local use only

32

SPECIAL NORM GROUP

470 – 475

Local use only

33

LEVEL OF AGGREGATION

476 – 490

Local use only

34

+TESTING MODIFICATION

(ASSESSMENT ACCOMMODATION CODES)

491 – 500

NYS Reporting

ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv In ('ACCOMM_1', 'ACCOMM_2', 'ACCOMM_3', 'ACCOMM_4', 'ACCOMM_5', 'ACCOMM_6')

Test Scores > All > Student > Test History by Student: fields for Accommodations 1 – 6 (State Code Equivs of ACCOMM_1 – ACCOM_6)

35

TEST ASSIGNMENT DATE

501 – 510

Local use only

36

EVALUATOR ID

511 – 522

Local use only

37

EVALUATOR NAME

523 – 562

Local use only

38

SCHOOL YEAR DATE

(SCHOOL YEAR)

563 – 572

39

SUBTEST SCALE SCORE

573 – 582

Local use only

40

NUMBER OF TIMES TESTED

583 – 584

Local use only

41

CONVERTED SCORE

585 – 592

Local use only

42

DISTRICT ACCOUNTABILITY STATUS

593 – 595

Local use only

43

TESTING ACCOMMODATION

596 – 598

Local use only

44

STANDARD ERROR OF MEASUREMENT

599 – 606

Local use only

45

*SCORING MODEL CODE

(SCORING MODEL KEY)

607 – 618

NYS Reporting

ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv = 'SCORING'

Test Scores > All > Student > Test History by Student: Field for Scoring Model (State Code Equiv of SCORING)

46

+SURVEY COMPLETION INDICATOR

619 – 621

NYS Reporting

ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv = 'SURVEY'

Test Scores > All > Student > Test History by Student: Field for Survey Completion (State Code Equiv of SURVEY)

47

SCHOOL ACCOUNTABILITY STATUS

622 – 624

Local use only

48

LEXILE MINIMUM SCORE

625 – 630

Local use only

49

LEXILE MAXIMUM SCORE

631 – 636

Local use only

50

NUMBER OF ITEMS ATTEMPTED

637 – 642

Local use only

51

NUMBER OF ITEMS OMITTED

643 – 648

Local use only

52

NUMBER OF ITEMS INCORRECT

649 – 654

Local use only

53

ASSOCIATED COURSE INDICATOR

655 – 657

54

REPEAT INDICATOR

658 – 660

55

QUANTILE SCORE

661 – 666

56

TITLE I STATUS

667 – 669

57

+TEST BOOKLET ID

670 – 729

NYS Reporting

58

HOLISTIC SCORE

730 – 735

59

STATE ACCOUNTABILITY STATUS

736 – 738

60

TESTING LOCATION DISTRICT CODE

739 – 758

61

ACCOUNTABLE LOCATION CODE

759 – 770

62

ACCOUNTABLE LOCATION DISTRICT CODE

771 – 790

63

STUDENT SNAPSHOT DATE

791 – 800

64

REGIONAL PERCENTILE

801 – 808

65

TESTING ENVIRONMENT CODE

809 – 828

66

ALTERNATE STANDARD ACHIEVED CODE

829 – 858

NYS Reporting

ltdb_stu_subtest.score where ltdb_subtest_score.state_code_equiv = 'ALTSTANDARD'

or,

if this score is not defined, load NA

Test Scores > All > Student > Test History by Student: Field for Alternate Standard Achieved Code (State Code Equiv of ALTSTANDARD)

If this score is not set up for the subtest, load a value of NA.

67

STUDENT GRADE LEVEL CODE WHEN ASSESSED

859 – 883

Blank

N/A

68

GROWTH SCORE

884 – 893

Blank

N/A

69

STUDENT MET STANDARD INDICATOR

894 – 896

Blank

N/A

70

STUDENT MET ALTERNATE STANDARD INDICATOR

897 – 899

Blank

N/A

71

PRIMARY STANDARD ACHIEVED SCORE TYPE

900 – 949

Blank

N/A

72

ALTERNATE STANDARD ACHIEVED SCORE TYPE

950 – 999

Blank

N/A

73

EVENT CIRCUMSTANCE CODE

1000 – 1019

Blank

N/A

74

EVENT CIRCUMSTANCE COMMENT

1020 – 2043

Blank

N/A

75

RASCH SCORE

2044 – 2051

Blank

N/A

76

RASCH SCALED SCORE

2052 – 2061

Blank

N/A

77

PLATFORM TYPE

2062 – 2086

Blank

N/A

78

PRE-SLUGGED TEST BOOKLET INDICATOR

2087 – 2089

Blank

N/A

79

TIME TAKEN

2090 - 2097

Blank

N/A