Enter letters or numbers to start the search. Searching is automatic as you make changes.

The Basic Keyword Search searches for any field that is displayed in the search results.

The Advanced Search searchers for any field that is downloaded in the CSV file. Permission from your district is required to use the Advanced Search.

The basic keyword searches for any field that is displayed in the search results:

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 enrollment date or graduation date.

There are a couple of handy hints:

1. Enter part of the first and last name. For instance 'Bil Ad' would find 'William Adams'.
2. Notice first names match against common nicknames:
   • Billy finds william,willy,bell,bela,bill,will,billy and willie
   • Betty finds elizabeth,libby,lisa,lib,lizzie,eliza,betsy,liza,betty,bessie,bess,beth and liz
   • Richy finds richard,dick,dickon,dickie,dicky,rick,rich,ricky
3. Start typing in an identifier. The search results will start showing the students who's State-ID, Local-ID, National-ID, last four of SSN or an SSN that begins with a '9' are close to what has been entered.
4. Start typing a date in the format YYYYMMDD. The search results will start with students who's enrollment date, or graduation date that are close to what has been entered. Notice that the beginning of a date usually also finds identifiers that have the same numbers.
5. Enter an exact SSN (with the dashes like 111-22-3333) to find a record matching that SSN. Clicking the found record will open the student's transcript record.
6. Enter a Smart Core authorization code (with the dashes like Tb8p-AwMD-Bgcv-EaQM) to find a record for that authorization code. Clicking the found record will open the student's Smart Core report.

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.

When searching for students the bucket should be set to "district" even if you have access to multiple districts. Use the "districtlea" field to limit the return transcripts to a specific district.

The "q" field is the same as the "Enter keywords" user interface field.

Here are some examples that you might find helpful.

find all currently enrolled students at Alma School District.

find all currently enrolled students at Alma School District who are at risk.

find all students who attended Alma School District during school year 2018/19.

find all students at Alma School District that have had a transcript change after July 1st 2019.

Advanced searchable fields are divided into several categories.

Catalog Information

Completion Status

Programs

Enrollment / Withdrawals