Tool Search: WDE950
The WDE-950 Graduating Student Extract is a student level extract that collects transcript data for all Wyoming graduating students. The report is used for state level analysis and as a guide for ongoing review of Hathaway Scholarship Program (HSP) eligibility requirements and current participants. The extract can be generated in four different extract types: Student Data, Courses, Test and Immunizations.
WDE-950 Extract Editor
Report Logic
All extract types respect State Exclude for enrollments, calendars and grade levels. To report, a student must have at least one transcript record in grades 9-12 and a WISER ID number.
Student Data File
- Reports one record per student for the most recent Primary enrollment in a selected calendar.
- Records are sorted by school and then alphabetically by student last name.
- If a student enrollment is marked as "State Exclude" or "No Show," reports the previous Primary enrollment.
- When more than one State Seal record has the same "Date Earned" entry, the records will be sorted and reported beginning with earliest RecordID.
Courses File
- Populate one record per course on transcript for each student while in grade 09 - 12 OR when Hathaway NOT = null on the transcript.
- Records are sorted by school and then by WISER ID.
- Does not report a record for a transcript entry when the Standard Name is not null.
- With the release of Campus.1717. Courses marked as State Exclude are not reported.
Tests File
- Reports one record for each National Test/Assessment record attached to a student.
- Records that do not have a value to report in Test Score will not report.
- Sorts records by school and then by WISER ID.
- WorkKeys assessments are determined by the National Code or the State Code (as of Campus.1909).
- If the student does not have an ACT or WorkKeys assessment, reports one record with a Test Type of NoACTorWorkKeys.
Immunizations File
- Reports one record per immunization record per student.
- Records are sorted by school and then by WISER ID.
If Graduated Seniors, Previous Year is selected as a Grade in the extract editor, only students report who have:
- A Diploma Date entered that is on or before 09/15 in the selected calendar
- A Primary enrollment in grade 12 in the previous year.
Extract Types
Extract Type | Description |
|---|---|
Student Data | The Student Data extract type includes basic student demographics and enrollment data. |
Courses | The Courses extract type reports data for the courses the student has completed. |
Tests | The Tests extract type includes basic information about assessments the student has taken. |
Immunizations | The Immunizations extract type reports vaccine compliance information for the student. |
Generating the Extract
- Select the Extract Type being generated. See options in the Extract Types table above.
- Select the Format in which the report should generate. Options are:
- Use HTML format for data review and verification.
- Use State Format (CSV) for submission to the state.
- Mark the Include Class Rank checkbox if class rank should be included in the report. This option is only available when generating the Student Data Extract Type.
- Indicate if Demographics fields should Report Student Legal Identities.
- Select which Grades should be included in the report. Use Shift and CTRL keys to select multiple grade levels.
- Select an Ad hoc Filter if individuals included in the report should be limited.
- Select the Calendar(s) that should be included in the report.
- Click Generate Report to view the report in the selected format or Submit to Batch to schedule when the report will generate.
Users have the option of submitting a WDE-950 report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.
WDE-950 State Format (CSV)
WDE-950 HTML Format
Extract Layouts
The following sections described the fields reported for each extract type.
Student Data Extract Type
If the Report Student Legal Identities is marked, Demographics fields report from Census > People > Identities > Active Identity > Protected Identity Information
Element Name | Description and Format | Campus Location |
|---|---|---|
Last Name | The student's last name. Alphanumeric, 35 characters | Demographics > Last Name Identity.lastName |
First Name | The student's first name. Alphanumeric, 25 characters | Demographics > First Name Identity.firstName |
Middle Name | The student's middle name. Alphanumeric, 15 characters | Demographics > Middle Name Identity.middleName |
Name Suffix | The student's generation indicator, such as Jr. Alphanumeric, 8 characters | Demographics > Suffix Identity.suffix |
Street | The street number and name of the student's address. Alphanumeric, 30 characters | Households > Primary Household > P.O Box, Number, Prefix, Street, Tag, Direction Address.postOfficeBox |
Apt Num | The apartment number of the student's residence. Alphanumeric, 5 characters | Households > Primary Household > Apt Number Address.apt |
City | The city in which the student's address is located. Alphanumeric, 25 characters | Households > Primary Household > City Address.city |
State | The abbreviation of the state in which the student's address is located. Alphanumeric, 2 characters | Households > Primary Household > State Address.state |
Zip Code | The zip code of the student's address. Numeric, 5 digits | Households > Primary Household > Zip Code Address.zip |
Phone | The phone number of the student's primary household. Numeric, 10 digits | Households > Household Info > Phone Number Address.phone |
Birth Date | The student's date of birth. Date field, 8 digits YYYYMMDD | Demographics > Birth Date Identity.birthDate |
Grade Level | The grade level of the student's current enrollment. Numeric, 2 digits | Enrollments > Grade Enrollment.grade |
Gender | The student's gender. Alphanumeric, 1 character M or F | Demographics > Gender Identity.gender |
Student Num | The locally-maintained student identification number. Alphanumeric, 10 characters | Demographics > Person Identifiers > Local Student Number Person.studentNumber |
WISER ID | The student's state identification number. Alphanumeric, 10 characters | Demographics > Person Identifiers > Student State ID Person.stateID |
School District Name | The name of the school district in which the student is enrolled. Alphanumeric, 25 characters | District Information > Name District.name |
School Name | The name of the school in which the student is enrolled. If the Resident School selected on the student's most recent Primary enrollment matches the State School Number, reports the Name of the school. Otherwise reports as blank. If Resident School is blank, reports the Name of the school of the student's most recent Primary enrollment. Alphanumeric, 25 characters | School Information > Name School.name |
School Street | The street address of the school reported for School Name above. Alphanumeric, 30 characters | School Information > Address |
School Apt | The apartment or suite number of the school's address. Reports as blank. | |
School City | The city in which the school reported for School Name is located. Alphanumeric, 30 characters | School Information > City School.city |
School State | The abbreviation of the state in which the school reported for School Name is located. Alphanumeric, 2 characters | School Information > State School.state |
School Zip | The zip code of the school's address. Numeric, 5 digits | School Information > Zip School.zip |
School Phone | The phone number of the school reported for School Name above. Numeric, 10 digits | School Information > Phone School.phone |
School District URL | The school's website. Reports for the school reported for School Name above. Alphanumeric, 50 characters | School Information > URL School.url |
State ID | The state identification number of the school. Numeric, 7 digits | School Information > number School.number |
Grad Date | The date the student received a diploma. If a Diploma Date is entered for the student, reports Graduation Date. If the Diploma Date is blank and the student is in grade 12, reports as n/a. Otherwise reports blank. Date field, 8 digits YYYYMMDD | Graduation > Diploma Date Graduation.diplomaDate |
Success Curriculum Level (previously Scholarship Award Level) | The initial level of the Hathaway Scholarship earned based on Hathaway Success Curriculum courses completed. Reports as follows:
Alphanumeric, 30 characters | Graduation > Transcript Endorsement Graduation.diplomaType |
| Success Curriculum Waiver | When Success Curriculum Level reports as CW, HW, PW, OW, or NW, reports as Y. Otherwise reports as N. Alphanumeric, Y or N | Not dynamically stored. |
GPA Unweighted | The total unweighted grade point average earned by the student. Reports all unweighted GPA values across all courses on the student's transcript from grades 9-12 divided by the total credits earned from grades 9-12. Decimal, 3 digits X.XX | Transcript > Unweighted AND Student Information > General > Credit Summary > Total Not dynamically stored |
GPA Weighted Hathaway | The total weighted grade point average earned by the student during grades 9-12. Decimal, 3 digits X.XX | Credit Summary > Cumulative GPA Not dynamically stored |
Credit Earned | The number of credits the student has earned for completing courses included in this transcript during grades 9-12. Decimal, 3 digits X.XX | Transcripts > Credit (total) Not dynamically stored |
Class Size | The total number of students in the student's graduating class. Calculated from all students who have the same State Grade Level as the student. Numeric, 4 digits | Calculated, not dynamically stored |
Class Rank | The academic rank of the student in relation to his or her graduating class. Numeric, 4 digits | Credit Summary > Rank Not dynamically stored |
Rank Date | The month, day and year on which the class rank was determined. When Diploma Date, Enrollment End Date or Calendar End Date is the current date, reports the current date. Otherwise, reports Diploma Date, then Enrollment End Date, then Calendar End Date. | Student Information > General > Graduation > Diploma Date OR Student Information > General > Enrollments > End Date OR System Administration > Calendar > Calendar > End Date Not dynamically stored |
Birth City | The city in which the student was born. Alphanumeric, 30 characters | Identities > Birth Place Identity.birthCity |
School Entry Date | The date the student entered the school. Reports the start date of the first enrollment in the current school with no break in enrollment. Date field, 8 digits YYYYMMDD | Enrollments > Start Date Enrollment.startDate |
Credit Attempted | The total number of credits attempted by the student in grades 9-12. If the GPA Value and UnWeighted GPA values on the transcript are null, the score assigned to the student reports if mapped to a State Score that is not W, AU, or null. The transcript record links back to the Score Group for the credit associated with the transcript record to be included in this field. If Credit Earned is higher than Credit Attempted, Credit Attempted reports the Credit Earned value. Decimal, 3 digits X.XX | Calculated from Transcript > Course (edit) > Transcript Credit > Earned/Attempted Calculated, not dynamically stored |
GPA Credit Earned | The total number of credits earned and used to calculate GPA. Decimal, 3 digits X.XX | Credit Summary > Total Calculated, not dynamically stored |
GPA Quality Points | The total value of quality/bonus points used to calculate GPA. Decimal, 3 digits X.XX | Calculated from Transcript > Course (edit) > Bonus Points Calculated, not dynamically stored |
| Achievement Proficiency 1 |
| Graduation > State Seal Information > State Seals and Certs |
| Achievement Language 1 | World Language Seal of Biliteracy is Earned in. From the student's State Seal record with the earliest "Date Earned" entry, where (Student Information > General > Graduation > State Seal Information) = ADV or BAS:
| Graduation > State Seal Information > Language |
| Achievement Proficiency 2 |
| Graduation > State Seal Information > State Seals and Cert |
| Achievement Language 2 | World Language Seal of Biliteracy is Earned in. From the student's State Seal record with the 2nd earliest "Date Earned" entry, where (Student Information > General > Graduation > State Seal Information) = ADV or BAS:
| Graduation > State Seal Information > Language |
| Achievement Proficiency 3 |
| Graduation > State Seal Information > State Seals and Cert |
| Achievement Language 3 | World Language Seal of Biliteracy is Earned in. From the student's State Seal record with the 2nd earliest "Date Earned" entry, where (Student Information > General > Graduation > State Seal Information) = ADV or BAS:
| Graduation > State Seal Information > Language |
Courses Extract Type
Element Name | Description & Format | Campus Location |
|---|---|---|
WISER ID | The student's state identification number. Alphanumeric, 10 characters | Demographics > Student State ID Person.stateID |
Course School Name | The name of the school in which the course was completed. If a School ID Override is entered on the Course, that value is reported. Otherwise reports the State School Number. Alphanumeric, 25 characters | Course > School ID Override School Information > Name Course.providerSchool School.name |
Term Year | The year of the reported school session based on the Start and End dates of the calendar(s) selected in the extract editor. Date field, 4 digits, YYYY | Calendar Information > Start and End Dates (years only) Calendar.startDate |
Term Code | Reports the Standard Number from the transcript entry. If Standard Number is null, reports Actual Term. Alphanumeric, 12 characters | Transcript > Course (edit) > Standard Number, Actual Term TranscriptCourse.standardNumber |
Session Code | The designator for multiple course entries within a single term, such as S1, Q2, etc. Alphanumeric, 2 characters | Transcript > Course (edit) > Actual Term TranscriptCourse.actualTerm |
Start Date | The start date of the course session. Date field, 8 digits YYYYMMDD | Transcript > Course (edit) > Term Start Date TranscriptCourse.termStartDate |
End Date | The end date of the course session. Date field, 8 digits YYYYMMDD | Transcript > Course (edit) > Term End Date TranscriptCourse.termEndDate |
Course ID | The identification number of the course. Alphanumeric, 7 characters | Course > Number Course.number |
SCED Code | The SCED code associated with the course. Alphanumeric, 13 characters | Transcript > Course (edit) > State Code TranscriptCourse.stateCode |
Title | The descriptive name given to the course. Alphanumeric, 35 characters | Course > Name Course.name |
Scholarship Course Indicator | Indicates if the course is a scholarship success curriculum course.
| Transcript > Transcript Course editor; Scheduling > Courses > Course > Hathaway TranscriptCourse.transcriptField1 |
| Pre Ninth Hath |
| Transcript > Transcript Course editor TranscriptCourse.transcriptField1 |
Mark | The final indicator of student performance in the class. If the State Score associated with the score is not null or 99, reports the State Score code. If the State Score is null or 99, reports the score. Alphanumeric, 2 characters | Transcript > Course (edit) > Current Score Calculated, not dynamically stored |
Credit Earned | The number of credits the student earned for completing a given course. Decimal, 3 digits X.XX | Transcript > Course (edit) > Transcript Credit > Earned TranscriptCredit.creditsEarned |
| Instruction Level | Reports the Instruction Level code selected for the Section.
Alphanumeric | Section > Instruction Level Course > Instruction Level Section.instructionLevel Course.instructionLevel |
| Location Section ID | Reports the concatenated value of the Course Number - Section Number associated with the course on the student's transcript. Alphanumeric | Scheduling > Courses > Course > Number; Scheduling > Courses > Section > Number Course.number Section.number |
| State Course ID | Reports the value of the State Code tied to the course listed on the transcript:
N = a number C = a letter OR
Examples
Alphanumeric | Transcript > Course > State Code TranscriptCourse. stateCode |
Tests Extract Type
Element Name | Description & Format | Campus Location |
|---|---|---|
WISER ID | The student's state identification number. Alphanumeric, 10 characters | Demographics > Student State ID Person.stateID |
Test Type | The title or name of the assessment administered on or before the extract Effective Date. Reports the National Test selected from the Parent assessment, then reports additional records for Child assessments. Alphanumeric, 25 characters | Assessment Center > Tests > Assessment Type Test.type |
Subtest Name | The description of the content or subject area of the assessment.
Alphanumeric, 15 characters | Assessment > Tests > Name Test.name |
Test Score | The score the student received for the assessment. Reports from the parent assessment first, then from the child assessment if null. Always reports as Y for NoACTWorkKeys records. If the record is for an ACT assessment parent and Received Accommodation is marked, reports as Y. Alphanumeric, 25 characters | Assessment Center > Test Score > Score TestScore.scaleScore |
Score Type | The type of scoring method used. Alphanumeric, 50 characters | Assessment Center > Tests > Test Detail > Select the score fields... Test.useDate |
Test Date | The date the student took the assessment. Date field, 8 digits YYYYMMDD | Student Information > General > Assessment > Test Scores > Date TestScore.date |
Immunizations Extract Type
Element Name | Description & Format | Campus Location |
|---|---|---|
WISER ID | The student's state identification number. Alphanumeric, 10 characters | Demographics > Student State ID Person.stateID |
Immunization Type | The type of immunization the student has received. Alphanumeric, 25 characters | Vaccines > Code Vaccine.code |
Immunization Date | The date an immunization was received. Reports a record for each immunization dose received. Date field, 8 digits YYYYMMDD | Immunizations > Shots VaccineShot.date |
Immunization Status | If the immunization dose was waived, reports the waiver reason for the immunization record. Alphanumeric, 2 characters | Immunizations > Waiver VaccineShot.waiver |
