Home‎ > ‎Announcements‎ > ‎

Student Search Commands

posted Mar 26, 2014, 10:09 AM by Lawrence Esplin

The following commands are intended to be used in student searches, and can be used from the Start Page in PowerSchool. Following each command is a table indicating how it interacts with certin PowerSchool values.

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESYES YESYES NO

 Enroll_Status

If YES, the Search Command is sensitive to whether the student is Active (Enroll_Status=0) or Not-Active (Enroll_Status#0).

Term Selector

If YES, the Search Command is sensitive to what Term is currently selected.

School Selector

If YES, the Search Command is sensitive to what School is currently selected.

School Year

If YES, the Search Command is sensitive to what School Year is currently selected.

PowerScheduler

If YES, the Search Command is sensitive to PowerScheduler settings.

 

Enrolled in Course.Section

Format: *enrolled_in=[Course_Number].[Section_Number}

Example: *enrolled_in=SOC1000

Example: *enrolled_in=SOC1000.5

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESYES YESYES NO

 

Not Enrolled in Course.Section

Format: *not_enrolled_in=[Course_Number].[Section_Number]

Example: *not_enrolled_in=SOC1000

Example: *not_enrolled_in=SOC1000.5

(Local) Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESYES YESYES NO

 

From Another School Enrolled in Courses Here

Format: *secondarystudents=[Grade_Level]

Example: *secondarystudents=all

Example: *secondarystudents=5

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
NOYES YESYES NO

 

From any School Enrolled in Courses Here

Format: *allstudents=[Grade_Level]

Example: *allstudents=5

Example: *allstudents=all

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESYES YESYES NO

 

Not enrolled in Period

Format: *not_enrolled_in_period=[Internal Period Number]

Example: *not_enrolled_in_period=1

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESYES YESYES NO

 

Enrolled in Special Program

Format: *special_program=[Special Program Name]

Example: *special_program=Gifted

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESNO YESNO NO

 

Enrolled in Number of Classes

Format: *number_of_classes[operator][number]

Example: *number_of_classes=7

Example: *number_of_classes<8

Example: *number_of_classes>6

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESYES YESYES NO

 

(PowerScheduler) Requested Credit Hours in Scheduling Year

Format: *hours_requested[operator][number]

Example: *hours_requested<11

Example: *hours_requested=10

Example: *hours_requested>9

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESNO YESNO NO

 

(Live Side) Requested Credit Hours in Current Year

Format: *currenthours_requested[operator][number]

Example: *currenthours_requested=5

Example: *currenthours_requested<6

Example: *currenthours_requested>4

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESNO YESYES NO

 

Date of Birth is MM/DD/YYYY

Format: DOB=[MM/DD/YYYY]

Example: DOB=03/01/2012

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESNO YESNO NO

 

Birthday (Anniversary) is MM/DD

Format: *birthday=[MM/DD]

Example: *birthday=today

Example: *birthday=03/01

Example: *birthday>=04/01;*birthday<=04/30

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESNO YESNO NO

 

Active in Current School as of MM/DD/YYYY

Format: *as_of=[MM/DD/YYYY]

Example: *as_of=03/01/2011

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
NONO YESNO NO

 

Made Inactive During the School Year

Format: /enroll_status#0;exitdate>=[First Day of School]

Example: /enroll_status#0;exitdate>=08/26/2011

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESNO YESNO NO

 

Has At Least One Historical Grade for Course Number

Format: *has_completed_course=[CourseNumber]

Example: *has_completed_course=9500

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESYES YESNO NO

 

Has No Historical Grades for Course_Number

Format: *has_not_completed=[Course_Number}

*has_not_completed=9500

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESYES YESNO NO

 

Less Than Number Credit Hours in Historical Grades

Format: *cumulative_credit_hours[operator][number]

Example: *cumulative_credit_hours<15

Example: *cumulative_credit_hours=14

Example: *cumulative_credit_hours>13

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESNO YESNO NO

 

More than Number Meeting Attendance Points

Format: *attendance_points[operator][value]

Example *attendance_points>10

Example *attendance_points=11

Example *attendance_points<12

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESNO YESYES NO

 

Has Other Alerts

Alert_Other#

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESNO YESNO NO

 

Has Medical Alerts

Alert_Medical#

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESNO YESNO NO

 

Has Guardian Alerts

Alert_Guardian#

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESNO YESNO NO

 

Has Discipline Alerts

Alert_Discipline#

Enroll_Status 
Term SelectorSchool SelectorSchool Year 
PowerScheduler
YESNO YESNO NO

 

Comments