WDE-950 Graduating Student Extract (Wyoming)

Classic View: WY State Reporting > WDE950 Graduating Student Extract 

Search Term: Graduating Student Extract

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.

Image 1: 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.

Courses File

  • Reports one record per grade 9-12 course on a student's 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

  1. Select the Extract Type being generated. See options in the Extract Types table above.
  2. 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.
  3. 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.
  4. Indicate if Demographics fields should Report Student Legal Identities.
  5. Select which Grades should be included in the report. Use Shift and CTRL keys to select multiple grade levels.
  6. Select an Ad hoc Filter if individuals included in the report should be limited.
  7. Select the Calendar(s) that should be included in the report.
  8. 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.


 Image 2: WDE-950 State Format (CSV) 


 Image 3: 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 & Format

Campus Location

Last Name

The student's last name.


Alphanumeric, 35 characters

Census > People > Demographics > Last Name


Identity.lastName

First Name

The student's first name.


Alphanumeric, 25 characters

Census > People > Demographics > First Name


Identity.firstName

Middle Name

The student's middle name.


Alphanumeric, 15 characters

Census > People > Demographics > Middle Name


Identity.middleName

Name Suffix

The student's generation indicator, such as Jr.


Alphanumeric, 8 characters

Census > People > Demographics > Suffix


Identity.suffix

Street

The street number and name of the student's address.


Alphanumeric, 30 characters

Census > People > Households > Primary Household > P.O Box, Number, Prefix, Street, Tag, Direction


Address.postOfficeBox
Address.number
Address.prefix
Address.street
Address.tag
Address.dir

Apt Num

The apartment number of the student's residence.


Alphanumeric, 5 characters

Census > People > Households > Primary Household > Apt Number


Address.apt

City

The city in which the student's address is located.


Alphanumeric, 25 characters

Census > People > Households > Primary Household > City


Address.city

State

The abbreviation of the state in which the student's address is located.


Alphanumeric, 2 characters

Census > People > Households > Primary Household > State


Address.state

Zip Code

The zip code of the student's address.


Numeric, 5 digits

Census > People > Households > Primary Household > Zip Code


Address.zip

Phone

The phone number of the student's primary household.


Numeric, 10 digits

Census > Households > Household Info > Phone Number


Address.phone

Birth Date

The student's date of birth.


Date field, 8 digits YYYYMMDD

Census > People > Demographics > Birth Date


Identity.birthDate

Grade Level

The grade level of the student's current enrollment.


Numeric, 2 digits

Student Information > General > Enrollments > Grade


Enrollment.grade

Gender

The student's gender.


Alphanumeric, 1 character M or F

Census > People > Demographics > Gender


Identity.gender

Student Num

The locally-maintained student identification number.


Alphanumeric, 10 characters

Census > People > Demographics > Person Identifiers > Local Student Number


Person.studentNumber

WISER ID

The student's state identification number.


Alphanumeric, 10 characters

Census > People > 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

System Administration > Resources > 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

System Administration > Resources > School > Name


School.name

School Street

The street address of the school reported for School Name above.


Alphanumeric, 30 characters

System Administration > Resources > School > 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

System Administration > Resources > School > City


School.city

School State

The abbreviation of the state in which the school reported for School Name is located.


Alphanumeric, 2 characters

System Administration > Resources > School > State


School.state

School Zip

The zip code of the school's address.


Numeric, 5 digits

System Administration > Resources > School > Zip


School.zip

School Phone

The phone number of the school reported for School Name above.


Numeric, 10 digits

System Administration > Resources > School > Phone


School.phone

School District URL

The school's website. Reports for the school reported for School Name above.


Alphanumeric, 50 characters

System Administration > Resources > School > URL


School.url

State ID

The state identification number of the school.


Numeric, 7 digits

System Administration > Resources > School > 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

Student Information > General > Graduation > Diploma Date


Graduation.diplomaDate

Endorsement Type

The type of Hathaway Scholarship certification earned by the student. Options are:

  • General: when Transcript Endorsement is 90: General Endorsement 
  • Comprehensive: when Transcript Endorsement is 91: Comprehensive Endorsement 
  • Advanced: when Transcript Endorsement is 92: Advanced Endorsement 
  • null: when Transcript Endorsement is null and Diploma Date is on or before the current date
  • Pending: when Transcript Endorsement is null and Diploma Date is after the current date.

Alphanumeric, 30 characters

Student Information > General > Graduation > Transcript Endorsement, Diploma Date


Graduation.diplomaType
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:

  • C or CW: Provisional Opportunity
  • H, HW, P, PW: Honors/Performance
  • O or OW: Opportunity
  • N, NW, or blank: None

Alphanumeric, 30 characters

Student Information > General > Graduation > Transcript Endorsement


Graduation.diplomaType

Success Curriculum WaiverWhen 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

Student Information > General > 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

Student Information > General > 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

Student Information > General > Transcript > 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

Student Information > General > 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

Census > People > Person Information > 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

Student Information > General > Enrollments > Start Date


Enrollment.startDate

English Proficiency

Indicates whether the student is proficient in English.

Reports as Y if the student has an EL record active during the calendar with a EL or Exited EL. Otherwise reports as N.


Alphanumeric, 1 character

