WASL & ITBS/ITED Report & Pre-ID Extract File

Contents

1 Overview

2 Extract Report

3 Exception Report

4 Report Parameters

5 Report Abbreviations

6 How-to

7 Report Fields

8 Extract File Format

Name

Field Length

Field Start

Field End

Description and path to data field

School Year

9

1

9

Unused. Leave blank.

Collection Period

2

10

11

Unused. Leave blank.

State Student Identifier (SSID)

10

12

21

Student Management / Student / WA/NCLB

Serving District

5

22

26

State assigned county district number:

System Admin / System / Dist Config

District Student ID

50

27

76

District student identifier:

Student Management / Student / WA/NCLB

Last Name

60

77

136

Student Management / Student / General 1

First Name

60

137

196

Student Management / Student / General 1

Middle Name

60

197

256

Student Management / Student / General 1

Birth Date

10

257

266

Birth date (mm/dd/yyyy): Student Management / Student / General 1

Gender

1

267

267

Student Management / Student / General 1

Zip Code

6

268

273

Unused. Leave blank.

Zip Code Extension

4

274

277

Unused. Leave blank.

Grade Level

2

278

279

State Equivalent Grade Level associated with the graduation year. Retesters must be marked as grade 11: Student Management / Student / General 1 / Edit / Grade/Grad Yr

Language

3

280

282

Primary language spoken by the student (numeric or blank if not known):

Student Management / Student / General 1

Race/Ethnic Group

1

283

283

1* = 1,  A* = 2, B* = 3; H*=4, W* = 5, P* = 6, M* = 7, X* = 8:

 Student Management / Student / General 1

Disability Code

2

284

285

Numeric "00" through "14".  If Special Education is "N", Disability Code is "00"; if Special Education = "Y", use the primary disability code (standard codes "01"-"14"):

Student Management / Codes / Dist. Codes / Special Education / State Rpt Code

GPA

5

286

290

Unused. Leave blank.

Expected Grad Year

4

291

294

Unused. Leave blank

Resident District

5

295

299

Unused. Leave blank

Teacher/Group Name – WASL Math or ITBS/ITED

40

300

339

Blank if no sort criteria defined. Possible values include "Homeroom Teacher", "Class Period and Teacher", "Advisor":

Last Name, First Name

Teacher/Group Name – WASL LRW

40

340

379

WASL only (Blank if no sort criteria defined. Possible values include "Homeroom Teacher", "Class Period and Teacher", "Advisor"):

Last Name, First Name

Teacher/Group Name – WASL Science

40

380

419

WASL only (Blank if no sort criteria defined. Possible values include "Homeroom Teacher", "Class Period and Teacher", "Advisor"):

Last Name, First Name

LAP Reading

1

420

420

Y" or "N" (Special Program Funding Source = "LAP" and Service Area = "R*", or Special Program Funding Source = "LAR"):

Student Management / Student / ASI / Student Programs

LAP Math

1

421

421

"Y" or "N" (Special Program Funding Source = "LAP" and Service Area = "M*", or Special Program Funding Source = "LAM"):

Student Management / Student / ASI / Student Programs

TAS Reading

1

422

422

Unused. Leave blank.

TAS Math

1

423

423

Unused. Leave blank.

Migrant

1

424

424

"Y" or "N" (Special Program Funding Source = "TL1" and Service Area = "G*", or Special Program Funding Source = "T1G"):

Student Management / Student / ASI / Student Programs

Section 504

1

425

425

Unused. Leave blank.

Grant 21st Century

1

426

426

Unused. Leave blank.

Homeless

1

427

427

Unused. Leave blank.

Gifted

1

428

428

"Y" or "N" (Special Program Funding Source = "HC*"):

Student Management / Student / ASI / Student Programs

LEP Bilingual

1

429

429

"Y" or "N" (Special Program Funding Source = "BLE"):

Student Management / Student / ASI / Student Programs

F/R Eligibility

1

430

430

"Y" or "N" (Free / Reduced Eligibility):

Student Management / Student / Food Service

Special Education

1

431

431

"Y" or blank (Is the student active in Special Education? For a complete discussion of the logic, see the definition on the Report Fields page):

Student Management / Stu Serv / Special Ed / Eval Info

Special Ed LREA

2

432

