Students

The Advanced Search searches for any field that is downloaded in the CSV file.

1. The name of the student, school, or district.
2. Student identifiers Local-ID, State-ID or National-ID.
3. Student date of birth or last four of student's SSN.
4. Any SSN that begins with a '9' (which indicates that the number is NOT an SSN, but a random number assigned by the district).
5. Student demographics and programs (see list below).
6. Student grade.
7. Student enrolled status and enrollment date.
8. Student graduation status and graduation date.

Start the search with a '#'.

Some examples:

Advanced searches contain a combination of field:value pairs.

The search will match the value against the contents of the field.

Fields are one of the following types:

1. Yes/No fields, like 'enrolled', allow a few different entries to represent a Yes value: 'Yes', 'yes', 'Y', 'y' or a '1' all will search for Yes.
   Any other value for a Yes/No field means search for a No.

2. Words fields, like 'school', consist of one or more words. Enter some of the letters, or all the letters, in a word to search for the word.

   To search using multiple words in the same field, surround the words with quotation marks.

   Will find all schools with Alma in the name.

   Will find "Vilonia Primary".

   Will find "Cutter Morning Star Elem".

3. Identifier fields, like 'localID', consist of one or more numbers. Enter some of the numbers, or all the numbers, in an identifier to search for the identifier.

4. Date fields, like 'grad', have the year, month and day organized as YYYY-MM-DD.

   'YYYY' is the four digit year, 'MM' is the two digit month and 'DD' is the two digit day of the month.

   If the day is omitted then '01' is used. If the month is omitted then '01' is used.

   Use a '~' to indicate a range of dates. '2014~' means on, or after, 2014. '~2014' means 2014 or before.

   To find records between two dates (like graduated on, or after, May 1st, 2013 but before, or on, August 1st, 2014) put a '~' between the dates: .

5. Character code fields have one or more characters in a code for the field. The character code fields are:

   • grade
   • gender
   • esi
   • el
   • ethnicity

   To search on multiple values for a character code field put all the values inside parenthesizes. For instance, do the following for finding all students in high school: .

Combine key:value pairs to create sophisticated searches.

Some searches by definition should return no results. For instance should not find any records because students who graduated before January 1st, 2015 should not still be enrolled today.

Some fields require specific permissions. If the required permissions to search on a specific field (like EconDis) are not available then the search will be rejected.

ANY - With some character code fields, like lep or esi, it is hard to know exactly what to enter for the search. To find all students with some kind of testing accommodation enter . That is 'ANY' (all capitals) for the value and the search will return all records that have at least one character in the field.

NONE - To find all records without at least one character in a field then enter . That is 'NONE' (all capitals) for the value and the search will return all records that do not have at least one character in the field.