DistrictSchoolView (ver7.2.0)
This view provides a list of schools including the district office.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Abbreviation | 7.2.0 | Varchar2(20) | [From Schools] The short name for the school displayed on most screens. |
ActiveCrsList | 7.2.0 | CLOB | [From Schools] List of all the courses active in this school taken from district list. This is the actual course catalog for a school. |
Address | 7.2.0 | CLOB | [From Schools] The physical address of the school. Also see SchoolAddress. |
Alternate_School_Number | 7.2.0 | Number | [From Schools] An alternate school number used for state reporting. |
AsstPrincipal | 7.2.0 | Varchar2(79) | [From Schools] The name of the Vice Principal. No longer used by application. This field may still be referenced on reports and/or custom pages. |
AsstPrincipalEmail | 7.2.0 | Varchar2(79) | [From Schools] The Vice Principal's email address. |
AsstPrincipalPhone | 7.2.0 | Varchar2(31) | [From Schools] The Vice Principal's phone number. |
BulletinEmail | 7.2.0 | CLOB | [From Schools] Email address of the person who gets email for bulletin information. |
CountyName | 7.2.0 | Number | [From Schools] The name of the county the school is located at. |
CountyNbr | 7.2.0 | Number | [From Schools] The abbreviation for the county or its number. |
Custom | 7.2.0 | Number | [From Schools] Any custom fields and values created for this particular school. |
DCID | 7.2.0 | Number | [From Schools or 0] Unique identifier for this table. Indexed. Required. |
DfltNextSchool | 7.2.0 | Number | [From Schools] The default next school number on the students will be promoted after this graduating from this school. 0 = for none. |
DistrictNumber | 7.2.0 | Number | [From Schools] No longer used by application. This field may still be referenced on reports and/or custom pages. |
Fee_Exemption_Status | 7.2.0 | Number | [From Schools] Determines what fees are exempt from these schools students. Valid values: 0 = Students Not Exempted, 1 = Students Exempted from Course Fees, 2 = Students Exempted from School Fees, 3 = Students Exempted from All Fees. |
High_Grade | 7.2.0 | Number | [From Schools] The highest grade that will be attending this school. |
Hist_High_Grade | 7.2.0 | Number | [From Schools] The highest historical grade level that will be used for Cumulative GPA, etc. |
Hist_Low_Grade | 7.2.0 | Number | [From Schools] The lowest historical grade level that will be used for Cumulative GPA, etc. |
ID | 7.2.0 | Number | [From Schools or 0] Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
IsSummerSchool | 7.2.0 | Number | [From Schools] Flag to determine whether or not this School is a Summer School. |
Low_Grade | 7.2.0 | Number | [From Schools] The lowest grade level that will be attending this school. |
Name | 7.2.0 | Varchar2(60) | [From Schools or 'District Office'] The name of the school. Indexed. |
PortalID | 7.2.0 | Varchar2(20) | [From Schools] No longer used. Still being checked in one Method. |
Principal | 7.2.0 | Varchar2(79) | [From Schools] The name of the Principal. |
PrincipalEmail | 7.2.0 | Varchar2(79) | [From Schools] The Principals email address. |
PrincipalPhone | 7.2.0 | Varchar2(31) | [From Schools] The Principals phone number. |
PSComm_Path | 7.2.0 | CLOB | [From Schools] This was converted from Gen table for pscommpath field in the custom field. |
ScheduleWhichSchool | 7.2.0 | Varchar2(10) | [From Schools] This was converted from Pref table for class to be scheduled for school. |
SchoolAddress | 7.2.0 | Varchar2(79) | [From Schools] 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 | 7.2.0 | Varchar2(79) | [From Schools] The city the school is in. |
SchoolCountry | 7.2.0 | Varchar2(79) | [From Schools] No longer used by application. This field may still be referenced on reports and/or custom pages. |
SchoolFax | 7.2.0 | Varchar2(31) | [From Schools] The fax number for the school. |
SchoolGroup | 7.2.0 | Number | [From Schools] No longer used but is still being set as Interprocess variable. |
SchoolInfo_GUID | 7.2.0 | Varchar2(32) | [From Schools] Globally unique identifier for this table for SIF compliancy. Indexed. |
SchoolPhone | 7.2.0 | Varchar2(31) | [From Schools] The phone number of the school. |
SchoolState | 7.2.0 | Varchar2(79) | [From Schools] The state the school is in. |
SchoolZip | 7.2.0 | Varchar2(79) | [From Schools] The zip code of the school. |
School_Number | 7.2.0 | Number | [From Schools or 0] The school number the school for all non-district level entities must be non zero unique positive. Indexed. |
SIF_StatePrID | 7.2.0 | Varchar2(32) | [From Schools] SIF-specific identifier. |
SortOrder | 7.2.0 | Number | [From Schools] The order the schools show on lists. |
State_ExcludeFromReporting | 7.2.0 | Number | [From Schools] Flag to stop state reports from updating. |
SysEmailFrom | 7.2.0 | CLOB | [From Schools] The email address PowerSchool says it is from. |
TchrLogEntrTo | 7.2.0 | CLOB | [From Schools] When teachers submit a log entry the email address of the person who is notified. |
View_In_Portal | 7.2.0 | Number | [From Schools] No longer used. Set the preference to 1 in a version fix. |