Assessment Fact File Layout
The following table shows field numbers, field names, the eSchoolPlus Tables and Columns and where the data is coming from in eSchoolPlus for the Assessment Fact file.
* = Required for all students
+ = Required only for specified students
Field # | FIELD NAME from eScholar template (DATA ELEMENT NAME)as used by NYSED, if different from eScholar name | Positions | NYS or Local Purpose | eSchoolPlus Table.Column | Where in eSchoolPlus? |
---|---|---|---|---|---|
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 |