Prefs, 9 (ver3.6.1)
Stores all general preferences for the system, user, school etc.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ID | 4.0.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Name | 3.6.1 | Varchar(50) | The name of preferences of almost anything in the system. User specific preferences are the name-U0#### where ##### represents the users internal ID relating to the Users table. And school specific preferences are name-S##### where ##### is the schools number. Indexed. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
SchoolID | 4.0.0 | Number(10,0) | The School_Number of the associated Schools record. |
UserID | 4.0.0 | Number(10,0) | User ID of the person associated with this preference record. Indexed. |
Value | 3.6.1 | CLOB | The actual data stored for the preference. |
YearID | 4.0.0 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Maintained in the Terms table. Indexed. |