Summary
This article documents various Student Search commands for use in the PowerSchool Start Page.
Shortcuts
Column Definitions
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 Selector |
School Selector |
School Year |
PowerScheduler |
YES |
YES |
YES |
YES |
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 Selector |
School Selector |
School Year |
PowerScheduler |
YES |
YES |
YES |
YES |
NO |
From Another School Enrolled in Courses Here
Format: *secondarystudents=[Grade_Level]
Example: *secondarystudents=all
Example: *secondarystudents=5
Enroll_Status |
Term Selector |
School Selector |
School Year |
PowerScheduler |
NO |
YES |
YES |
YES |
NO |
From any School Enrolled in Courses Here
Format: *allstudents=[Grade_Level]
Example: *allstudents=5
Example: *allstudents=all
Enroll_Status |
Term Selector |
School Selector |
School Year |
PowerScheduler |
YES |
YES |
YES |
YES |
NO |
Not enrolled in Period
Format: *not_enrolled_in_period=[Internal Period Number]
Example: *not_enrolled_in_period=1
Enroll_Status |
Term Selector |
School Selector |
School Year |
PowerScheduler |
YES |
YES |
YES |
YES |
NO |
Enrolled in Special Program
Format: *special_program=[Special Program Name]
Example: *special_program=Gifted
Enroll_Status |
Term Selector |
School Selector |
School Year |
PowerScheduler |
YES |
NO |
YES |
NO |
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 Selector |
School Selector |
School Year |
PowerScheduler |
YES |
YES |
YES |
YES |
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 Selector |
School Selector |
School Year |
PowerScheduler |
YES |
NO |
YES |
NO |
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 Selector |
School Selector |
School Year |
PowerScheduler |
YES |
NO |
YES |
YES |
NO |
Date of Birth is MM/DD/YYYY
Format: DOB=[MM/DD/YYYY]
Example: DOB=03/01/2012
Enroll_Status |
Term Selector |
School Selector |
School Year |
PowerScheduler |
YES |
NO |
YES |
NO |
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 Selector |
School Selector |
School Year |
PowerScheduler |
YES |
NO |
YES |
NO |
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 Selector |
School Selector |
School Year |
PowerScheduler |
NO |
NO |
YES |
NO |
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 Selector |
School Selector |
School Year |
PowerScheduler |
YES |
NO |
YES |
NO |
NO |
Has At Least One Historical Grade for Course Number
Format: *has_completed_course=[CourseNumber]
Example: *has_completed_course=9500
Enroll_Status |
Term Selector |
School Selector |
School Year |
PowerScheduler |
YES |
YES |
YES |
NO |
NO |
Has No Historical Grades for Course_Number
Format: *has_not_completed=[Course_Number}
*has_not_completed=9500
Enroll_Status |
Term Selector |
School Selector |
School Year |
PowerScheduler |
YES |
YES |
YES |
NO |
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 Selector |
School Selector |
School Year |
PowerScheduler |
YES |
NO |
YES |
NO |
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 Selector |
School Selector |
School Year |
PowerScheduler |
YES |
NO |
YES |
YES |
NO |
Has Other Alerts
Alert_Other#
Enroll_Status |
Term Selector |
School Selector |
School Year |
PowerScheduler |
YES |
NO |
YES |
NO |
NO |
Has Medical Alerts
Alert_Medical#
Enroll_Status |
Term Selector |
School Selector |
School Year |
PowerScheduler |
YES |
NO |
YES |
NO |
NO |
Has Guardian Alerts
Alert_Guardian#
Enroll_Status |
Term Selector |
School Selector |
School Year |
PowerScheduler |
YES |
NO |
YES |
NO |
NO |
Has Discipline Alerts
Alert_Discipline#
Enroll_Status |
Term Selector |
School Selector |
School Year |
PowerScheduler |
YES |
NO |
YES |
NO |
NO |
Comments
0 comments
Please sign in to leave a comment.