~[wc:commonscripts] ~[wc:admin_header_css] ~[text:psx.html.admin_reports.runreports.start_page] > MBA Data Reference & Resource ~[wc:admin_navigation_css] ~[SetPostValue:tab=scodes]

PowerSchool Search Codes

~[x:insertfile;tabs.html]

Search Codes

A search code is a special type of command that is searched by completing a calculation and comparing the results.

Search codes can search for students who were:

  • Born in a specific month
  • Not enrolled into a specific period
  • Active as of a specific date
  • Enrolled in a specific program

Multiple search codes can be combined to perform a compound query. When using search codes within a compound query, the search code must come first with each query being separated by the AND (;) comparator.


Examples:

Search Code Query Example Data Returned
*allstudents *allstudents=all
*allstudents=5
Returns a list of all students in all grades taking classes in the current school, including those enrolled
Returns a list of all students in the selected grade level taking classes in the current school, including those enrolled
*as_of *as_of=10/1/2011 Returns any students who were enrolled as of October 1 of a specific school year
*birthday *birthday=today
*birthday=11/10
*birthday>=04/01;*birthday<=04/30
Returns all currently enrolled students whose birthday is today
Returns all currently enrolled students born on November 10th
Returns all currently enrolled students whose birthday is in the month of April
*fee.fee_balance *fee.fee_balance > 0 Returns any students who owe money on their student fee accounts
*currently_enrolled_in *currently_enrolled_in = H2011ES Returns any students who are currently enrolled in Algebra 1 during the "current term"
*not_currently_enrolled_in *not_currently_enrolled_in = H2011ES Returns any students who are NOT currently enrolled in Algebra 1 during the "current term"
*enrolled_in *enrolled_in = H3011ES Returns any students who have been enrolled into English during any term
*not_enrolled_in *not_enrolled_in = H3011ES Returns any students who have not been enrolled into English 1 for the current school year
*not_enrolled_in_period *not_enrolled_in_period = 4 Returns any students who are not enrolled in a course for the specified period
*has_completed_course *has_completed_course=H2011ES Returns any students who have at least one historical grade entry for Algebra 1
*has_not_completed *has_not_completed = H2011ES Returns any student who does not have any historical grade entries for Algebra 1
*cumulative_credit_hours *cumulative_credit_hours = 12 Returns any student with the credit hours equal to 12
*number_of_classes *number_of_classes < 7 Returns any student who is currently enrolled in less than 7 classes
*currenthours_requested *currenthours_requested=5 Returns any students who have 5 credit hours requested in the current year (Live Side)
*hours_requested *hours_requested > 8 Returns any students who have more than 8 hours worth of course requests (PowerScheduler)
*secondarystudents *secondarystudents= all
*secondarystudents = 8
Returns all who are enrolled in a course at the current school but whose school enrollment is at another school
Returns all 8th grade students who are enrolled in a course at the current school but whose school enrollment is with another school
*special_program *special_program=Gifted Returns all students enrolled in the Gifted special program
Compound example w/ search code *as_of=10/1/2022;grade_level=12 Returns all currently enrolled 12th graders who were enrolled as of October 1 of 2022

Report Codes

Report codes are used to customize the following:

  • Reports
  • Labels
  • Calculated GPAs
  • Export Data

In addition, parameters and delimiters can be added to modify or limit a fields display.



Modifies how data output is displayed on reports using the format ^(fieldname). To modify the field display insert a semicolon after the field and specify the format, ex: ^(fieldname;XXXX).

Examples:

Code Modified Code What it Does What it Prints
^(Last_Name)
^(First_Name)
^(LastFirst)
^(Last_Name;uppercase)
^(First_Name;lowercase)
^(LastFirst;uppercase)
^(LastFirst;lowercase)
Prints the student's name in uppercase or lowercase letters SMITH
smith
SMITH, JOHN A
smith, john a
^[Date] ^[date;dateformat=MM/DD/YYYY] Prints the date as month, day, and year separated by a slash 03/15/2021
^(DOB) ^(dob;dateformat=MMMM D, YYYY) Prints the date of birth as text for the month and numbers for the day March 15, 2021
^(Gender) ^decode;^(gender);m;Male;f;Female;Blank) Prints the gender as "Male" or "Female" rather than "m" or "f"
If no gender is entered, prints the word "Blank"
Male
Female
Blank

Some codes look like PowerSchool fields, but aren't. For example, the code ^(Schoolname) is not a field in PowerSchool; but instead a code that can be used to print the name of the school for any student in the district. A separate report or label is no longer needed when using the schoolname code.

Examples:

Code Example What it Does What it Prints
^(age)
or
^(age;long)
John is ^(age) old.
or
John is ^(age;long) old.
Prints the student's age in years and months, or years, months, and days John is 10 yrs 4 months old.
or
John is 10 years 4 months and 6 days old.
^(he/she)
^(son/daughter)
Your ^(son/daughter) said that ^(he/she) was excused Substitutes the appropriate pronoun for the gender Your son said that he was excused
^(schoolname)
or
^(schoolabbr)
Best Practice Tip- Use ^([schools]name) to pull the school name on reports if printing from the District Office.
Welcome to ^(schoolname).
or
Welcome to ^(schoolabbr).
Prints the full name of the school or the abbreviated school name Welcome to Apple Grove High School.
or
Welcome to AGHS.
^(yearname) Welcome to the ^(yearname) school year. Prints the full name of the school year Welcome to the 2012-2013 school year.
^[letter.date] Today is ^[letter.date]. Prints the current date and spells out the month Today is June 11, 2021.
^[short.date] Today is ^[short.date]. Prints the current date in numbers Today is 6/11/2021.

Sometimes, when printing a report or a list of students, the records printed need to be limited.

Codes that include an asterisk * complete a calculation and display the result on the report. To use any of the following codes in reports, include a caret and parentheses ex: ^(*period_info;XX;room).

Examples:

Code Example What it Does What it Prints
*period_info;XX;teacher_name *period_info;1(A);teacher_name Prints the first period teacher's name Adams, John L
*period_info;XX;room *period_info;1(A);room Prints the first period room number 247
*period_info;XX;course_name *period_info;1(A);course_name Prints the first period course name Math 8
*count *count Prints the count of records printed 1.
2.

Use the following example code to print GPA results on form letters, object reports, and report cards. Instead of using a semicolon to separate code parameters, use an equals sign.

The following table contains a code that returns a student's first semester GPA for English courses. Each parameter entered defines the code further. Use the GPA codes to display results contained within the Cumulative Info student page.

Examples:

Type of Code Calculation Parameter Term Parameter Type Parameter Credit Parameter
GPA method="weighted" term="S1" type="current" Credittype="ENG"

Code Example: ^(*GPA method="weighted" term="S1" type="current" credittype="ENG")

Examples:

Type of Code Test Name Selection Test Score Selection Test Selection TEst Score Type Test Output Result Code
tests name=ACT score=English Which=best type=num result=value ^(tests;name=ACT;score=English;which-best;type=num;result=value)

Returns Best ACT English Score
tests name=SAT score=MATH which=Last type=num result=value ^(tests;name=SAT;score=Math;which=Last;type=num;result=value

Returns Last SAT Math Score
tests name=ACT score - omit this attribute which=first type=num result=date ^(tests;name=ACT;which=first;type=num;result=date)

Returns First ACT Test Date
tests name=SAT score - omit this attribute which=last type=num result=date ^(tests;name=SAT;which=last;type=num;result=date)

Returns Last SAT Date

Note: Only First, Last, and Best Scores can be reported using test codes.

~[x:insertfile;footer.html] ~[wc:admin_footer_css]