Related Topics   

CSRS Data Extract (2007-08)

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

 

17 Extract Report Fields

Name

Path to Data Field

Source of Data

Header:

Serving County-District Code

Data element 4: District-Config.District-Code

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

School Year

Based on the menu option selected

Data element 1

Effective Date

Effective date for running the process

Entered when the process is run

Collection Period (Reporting Month)

Month for which data is collected

Data element 2

First Line (Student Level):

Student Legal Last Name

Student Management / Student /  General 1 / Edit

Data element 6: Name.Last-Name

Student Legal First Name

Student Management / Student /  General 1 / Edit

Data element 7: Name.First-Name

Student Legal Middle Name

Student Management / Student /  General 1 / Edit

Data element 8: Name.Middle-Name

Student Birth Date

Student Management / Student /  General 1 / Edit

Data element 9: Name.Birthdate

Student Gender

Student Management / Student /  General 1 / Edit

Data element 10: Name.Gender

Student Residential Zip Code

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

Data elements 11-12: Address.Zip-Code, Address.Plus4

Student Race/Ethnicity

Student Management / Student /  General 1 / Edit

Data element 15: Name.Race-Code

Student Cumulative Grade Point Average

Calculated

Data element 17

Did the Student Receive Special Education Services?

Calculated

Data Element 34

Student Disability Status

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

Data element 16: SE-STU-EVAL-HANDICAP.SPECIAL-SERVICE-ID

Special Education Student Placement in Least Restrictive Environment

(LRE Part A)

Student Management / Stu Serv / IEP Info tab / LRE

Data element 35: SE-IEP.SE-IEP-LRE-ID

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

Data Element 19: Student Management / Student / Entry/With / Edit

 Student-EW.District-Code

State Student ID (SSID)

Student Management / Student / WA/NCLB

Data element 3: STUDENT.MN-EDE-NBR

District Assigned Student Code

A unique code assigned by the system that cannot be updated

Data element 5: STUDENT.STUDENT-ID

Second Line (Student Level)

Student Primary Language

Identifies the student’s primary language.

Data element 14

Student Language Spoken at Home

Identifies the language the student primarily speaks at home.

Data element 39

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

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

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

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

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

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

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

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

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

State Transitional Bilingual Program Enrollment Date

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

Data Element 72: WA-STU-PROGRAMS.START-DATE

State Transitional Bilingual Program Exit Date

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

Data Element 73: WA-STU-PROGRAMS.END-DATE

Student SSN (Social Security Number)

Student Management / Student / WA/NCLB / Edit

Data Element 74: "Reported" displays when number is available.

Third Line (Entity Level):

Entity Number

Viewable: Student Management / Student /  General 1 / Default Entity Entity

Student-Entity.Entity-ID

Serving School Code

Student Management / Student / Entry/With / Edit

Data element 41: Student-EW.School-ID

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

Student Management / Student /  General 1

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

Student Grade Level

Student Management / Student / Entry/Withdrawal

Data element 13: Calculated from Student-EW.WITHDRAWAL-Grad-Yr

Student Expected Year of Graduation

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

Data element 18: STUDENT.WA-GRAD-YR

Did the Student Receive Services from a Learning Assistance Program (LAP) - Reading?

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

Data element 23

Did the Student Receive Services from a Learning Assistance Program (LAP) - Math?

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

Data element 24

Did the Student Receive Services from Title I Targeted Assistance (TAS) Reading?

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

Data element 25

Did the Student Receive Services from Title I Targeted Assistance (TAS) Math?

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

Data element 26

Did the Student Receive Services from Title I Migrant?

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

Data element 27

Section 504 Plan

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

Data element 28

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

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

Data element 29

Is Student Homeless?

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

Data element 30

Did the Student Receive Services from Highly Capable?

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

Data element 31

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

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

Data element 32

Free/Reduced-Price Meal Eligibility Status

Calculated

Data element 33

Did the Student Receive Supplemental Services?

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

Data element 37

Is Student Attending your School by School Choice?

Calculated: Student Management / Student / Entry/With / Enter / Open Enrolled In

Data element 38: Student-EW.Enrolled-In

Did the Student Participate in an Early Education Program?

Calculated: Student Management / Student / ASI / Student Programs / Add or Edit

Data element 40: WA-Stu-Programs.Funding-Src-ID

Student Enrollment Status

Calculated

Data element 43

Date Student Enrolled in District

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

Data element 46: STUDENT-EW.EW-DATE

Date Student Exited from District

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

Data element 47: STUDENT-EW.WITHDRAWAL DATE

Date Student Enrolled in School

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

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

Date Student Exited from School

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

Data element 45: STUDENT-EW.WITHDRAWAL DATE

Number of Days Attended in School

Number of days (partial or full) student attended or received educational services during reporting month

Data element 48

Number of Days Enrolled in School

Number of days student enrolled during reporting month

Data element 49

Number of Unexcused Absences this Month

Number of unexcused absences during the collection period, as determined by school district policy

Data element 71

Fourth Line (Course Level):

 

 

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

 

Data element 60: Course.CIP-Code

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

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

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

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

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

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

Is the Student a Tech Prep Completer?

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

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

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

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

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

Voc Ed Vocational Completer Follow-Up

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

Data element 65: Student-Vocational-Ed.WA-Voc-Follow-Up = "Y"

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

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

Data element 66: STUDENT-VOCATIONAL-ED.WA-VOC-IND-CERT = "Y"

Course

Identifies a course in which the student is enrolled which has an Advanced Placement code

 

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

Identifies the Advanced Placement type associated with a course in which student is enrolled

Data element 67

Page Updated 8/07

Top