PageCatalog (ver22.5.0)
This table contains a catalog of all the navigational pages in PowerSchool.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| DistrictLevelContext | 22.5.0 | Number(1,0) | Flag to determine if the page is District Only, School Only, or Both. 0 indicates Both, 1 indicates School Only and 2 indicates District Only. Default 0. Required. |
| FeatureFlag | 22.5.0 | VarChar2(100) | Name of feature flag which the Link should be hidden behind. Not required. |
| IsCompliance | 22.5.0 | Number(1,0) | Flag to determine if the page is a Compliance page. Default 0. Required. |
| IsCustomerRemoved | 22.5.0 | Number(1,0) | Customers will eventually have the ability to remove links they don’t want via the Security page, this is similar functionality to how they customize the left nav today to remove links they don’t need. Default 0. Required. |
| IsCustomLink | 22.11.0 | Number(1,0) | Flag to determine if page was created via the customer Custom Link upload process. Default 0, Required. |
| isLandingPage | 22.5.0 | Number(1,0) | Flag to indicate that the record is for a page that will include additional links. Default 0. Not required. |
| IsNewTab | 22.5.0 | Number(1,0) | Needs to be opened in a new tab. Default 0. Required. |
| OriginalParentUrl | 22.5.0 | VarChar2(4000 Char) | Original linked list parent page URL(s). If there are multiple, they're comma delimited or use 'parent>child' formatting. Not required. |
| PageCatalogID | 22.5.0 | Number(10,0) | Unique ID. Indexed. Required. |
| PageURL | 22.5.0 | VarChar2(4000 Char) | URL to the page, these can include PS-HTML tags |
| PageDescription | 22.5.0 | VarChar2(256 Char) | Description of the page, this will allow us to have more robust search functionality in the future. Should be Message Key. But supports the use of a non-message key. Indexed. |
| PluginId | 22.5.0 | Number(10,0) | Determines the Plugin associated with the record. Indexed. Foreign Key. |
| RequiredContext | 22.5.0 | VarChar(30 Char) | Context needs more research. Initially will account for Student/Staff |
| Title | 22.5.0 | VarChar2(256 Char) | URL title to display in the left nav, should be Message Key. But supports the use of a non-message key. Required. |
| WhenCreated | 22.5.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. Required. |
| WhenModified | 22.5.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. Required. |
| WhoCreated | 22.5.0 | VarChar(100 Char) | The user login that created the record. Defaults to the database user. Required. |
| WhoModified | 22.5.0 | VarChar(100 Char) | The user login that modified the record. Defaults to the database user. Required. |