Related Topics   

CSRS Data Extract (2008-09)

Contents

1 Overview

2 Data Elements

3 Extract File

4 Extract Report

5 Students without SSID Rpt

6 Exception Report

7 Warning Report

8 Primary School Report

9 Special Education IEP Report

10 Report Parameters

 

 

11 How-to

12 Student Selection Criteria

13 Special Programs Data

14 Category Data

15 Data Element Criteria

16 Extract File Fields

17 Extract Rpt Fields

18 No SSID-Exception Rpt Fields

19 Primary School Report Fields

20 Special Education IEP Report Fields

 

16 Extract File Fields

Name

Maximum

Field Length

Description

 Path to Data Field

School Year

9

Data element 1

Based on the menu option selected

Collection Period (Reporting Month)

2

Data element 2

Month for which data is collected

State Student Identifier (SSID)

10

Data element 3: Student.MN-Ede-NbR

Student Management / Student / ASI

Serving County-District Code

5

Data element 4: District-Config.District-Code

Student Management / Entity / Edit / Edit Entity School Information / District / Edit

District Assigned Student Code

12

Data element 5: Student.Student-ID

A unique code assigned by the system that cannot be updated

Student Legal Last Name

60

Data element 6: Name.Last-Name

Student Management / Student /  General 1 / Edit

Student Legal First Name

60

Data element 7: Name.First-Name

Student Management / Student /  General 1 / Edit

Student Legal Middle Name

60

Data element 8: Name.Middle-Name

Student Management / Student /  General 1 / Edit

Student Birth Date

10

Data element 9: Name.Birthdate

Student Management / Student / General 1 / Edit

Student Gender

1

Data element 10: Name.Gender

Student Management / Student /  General 1 / Edit

Student Residential Zip Code

5

Data element 11: Address.Zip-Code

Student Management / Student / General 1 / Addr(H) / Update Home/Mailing Address

Student Residential Zip + 4 Extension

4

Data element 12: Address.Plus4

Student Management / Student /  General 1 / Addr(H) / Update Home/Mailing Address

Student Grade Level

2

Data element 13: Calculated from student-ew.withdrawal-grad-yr

Student Management / Student / Entry/Withdrawal

Student Primary Language

3

Data element 14: Language.STATE-LANGUAGE-TYPE

Student Management / Student /  General 1 / Edit

Student Race/Ethnicity

2

Data element 15: Name.Race-Code

Student Management / Student /  General 1 / Edit

Student Disability Status

2

Data element 16: SE-Stu-Eval-Handicap.Special-Service-ID

Student Management / Stu Serv / Special Ed. / Gen. Info / Disability / Edit or Add

Student Cumulative Grade Point Average

4

Data element 17

Calculated

Student Expected Year of Graduation

4

Data element 18: Student.WA-Grad-Yr

Calculated: Student Management / Student /  General 1 / Edit WA Grad Yr

Student Resident County-District Code (the district that collects apportionment)

5

Data element 19

Calculated: Student Management / Student / E/W / Edit

WASL Mathematics Teacher

40

Data element 20

To be determined

WASL LRW Teacher

40

Data element 21

To be determined

WASL Science Teacher

40

Data element 22

To be determined

LAP Reading

1

Data element 23

Calculated: Student Management / Student / WA/NCLB / Student Programs / Add or Edit

LAP Math

1

Data element 24

Calculated: Student Management / Student / WA/NCLB / Student Programs / Add or Edit

Title I Targeted Assistance Reading

1

Data element 25

Calculated: Student Management / Student / WA/NCLB / Student Programs / Add or Edit  (or derived from Title I Reading as set in School Maintenance)

Title I Targeted Assistance Math

1

Data element 26

Calculated: Student Management / Student / WA/NCLB / Student Programs / Add or Edit  (or derived from Title I Math as set in School Maintenance)

Title I Migrant

1

Data element 27

Calculated: Student Management / Student / WA/NCLB / Student Programs / Add or Edit

Section 504 Plan

1

Data element 28

Calculated: Student Management / Student / WA/NCLB / Student Programs / Add or Edit

Did the Student Receive Services from a 21st Century Community Learning Program?

1

Data element 29

Calculated: Student Management / Student / WA/NCLB / Student Programs / Add or Edit

Is Student Homeless?

1

Data element 30

Calculated: Student Management / Student / WA/NCLB / Student Programs / Add or Edit (or NCLB-2 /Homeless)

Highly Capable

1

Data element 31

Calculated

Did the Student Receive Services from a State Transitional Bilingual Instruction Program?

1

Data element 32

Calculated: Student Management / Student / NCLB-2 / Limited English Proficiency or Student Management / Student / WA/NCLB / Student Programs

Free/Reduced-Price Meal Eligibility Status

1

Data element 33

Calculated

Did the Student Receive Special Education Services?

1

Data element 34

Calculated

Least Restrictive Environment

2

Data element 35:

SE-IEP.SE-IEP-LRE-ID

Student Management / Stu Serv / Special Ed / IEP Info / LRE

Special Education LRE (Part B)

1

Data element 36

 

Did the Student Receive Supplemental Services?

1

Data element 37

Calculated: Student Management / Student / WA/NCLB / Student Programs / Add or Edit

Is Student Attending your School by School Choice?

1

Data element 38: Student-CLASSIFICATIONS-sc-CODE-1

Calculated: Student Management / Student / NCLB-2 / Non-Res Enrolled In

Student Language Spoken at Home

1

