FavoriteCategory (ver22.9.0)
Reserved for future use
This table contains the favorite page categories for the users in PowerSchool.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| FavoriteCategoryID | 22.9.0 | NUMBER(19,0) | Unique ID. Indexed. Required. |
| Name | 22.9.0 | VARCHAR2(100 CHAR) | Name of the Category. Required. |
| SortOrder | 22.9.0 | NUMBER(4,0) | The order by which the categories are displayed in the application |
| UserDCID | 22.9.0 | NUMBER(10,0) | Foreign key to the Users table. Required. Indexed. |
| WhenCreated | 22.9.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. |
| WhenModified | 22.9.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. |
| WhoCreated | 22.9.0 | VARCHAR2(100 CHAR) | The name of the person who created the record. Defaults to user. |
| WhoModified | 22.9.0 | VARCHAR2(100 CHAR) | The name of person who modified the record. Defaults to user. |