Schools, 39 (ver3.6.1)
Information held on each of the schools.
Note: This table includes schema extension. For more information, see _C_SCHOOL_REGISTRAR{_}.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Abbreviation | 3.6.1 | Varchar(20) | The short name for the school displayed on most screens. |
ActiveCrsList | 3.6.1 | CLOB | List of all the courses active in this school taken from district list. This is the actual course catalog for a school. |
Address | 3.6.1 | CLOB | The physical address of the school. Also see SchoolAddress. |
Alternate_School_Number | 3.6.1 | Number(10,0) | An alternate school number used for state reporting. |
AsstPrincipal | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
AsstPrincipalEmail | 3.6.1 | Varchar(79) | The Vice Principal's email address. |
AsstPrincipalPhone | 3.6.1 | Varchar(31) | The Vice Principal's phone number. |
BulletinEmail | 3.6.1 | CLOB | Email address of the person who gets email for bulletin information. |
CountyName | 3.6.1 | Varchar(79) | The name of the county the school is located at. |
CountyNbr | 3.6.1 | Varchar(79) | The abbreviation for the county or its number. |
Custom | 3.6.1 | CLOB | Any custom fields and values created for this particular school. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
DfltNextSchool | 3.6.1 | Number(10,0) | The default next school number on the students will be promoted after this graduating from this school. 0= for none. |
District_Number | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Fee_Exemption_ Status | 3.7.0 | Number(10,0) | Determines what fees are exempt from these schools students. Values are, 0 = Students Not Exempted1 = Students Exempted from Course Fees. 2 = Students Exempted from School Fees 3 = Students Exempted from All Fees. |
High_Grade | 3.6.1 | Number(10,0) | The highest grade that will be attending this school. |
Hist_High_Grade | 3.6.1 | Number(10,0) | The highest historical grade level that will be used for Cumulative GPA, etc. |
Hist_Low_Grade | 3.6.1 | Number(10,0) | The lowest historical grade level that will be used for Cumulative GPA, etc. |
ID | 3.6.1 | Number(10,0) | Not used by the application. Uniqueness is not guaranteed. NOT to be used as a key for this table. |
IsSummerSchool | 5.0.7 | Number(10,0) | Flag to determine whether or not this School is a Summer School. |
Low_Grade | 3.6.1 | Number(10,0) | The lowest grade level that will be attending this school. |
Name | 3.6.1 | Varchar(60) | The name of the school. Indexed. |
PortalID | 3.6.1 | Varchar(20) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
Principal | 3.6.1 | Varchar(79) | The name of the Principal. |
PrincipalEmail | 3.6.1 | Varchar(79) | The Principals email address. |
PrincipalPhone | 3.6.1 | Varchar(31) | The Principals phone number. |
PSComm_Path | 3.6.1 | CLOB | This was converted from GEN table for pscommpath field in the custom field. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
ScheduleWhichSchool | 3.6.1 | Varchar(10) | This was converted from PREF table for class to be scheduled for school. |
SchoolAddress | 3.6.1 | Varchar(79) | The street number and address of the school. |
| SchoolCategoryCodesetID | 19.11.0 | Number(16,0) | The ID of the School Category Code for the school. References record in the Codeset table. |
SchoolCity | 3.6.1 | Varchar(79) | The city the school is in. |
SchoolCountry | 3.6.1 | Varchar(79) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
SchoolFax | 3.6.1 | Varchar(31) | The fax number for the school. |
SchoolGroup | 3.6.1 | Number(10,0) | No longer used by the application, but is still being set as Interprocess variable. |
SchoolInfo_GUID | 4.0.0 | Varchar(32) | Globally unique identifier for this table for SIF compliancy. Indexed. |
SchoolPhone | 3.6.1 | Varchar(31) | The phone number of the school. |
SchoolState | 3.6.1 | Varchar(79) | The state the school is in. |
SchoolZip | 3.6.1 | Varchar(79) | The zip code of the school. |
School_Number | 3.6.1 | Number(10,0) | The school number the school for all non-district level entities must be non zero unique positive. Indexed. |
SortOrder | 3.6.1 | Number(10,0) | The order the schools show on lists. |
SIF_StatePrID | 5.0.7 | Varchar(32) | SIF specific Identifier. |
State_ExcludeFromReporting | 3.6.1 | Number(10,0) | Flag to stop state reports from updating. |
SysEmailFrom | 3.6.1 | CLOB | The email address PowerSchool says it is from. |
TchrLogEntrTo | 3.6.1 | CLOB | When teachers submit a log entry the email address of the person who is notified. |
View_In_Portal | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |