AB_PASISCHAUTHSCHINFO
This table stores School Authority and Schools Information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_PASISchAuthSchInfoID | 13.0.0 | NUMBER(19,0) | Primary Key |
| AuthorityCode | 13.0.0 | Varchar2(4) | School Authority's code. |
| SchoolCode | 13.0.0 | Varchar2(4) | School's number. |
| Name | 13.0.0 | Varchar2(140) | School Authority's name. |
| SourseVersion | 13.0.0 | Varchar2(32) | The version number of the school from the source version. |
| CoreVersion | 13.0.0 | NUMBER(19,0) | Unique number allowing easy identification of when an entity has changed. |
| FaxNumber | 13.0.0 | Varchar2(31) | School Authority's fax number. |
| EmailAddress | 13.0.0 | Varchar2(79) | School Authority's email address |
| Country | 13.0.0 | Varchar2(60) | The country for the address. |
| Street | 13.0.0 | Varchar2(140) | The street element (number and name). Usually line one of the address. |
| City | 13.0.0 | Varchar2(60) | The city element of the address. |
| StateProvince | 13.0.0 | Varchar2(20) | The province element of the address. |
| PostalCode | 13.0.0 | Varchar2(15) | The postal code element of the address. |
| PhoneNumber | 13.0.0 | Varchar2(31) | School Authority's phone number. |
| WhoCreated | 13.0.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. |
| WhenCreated | 13.0.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. |
| WhoModified | 13.0.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. |
| WhenModified | 13.0.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date |
| SchoolAuthorityType | 13.0.0 | NUMBER(4,0) | Identifies if this is a school or a school authority. |