PSM_School (ver1.0)
This table contains information about each of the schools within the district. Data duplicated here from the originating SIS.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Abbreviation | 1.0 | Varchar2(30) | The short name for the school displayed on most screens. |
Address | 1.0 | Varchar2(4000) | The physical address of the school. |
DistrictID | 1.0 | Number(19,0) | The internal ID of the PSM_District record to which the record is associated. Required. |
ID | 1.0 | Number(19,0) | Unique sequential number generated by the application. Required. |
Name | 1.0 | Varchar2(60) | The name of the school. Required. |
SchoolNumber | 1.0 | Varchar2(30) | The school number for the school for all non-district level entities. |