Navigation (ver22.5.0)
This table contains the data to build the navigation menus in PowerSchool SIS.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| CheckParams | 23.2.0 | Number(1,0) | Boolean flag indicating if the query parameters need to be inspected to determine which menu item to highlight in the navigation menu. Default 0. Required. |
| Context | 22.5.0 | VarChar(30 Char) | Used to determine what navigation context the url is rendered in. “main“ will be the main PDS App Nav component. “student” specifies a category in the Student PDS vertical tab navigation. Required. |
| HTMLID | 22.5.0 | VarChar2(50 Char) | The HTML Id to be used in the left nav. Must be unique to support Automation and proper HTML structure. Indexed. Required. |
| IconName | 22.5.0 | VarChar2(30 Char) | Name of an icon from </admin/ui_examples/navigation/showPdsIcons.html>. This is only used on main category records. |
| NavigationID | 22.5.0 | Number(10,0) | Unique ID. Indexed. Required. |
PageCatalogID | 22.5.0 | Number(10,0) | Determines the Page associated with the Navigation record. Indexed. Foreign Key. |
ParentNavID | 22.5.0 | Number(10,0) | Used to determine the Category the Navigation record belongs in. Querying the DB grouped on this field will result in the structure of the navigation being defined. Indexed. Foreign Key to Navigation. |
| SortOrder | 22.5.0 | Number(4,0) | Default 0. Required. |
| Version | 22.5.0 | VarChar(50 Char) | Version of the nav menu item. This will allow the Navigation Service to only update new changes from the seed files. |
| WhenCreated | 22.5.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. |
| WhenModified | 22.5.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. |
| 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. |