Home > WESPaC Student Management > WASL & ITBS/ITED Rpt & Pre-ID Extract File > 7 Report Fields
|
|
|
|
|
|
|
Contents |
The following fields either appear in the reports, or are criteria used in selecting students:
|
Field Name |
Path to data field |
Table/ field ID |
|
|
Entity ID |
Student Management / Entity |
Entity.Entity-ID |
|
|
Entity Name |
Student Management / Entity |
Entity.Entity-Name |
|
|
Report Title |
ITBS/ITED File Extract Report or WASL File Extract Report |
N/A |
|
|
State Building Code |
Student Management / Entity / Edit / Entity School Information / Edit / School Number used in state reporting |
School.School-Number |
|
|
School ID |
Student Management / Codes / Dist Codes / School / School Codes |
School.School-ID |
|
|
School Name |
Student Management / Codes / Dist Codes / School / School Codes |
School.School-Name |
|
|
District Name |
System Admin / System / Dist Config |
District-Config.District-Name |
|
|
District ID |
System Admin / System / Dist Config |
District-Config.District-Code |
|
|
Student Status |
Students, in their default entity, with an active entry withdrawal record on the run date appear on the report. Grade 11 students only appear if marked as a retester in at least one WASL subject area: Student Management / Student / Entry/With |
STUDENT-EW.EW-DATE STUDENT-EW.WITHDRAWAL-DATE
|
|
|
Student Name |
Student Management / Student / General 1 |
Name.Last-Name Name.First-Name Name.Middle-Name |
|
|
State Student Identifier (SSID)
|
State Student Identifier (as assigned by OSPI): Student Management / Student / WA/NCLB |
Student.MN-Ede-Nbr |
|
|
District Student ID (Dst Stu ID) |
Student Management / Student / WA/NCLB |
STUDENT.STUDENT-ID |
|
|
Grade Level |
State equivalent grade level associated with the graduation year: Student Management / Student / General 1 / Grad Yr/Grade |
Student.Grad-Year
|
|
|
Language (Lng) |
Primary language spoken by the student: Student Management / Student / General 1 |
LANGUAGE.STATE-LANGUAGE-TYPE |
|
|
If all the following criteria are true, the student is active in Special Education and "Y" is printed. The field is otherwise blank: |
|
||
|
(1) Active in Special Education, based on Exit Date: Student Management / Stu Serv / Special Ed / Eval Info / State Rpt / Exit Date |
SE-Student.Spec-Ed-Dismissal-Date |
|
|
|
(2) Evaluation is current: Student Management / Stu Serv / Special Ed / Eval Info |
|
|
|
|
a. Evaluation is not a work in progress (WIP) |
SE-Stu-Eval.Eval-WIP |
|
|
|
b. Evaluation complete date is not blank, and is less than or equal to system date (Eval Completion Date) |
SE-Stu-Eval.Assmt-Compl-Due-Date |
|
|
|
c. Next evaluation date is not blank, greater than or equal to system date, and no more than 3 years in the future (Next Evaluation Date) |
SE-Stu-Eval.Next-Eval-Date |
|
|
|
(3) IEP is current: Student Management / Stu Serv / Special Ed / IEP Info |
|
|
|
|
a. IEP is not a work in progress (WIP) |
SE-IEP.IEP-WIP |
|
|
|
b. IEP beginning date is not blank, and is less than or equal to the system date (Begin Date) |
SE-IEP.IEP-Beg-Date |
|
|
|
c. IEP end date is not blank, greater than or equal to system date, and no more than 1 year in the future (End Date) |
SE-IEP.IEP-End-Date |
|
|
|
(4) The current evaluation has a special service code that is flagged as a handicap code, and has a state equivalent disability (or handicap) code: Student Management / Stu Serv / Special Ed / Eval Info / Gen Info / Disability |
SE-Stu-Eval-Handicap.Special-Service-ID |
|
|
|
Disability Code |
If Special Education is blank, Disability Code is blank. If Special Education = "Y", use the primary disability code (standard codes 01-14): Student Management / Codes / Dist. Codes / Special Education /State Rpt Code |
Special-Service.State-Reporting-Code |
|
|
Ethnicity (Eth) |
Student Management / Student / General 1 |
Name.Race-Code |
|
|
Birth Date
|
Student Management / Student / General 1 |
Name.Birthdate |
|
|
Student Management / Student / General 1 |
Name.Gender |
|
|
|
Teacher Sort Data |
Includes the following possible values: |
|
|
|
(1) Homeroom number: Student Management / Student / Entity / Edit / Room |
Student-Entity.Homeroom-Number Homeroom.Homeroom-Teacher Name.Nalphakey |
|
|
|
(2) Class Period and Teacher: Student Management / Office / Current Scheduling / Course Master / Meet |
Class-Meet.Sch-Period Name.Nalphakey |
|
|
|
(3) Advisor: Student Management / Student / Entity / Advisor |
Student-Entity.Advisor Name.Nalphakey |
|
|
|
ITBS/ITED Teacher |
ITBS/ITED only: See Teacher Sort Data for possible values |
|
|
|
LRW Teacher |
WASL only: See Teacher Sort Data for possible values. |
|
|
|
Math (Mth) Teacher |
WASL only: See Teacher Sort Data for possible values. |
|
|
|
Science (Sci) Teacher |
WASL only: See Teacher Sort Data for possible values. |
|
|
|
LR – LAP Reading |
Student Management / Student / ASI / Student Programs |
WA-Stu-Programs.Funding-Src-ID = "LAR" |
|
|
LM – LAP Math |
Student Management / Student / ASI / Student Programs |
WA-Stu-Programs.Funding-Src-ID = "LAM" |
|
|
FR – Free / Reduced |
Student Management / Student / Food Service |
FS-LUN-CODE.FS-LUN-CODE-ID = "F" OR "R" |
|
|
FX – Foreign Exchange Student |
Student Management / Student / General 2 / Student Category Codes |
STUDENT-CATEGORY.CATEGORY-TYPE-ID = "FOR" |
|
|
BL – Bilingual/ESL |
Student Management / Student / ASI / Student Programs |
WA-Stu-Programs.Funding-Src-ID = "BLE" |
|
|
GT – Gifted/Talented |
"Y" = Yes, blank = "No": Student Management / Student / ASI |
Student.X-Gifted-Talented |
|
|
MI – Title 1 Migrant |
"Y" = Yes, blank = "No": Student Management / Student / ASI |
Student.X-Migrant |
|
|
PR – Private Schooled |
Student Management / Student / General 2 / Student Category Codes |
Student-Category.Category-Type-ID = "PRI" |
|
|
HM – Home Schooled |
Student Management / Student / General 2 / Student Category Codes |
Student-Category.Category-Type-ID = "HOM" |
|
|
RR – Grade 11 Restester (Reading) |
Student Management / Student / General 2 / Student Category Codes |
STUDENT-CATEGORY.CATEGORY-TYPE-ID = "11R" |
|
|
RW – Grade 11 Restester (Writing) |
Student Management / Student / General 2 / Student Category Codes |
STUDENT-CATEGORY.CATEGORY-TYPE-ID = "11W" |
|
|
RM – Grade 11 Restester (Math) |
Student Management / Student / General 2 / Student Category Codes |
STUDENT-CATEGORY.CATEGORY-TYPE-ID = "11M" |
|
|
RD – WASL Previously Passed Reading |
Student Management / Student / ASI |
Student.WASL-Prev-Passed-Reading |
|
|
WR – WASL Previously Passed Writing |
Student Management / Student / ASI |
Student.WASL-Prev-Passed-Writing |
|
|
MT – WASL Previously Passed Math |
Student Management / Student / ASI |
Student.WASL-Prev-Passed-Math |
|
|
SC – WASL Previously Passed Science |
Student Management / Student / ASI
|
Student.WASL-Prev-Passed-Science |
|
|
WAAS – Washington Alternative Assessment |
Student Management / Student / General 2 / Student Category Codes |
Student-Category.Category-Type-ID = "WAA" |
|
|
Dst Enr Dt – District Enrolled Date |
Student Management / Student / Entry/With |
STUDENT.WA-MOST-RECENT-DIST-ENROLLMENT |
|
|
Dst Ext Dt – District Exit Date |
Blank. Only actively enrolled students are reported. |
-- |
|
|
Sch Enr Dt – School Enrolled Date |
Student Management / Student / Entry/With |
STUDENT-EW.EW-DATE |
|
|
Sch Ext Dt – School Exit Date |
Blank. Only actively enrolled students are reported. |
-- |
|
Page Updated 11/04