Student Directory

Introduction

The report extracts directory data for high school students in grades 9 to 12 and their parents/guardians who have not opted out of information sharing through the annual FERPA notification process.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis of report results when the report does not return the correct records.

Student Selection

The report selects student records based on the following criteria:

The student must in the grade levels 9 - 12.
The Exclude from OSPI Student Directory Reporting flag is not checked for the student. ([s_wa_stu_x]OPTOUTSTUDIRECTORY)

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Select Schools

If run at the district level, choose one of the following:

Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report
All Schools – Run the report for the entire district.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Current Selection Students

Indicate which students to include in the report by selecting one of the following options:

The Selected [number] Students Only – run the report for students in the current selection.
All Students (default) – run the report for all students in the current school or district that meet the selection criteria.
Note: If running the report for a single student, or group of students, select the students prior to running report.

School Year

Select the appropriate school year from the drop-down list. The menu is automatically populated with the full-year term associated with the term currently selected at the top of the page. To change the School Year, click Term at the top of the page and choose a different term from the drop-down list.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Data Element	Description	[Table]Fieldname	Data Type	Length
District Code	A unique five-digit code assigned by OSPI to every LEA in Washington.	[Prefs]value - districtnumber [cst_subdistricts]SUBDISTRICT_NUMBER	CHAR	5
School Code	A unique four-digit code assigned by OSPI to every school in Washington.	[Students]Schoolid	CHAR	4
School Year	For academic years that span a calendar year, this is the four-digit of the ending year. For example, 2023 for 2022-2023.	[Terms]Firstday, [Terms]Lastday	CHAR	4
SSID	The state assigned Student Identifier.	[Students]State_StudentNumber	CHAR	10
Contact Type	G for guardian or "S" for student. Currently, the report displays the value S in the output.	“S”	CHAR	1
LastName	The full legal last name borne in common by members of a family.	[Students]Last_Name	VARCHAR	75
FirstName	The full legal first name given to a person at birth, baptism, or through legal change.	[Students]First_Name	VARCHAR	75
Mailing Address Street	The street number and street name or post office box number of an address.	[Students]Street	VARCHAR	150
City Name	The name of the city in which an address is located.	[Students]City	VARCHAR	30
State Abbreviation	The abbreviation for the state (within the United States) or outlying area in which an address is located.	[Students]State	CHAR	2
Zip Code	A number that identifies each postal delivery area in the United States used as a portion of an address.	[Students]Zip	VARCHAR	17
Phone Number	The telephone number including the area code, and extension, if applicable.	[Students]Home_Phone	VARCHAR	24
Email Address	The numbers, letters, and symbols used to identify an electronic mail (e-mail) user within the network to which the person or organization belongs.	[EmailAddress]EmailAddress	VARCHAR	128