Data element 39: Language.STATE-LANGUAGE-TYPE

Calculated: Student Management / Student / Family / Add or Edit

Did the Student Participate in an Early Education Program?

1

Data element 40:

WA-Stu-Programs.Funding-Src-ID

Calculated: Student Management / Student / WA/NCLB / Student Programs / Add or Edit

Serving School Code

4

Data element 41: Student-EW.School-ID

Student Management / Student / Entry/With / Edit

Is this the School that is Primarily Responsible for the Student?

1

Data element 42: Determined from Student-Entity.X-Default-Entity flag field and STUDENT-EW.X-WITHDRAWAL-DEFAULT-ENTITY

Student Management / Student /  General 1

Student Enrollment Status

2

Data element 43

Calculated

Date Student Enrolled in District

10

Data element 44: StudenT.WA-MOST-RECENT-DIST-ENROLLMENT

Most recent date student enrolled in district: Student Management / Student / Entry/With / Ent-Wthdrw

Date Student Exited from District

10

Data element 45: STUDENT-EW.WITHDRAWAL DATE

Most recent date student left district: Student Management / Student / Entry/With / Ent-Wthdrw

Date Student Enrolled in School

10

Data element 46: Student-EW.EW-Date

Most recent school entry date: Student Management / Student / Entry/With / Ent-Wthdrw

Date Student Exited from School

10

Data element 47: Student-EW.Withdrawal Date

Most recent date student left school: Student Management / Student / Entry/With / Ent-Wthdrw

Number of Days Attended in School

5

Data element 48

Calculated

Number of Days Enrolled in School

5

Data element 49

Calculated

Vocational Education Basic Education Allocation FTE

4

Data element 50

Calculated

Vocational Education FTE

4

Data element 51

Calculated

Skill Center FTE

4

Data element 52

Calculated

Running Start FTE

4

Data element 53

Calculated

Vocational Running Start FTE

4

Data element 54

Calculated

Non-Standard School Year AAFTE

4

Data element 55

Calculated

Non-Standard School Year Vocational AAFTE

4

Data element 56

Calculated

Non-Standard School Year Skill Center AAFTE

4

Data element 57

Calculated

Private Student Ancillary Service Hours

5

Data element 58

Calculated

Home-Based  Student Ancillary Service Hours

5

Data element 59

Calculated

Career and Technical Education (CTE) Classification of Instructional Program (CIP) Code Number

6

Data element 60: Course.CIP-Code

Student Management / Student / Voc Ed / Edit / CIP

Is the Career and Technical Education (CTE) Course Part of a Tech Prep Articulation Agreement?

1

Data element 61: Course.WA-Articulated-Tech-Prep = Y

Student Management / Office / Current Scheduling / Course Master / Edit or Add / More / Articulated Tech Prep

Is Career and Technical Education (CTE) Direct Transcription Available?

1

Data element 62: Course.WA-Direct-Transcription-Avail = Y

Student Management / Office / Current Scheduling / Course Master / Edit or Add / More / Direct Transcription Available

Is the Student a Tech Prep Completer?

1

Data element 63: Student-Vocational-Ed.WA-Tech-Prep-Completer = "Y"

Student Management / Voc Ed / Edit / CIP / Tech Prep

Is the Student a Career and Technical Education (CTE) Program Completer?

1

Data element 64: Student-Vocational-Ed.WA-Voc-Completer = "Y"

Student Management / Student / Voc Ed / Edit / CIP / Voc Comp

Did the Student Take or Pass a State or Nationally Recognized Assessment Test of Technical Skill and Knowledge?

1

Data element 65:

Student Management / Student / Test Scores / Add / CTE Test

Did the Student Receive a State or Nationally Recognized Industry Certificate?

1

Data element 66

Student Management / Student / Voc Ed / Edit / CIP / Industry Cert

Student Advance Placement (AP) and International Baccalaureate (IB) Course Codes

5

Data element 67

Calculated

Is Student from a Foreign Country with an F-1 Visa?

1

Data Element 68: STUDENT-CATEGORY.CATEGORY-TYPE-ID

Student Management / Student / General 2 / Edit Catg or Entity / Edit Catg

Is Student a Home-Schooled Student Attending Class Part-Time?

1

Data Element 69: STUDENT-CATEGORY.CATEGORY-TYPE-ID

Student Management / Student / General 2 / Edit Catg or Entity / Edit Catg

Is Student an Approved Private School Attending Class Part-Time?

1

Data Element 70: STUDENT-CATEGORY.CATEGORY-TYPE-ID

Student Management / Student / General 2 / Edit Catg or Entity / Edit Catg

Number of Unexcused Absences this Month

2

Data Element 71

Calculated

State Transitional Bilingual Program Enrollment Date

10

Data Element 72: STUDENT-CLASSIFICATIONS.SC-STR-DATE or WA-STU-PROGRAMS.START-DATE

Calculated: Student Management / Student / NCLB-2 / Limited English Proficiency or Student Management / Student / WA/NCLB / Student Programs

State Transitional Bilingual Program Exit Date

10

Data Element 73: STUDENT-CLASSIFICATIONS.SC-END-DATE or WA-STU-PROGRAMS.END-DATE

Calculated: Student Management / Student / NCLB-2 / Limited English Proficiency or Student Management / Student / WA/NCLB / Student Programs

Student SSN (Social Security Number)

9

Data Element 74: NAME.FEDERAL-ID-NO

Student Management / Student / WA/NCLB / Edit

Page Updated 8/08

Top