luSubSchool lookup table

Modified on Sun, 19 Apr at 11:43 PM

Description
The luSubSchool lookup table is used to define any sub-school entries. This is used mostly by multi-campus organisations that provide schooling for all year levels at each campus.
For example, year levels can be grouped into a:

junior school
middle school
senior school.

The sub-school entries are linked to year levels in the luYearLevel lookup table. For example, the SubSchool field is set to Middle for years 7, 8 and 9 - that is, the middle school. See luYearLevel lookup table (Next Year Process).

You can search for current students based on their sub-school. Students are retrieved based on the year levels that are linked to the sub-school. See Searching for existing students in the Current students manual.

Example

Fields

Field	Description
Code	Unique code used to identify the sub-school.
Description	Description as it appears on the Sub School field when searching for current and future students. For example, the Set Current Student Search Criteria window.
ActiveFlag	If selected, this sub-school can be used within Synergetic.
ModifiedDate	Date and time the lookup table entry was last modified.
ModifiedUser	User that last modified the lookup table entry.

Attachments (4)

worddav89cca63316ab4bddb1d684fc85a8b821.png
4.02 KB

69e1f36a470b1.Lookup_Table_Maintenance_-_luYearLevel_(SubSchool).gif
6.45 KB

69e1f36a470b4.Set_Current_Student_Search_Criteria_(Sub_School).gif
7.21 KB

69e1f36a470b5.Lookup_Table_Maintenance_-_luSubSchool.gif
5.23 KB