Skip to main content
Skip table of contents


This table stores School Authority and Schools Information.

Column Name


Data Type





Primary Key

AuthorityCode13.0.0Varchar2(4)School Authority's code.
SchoolCode13.0.0Varchar2(4)School's number.
Name13.0.0Varchar2(140)School Authority's name.
SourseVersion13.0.0Varchar2(32)The version number of the school from the source version.
CoreVersion13.0.0NUMBER(19,0)Unique number allowing easy identification of when an entity has changed.
FaxNumber13.0.0Varchar2(31)School Authority's fax number.
EmailAddress13.0.0Varchar2(79)School Authority's email address
Country13.0.0Varchar2(60)The country for the address.
Street13.0.0Varchar2(140)The street element (number and name). Usually line one of the address.
City13.0.0Varchar2(60)The city element of the address.
StateProvince13.0.0Varchar2(20)The province element of the address.
PostalCode13.0.0Varchar2(15)The postal code element of the address.
PhoneNumber13.0.0Varchar2(31)School Authority's phone number.
WhoCreated13.0.0Varchar2(100)The name of the person who created the record. Defaults to user.
WhenCreated13.0.0TIMESTAMP(6)The date and time the record was created. Defaults to system date.
WhoModified13.0.0Varchar2(100)The name of person who modified the record. Defaults to user.
WhenModified13.0.0TIMESTAMP(6)The date and time the record was modified. Defaults to system date
SchoolAuthorityType13.0.0NUMBER(4,0)Identifies if this is a school or a school authority.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.