luSchool lookup table

Description

The luSchool lookup table is used to populate the drop-down list of previous schools when creating a current or future student.

luSchool lookup table example of use

Also see:

Create New Student - School window in the Current students manual
Maintaining community members in the Community manual.

Example

luSchool lookup table

Fields

Note: These fields are not editable. All changes to these fields must be made via Community Maintenance. See Maintaining community members in the Community manual.

Field	Description
Code	Unique code to represent the school. Note: This field can use both letters and numbers.
Description	Name of the school.
Address1	School's main address.
Address2	School's secondary address, if applicable.
Address3	School's third address, if applicable.
Suburb	Suburb school is located in.
State	State school is located in.
PostCode	School's post code.
Phone	School's main phone number.
Fax	School's fax number.
Email	School's email address.
CountryCode	Code for country school is located in.
RSBNumber	Registered School Board number. Used when exporting data.
Type	School type. For example, a primary school.
SchoolID	Synergetic ID for the school.
PrincipalID	The Synergetic ID of the school principal.
ExternalSystem- Type	Used for mapping data to external systems.
ExternalSystem- Code	Used for mapping data to external systems.
ActiveFlag	If selected, this school is active and appears in drop-down lists.
Principal Name	Name of the school's principal.

Last modified: 4/10/2012 11:56:40 AM