Student Information > Program Participation > English Learners (EL) > Identified Date, Program Exit Date


LEP.identifiedDate

Foreign Language ProficiencyWhen Foreign Language Proficiency is marked, reports as Y. Otherwise reports as N.

Alphanumeric, 1 character
Census > People > Demographics

Identity.foreignLanguageProficiency

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 Student Information > General > 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

Student Information > General > 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 Student Information > General > Transcript > Course (edit) > Bonus Points


Calculated, not dynamically stored

Courses Extract Type

Element Name

Description & Format

Campus Location

WISER ID

The student's state identification number.


Alphanumeric, 10 characters

Census > People > Demographics > Person Identifiers > 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

Scheduling > Courses > Course > School ID Override; System Administration > Resources > School > 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 

System Administration > Calendar > Calendar > Start and End Dates (years only)


Calendar.startDate
Calendar.endDate

Term Code

Reports the Standard Number from the transcript entry. If Standard Number is null, reports Actual Term.


Alphanumeric, 12 characters

Student Information > General > Transcript > Course (edit) > Standard Number, Actual Term


TranscriptCourse.standardNumber
TranscriptCourse.actualTerm

Session Code

The designator for multiple course entries within a single term, such as S1, Q2, etc.


Alphanumeric, 2 characters

Student Information > General > Transcript > Course (edit) > Actual Term


TranscriptCourse.actualTerm

Start Date

The start date of the course session.


Date field, 8 digits YYYYMMDD

Student Information > General > Transcript > Course (edit) > Term Start Date


TranscriptCourse.termStartDate

End Date

The end date of the course session.


Date field, 8 digits YYYYMMDD

Student Information > General > Transcript > Course (edit) > Term End Date


TranscriptCourse.termEndDate

Course ID

The identification number of the course.


Alphanumeric, 7 characters

Scheduling > Courses > Course > Number


Course.number

SCED Code

The SCED code associated with the course.


Alphanumeric, 13 characters

Student Information > General > Transcript > Course (edit) > State Code


TranscriptCourse.stateCode

Title

The descriptive name given to the course.


Alphanumeric, 35 characters

Scheduling > Courses > Course > Name


Course.name

Scholarship Course Indicator

Indicates if the course is a scholarship success curriculum course. If the Hathaway checkbox is marked on the student's transcript record, or the Hathaway checkbox is marked for the course, reports as (T)rue. Otherwise reports as (F)alse.


Alphanumeric, 1 character

Student Information > General > Transcript > Transcript Course editor; Scheduling > Courses > Course > Hathaway


TranscriptCourse.transcriptField1
Course.transcriptField1

Pre Ninth HathIf the student has a transcript record for a grade other than 9, 10, 11, or 12 that has the Hathaway checkbox marked on the record or on the Course, reports as Y. Otherwise reports as N.

Alphanumeric, 1 character
Student Information > General > 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

Student Information > General > 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

Student Information > General > Transcript > Course (edit) > Transcript Credit > Earned


TranscriptCredit.creditsEarned

Instruction Level

Reports the Instruction Level code selected for the Section. Otherwise reports the Instruction Level selected on the Course.

Reports the attribute default value when a valid value exists in this field.

Reports "GE" in the Instruction Level field when a course is entered manually onto the student's transcript and cannot be linked back to a course.


Alphanumeric

Scheduling > Courses > Section > Instruction Level; Course > Instruction Level

Section.instructionLevel Course.instructionLevel
Location Section IDReports 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 IDReports the value of the State Code tied to the course listed on the transcript when:

Format = NNNNNCN.NNNN, where N = a number, and C = a letter.


  • Reports blank when the State Code does not conform to the above rule.

Alphanumeric
Student Information > General > 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

Census > People > Demographics > Person Identifiers > 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 > Test Setup > Tests > Test Detail > Assessment Type


Test.type

Subtest Name

The description of the content or subject area of the assessment. Reports a record for each assessment and each child assessment when the Parent Assessment Date is on or before the extract Effective Date. For ACT assessments where the student did not Receive Accommodation, reports as 'CompositeHighest' when the record is for the student's highest composite ACT score or as 'Compose' if not. For WorkKeys assessments, reports as 'TotalScore' for the parent assessment.


Alphanumeric, 15 characters

Assessment > Test Setup > Tests > Test Detail > 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

Student Information > General > Assessments > Test Score > Score


TestScore.scaleScore

Score Type

The type of scoring method used.


Alphanumeric, 50 characters

Assessment > Test Setup > Tests > Test Detail > Select the score fields...


Test.useDate
Test.useScaleScore
Test.useRawScore
Test.useReasonCode
Test.useReceivedAccommodation
Test.usePercentile
Test.usePercent
Test.useNormalCurveEquivalent
Test.useResult
Test.useInvalid

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

Census > People > Demographics > Person Identifiers > Student State ID


Person.stateID

Immunization Type

The type of immunization the student has received.


Alphanumeric, 25 characters

System Administration > Health > 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

Student Information > Health > Immunizations > Shots


VaccineShot.date

Immunization Status

If the immunization dose was waived, reports the waiver reason for the immunization record.


Alphanumeric, 2 characters

Student Information > Health > Immunizations > Waiver


VaccineShot.waiver

Save