433

Unused. Leave blank.

Special Ed LREB

1

434

434

Unused. Leave blank.

Outside Services

1

435

435

Unused. Leave blank.

School Choice

1

436

436

Unused. Leave blank.

Home Language

3

437

439

Unused. Leave blank.

Pre School

1

440

440

Unused. Leave blank.

Serving School

4

441

444

Numeric:

Student Management / Entity / Edit / Entity School Information / Edit / School #

Primary School

1

445

445

Unused. Leave blank

Enrollment Status

2

446

447

Unused. Leave blank

Date Enrolled in District

10

448

457

District enrollment date (most recent) (mm/dd/yyyy):

Student Management / Student / Entry/With

Date Exited from District

10

458

467

Field will be blank because students who have exited the district will not be selected for Pre-ID.

Date Enrolled in School

10

468

477

School entry date (most recent) (mm/dd/yyyy):

Student Management / Student / Entry/With

Date Exited from School

10

478

487

Field will be blank because students who have exited the school will not be selected for Pre-ID.

Days Attended

4

488

491

Unused. Leave blank.

Days Enrolled

4

492

495

Unused. Leave blank.

BEAFTE

4

496

499

Unused. Leave blank.

Voc Ed FTE

4

500

503

Unused. Leave blank.

Skill Center FTE

4

504

507

Unused. Leave blank.

Running Start FTE

4

508

511

Unused. Leave blank.

Voc Ed Running Start FTE

4

512

515

Unused. Leave blank.

NS School Year AAFTE

4

516

519

Unused. Leave blank.

NS School Year Voc AAFTE

4

520

523

Unused. Leave blank.

NS School Year Skills AAFTE

4

524

527

Unused. Leave blank.

Private Ancillary Service

4

528

531

Unused. Leave blank.

Home Based Ancillary Service

4

532

535

Unused. Leave blank.

Voc Ed CIP

6

536

541

Unused. Leave blank.

Voc Ed Tech Prep

1

542

542

Unused. Leave blank.

Voc Ed Direct Tran

1

543

543

Unused. Leave blank.

Voc Ed Tech Prep Comp

1

544

544

Unused. Leave blank.

Voc Ed Voc Comp

1

545

545

Unused. Leave blank.

Voc Ed Voc Comp Followup

1

546

546

Unused. Leave blank.

Voc Ed Industry Certificate

1

547

547

Unused. Leave blank.

AP Course

5

548

552

Unused. Leave blank.

Foreign Exchange Student

1

553

553

"Y" or "N" (Student Category Code = "FOR"):

Student Management / Student / Gen #2 / Student Category Codes

Home Based Student Attending Part Time

1

554

554

"Y" or "N" (Student Category Code = "HOM"):

Student Management / Student / Gen #2 / Student Category Codes

Private School Based Student Attending Part Time

1

555

555

"Y" or "N" (Student Category Code = "PRI"):

Student Management / Student / Gen #2 / Student Category Codes

Number Unexcused Absences

2

556

557

Unused. Leave blank

ELL Enrollment Date

10

558

567

Unused. Leave blank

ELL Exit Date

10

568

577

Unused. Leave blank

Social Security Number (SSN)

9

578

586

Unused. Leave blank

WAAS Flag

1

587

587

WASL only ("Y" or "N"; Student Category Type = "WAA"):

Student Management / Student / Gen #2 / Student Category Codes

WASL Previously Passed Reading

1

588

588

"Y" or "N":

Student Management / Student / ASI

WASL Previously  Passed Writing

1

589

589

"Y" or "N":

Student Management / Student / ASI

WASL Previously  Passed Math

1

590

590

"Y" or "N":

Student Management / Student / ASI

WASL Previously Passed Science

1

591

591

"Y" or "N":

Student Management / Student / ASI

Grade 11 Retester – Reading

1

592

592

("Y" or "N"; Student Category Type = "11R"):

Student Management / Student / Gen #2 / Student Category Codes

Grade 11 Retester – Writing

1

593

593

("Y" or "N"; Student Category Type = "11W"):

Student Management / Student / Gen #2 / Student Category Codes

Grade 11 Retester – Math

1

594

594

("Y" or "N"; Student Category Type = "11M"):

Student Management / Student / Gen #2 / Student Category Codes