StaffPersonal
If there is no need to change the StaffPersonal Race query, it does not need to be overridden and included in the directory. If the file is not there, the SIF Agent will use the default of the agent.
File Names: queries\StaffPersonal.txt; queries\StaffPersonalRace.txt
Base Table Alias: u
Options
Value | Description |
|---|---|
%SCHOOLDCID% | This is a list of the schools that are part of the zone. |
/*OR_DISTRICT_AS_SCHOOL*/ | Option to include the District Office when filtering by schools. |
/*AND_STAFFSTATUS_FILTER*/ |
|
/*AND_STATUS_FILTER*/ |
|
/*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. |
ORDER BY USERSDCID | This is required for both queries. This is used to match the StaffPersonal records with the Races from the second query. If the ordering is not the same, then the races will not be published correctly. |