Wave Requirements
Wave Data Requirements
Wave Requirements
Version 1.12
Purpose
The purpose of this webpage is to provide information necessary for the collection of required student demographics, enrollment, teacher and course data, within The Wave. In accordance with 70 O.S. § 3-104, state law authorized the Oklahoma State Board of Education and the Oklahoma State Department of Education to collect data from schools necessary to perform required duties and functions.
This technical requirements webpage is intended for Student Information Systems (SIS) vendors to use in mapping the elements? necessary for data collection, however, any entity with a stake in education data may use this document as a reference.
Oklahoma school district personnel must ensure their vendor is referencing this documentation in order to meet the defined data submission requirements through legislation that began in the 2005-2006 school year. Vendors may utilize this document as a vital starting point for SIF? agent development as it clearly identifies Oklahoma’s expectation in regards to the SIF 2.0r1 Implementation Specification. Data objects? and elements? identified in this document, to be collected through The Wave, fall under the same School Laws of Oklahoma as all reports required of school districts.
All persons charged with the collection of data through The Wave shall maintain event and scheduled data collections with the highest degree of diligence, accuracy, and good faith in reflecting the truth.
How to navigate the SDE webpages and Airtable
The Wave Requirements technical webpage will be viewed via Airtable. There are 27 Data Types that are sent to the Wave throughout the year. To get more detail, review the entire Wave Requirements table via Airtable.
Airtable is a website that allows you to combine the ease of utilizing a spreadsheet with the power of using a database to store, reference and retrieve information. The new Wave Requirements sets to be a tool that can be used not only by student information system vendors but can also be a tool to use as a repository for reporting requirements and guidance.
Review Airtable how-to guides that contain tips and tricks that may help you navigate Airtable.
27 Data Types sent to the Wave
Below are the 27 data types that are sent to the Wave.
Address: This element provides details about an address and occurs within objects and elements such as StudentPersonal.
Attendance Code Info: This object provides information about a particular attendance code.
Calendar Date: This object defines information related to a school calendar day in a given school calendar year.
Calendar Summary: This object provides a summary of a school’s calendar information for a given school year.
Demographics: This object is used to provide demographic information.
Discipline Incident: This object provides information on incidents involving violence, weapons, drugs, and other safety and discipline issues.
LEA Info: This object is used to provide information about the Local Educational Agency (LEA.).
Mark Info: This object defines each grade type that can be recorded and associates it with a MarkValueInfo object that lists the types of values and valid values for each type.
Mark Value Info: This object defines the types of values allowed for a letter grade and the domain for each mark value. At least one of the Percentage, Numeric, Letter, or Narrative grade types must be used to create a valid MarkValueInfo.
Room Info: This object may contain a reference to a room type so that it may represent anything from a gym, cafeteria, to a standard classroom.
School Course Info: This object is for course information.
School Info: This object is used to collect school site information.
Section Info: This object provides information about the section – the specific time period a session of the course meets
Section Mark Info: This object defines the marking periods (TermInfo) that marks (StudentSectionMarks) are recorded in for a particular section (SectionInfo) and lists the types of marks (MarkTypeInfo) that are valid for that marking period (TermInfo).
Staff Assignment: This object defines information related to a staff member's assignment(s); commonly, this will be a school assignment.
Staff Personal: This object contains all the personal information relating to a staff member who might be a teacher or other employee of the school or district.
Student Academic Record: This object conveys a student’s academic record data for student record exchange and transcript purposes.
Student Attendance Summary: This object provides a summary of a student’s daily attendance and membership information for a given school.
Student Contact: This object is used to create student contact information. It is also used to update the student contact information during data collection.
Student Daily Attendance: This object provides daily attendance information for a particular student in a particular school on a particular date.
Student Period Attendance: This object provides attendance for a student in the context of the section they are enrolled in.
Student Participation: This object contains information pertaining to student eligibility for and participation in an individualized special program such as special education, Gifted and Talented, Section 504, etc.
Student Personal: This object is used to assign additional informational student information not collected in Demographics and to assign Student Testing Number (STN).
Student School Enrollment: This object is used to get information about a student's enrollment in an accredited Oklahoma public school.
Student Section Enrollment: This object contains information about a student’s enrollment in a section of a course.
Student Section Marks: This object contains the grades entered for a student in a class section for a specific marking period.
Term Info: This object provides information about a term.
Review Wave Requirements
You can interact with the table below without leaving this webpage, however, if you would like to review the table in a larger format, click here or the "View Larger version" button at the bottom right-hand side of the table.
Next to any object below and click the triangle to expand and view the collected data points. Note that this table is interactive and customizable for ease of use.
There are two ways you can review the data via Airtable:
Use the Airtable just as you would a normal spreadsheet created in Microsoft Excel, Google Sheets, or Apple Pages.
To expand a record using the keyboard, click the cell then click the "Space" key to get more detail
To expand a specific cell using on-screen tools, click on the cell and click the blue up and down arrow to get more detail
To review data vertically, hover over a data point, click on the blue up and down arrow icon to expand the view.
Overview of the Airtable tabs:
Overview and reminders of common issues related to objects? collected in the Objects tab.
Overview of all data points collected in the Wave Requirements tab.
List of code tables in the Code Tables tab.
List of extended elements in the Extended Elements tab.
Any changes between the latest Wave Requirements release and the previously released requirements in the Changes tab.
Calendar of all reports collected in OSDE in the Reports/Guides tab.
An archive of past Wave Requirements in the Archive tab.
A condensed version of the Code Tables in the Code Tables Compact tab.
The list of validations currently applied to a data point in the Validations tab. Coming Fall 2023
To search the entire Airtable click the "Blocks" button found on the upper right-hand corner of your screen.
For Questions: Contact the Office of Data and Information Systems at StudentDataInfo@sde.ok.gov or call 405-521-3020.
