PowerSchool SIS All States

StudentSchoolEnrollment

File Names: queries\StudentSchoolEnrollment.txt
Base Table Alias: s

Options

Value

Description

%TARGETDATE%

This is the current date of the system the agent is running on.

%SCHOOLDCID%

This is a list of the schools that are part of the zone.

%SCHOOLYEAR%

This is the School Year configured in the Agent Settings.

%STUDENT.DATAFILTER%

This is the student data filter configured in the Agent Settings.

/*WHERE_QUERY_CONDITION*/

This is the condition that is used by the SIF Agent to filter data based on the request.  This should always be included at the bottom of the query.